Running the Basic Conversion Tool
Prior to starting the ECT, the user should place the input files "Input_Files" folder. By default, this folder is:
C:\Documents and Settings\\My Documents\EMTS Conversion Tool (ECT)\Input_Files
Figure 1 depicts this folder for a user "wgo". The "Input_Files" folder has been circled. See the guide
"Installing and Setting Up the Conversion Tool" for instructions on changing the location of the
"Input_Files" folder. Note that the extension for all Excel files saved in this folder should be .xls rather than
.xlsx (the default for Excel 2007).
Figure 1: EMTS Conversion Tool Input File Directory
EMTS Conversion Tool (ECT)
File Edit View Favorites Tools Help
^'
Search Folders
Address Q C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)
A
File and Folder Tasks v£J | / Error Fifes!
f '^
/ History_Files
Val_Log
Good Files
/'
Go
Running the ECT
The ECT can be opened from the Start Menu. Upon starting the ECT, the start-up screen is displayed (see
Figure 2).
&EPA
United Stoics
Environmental Protection
Agency
EPA-420-b-10-010b
May 2010
-------
EMTS Conversion Tool
Figure 2: Start-up Screen
IJH EMTS Conversion Tool (ECT) Front Page
File Help
Convert a delimited text file or Excel file to EMTSXMLfile (files can be zipped).
Advanced Version
This version allows the flexibilty that (he Basic version doesn't.
This is a basic version which requires:
1) If using a text file then it must be a tab, comma, or bar delimited format.
2) The columns of the files must be the EPA recommended column names.
3) For an existing file all elements must be included, set unused defaults as blanks.
N.B. Please keep in mind that the ECT performs only basic QA checks while EMTS performs high-level QA checks which are
company specific and are based on a company's registration with EPA.
Therefore, it may be possible for a user to successfully convert files to XML using the ECT but then
an upload to EMTS may fail.
I Don't show this page anymore.
If later you would like this see this display then, on the Main Menu, select ShowFrontPage and unselect Don't Show.
Exit
On the start-up screen, the user has the option to click the checkbox beside "Don't show this page
anymore". This will cause the ECT to skip the start-up screen and open on the File Selection screen of the
version (Basic or Advanced) previously selected. To start the Basic version, click the "Go" button under
"Basic Version".
Selecting Files
After clicking the "Go" button, the File Selection Screen appears (see Figure 3).
-------
EMTS Conversion Tool
Figure 3: File Selection Screen
H EMTS Conversion Tool (ECT)
- n x
File Help File List View Show Front Page Show Log WinZip
Welcome: wgo . This application will format an Excel or delimited file for conversion to XML. For questions concerning compatibly refer to Help/About ECT.
Select a Folder on the left panel and File(s] on the right panel and click on the Process File(s) button to p
i-H Error_Files
i li-Si Good_Files
1-0 History_Files
1 El £3 InpuLFiles
O Val_Log
! ffi-Sl FinePrint files
|-O FormatXML
n My Google Gadgets
O My Music
i-O My Pictures
|-O My Videos
I ffl O My Virtual Machines
|-O New Folder
ftO PDF files
| SO TotarValidatorTool
ffl-O NetHood
i-O PrintHood
i-O P'ivaclE
i-O Flecent
|-O SendTo
El O Spark
[JO Start Menu
i O Templates
, -. , , ,-. ,
Name Size Modified
ocess OR Select the Build a New File button.
Attribute I Exist
B BuyDenyTemplate.xls 30,720 3/1 0/201 01 0:56: 05 AM A Flle(sl
B BuyTemplate.xls 27,136 4/14/2010
B| Generat.eTemplate.xls 51,712 4/14/2010
'H FietireTemplate.xls 40,960 4/14/2010
B| SellTernplate.xls 33,792 4/14/2010
1 SellTemplateCancel.xls 37,376 3/9/20101
H Separate! emplate.xls 39,424 4/14/2010
3:49:52 PM A Or
3:49:52 PM A
Build a New
3:49:52 PM A File
3:49:52 PM A
:00:27 PM A Or
3:49:52 PM A
Exit
Files
Input File(s] Folder: JGADocuments and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)Mnput_Files
*Good File(s) Folder: C:\Documents and SettingsVwgoVMy DocumentsVEMTS Conversion Tool (ECT]\Good_Files
"Bad File(s) Folder: |C:\Docurnents and Settings\wgo\Mii Documents\EMTS Conversion Tool (ECT)\Error_Files
Log File(s) Folder: |C:\Docurnents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT]Wal_Log
History File(s) Folder: |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\History_Files
"Location of formatted output that has NO errors. ""Location of formatted output that has errors.
Set Path
Set Path
Set Path
Set Path
Set Path
The user should select the desired file(s) and click the "Process Existing File(s)" button, or click the "Build a
New File" button without selecting any files. To select multiple files, the user should press "Ctrl" on the
keyboard and click on all of the files to be processed. If the file name contains the transaction type, the ECT
will assume that the named transaction type is the type to process and will go immediately to the File
Processing screen (Figure 4) when "Process Existing File(s)" is clicked. If the transaction type is not
contained in the file name, the user will be asked to specify the transaction type (see Figure 8).
-------
EMTS Conversion Tool
Processing Files
The File Processing screen is depicted in Figure 4. First, the user should complete Step #2, "Enter Company
Info". The required company information includes:
User Login (case sensitive and must be the same as the EMTS login);
Organization ID (EPA assigned, four-digit ID); and
Submittal Creation Date.
Figure 4: File Processing Screen
' BuyTransaction - Processing file: BuyTemplate2.xls
Process Rows Columns Help 5how Log WinZip
Step 82 -Enter Company Info
i.uLiniltdl LiHdliu i ['-ate: JJUJ-iJ^I'j - iutimu-Jiun "
Header Infomation
"^plication Usei ID: |
Transmission ID: TED
Step tt3 - Process And Wrile to XML File
Output File Options I Bill/Stop Recessing
Progress:
Finished Loading Input Data.1 data records read.
The ECT uses the following default settings when processing files: the output file is an uncompressed XML
file, and the output file name is formatted as "TtOrgId_YYYY-MM-DD-HH-MM-SS" where "Tt" is the
transaction type (i.e., Generate) and "Orgld" is the four-digit ID entered in the "Organization ID" field. To
change these default settings, the user should click the "Output File Options" button (see Figure 5).
Figure 5: "Output File Options" Button
Process Rows Columns Help 5how Log WinZip
:" User L>gin: | - Submittal Creation Dale: |2010-01-26 Submission Comment: ^plication User ID: | I*" ^ply User Login Value
Organization ID: | Transmission ID: TBD
SlepJ3 - Process And Write to XML File
(I Output File Options J) EHit/Stop Processing
Process File
PhWK
Finished Loading Input Data.3 data records read.
I
On the Formatted Output File Options screen (see Figure 6), the user can specify the output file type,
compression, and file name. To specify the file name, the user should check the checkbox to override the
default name and then enter a new file name. The ECT automatically appends the date and timestamp of
-------
EMTS Conversion Tool
the file being processed to the end of the new file name. Once a user updates the Formatted Output File
Options screen, the updates become the default setting for subsequent file conversions and remain so until
the user goes back to the Formatted Output File Options screen and changes the settings.
Figure 6: Formatted Output File Options Screen
S] Formatted Output File Options
- n x
File type XML is the ONLY option required for submission/transmission
File Type(s)
! XML - This is the ONLY option required for submission/transmission
Excel - For your use only, not to be transmitted (if transmitted, it will be ignored.)
\~ Text - For your use only, not to be transmitted (if transmitted, it will be ignored.)
File Compression (using WinZip32)
<* Do Not Compress any Files
f* Compress only the XML File for Node Submission/Transmission
C Compress All Output File Types Selected Above |XML, Excel, Text) - It is NOT necessary to include Excel or Text in the compression.
Override Output File Name
The time stamp will still be appended, EMTS does not allow spaces in the file name.
Overridden File Name: |BatchOneGeneratej
Do NOT include the Folder (Path) name. The "Good Files" folder is assumed.
Other File Qption(s)
Use Recommended Names for Column Headers. Text or Excel file only)
f~ Display Processed File
OK
After specifying the output file options, the user should click the "Process File" button. Note that if multiple
files have been selected for processing, only one file is processed at a time. In this case, a "Next file" button
will be visible next to the "Process File" button (see Figure 7). The user should first click the "Process File"
button, verify that the file processes successfully (see the Results of File Processing section in this guide),
and then press the "Next file" button.
-------
EMTS Conversion Tool
Figure?: "Next file" Button
liH Bin/Transaction - Processing file: BuyfiizoBlenders.xls
Process Rows Columns Help Show Log WinZip
Step 82 - Enter Company Info
"User Login: [
Organization ID:
- Submitral Crealion Dale: |2u10-u2-01 Submission Comment:
Header Infomalion
replication User ID: |epa
ID: TED
ftpply User Login Vali
Step 03 - Process And Write to XML File
Output File Optio
Me Hi file j)
Progress:
Finished Loading Input Data.1 data records read.
Creating New Files
If the "Build a New File" button is clicked on the File Selection Screen (see Figure 3), a screen will appear
asking the user to specify the transaction type (see Figure 8).
Figure 8: Selecting the Transaction Type
Choose the Transaction Type
- n x
Select the transaction type from the drop-down pick list below for file:
Select Transaction Type:
Enter Skip this file
Once the user selects the transaction type and clicks "Enter," the File Processing screen appears (Figure 9).
-------
EMTS Conversion Tool
Figure 9: File Processing Screen
Columns Help Show Log WinZip
Step 113 - Enler Company Info
* User Login: |j Submillal Creation Date. 2Q1Q-C4-13 - Submission Comment. I
Header InfomaLion
"^plication User ID: |
Transmission ID: TED
Step iM - Select column to upload
Add New Empty Ron | Copy Row(s) to NeM Rowls) Delete Row|s| |
> Show Legend; <== j
Step 4lb - Process And Write to XML File
Output File Options Exit/Stop Processing
Pi ogress:
o Recommended Defaults
l^ ^pply User Login V
I
First, the user should complete Step #3, "Enter Company Info". The required company information
includes:
User Login (case sensitive and must be the same as the EMTS login);
Organization ID (EPA assigned, four-digit ID); and
Submittal Creation Date.
Under the "Enter Company Info" section, a data grid is displayed. The user should enter the transaction
data in the grid and click the "Process File" button.
Results of Processing
If processing is successful, the screen will display a message that reads "Records were successfully
processed. Formatted to: XML file" (see Figure 10).
-------
EMTS Conversion Tool
Figure 10: A Successfully Processed File
Step tt3 - Process And Write to XML File
Output File Option;
^nit/Stop Process':!
Process File
Progress:
Processing Data. ApproK Records to be processed = 2
Finished processing Input Data. Records processed = 2.2 records were successfully processed.
Formatted to: XML file.
Compressed to: No compressions were selected.
Upon successful processing, the output XML file is written to the following directory:
C:\Documents and Settings\\My Documents\EMTS Conversion Tool (ECT)\Good_Files
If processing is not successful, the screen will display a message that includes, "Missing or incorrect value
for required element(s) in record(s):<...>, refer to columns marked". Figure 11 depicts an example of this.
If the user had previously selected the "Build a New File" option, a data grid will be visible and the
appropriate cell(s) in this grid will change color to indicate where the error has occurred.
Figure 11: An Unsuccessfully Processed File
Step S3 - Process And Write to XML File
Output File Options
But/Stop Recessing
FVocess File
Status
Missing or incorrect value for required element (s) in record (s): 1,
Processing Data, Approw Records to be processed = 1
Finished processing Input Data. Records processed = 1.
1 records were found with errors, these files can not be loaded to the server.
.^.
The ECT maintains a log file, which can be used to view additional descriptions of the errors if processing is
unsuccessful. Clicking the "Show Log" button at the top of the File Processing screen displays the log file in
the log viewer (see Figure 12). This viewer includes buttons which allow the user to print the log and to
select another log file for viewing. Clicking "Exit" closes the log viewer.
-------
EMTS Conversion Tool
Figure 12: Errors Reported in Log File
§nl C:\Documents and Settings \wgo\My Documents\EMTS Conversion Tool (ECT)Wc
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
Finished proce;
1 records were
INFO: {0}
.<><>
Missing: RIN Quantity
-1 2/1 8/2009 3:1 8: 4S PM
Missing data for required fields on record(s): 1, Record will not be processed.
Missing or incorrect value for required element(s) in record(s): 1,
Processing Data. Approx Records to be processed = 1
sing Input Data. Records processed = 1.
found with errors, these files can not be loaded to the server.
III!
M
Print Log OpenAnothe
rj
m\
r Log Exit
If a selected input file is not successfully processed, the ECT will still attempt to create an output XML file.
This file will be located in the following directory:
C:\Documents and Settings\\My Documents\EMTS Conversion Tool (ECT)\Error_Files
Only the data rows with no errors will be written to the output file. All data rows that contain errors will
not be converted to XML.
Processing Multiple Files
If multiple files were selected for processing and the user wishes to process the next file in the batch, the
user should click "Next file," as indicated in Figure 13. Before processing the next file, the user will have to
re-enter the Organization ID and the Submittal Creation Date. Note that the "Next file" button will be
present for all files except the last one in the batch.
-------
EMTS Conversion Tool
Figure 13: Processing Next File
Step tt3 - Process And Write to XML File
Output File Options
But/Stop Recessing
FVocess File k_ Next file
)
Progress:
Status
Recessing Data. Approw Records to be processed = 1
Finished processing Input Data. Records processed =1.1 records were successfully processed.
Formatted to: XML file.
Compressed to: Ho compressions were selected.
------- |