Add or Modify Enterprise EDP Formats

<< Click to Display Table of Contents >>

Navigation:  Enterprise > Installation and Configuration > Configuration > Enterprise EDP Configuration >

Add or Modify Enterprise EDP Formats

Add EQuIS Format File to Enterprise


Enterprise supports multiple EDP formats. If the user has proper permissions to the server and the database, setting up EDP formats for use is a two-step process:

1.Add Format Files to Server.

2.Add Format Files to Database.


Permission Prerequisites

Server Access – The ability to add the format files to the Enterprise 7 folder or alter folder permissions.

Database Access – The ability to add or edit records in the ST_CONFIG table (for adding additional formats).


Add Format Files to Server


For standard installations, the server administrator can add the format files within the Enterprise 7 directory by adding a folder called Formats, if it does not already exist (e.g., C:\Program Files\EarthSoft\Enterprise7\Formats\EarthSoft). Using this structure will allow the application pool identity to have the same access to the formats folder as it does to the Enterprise 7 directory. If another directory is chosen, the folder permissions will need to be updated on the Format folder so that the IIS Application Pool Identity account has proper access to read and execute as well as list directory contents permissions on that folder.


The STRING_VALUE in the ST_CONFIG table will also need to be updated with the Format path as described in the "Update Enterprise to Use Format Files" Section below.


Add Format Files to Database


The zipped (*.zip) format file can be uploaded to the DT_FILE table using the Explorer Widget in Enterprise or the Docs and Photos Form in Professional.



Update Enterprise to Use Format Files


When the Schema is created, Enterprise is configured with two sets of records in the ST_CONFIG table for two EQuIS formats: EQEDD and EFWEDD. Various default configuration settings have been applied for these formats and Enterprise workflow service agents; these should be reviewed and modified to meet user needs.  


Administrators may use the Workflow Widget to modify workflow service agents or EQuIS format files and to add new format files. Alternatively, administrators can directly edit the records in the ST_CONFIG table to add or configure format files. See the EQuIS Format Definition Management chapter and associated articles for more details on using the ST_CONFIG table settings.


Each format has associated records in the ST_CONFIG table that define the format (XSD file name), the commit type, and whether or not it accepts warnings. A format may also be set as a default format. Note that most formats will have three records, where OBJECT_VALUE = "xsdFileName", "commitType", and "acceptWarnings". The default format for the Enterprise instance should have a fourth record, where OBJECT_VALUE = "isDefault" and STRING_VALUE = "True". This record is not necessary for the other formats.




Note: Making changes to the ST_CONFIG table requires the Enterprise workflow services to be restarted on the server.


Warning: Do not make any changes to records in the ST_CONFIG table other than the intended records for modifying the EDP formats.