File Management in EQuIS Professional

<< Click to Display Table of Contents >>

Navigation:  Professional >

File Management in EQuIS Professional

Uploading and Downloading Files

Permissions

Associate Image with Specific Location

Associate Image with Location Types

Show Associated Images in Google Earth

File Storage Fields

Other EQuIS File Management

 

The EQuIS database mainly stores files in the DT_FILE data table. Most DT_FILE fields contain file information or metadata; the files themselves are stored as Binary Large Objects (BLOBs) in the CONTENT field using the varbinary(max) data type. In EQuIS 7.22.3 and newer, the DT_FILE.CONTENT field is hidden to improve performance. A field that contains a BLOB shows the text “System.Byte[]”.

 

Before adding a file of a new file type, create a record for that file type in RT_FILE_TYPE. For more information on this reference table, see RT_FILE_TYPE – MIME Types.

 

Uploading and Downloading Files

 

Within EQuIS Professional, upload and download files in the following ways:

for files in DT_FILE, through the Docs & Photos Form

for files in other locations, through the EQuIS Blobber Form

 

EQuIS features like tables, reports, and charts will output files if the user chooses an export option, such as Export to Excel or Save Parameters .

 

Permissions

 

Enterprise permissions will restrict a non-admin user from accessing Tables\DT_FILE in Professional. The restriction details are:

1.A non-admin user without any Enterprise Viewer, Editor, or Owner permissions to the Files Object Type nor to individual Files/Documents of DT_FILE:

i.cannot see the files in Professional\Tables\DT_FILE, and

ii.cannot see the files in the open dialog for loading a template file in Crosstab Configurations.

2.A non-admin user with any of Enterprise Viewer, Editor, or Owner permission to all or some files of DT_FILE, whether associated with the connected facility or with DT_FILE.FACILITY_ID = null:

i.can see the files in Professional\Tables\DT_FILE, and

ii.can select the files in an open dialog for loading a template file in doing a crosstab config.

3.A non-admin user with a denied Viewer permission to all or some files of DT_FILE cannot see the files in Professional\Tables\DT_FILE.

 

Associate Image with Specific Location

 

1.In the DT_FILE.PLACE_TYPE field for an image file record, enter "sys_loc_code".

2.In the DT_FILE.PLACE_CODE field for that record, enter the sys_loc_code value (e.g., "B-30") of the location from DT_LOCATION.

 

 

Associate Image with Location Types

 

1.Upload an image file, such as through the Docs & Photos Form or EQuIS Enterprise Explorer Widget.

2.Open DT_FILE and locate the record for that image file.

3.Fill in the following fields for that record:

a.PLACE_TYPE = LOCATION_TYPE_CODE

b.PLACE_CODE = the name of the location type (e.g. "MONITORING WELL"). Find this information in DT_LOCATION in the LOC_TYPE field, as well as in RT_LOCATION_TYPE.

 

This image provides an icon in Google Earth for each point with that Location Type.

 

Show Associated Images in Google Earth

 

1.In the ribbon, click the Reports Reports-16 button.

2.Select the Google Earth: Locations Report, then Open.

3.Choose the appropriate parameters, and under "Description:", select "Embed Files".

4.Run the report.

 

Google Earth should open and navigate to the locations. In addition, designated icons for Location Type will be visible and/or any associated image(s) will be visible if a specific location is clicked on.

 

15695_associmg

 

File Storage Fields

 

Along with DT_FILE, file storage locations in the EQuIS database include the following:

DT_ACTION_LEVEL.ASSEMBLY – for custom action level DLLs

DT_CHAIN_OF_CUSTODY.SAMPLER_SIGNATURE

RT_DQM_CHECK.ASSEMBLY

Collect system tables

oCONTENT field in ST_COLLECT_DATA_ENTRY, ST_COLLECT_FIELD_FILES, and ST_COLLECT_FORMS

oST_COLLECT_FORMS.FORMS_IMAGE

ST_FILE_REGISTRATION.CONTENT – loaded EDD files

ST_MODULE.ASSEMBLY – published reports and forms that appear in this table

ST_NOTICE_ATTACHMENT.CONTENT – notice attachments

ST_REPORT.ASSEMBLY – configurations for published crosstab reports (both grid and non-grid) and published Alive survey reports

ST_SPLA.CERTIFICATE – for Service Provider Licensing Administration (SPLA) certificates

 

Depending on license portfolio, some of the above tables may not exist in an organization’s EQuIS database. Non-admin users will have limited access to system tables.

 

Other EQuIS File Management

 

For file use and management in other parts of EQuIS, see the following pages.

EQuIS Enterprise:

oFile Management in the Explorer Widget

oFile Metadata Customization

oLinking and Downloading Files from Locations on the Map Widget

oUsing DT_FILE Images in the HTML Widget

oAdd or Modify Enterprise EDP Formats

EQuIS Live: Live File Processor Agent

SPM: Associate Commitment Report with a File or Web Page

EDGE:

oAttach Files in EDGE

oPhotos and Files Column

EQuIS Alive: EDGE Export from Alive Survey Definition Form

EQuIS Collect: File Management and Processing