Electronic Data Submittal Application (EDSA) User's
EDSA version 7.1.0 August 2012
Prior to submitting electronic data to SRP, the LSRP or the data preparer on behalf of the responsible party, should run the data through the Electronic Data Submittal Application version 7 (EDSA7) to determine if the data meet the administrative and format requirements described in the SRP-Electronic Data Interchange Manual (SRP-EDI). This check ensures that the data are in the correct format. The use of EDSA7 is not required by law, however EDSA7 is extremely beneficial to the data preparer because it reduces data submittal failures and increases data quality. SRP strongly recommends the use of EDSA7 for all data submittals. The computer running EDSA7 must have Windows XP or higher. EDSA7 must be installed on the computer that is being used to run the data.
How to install EDSA7
- Click on EDSA7
- Download the installer
- Unzip all files into one directory
- Run Setup.exe
- Click OK
- Click the computer and wait for the setup to finish installing
- The last message asks you to restart your machine. This is not necessary for EDSA7.
- Start > Programs > Electronic Data Submittal
- Starting EDSA7 from the icon brings up the main screen:
The main screen includes buttons to activate the data checking process (START DATA CHECK), Reset, Utilities and Cancel.
- Click the "START DATA CHECK" button
The START DATA CHECK button opens a standard Windows navigation window. The window allows the user to pick the location where the files being checked are stored. EDSA7 will automatically store these files in C:\TEMPEDSA temporarily, if another location is not selected. EDSA7 will delete the files stored in C:\TEMPEDSA when the data preparer clicks the Reset button or re-starts the program. SRP strongly recommends that you save the files in a separate location for future use, if necessary.
Note: Included among these stored files are correctly-formatted Excel files. Your DTST, HZSAMPLE and HZRESULT data will be loaded into these files as it is received. Error tables for each of the files (ERDTST.DBF, ERSAMP2.DBF and ERRESUL2.DBF) are also stored in C:\TEMPEDSA. These files are used by the Error Report Reader to create an HTML error report with links to a webpage that explains the errors encountered
- Select the disk drive where your data is located and click on the DTST file.
- If there are any errors, EDSA7 will identify the errors and automatically display them via the Error Report Reader. A Message Code and a brief explanation of what the error is will also be displayed. Click on the Message Code for additional information and possible fixes. Warning messages are triggered by possible errors symptoms that EDSA7 could not verify as an error. Warning messages and the associated data should be reviewed and rectified if needed.
- In addition, if the spatial software “Google Earth” or “Arc Explorer” is installed on your computer, EDSA7 will automatically launch the software. The KML Coordinate Tool used to display spatial data, will help the data preparer valid coordinate locations. The KML tool uses the coordinates in your HZSAMPLE.TXT file, as it is submitted, to automatically zoom to that location. All sampling location numbers included in HZSAMPLE.TXT are also automatically displayed by the KML tool. Once you are at the location, you can use aerial views and street views to verify all the sampling locations.
KML files are automatically saved in C:\tempEDSA_KML as SRPID_yyyymmdd_YYYYMMDD.KML where the first date is the earliest “SampDate” value and the second date is the latest “SampDate” value.
Tutorials and Help menus on loading and using the spatial software are available via the web site of the spatial software that you chose. NJDEP GIS is currently working on additional KML tools, for Arc Explorer, which will be available soon.
The Reset button clears all data stored in C:\TEMPEDSA to prepare a new dataset