Running the Advanced Conversion Tool
Prior to starting the ECT, the user should place the input files in the following folder:
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. 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
Back - JO Search Folders
Address Q C:\Documents and 5ettings\wgo\My Documents\EMTS Conversion Tool (ECT)
File and Folder Tasks v
My Documents
My Computer
My Network Places
Go
Good Files
Val_Log
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).
United Stales
Environmental Protection
Agency
EPA-420-B-10-009a
March 2010
-------
EMTS Conversion Tool
Figure 2: Start-up Screen
EMTS Conversion Tool (ECT) Front Page
- n x
File
Convert a. delimited text file or Excel file to EMTS XML file (files can be zipped).
Advanced Version
Go
This version allows the flexibilty that the Basic version doesn't.
Basic Version
Go
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 open on the File Selection screen instead of the start-up screen. Click
the "Go" button under Advanced 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) [_ |(r[j®
F
le Help File List View Show Front Page
•vgo: Welcome to Version 1.0.0.8.4. This application
Step 81 - If using a delimited file specify de
Start by putting your data in a compatible delimited fc
The default method is to let this application figure ou
Otherwise, you may choose your own delimiter.
This option is not needed if using an excel file, applit
Show Log WinZip
will format an Excel or delimited file for conversion to XML.
rrnat. Dellmlters
t if it is a tab, comma, or bar delimited format. (T Default (~ Tab <™ Comma
T Bar r Other:)
ation will determine file type by it's extension.
[
Select a Folder on the left pane! and File(s) on the right panel and click on the Process File[s) button to process OR Select the Build a New File button.
Sd EMTS Conversion To< A
;• d Error_Files
i B d Good_Files
| fS --€3 InpuLFiles
d Val_Log
E-d FinePrint files
id FormatXML
I ~l My Google Gadgets
d My Music
i d My Pictures
d My Videos
\ Eld My Virtual Machines
i d New Folder
i B d PDF files
i E d TotafvalidatorTool
+ _| NetHood
d PrintHood
d PrivaclE
d Recent
: d SendTo
Bd Spark
ad Start Menu
d Templates v
< >
Name | Size Modified Attribute |
si BuyDenyExample! Feb3.xls 37,888 2/3/201 02: 07: 47PM A
"B BuyExarnple1_Feb3.xls 37,888 2/3/2010 1:28:37 PM A
1 GenerateAdvancedExample1_Feb3.xls 61,952 2/3/2010 2:1 1:08 PM A
B GenerateExample1_Feb3.xls 61,952 2/3/201 0 1:54:20 PM A
^1 RetireExarnple! Feb3xls 44544 2/3/201 01'27'28PM A
B SellCancelExample1_Feb3.xls 37,376 2/3/201 02: 02: 24PM A
1 SellExample1_Feb3.xls 37,376 2/3/201 0 1:57:57 PM A
i! SeparateExample1_Feb3.xls 43,008 2/3/201 01:26:35PM A
Process
Existing
File(s)
Or
Build a New
File
Or
Exit
nputFile(s) Folder: |C:\Documents andSettings\wgo\My Documents^EMTS Conversion Tool (ECT)Mnput_Files Set Path
'Good File(s) Folder: |C:\Documents and Settings\wgo\My Documents^EMTS Conversion Tool (ECT]\Good_Files Set Path
"Bad File(s) Folder : |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT]\Error_Files Set Path
_og F le(s) Folder : j C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)Wal_Log
"Location of formatted output that has NO errors.
""Location of formatted output that has errors.
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 input files, the user should press "Ctrl" on
the keyboard and click on all of the files to be processed. The input files must be either Excel files or text
files. If a text file is used as input, the delimiter should be specified (see "Step #1" in Figure 3 above). 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
-------
EMTS Conversion Tool
clicked. If the transaction type is not contained in the file name, the user will be asked to specify the
transaction type (see Figure 9).
Processing Files
The File Processing Screen is depicted in Figure 4. 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.
In Step #4, a data grid displays the column headers and data from the input file.
Figure 4: File Processing Screen
£ GeneraleTransaction - Processing file: Generate43247.xls
Process Rows Columns Help 5how Log WinZip
'-' User Login: |3S
'Organisation ID: |~~
Step tt4 - Select eo
Add New Empty Row
* SubmitSal Creation Date:
Copy Rowjs) to New Row(s)
£010-02-01 Submission Comment:
Delete Rowls) Set Columns to Recommended Defaults Import/Export Company Column Names
Show Legends
"Application User ID: |epa
Transmission ID: TBD
f? Apply User Login
Select the appropriate columns from the drop-downs below. Refer to the legend on the middle tight as to whether fields are required o
NOT on the input file.
iows can be sorted by dirking on [he column header. Changes made will be reflected in rhe new output file and
Required Fields
' Fuel Code
* BatchVolume
* Fuel Category Code
" Process Code
* RINQuantity
* Generate Facility Identifier
" Batch Number Tent
Fuel Code _^J
Batch Volume ^
Fuel i.at&qory Code f
Flocess Code T
RINQuantity v
Generate Facility Identifier -r
DenaturantVolume (Denature Volume ^
EquivalenceValue ] Equivalence Value T
Generate Organisation Ideniifier (Generate Organization Identifier -r
Transaction Detail CommentTeKt (Transaction Detail Comment Tent T
Import Facility identifier (import Facility Identifier jj
All Remaining Fields
zJ
Co Product Codel (CoRroduct Code 1 _^J
Co Pfoduct Detail CommentTeHtl |CoFtoduct Detail Comment Tent 1 T |
Co Product Code2 jCoFroduct Code 2 jrj
Co Pfoduct Detail CommentTeKt2 CoFToduet Detail Comment Tewt 2 T|
Co Product Code3 [CoFtoduot Code 3 ^J
Co Pfoduct Detail CommentTeKtS [CoProduct Detail Comment TeKl 3 j^J
* Feedstock Code 1
* Rene wableBiomass Indicator 1
' Feedstock Volume!
' Feedstock Measure Codel
* Feedstock Detail CommentTeml
* Feedstock Code2
* Renewable Biomass Indicator 2
1 FeedstockVolume2
1 Feedstock Measure Code2
" FeedstockDetailCommentTe>it2
* Feedstock CodeS
R-nfeW'-iblfcriioiri.a.;.- Incli'jnlC'ro
* FeedstockVolume3
" Feedstock Measure CodeS
" FeedstockDetailCommentTeKtS
•iirrium - J sets
Feedstock Code 1 T
Renewable Biomass Indicator 1 _^_|
Feedstock Voiume 1 _»J
Feedstock Measure Code 1 -*
Feedstock Detail Comment Tent 1 _rj
Feedstock Code 2 •»]
Renewable Biomass Indicator 2 _^j
Feedstock Volume 2 T
Feedstock Measure Code 2 *
Feedstock Detail Comment Ten! 2 _^J
Feedstock Code 3 _rj
Renewable Eiomass Indicators » j
Feedstock Volume 3 _rj
Feedstock Measure CodeS _rj
Feedstock Detail Comment Tent 3 ^rj
Step tt5 - Process And Write to XML File
Output File Options Exit/Stop Processing
Piogiess:
Finished Loading Input Data.1 data records read.
-------
EMTS Conversion Tool
The File Processing screen indicates whether a field is required, conditional, or optional using color-coded
labels (defined in the legend). Additionally, a list of allowed values is included to the left of the legend. Due
to space limitations while processing generate transactions, you must click the "Show Legends" button to
display the List of Values and Legend.
Mapping User-specified Column Headers
Below the data rows, there is an area where the fields that will be written to the output XML as labels need
to be mapped to the appropriate column headers. The tool has the ability to set these drop-downs to the
"recommended defaults." These defaults are the column headers used in the basic templates provided by
EPA. If the user is using these templates, setting the columns to the recommended defaults would be the
easiest way to map the data.
First, click the "Set Columns to Recommended Defaults" button (see Figure 5).
Figure 5: Selecting Recommended Default Headers
Step tt4 - Select column to upload
Add New Empty Row Copy Row(s) to New Row(s)
Delete Row(s)
.Set Columns to Recommended
^
I Defaults])
Select the appropriate columns from the drop-downs below. Refer to the legend on the 11 ildUL i !yl il uj tu n I lutl ILM ii_lds are require
NOT on the input file.
The column headers will be populated with the recommended default headers (see Figure 6).
Figure 6: Drop-downs that Must Match the Columns
, T ,-, {-, |, .,. Transaction Partner Organisation Iden T
Transaction Partner Organisation Identifier
1 Assignment Code [Assignment Code v \
* Fuel Code |Fuel Code f |
' RINQuantity |RIN Quantity jrj
1 Transaction Partner Organisation Name (Transaction Partner Organisation Nam -r \
1 TransactionDate [Transaction Date T |
-RINYear |RINYear _rj
Optional and Conditionally Optional
BatchVolume
PTD Number
Price Per Gallon
PrioePerRIN
Transaction Detail Comment
GenerateQrganlsation Identifier
Generate Facility Identifier
Batch Number
SupportingDocumentTewt
SupportlngDocument Number
Fields ]
Batch Volume T |
PTD Number -r \
Price Per Gallon T |
Price Per RIN -r \
Transaction Detail Comment ^ |
Generate Organisation Identifier •* \
Generate Facility Identifier T |
Batch Number -r \
Supporting Document Tent T |
Supporting Document Number T- j
-------
EMTS Conversion Tool
Figure 7: Matching Default Columns to Labels
BuyTransaction - Processing file: BuyExample.xls
Process Rows Columns Help Show Log WinZip
Step S3 - Enter Company Info
: * User Uigin:
1 Organization ID:
Step #4 - Select column to upload
Add New Empty Row Copy Row(s) to New Row(s) Delete Row(s)
1 Submittal Creation Date: \2010-02-01 Submission Comme
Set Colu
Select the appropriate columns from the drop-downs below. Refer to the legend on the n
NOT on the Input file.
Transaction Partner
Organization Identifier
Transaction Partner
Organization Name
action Partner Organisation Idetfr
* Assignment: L03e
ssgnment ioe
If the recommended column headers are not used in the input file, the user will need to select the
appropriate column headers in the drop-down menus. In Figure 8, a column header of "Trade ID" was used
in the input file for the Transaction Partner ID. This value must be selected in the drop-down menu next to
the "TransactionPartnerOrganizationldentifier" field.
-------
EMTS Conversion Tool
Figure 8: Matching User-Defined Column Headers to Labels
§H BuyTransaction - Processing file: BuyExample.xls
Process Rows Columns Help Show Log WinZip
Step 83 - Enter Company Info
: User Login: |epa
1 Submittal Creation Date: 2010-02-01
Submission Comme
* Organisation ID: |
Step tt4 - Select column to upload
Add New Empty Row
Copy Rowfs) to New Row(s) Delete Row(s) Set Colui
Select the appropriate columns from the drop-downs below. Refer to the legend on the rr
NOT on the input file.
Transaction Partner
Organization Name
.^EPA Fuels
RIH
Quantity
2000
Bat.
Voli
P^TIJrrrl Finmr
(^Transaction Partner Organization Identifie^J^^
1 Assignment Lode
1 Fuel Code
1 RINQuantity
'Transaction Partner Organisation Name
1 RINYear
1 Buy ReasonCode
Supporting Document Number Text 1 A
Supporting Document Number Tewt 2
Supporting Document Tent 1
Supporting Document Tent 2
[ransaction Date
rjsaction Detail Comment Tent
•i Partner Organisation Na"*' v
Buy Reason!
Note that information that is manually written into the data grid does not modify the input file. To save this
information to an Excel spreadsheet, the user must select the Excel file type by selecting the "Output File
Options" button under "Process and Write to XML File" near the bottom of the screen.
For required fields, a column name must always be chosen from the corresponding drop-down list For
conditional fields and optional fields, selecting a non-null column name from the corresponding drop-down
list indicates that the field should be included in the output XML. Otherwise, the field will not be included
in the output XML, even if data for this field is visible in the grid.
-------
EMTS Conversion Tool
Importing/Exporting User Defined Column Names
The user can optionally select to export the user-defined column names for later use. This can be done
either before or after the "Process File" button has been clicked. To export the column names, click the
"Import/Export Company Column Names" button (see Figure 9).
Figure 9: Import/Export Company Column Names Button
§9 BuyTransaction - Processing file: BuyExample.xls
Process Rows Columns Help Show Log WinZip
Step «3 - Enter Company Info —-^—
:-User Login: |epa • Submittal Creation Date: |2010-OS-01 Submission Comment:
* Organization ID:
Step B4 - Select column to upload
Add New Empty Row
s
Copy Row[s) to New Row(s) Delete Row(s) Set Columns to Recommended Defaults f Import/Enport Company Column Nam
"~"Sv
ames Jj
Select the appropriate columns from the drop-downs below. Refer to the legend on the middle right as to whether fields are required or not. 'Rows can be sorted by clicking on the column header. C
NOT on the input file.
Transaction Partner
Organization Name
RIN
Quantity
Batch
Volume
Fuel
Code
Assignment
Code
RIN
Year
Buy Reason
Code
RIN Price
Amount
The Company Column Names dialog box will be displayed (see Figure 10).
-------
EMTS Conversion Tool
Figure 10: Column Name Import/Export Screen
H3 Company Column Names
Exit Options Help Show Log
Export to Existing Profile
Delete Profile
Import Profile
Exit
After clicking the "Export New Profile" button, the user will be prompted to specify a name and location for
the profile (see Figure 11).
Figure 11: Saving Profile with User-Defined Column Names
Once this profile has been created, it can subsequently be imported by clicking the "Import/Export
Company Column Names" button. The saved profile will be displayed on the Company Column Names
screen (see Figure 12).
-------
EMTS Conversion Tool
Figure 12: Company Column Names Screen with Saved Profile
H3 Company Column Names
Exit Options Help Show Log
C:\Doeuments and Settings'\wgo\My Docurnents\EmtsConversionTool\GenerateTransactiori200911314440.ini
Export New Profile
Export to Existing Profile
Delete Profile
Import Profile
Exit
The user can then select the profile and click "Import Profile." This will load the saved column names into
the drop-downs used for mapping. Alternatively, the user can click on "Export to Existing Profile" to
overwrite the previously saved profile with new user-defined column headers.
Output File Options
Once the column headers are selected and the user information is complete, the user can adjust the ECT
default settings. 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 13).
Figure 13: "Output File Options" button
Step tt5 Process And Write to XML File
"" ' '—i
Output File Options J) Enit/Stop Processing
~"i
Recess File
Progress:
Status
Finished Loading Input Data.3 data records read.
10
-------
EMTS Conversion Tool
On the Formatted Output File Options screen (see Figure 14), 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 transaction type of the
file being processed to the beginning of the new file name. In the example in Figure 14, if a Generate file
were being processed and the user wanted to name the file "01-26-2010," the output file name would be
"Generate01-26-2010.xml." 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 14: Formatted Output File Options Screen
IB Formatted Output File Options
File type XML is the ONLY option required for submission/transmission
File Type(s)
!• XML - This is the ONLY option required for subrnission/transmission
Excel - For your use only, not to be transmitted (if transmitted, it will be ignored.)
l~ 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
l^r Override the default name of TtQrgld_YYVY-MM-DD-HH-MM-SS where Tt is the Transaction Type. The new file name will be
prepended with the Transaction Type.
Overridden File Name: 101-26-2010
Do NOT include the Folder (Path) name. The "Good Files" folder is assumed.
Other File Option(s)
Use Recommended Names for Column Headers. Text or Excel file only)
l~~ Display Processed File
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 15). The user should first click the "Process
File" button, verify that the file processes successfully (see the Results of File Processing section in this
Quick Guide), and then press the "Next file" button.
11
-------
EMTS Conversion Tool
Figure 15: "Next file" Button
Step «5 - Process And Write to XML File
Output File Option;
Ewit/Stop Processing
Status
Process File
Finished Loading Input Data.5 data records read.
Progress:
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 16).
Figure 16: Selecting the Transaction Type
Choose the Transaction Type
- ox
Select the transaction type from the drop-down pick list below for file:
Select Transaction Type:
Enter Skio this file
Once the user selects the transaction type and clicks "Enter," the File Processing Screen appears (Figure
17).
12
-------
EMTS Conversion Tool
Figure 17: File Processing Screen
'• GenerateTransattion - Processing file:
Process Rows Columns Help Show Log WinZip
Step 83 - Enter Company Info ^
-User Login: f^S' Submitlal Creation Date: J2Q 10-02-01 Submission Comment:
* Organisation ID: |
Step 1M - Select column to upload
Headei Infomation
Vippli cation User ID: j
Transmission ID: TBD
1 Appfy User Login Va
Add New Empty Row Copy Rowfs) to New Row(s) Delete Rowfs)
Select the appropriate columns from the drop-downs below. Refer to the legend on the middle right as to whether fields are required or not. Rows can be sorted by flicking on the column header. Changes made will be reflected in the new output file and
NOT on the input file,
#
Production
Date
Batch Denaturant
Equivalence
Value
PIN
Quantity
Import Faci
Identifier
ity
Iran
Com
action Detail
nentText
Identifier
Generate Facility
Identifier
Bat
Nur
Required Fields
* Fuel Code
" Batch/Volume
" FudCalegoryCode
* Production Date
1 Process Code
' RINQuantily
1 Generate Fadityiden
1 Batch NumberTeHt
Optional Fields
DenaturantVolume
EquivalenceValue
Generate Organization
Transaction Detail Comi
Import Facility Identifier
Identifier
•peritTenl
CoProduct Fields - Up to 3 sets
Co Product Code 1
Co Product Detail Comment Tent
Co Product Code2
Co Product Detail Comment Tent
Co Product CodeS
Co Product Detail CommentTewt
Feedstock Fields - Min
* Feedstock Code 1
1 Renewable Biomass Indicator!
" Feedstock Volume 1
' Feedstock Measure Code 1
* FeedstockDetailCommentTewtl
* Feedstock Cotte2
" Renewable Biomass Indicator 2
' FeedstockVolume2
* Feedstock Measure Code2
* Feedstock Detail Comment Te«t2
* Feedstock Code3
" RenewableSiomassindicatorS
" FeedstockVolume3
' Feedstock Measure CodeS
1 Feedstock Detail CommentTeKt3
Step 85 - Process And Write to XML File
Output File Qptk
Enit/Stop Proi
Process File
Progress:
s set to Recommended D
iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiifii
iiiimmmmimmmimimiiimimmmmmmmmi
Note that in this version of the File Processing Screen, there are no drop-down menus with column headers,
since the default column headers will always be used when the user elects to build a new file.
The user should first fill in the "Enter Company Info" portion of File Processing Screen. The company
information required 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.
13
-------
EMTS Conversion Tool
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 18).
Figure 18: A Successfully Processed File
Step 115 - Process And Write to XML File
Output File Options
Exit/Stop Roces:
Rocess File
Progress:
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." In addition, the appropriate cell(s) in
the data grid will change color to indicate where the error has occurred (see Figure 19).
14
-------
EMTS Conversion Tool
Figure 19: Indication of Error in File
$
1
"Fuel
Code
4
"Process
Code
200
"Production
Date
2009-12-02
"Fuel Category
Code
40 <
"Batch
Volume
C ->
\
Denaturani
Volume
Equivalence
Value
•1.0
"RIN
AmoL
1900
Required Fields
' Fuel Code
" BatchVolume
* Fuel Category Code
i p, i • PI t-
o uc ion a e
* FVoces-^Code
1 RINQuantity
z Generate Facility Identifier
1 Batch NumberTewt
Denaturant Volume
Equivalence Value
Generate Qrganizationldentifier
Transaction Detail CommentTent
Import Facility Identifier
All Remaining Fields
Fuel Code ^J
Batch Volume T |
Fuel Category Code w |
.
Pr r rl 1
^J
RIN Amount T I
Batch Number Tent v I
Denaturant Volume T |
Equivalence Value T
Generate Organisation Identifier T |
Transaction Detail Comment Tew t ^ j
Import Facility Identifier T- |
^J
Co Product Fields - Up to B sets
Co Product Code 1 \
Co Roduct Volume 1 \
Co Roduct Measure Code!
Co Roduct DetdilCommentleHt 1
V
Co Roduct Code2
\
Co RoductVolume2
Co Roduct DetailCommentTeHty
Co Roduct Code3 \
CoRoductVolume3 \
Co Roduct Measure Code3 i
Co Roduct Detail CommentTentS \
\
\
CoFtoduct Code 1 «r |
CoFtoduct Volume 1 jj
CoFtoduct Measure Code 1 f 1
Co Product Detail Comment Text 1 ^ 1
CoFtoduct Code 2 ^r |
r f\ H -r M r H ? 1
^ — 1
Co Product Detail Comment Text 2
-------
EMTS Conversion Tool
Figure 20: Errors Reported in Log File
HI C : \Doc ume nts an d Setti ngsXwgoXMy Doc ume n tsXEMTS Co n ve rsio n Too 1 ( EC T)\Va LLogXEmtsCo nversion... _ D | X
:inished processing Input Data. Records processed = 1.1 records were successfully processed.
Formatted to: XML file.
Compressed to: No compressions were selected.
NFO: {0} Input file: \Generale2.xls <><><>
INFO: {0}
INFO: {0} Missing: Batch Volume
INFO: {0} -12/1 1/2009 4:50:1 5PM
NFO: {0} Missing data for required fields on record(s): 1, Record will not be processed.
NFO: {0} Missing or incorrect value for required element(s) in record(s): 1, refer to columns marked
INFO' {0} ... . .
NFO: {0} Processing Data. Approx Records to be processed = 1
-inished processing Input Data. Records processed = 1 .
1 records were found with errors, these files can not be loaded to the server.
<
Yl
•) m\
Print Log Open Another Log Exit
j&
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.
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. Data rows that contain errors will not
be converted to XML.
Processing Multiple Files
If the user chooses to process multiple existing files and wishes to process the next file in the batch, the
user should click "Next file." as indicated in Figure 21. Before processing the next file, the user will have to
re-enter the Organization ID and the Submittal Creation Date. Also, if the input files do not use the same
column headers as the default Excel templates created by EPA, the user may have to re-specify the column
headers in the dropdown menus. Note that the "Next file" button will be present for all files except the last
one in the batch.
16
-------
EMTS Conversion Tool
Figure 21: Processing Next File
Step tt5 - Process And Write to XML File
Output File Options
But/Stop Recessing
Process File
Status
Recessing Data. ^pproH Records to be processed = 1
Finished processing Input Data. Records processed =1. 1 records were successfully processed.
Formatted to: XML file.
Compressed to: No compressions were selected.
Progress:
17
------- |