[ADaPT-l] ADaPT Version 9.0.11 Update-New DWM File Naming Standard
Fetrow, Chad
Chad.Fetrow at dep.state.fl.us
Wed May 17 12:15:54 EDT 2017
This ADaPT update is required for all labs, contractors, and consultants submitting ADaPT EDDs to any Division of Waste Management (DWM) program. ADaPT 9.0.11 will now automatically name the Lab EDD, Lab EDD Error Log, Field EDD, and ADaPT export file using the file name elements as outlined in the table below:
Hazardous Waste
Petroleum Restoration
Solid Waste
Waste Cleanup
1.Facility/Project/Site ID (LDD ProjectNumber)
CHAZ Facility ID
STCM Facility ID
WACS Facility ID
ERIC Facility ID, or from COMET or other Waste Cleanup Database.
2. Separator
_
_
_
_
3. Date format (of earliest or latest sample)
YYYYMMDD
YYYYMMDD
YYYYMMDD
YYYYMMDD
4. (-ext) - optional text for (none, AIR, CONF)
5. Separator
_
_
_
_
6. Program Area Code
HW
PR
SW
WC
7. EDD Type
fdd, ldd, ldd_ErrorLog
fdd, ldd, ldd_ErrorLog
fdd, ldd, ldd_ErrorLog
(fdd), ldd, ldd_ErrorLog
8. File Extension
.txt
.txt
.txt
.txt
Example Filenames
Field EDD
FLD046771952_20160915_HWfdd.txt
8519437_20160425_PRfdd.txt
45937_20160919_SWfdd.txt
ERIC_5150_20160824_WCfdd.txt
Lab EDD
FLD046771952_20160915_HWldd.txt
8519437_20160425_PRldd.txt
45937_20160919_SWldd.txt
ERIC_5150_20160824_WCldd.txt
Lab EDD Error Log
FLD046771952_20160915_HWldd_ErrorLog.txt
8519437_20160425_PRldd_ErrorLog.txt
45937_20160919_SWldd_ErrorLog.txt
ERIC_5150_20160824_WCldd_ErrorLog.txt
ADaPT Export csv file
ADAPTHW20161102073831.csv
ADAPTPR20161102073041.csv
ADAPTSW20161102100446.csv
ADAPTWC20161102100258.csv
ADaPT EDD Zip file
FLD046771952_20160915_HWzdd.zip
8519437_20160425_PRzdd.zip
45937_20160919_SWzdd.zip
ERIC_5150_20160824_WCzdd.zip
Example Filenames when Field EDD may not be required
Field EDD
8519437_20160425-CONF_PRfdd.txt
45937_20160919-RAD_SWfdd.txt
Lab EDD
8519437_20160425-CONF_PRldd.txt
45937_20160919-RAD_SWldd.txt
COM_169624_20141105_WCldd.txt
Lab EDD Error Log
8519437_20160425-CONF_PRldd_ErrorLog.txt
45937_20160919_SWldd-RAD_ErrorLog.txt
COM_169624_20141105_WCldd_ErrorLog.txt
ADaPT EDD Zip file
COM_169624_20141105_WCzdd.zip
Note: These file name elements are defined by each FDEP Program Area in the ADaPT FDEP Database's Website valid values table.
Coming soon, all ADaPT EDDs will be submitted to the Hazardous Waste, Petroleum Restoration, Solid Waste, and Waste Cleanup Programs through the DEP Business Portal<http://www.fldepportal.com/go/>, and all ADaPT file names must conform to the new DWM file naming convention. We will send a notification before this submission process is implemented.
We have also updated the Division of Waste Management (DWM) Valid Values. The following tables have been updated:
-ADaPT's LabID Valid Values
-ADaPT's Project Valid Values
-ADaPT FDEP Database's STORET Code valid values
-ADaPT FDEP Database's Website valid values table
To update ADaPT, download the file for your operating system by clicking the appropriate link below and saving to your local hard drive:
Windows (32-bit)
ftp://ftp.dep.state.fl.us/pub/WACS-ADaPT/Update_ADaPT_9_0_11_Consultant_(Windows_32_bit).exe
Windows (64-bit)
ftp://ftp.dep.state.fl.us/pub/WACS-ADaPT/Update_ADaPT_9_0_11_Consultant_(Windows_64_bit).exe
Ensure that ADaPT is not running and that you have finished processing all EDDs. Navigate to the appropriate file and double click on it to execute. This program will update the ADaPTModules.accde and ADaPTTables.accdb files and overwrite the existing files.
If you update ADaPT 9.0.11 and encounter any problems, please let us know.
Thank you.
Clark Moore
Florida Department of Environmental Protection
Operational and Program Performance
Phone: (850) 245-8739
Clark.b.moore at dep.state.fl.us<mailto:Clark.b.moore at dep.state.fl.us>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.dep.state.fl.us/pipermail/adapt-l/attachments/20170517/970508e0/attachment-0001.html>
More information about the ADaPT-l
mailing list