Running the Advanced 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

      Back T          ]T      Search
                              Folders
 Address
           :\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)
Make a new folder
Publish this folder to
the Web
Share this folder
                              £rroL.Fi|esj
                                     History_Fiies
                                     Val_Log
                                                                   Good Files
(        ) Input_Files   )
                                                                                        t
                                                                                              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-009b
                                               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 Advanced version, 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
File Help File List View Show Front Page
Welcome: wgo . This application will format an Excel
Step tt1 - If using a delimited file specify de
Start by putting your data in a compatible delimited ft
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
or delimited file for conversion to XML. For questions concerning cornpatibiltv refer to Help/About ECT.

rmat. Dellmiters
if it is a tab, comma, or bar delimited format. (7 Default (~ Tab (~ Comma
r Bar C Other: |
ation will determine file type by it's extension.




Select a Folder on the left panel and File(s] on the right panel and click on the Process File(s) button to process OR Select the Eluild a New File button.

|_J Error_Files
i fi-£l Good_Files
i Si -£3 InpuLFiles
U Val_Log
i ffil FinePrint files
-d FormatXML
LJ My Google Gadgets
I ~1 My Music
j-d My Pictures
-d My Videos
i BO My Virtual Machines
i--d New Folder
i-d PDF files
i j-d TotarValidatorTool
[j]-d NetHood
i--d PrintHood
d PrivaclE
J--Q Recent
• d SendTo
El d Spark
[jd Start Menu
! d Templates v
< i _ 2j»L " ' i m~
Name | Size Modified Attribute
H BuyDenyTemplate.xls 30,720 3/1 0/201 01 0:56: 05 AM A
8 BuyTemplate.xls 27,136 4/14/2010 3:49:52 PM A
B BuyTemplate2.xls 30,720 3/1 0/201 01 0:56: 05 AM A
1 QenerateTemplate.xls 51,712 4/1 4/201 03: 49:52 PM A
B RetireTemplate.Kls 40,960 4/14/2010 3:49:52 PM A
=* SellTemplate.xls 33,792 4/14/2010 3:49:52 PM A
B SellTemplateCanceLxIs 37,376 3/9/2010 11:00:27 PM A
1 SeparateTemplate.xls 39,424 4/1 4/201 03: 49:52 PM A

Process
Existing
File(s)
Or
Build a New
File
Or
Exit





nput File[s] Folder: | C:\Docurnents and Settings\wgo\My DocumentsVEMTS Conversion Tool (ECT]Mnput_Files Set Path
*Good File(s) Folder: | C:\Documents and SettingsSwgeAMy Documents\EMTS Conversion Tool (ECT)\Good_Files Set Path
"Bad File(s) Folder : | C:\Docurnents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT]\Error_Files Set Path

og File(s) Folder |C:\Docurnents and Settings\wgo\My DocumentsVEMTS Conversion Tool (ECT]\Val_l_og Set Path
History File(s) Folder: CADocuments 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


^
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
   Process  Rows  Columns  Help  Show Log  WinZip
   Step 03 -Enter Company Into
  •User Login: |         - Submiltal Creation Dale: 12010-04-1
   Clrgamzatiori ID: |
  Step 114 - Select column to upload
                                                                                                 Header Information
                                                                                                 Transmission ID: TBD
                               Lele:e II,:. '|s |   let Lolumns :: Recommended Defaults
                                                               lr='Ort''lL:-:p:r: Hompam Lc urfi Names

 Required Fields
 Fuel Code
 BatchVohme
 Fuel Category Code
 RoductionDate
 RooessCode
 RIN Quantity
 Generate Facility
 Batch Number Te:
-Optional Fields	
 DenaturantVohme
 EquivalenoeValue
 GeneraleOrganiEationldentilier
  n sa c tio n D e t a il Co mm e nt Ten t
 Import Facility Identifier






entitier

Fuel Code
Batch Volume
Fuel Category Code
Reduction Date
Process Code
RIN Quantity
Generate Facility Identifier
Batch Number Text
d
_^j
d
3
d
^J
^J
E
CoFtoduct Fields - Up to 3 sets
 CoRoductCodel
 CoRoduct Detail CommentTeHtl
 Cc,ProductCode2
 Co Product Detail Co mm en [Tent 2
 CoRoduct Code3
 CoProdui:tDe:ailLcin-me--iiTeHi3
                                                                  =roduct Detail Comment lewtJ
                                                                  'Product CodeS
                        | Denaturant Volume
                        | Equivalence Value

                             on Detail Comment Tent
                        F
Feedstock Fields - Minim
' FeedstockCodel
 Renewable Fjicimass Indicator!
1 FeedstockVolumel
' Feedstock Measure Code 1
1 Feedstock Detail CommentTe»t1
1 Feedstock Code2
' RenewableBiomasslndicaior2
' FeedstockVolume2
' Feedstock Measure Code2
1 Feedstock Detail CommentText2
 Feedstock Code3
' RenewableBiomasslndicatorS
1 FeedstockVolumeS
' Feedstock Measure CodeS
1 Feedstock Detail CommentTextS
                                                                                                          Feedstock Volume 1
                                                                                                          Feed;tu':l ['St-ail Commant Tent 1
                                                                                                          Feedstock Code 2
                                                                                                          Feedstock Volume 2
                                                                                                              :l Measure Code 2
                                                                                                             t':":! [ ctjil LumTient Tent 2  T
                                                                                                          Feedstock Code 3
                                                                                                          Feedstock Volume 3
                                                                                                              d Measure Code 3
                                                                                                             t':":! [ ctjil LomTMint Tent 3  T
   Step US  Piocess And Write to XML File
    Output File Options  But/Stop Recessing
   Progress:
                            Finished Loading Input Data.1 data records read.
  •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••I

-------
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 set of drop-downs which display 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 legend and the allowed values.

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 #4 - Select column to upload
      Add New Empty Row
Copy Row(s) to New Row(s)
Delete Rowfs)
Set Columns to Recommended
  ^
I Defaults])
     Select the appropriate columns from the drop-downs below. Refer to the legend on the midUL ligl it uj to i il iLlI lUr Melds are require
     NOT on the input file.
The drop-downs will be populated with the recommended default headers (see Figure 6), and will match
the column headers of input files that use the recommended defaults (see Figure 7).
Figure 6:  Drop-downs that Must Match the Columns
Required Fields
Transaction Partner Organisation Identifier
Assignment Code
1 Fuel Code
': R IN Quantity
1 Transaction Partner Organisation Name
1 RIHYear
Buy Reason Code
1 Transaction Date
Transaction Partner Organisation Ident T
Assignment Code ^ |
Fuel Code •»•
RIN Quantity -r \
Transaction Partner Organisation Nam T |
RIN Year jrj
Buy Reason Code T |
Transaction Date T

Supporting Document Fields - Up to 2 sets
Supporting DocumentTent1
Supporting Document NumberText 1
Supporting DocumentTent2

Supporting Document Tent 1 T |
Supporting Document Number Tent 1 f \
Supporting Document Tent 2 T |
Supporting Document NumberTeKt2 | Supporting Document Number Tent 2 _rj
Optional Fields
BatchVolume
RINPriceAmount
Transaction Detail CommentTeHt
PTD Number
Gallon Price Amount
Generate Organisation Identifier
Batch NumberTent
Generate Facility Identifier
All Remaining Fields
Batch Volume
RIN Price Amount
d
d
Transaction Detail Comment Tent T |
PTD Number
Gallon Price Amount
Generate Organisation Identifier
d
d
d
Batch Number Tent T |
Generate Facility Identifier T |
r
d


-------
EMTS Conversion Tool
Figure 7:  Matching Default Columns to Labels

                    OdT
uvTransaction - Processing file: BuvExamole.xls
                      Process   Rows   Columns   Help   Show Log   WinZip
                      Step S3 - Enter Company Info
                     : * User Login:
                     1 Organization ID:
                      Step tt4 - Select column to upload
                    1 Submittal Creation Date:  2010-02-01
                                                 Submission Comme
                      Add New Empty Row
                 Copy Row(s) to New Row(s)
Delete Row(s)
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
                        Required Fi=lrlc
                      (^transaction Partner Organisation IdeTIjfjer^^30110" Parlner Organization IdentwJ)
                       * Assignment: L03e                   Assignment Code
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
                       BuyTransaction - Processing file: Buy Example.xls
                      Process   Rows   Columns    Help   Show Log   WinZip
                      Step tt3 - Enter Company Info
                      : User Login: epa
                                             : Submittal Creation Date:  2010-02-01
                                                                          Submission Comme
                     * Organisation ID: |
                      Step tt4 - Select column to upload
                      Add New Empty Row
Copy Row(s) 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
Bat.
Vol.
                                                                     2000
                      {^Transaction Partner Organisation ldentifie£!>-ffl
                        Assignment Lode

                        FuelCode

                        RINQuantity

                        Transaction Partner Organisation Name

                        RINYear

                        Buy Reason Code
               Supporting Document Number Tewt 1  A '
               Supporting Document Number Tent 2
               Supporting Document Tent 1
               Supporting Document Tent 2

               transaction Date
                Dsaction Detail Comment Tent
              | Transaction Partner Organisation Ma"** v

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
§8 BuyTransaction - Processing file: BuyExample.xls
  Process   Rows  Columns   Help   Show Log   WinZip
  Step 83 - Enter Company Info        —-^—
 :'UserLj>gin: |spa        • Submittal Creation Date: |2010-02-01   Submission Comment:

 * Organization ID: |
  Step tt4 - Select column to upload

  Add Hew Empty Row   Copy Row(s) to Hew Row(s)   Delete Row(s)   Set Columns to Recommended Defaults    Import/Export Company Column Hames J)

  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
 IS Company Column Names
   Exit   Options   Help  Show Log
      Export New Profile
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
 IS Company Column Names
   Exit   Options   Help  Show Log
      C:\Documents and Settings\wgo\My Documents\EmtsConversionTool\GenerateTransaction2Q0911314440.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
  f—;    ;—4.
   Output File Options JJ Bull/Stop Processing
    —
     Recess File
  Progiess:
      Status
                               Finished Loading Input Data.3 data records read.


-------
 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 date and timestamp of
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 14: Formatted Output File Options Screen
     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 submissionAransmission
           Excel - For your use only, not to be transmitted (if transmitted, it will be ignored.)
        I" 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
        (" 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:  |BatchOneGenerate|
             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)
         ~ 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 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.


-------
EMTS Conversion Tool
Figure 15: "Next file" Button
  Step 85 - Process And Write to XML File
   Output File Option;
Ewit/Stop Processing
      Process File
  Progress:
                                   Status
                                  Finished Loading Input Data.5 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 16).
Figure 16: Selecting the Transaction Type
                        HI Choose the Transaction Type
                                                      -   n x
                         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).


-------
 EMTS Conversion Tool
Figure 17:  File Processing Screen
  Process  Rows  Columns  Help  Show Log  WinZip
  Step «3 - Entei Company Info       -^^^—
 * User Login: ||

  Organisation ID: |
  Step 04 - Select column to upload

  Add New Empty Row  Copy Row(s) to New Row(s]
               1 Submittal Creation ['ale ZOICi-OH'S - | Submission Comment:
                                                                                              Headei Iniomation
                                                                                              '^plication User ID: |
                                                                                                               IV Apply User Login Value
                                           ==> Show Legends <==
  Select the appropriate columns From the drop-downs below. Refer to the legend on the middle right as to whether held; are required or not. Row? tan be sorted by eliding on the column header Changes made will be reflected in the n.
  NOT on the input tile.
   Required Fields
   Fuel Code
   Batch Volume

   Fuel Category Code

   Production Date

   ProcessCode

   RIHQuantitj.

   Ge ner ate Fa c i lity Identifier

   6 = t;h Number TeHt
   Optional Fields
  De na tur an t Volum e
  EquivalenceValue
  Generate Drganizatic
       i Detail Cor
  h-iFortFadityldeirnei
CoR
 Col
CoRoduot Fields - Up to 3 set:
  .Product Code 1

 Co Roduct Detail Comment
 CoRoductCode2

 C o Ro du c t De tail Com men tie i
 CoRoductCodeS
 CoRodijctDetailCommenf^

Feedstock Fields - Mini
1 Feedstock Code 1

r Renewable Biomass Indicator 1
" FeedstockVolumel

" FeedstookHeasuteCodel
1 Feedrtock Detail CommentTentl
1 Feedstock Code2

* Renewable Biomasslndicatot2
' FeedstockVolume2
1 Feedstock Measure Code2

1 Feedstock Detail CommentTenl2
' Feedstock CodeS

* Renewable Biomass Indicators
* FeedstockVolume3
1 FeedstockMeasureCode3

r Feedstock Detail CommentTeulS
  Step tt5 - Piocess And Write to XML File

   Output File Options  Exit/Stop Rocessing
        -s File
  Progress:
                                o Recommended Defaults
 Illlllllllllllllllllllllllllllllllllllllllllllll
                                                                                        Illllllllllllllllllllllllllllllll
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.


-------
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 85 - Process And Write to XML File
  Output File Options
Exit/Stop Roces:
    FVocess 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).


-------
 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
CL . ^
f

Denaturani
Volume



Equivalence
Value
1.0


"RIN
Am 01
1900

Required Fields
1 Fuel Code
" BatchVolume
^ Fi Ji=*ir^ffinnrurnrli=*

i P, J •.• p.
o uc ion a e


R IN Quantity

Generate Facility Identifier

1 Batch NumberTewt


Denatur ant Volume
Equivalence Value
Generate Organization Identifier
Transaction Detail CommentTeKt
Import Facility Identifier
All Remaining Fields

Fuel Code ^J
Batch Volume T |
1

.







Batch Number Tent T 1


Denaturant Volume T \
Equivalence Value ^ |
Generate Organisation Identifier T \
Transaction Detail CommentTeKt T |
Import Facility Identifier T- |
:d
CoProducl Fields - Up tofe sets
Co Product Code"!
Co Roduct Volume 1
1
Co Roduct Measure Code "i
I
Co Roduct Detail Comment Vent 1
1
CoRoductCode2
1
Co Roduct Volume2



CoRoductDetailCommenlTent^
^^^^ 1
CoRoductCode3
Co Roduct Volume3
Co Roduct Measure Code3
Co Roduct Detail CommentTewtS \
\
1

CoProduct Code 1 ^|
Co Product Volume 1 f\
' 	 '
CoProduct Measure Code 1 -»•

CoProduct Detail Comment Tent 1 -»•

CoProduct Code 2 ^ |



r Pr H M r H ? 1
__l
CoProduct Detail Comment Text 2 -r \

CoProduct CodeS f \
Co Product Volume 3 T |
CoProduct Measure CodeS T |
CoProduct Detail Comment Text 3 f |


 Step tt5  Process And Write to XML File
   Output File Options
F_nit/Stop Rocessing
     Recess File
Status                                              \ —
Missing or incorrect value for required elements) in record(s): y**Tefer to columns
Rocessing Data. Approw Records to be processed = 1    ^**"~ i <  ,
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 20).


-------
EMTS Conversion Tool
Figure 20: Errors Reported in Log File
H C:\Documents and Settings\wgo\My DocumentsXEMTS Conversion Tool ( EC T) \Val_Log\EmtsCon\
version... [_ ](n][x]
Finished processing Input Data. Records processed = 1.1 records were successfully processed.
Formatted to: XML file.
Compressed to: No compressions were selected.
ihjpn. fn\
INFO: {0} I nput file: \Generate2.xls <><><>
INFO: {0}
INFO: {0} Missing: Batch Volume
INFO: {0} -12/1 1/2009 4: 50: 15PM
INFO: {0} Missing data for required fields on record(s): 1 , Record will not be processed.
INFO: {0} Missing or incorrect value for required element(s) in record(s): 1, refer to columns marked
INFO' {0}
INFO: {0} Processing Data. Approx 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.
< i


Print Log QpenAnothe

i
r Log Exit

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.


-------
EMTS Conversion Tool
Figure 21:  Processing Next File
  Step 85 - Process And Write to XML File
    Output File Options
£nit/Stop Processing
      Process File
  Progress:
 Status
Processing Data. ApproH 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.


-------