[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