These variables must be set as part of the initial installation of the eSeaGrant system, BEFORE any eSG FMP interfaces are actually used.
RFPThese variables are managed via the RFP FMP layout "FMP Administration > RFP FMP Config" | variable | description |
|---|
| domain | URL of host website (e.g. seagrant.mit.edu) | | ftp_domain | URL of host server (e.g. nereides.mit.edu) | | SFTP_login | Username that FMP uses to transfer files via SFTP | | SFTP_passwd | Password that FMP uses to transfer files via SFTP | | home_folder_path | Absolute path of home folder on host server (e.g. /var/https/htdocs) | | subcontract_PI_id | investigators::id value corresponding to SG Program Director | | subcontract_grantee | Host institution for SG program (e.g. Massachusetts Institute of Technology) | | grantee_inst_short | Host institution acronym for SG program (e.g. MIT) | | sg_program | SG program (e.g. MIT Sea Grant) | | sg_program_short | SG program acronym (e.g. MITSG) | | eSG_folder_path | Path to eSG system folder from home folder (e.g. /RFP/proposals/ - note slashes) | | PM_project_folder_path | Path to eSG project folders from home folder (e.g. Documents/Online_Project_Folders/ - note slashes) | | PM_project_resumes_path | Path to eSG project user resumes from home folder (e.g. Documents/Resumes/ - note slashes) | | current_FY_global | (Current Omnibus Cycle) Sets what the RFP FMP interface assumes to be the beginning funding year of the current omnibus cycle, for generating 90-2s, Overall 90-4s, etc. This is used to filter-out old funding year data from this type of form. | | 8192_char_limit | Toggle that allows each program to limit a specific set of textarea input boxes to 8192 characters. This addresses a conflict between Filemaker Pro and the MySQL ODBC connect script for Windows that causes text columns of greater than 8192 characters to appear truncated when viewed in Filemaker Pro for Windows. eSG programs that use Filemaker Pro via the Windows OS extensively should set this toggle to 1 and impose this limit. | | US_time_zone | The US time zone in which the webserver resides, and that the web forms think they are located in. This doesn't apply to the database - MySQL timestamps will still reflect the PHP / MySQL server timezone configuration, which should be considered when viewing record date/time data. | | ICODE | ICODE pertaining to SG program |
PMThese variables are managed via the PM FMP layout "FMP Administration > PM FMP Config" | variable | description |
|---|
| domain | URL of host website (e.g. seagrant.mit.edu) | | ftp_domain | URL of host server (e.g. nereides.mit.edu) | | SFTP_login | Username that FMP uses to transfer files via SFTP | | SFTP_passwd | Password that FMP uses to transfer files via SFTP | | home_folder_path | Absolute path of home folder on host server (e.g. /var/https/htdocs) | | sg_program | SG program - short (e.g. MIT Sea Grant) | | sg_program_short | SG program acronym (e.g. MITSG) | | sg_program_long | SG program - long (e.g. MIT Sea Grant College Program) | | eSG_folder_path | Path to eSG home folder (e.g. /RFP/proposals/) | | 8192_char_limit | Toggle that allows each program to limit a specific set of textarea input boxes to 8192 characters. This addresses a conflict between Filemaker Pro and the MySQL ODBC connect script for Windows that causes text columns of greater than 8192 characters to appear truncated when viewed in Filemaker Pro for Windows. eSG programs that use Filemaker Pro via the Windows OS extensively should set this toggle to 1 and impose this limit. | | SG Program Address | Toggle that allows each program to limit a specific set of textarea input boxes to 8192 characters. This addresses a conflict between Filemaker Pro and the MySQL ODBC connect script for Windows that causes text columns of greater than 8192 characters to appear truncated when viewed in Filemaker Pro for Windows. eSG programs that use Filemaker Pro via the Windows OS extensively should set this toggle to 1 and impose this limit. | | Program ID Scheme | Toggle that allows each program to limit a specific set of textarea input boxes to 8192 characters. This addresses a conflict between Filemaker Pro and the MySQL ODBC connect script for Windows that causes text columns of greater than 8192 characters to appear truncated when viewed in Filemaker Pro for Windows. eSG programs that use Filemaker Pro via the Windows OS extensively should set this toggle to 1 and impose this limit. | | The official address for the host SG program, for use in reporting coverpages and other reports | | Program ID Scheme | (Publications) The naming scheme for publication records
For example:
Right ( MEDIA::PUB_YEAR ; 2 ) & "-" & If (MEDIA::program_ID_int<10;"0") & MEDIA::program_ID_int would generate publication a Program ID of '14-09' for the 9th publication of 2014
| | Pub Naming Scheme | (Publications) The naming scheme for publication files
For example:
$$prgm_prefix &"_" & MEDIA::program_ID would generate publication filename of 'MITSG_14-09' for the 9th MITSG publication of 2014 | Pub Naming Scheme | Toggle that allows each program to limit a specific set of textarea input boxes to 8192 characters. This addresses a conflict between Filemaker Pro and the MySQL ODBC connect script for Windows that causes text columns of greater than 8192 characters to appear truncated when viewed in Filemaker Pro for Windows. eSG programs that use Filemaker Pro via the Windows OS extensively should set this toggle to 1 and impose this limit. | | US_time_zone | The US time zone in which the webserver resides, and that the web forms think they are located in. This doesn't apply to the database - MySQL timestamps will still reflect the PHP / MySQL server timezone configuration, which should be considered when viewing record date/time data. |
| 