EMTS Conversion Tool (ECT)
            User's Guide


            Version: L5
SEPA
United States
Environmental Protection
Agency

-------
                   EMTS Conversion Tool (ECT)
                              User's Guide


                               Version:  L5
                                Compliance Division
                           Office of Transportation and Air Quality
                           U.S. Environmental Protection Agency
SEPA
United States
Environmental Protection
Agency
EPA-420-B-11-059
December 2011

-------
                                       Table of Contents
                                                                                           Page
Section 1: Overview	1

  1.1   Purpose and Description	1
  1.2   Overview of the ECT Screens	1
  1.3   Transaction Types	6
  1.4   Required, Conditional, and Optional Fields	7
  1.5   Setting Up the Input Files	7
  1.6   Transaction Data Elements in the ECT	8

    1.6.1     Generate Transaction Data Elements	8
    1.6.2     Separate Transaction Data Elements	9
    1.6.3     Sell Transaction Data Elements	10
    1.6.4     Buy Transaction Data Elements	11
    1.6.5     Retire Transaction Data Elements	11

  1.7   Data Validation Checks in the ECT	12

Section 2: Installing and Setting Up the Conversion Tool	14

  2.1   System Requirements	14
  2.2   Obtaining the ECT and Transaction Templates	14
  2.3   Installing the ECT	16
  2.4   Setting Up the ECT	22

    2.4.1     Directories	22
    2.4.2     Folder:  Files to Process Folder	26
    2.4.3     Folder:  Good File(s) Path	26
    2.4.4     Folder:  Bad File(s) Path	26
    2.4.5     Folder:  History File(s) Path	26
    2.4.6     Folder:  Log File(s) Path	26

  2.5   Setting File Options	29

Section 3: Uninstalling the Conversion Tool	31

Section 4: Running the Basic Conversion Tool	36

  4.1   Opening the Basic ECT	36
  4.2   Selecting Files	37

-------
                                    Table of Contents f cont.l
                                                                                          Page
  4.3    Processing Files	39
  4.4    Creating New Files	41
  4.5    Results of Processing	42
  4.6    Processing Multiple Files	44

Section 5:  Running the Advanced Conversion Tool	45

  5.1    Opening the Advanced ECT	45
  5.2    Selecting Files	46
  5.3    Processing Files	48
  5.4    Mapping User-specified Column Headers	49
  5.5    Importing/Exporting User Defined Column Names	52
  5.6    Output File Options	54
  5.7    Creating New Files	56
  5.8    Results of Processing	58
  5.9    Processing Multiple Files	60

-------
Section 1: Overview

    1.1   Purpose and Description

The EMTS Conversion Tool (ECT) has been developed to assist users in the preparation of XML files for
submission to the EMTS. The ECT takes as input Excel or text files and produces as output XML files that
conform to the EMTS schema specification (see Appendix C for a logical representation of this schema).
Within the ECT, users may select to use either the Basic Version or the Advanced Version.

    •   Basic Version:  This version takes as input files that use EPA-defined standard column headers, or
       allows user to input data manually. EPA has created several basic Excel templates  that use these
       headers  and which are intended to facilitate the use of the  Basic Version.  The  templates are
       installed with the conversion tool and are stored in the Input_Files folder. These templates are also
       available     for     download    on    the     EMTS     Conversion    Tool     web    page:
       http://www.epa.gov/otaq/fuels/renewablefuels/emtshtml/emtsconversiontool.htm

    •   Advanced Version:  This version does not require the use of the basic EPA templates, or that the
       input files use the standard headers (though the templates or other files with the standard headers
       can be used).  Users can create mappings between their own user-defined column headers and
       labels that will be used  in the XML files.  Users can also input data manually and change existing
       data for conversion.
If the user wishes to directly input user-defined formatted
files that do not have  the same column headings as those
found in the template, then the Advanced Version must be
used  and the column headers must  be mapped to the
proper  ECT  column  headers  so that the data is  read
appropriately and valid output is produced.

  1.2  Overview of the ECT Screens
                                                 Data Entry
                                                 Inexperienced users are advised to use
                                                 the EMTS website for manual data entry.
                                                 The ECT does not run Quality Assurance
                                                 checks on data.
The User Interface for both the Basic and the Advanced Versions of the ECT consists of three screens.

   1.  A "Start-up" screen where the user can select whether to use the Basic or Advanced Version (see
       Figure 1-1).
4>EPA
United States
Environmental Protection
Agency

-------
 EMTS Conversion Tool
Figure 1-1:  Start-up Screen
 ffl EMTS Conversion Tool (ECT) Front Page
   File   Help

                 Convert a delimited text file or Excel file to EMTSXMLfile (files can be zipped).

        Advanced Version
-  n  x
           Go     This version allows the flexibilty that the Basic version doesn't.
        Build a New File
                   Go directly to Build a New XML File by-passing the file and folder selection displays.
                   Processing is the same for Advanced or Basic versions.
                  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
This screen allows the user to select from two versions of the ECT:  the Basic Version or the Advanced
Version. This screen also allows the  user to go directly to the "Build a New XML File" functionality.  The
user may check the "Don't show this page anymore" box if desired. This will cause the start-up screen to be
skipped on subsequent uses of the ECT, resulting in the processing starting up directly at the screen where
the input files are chosen. The version that will be used would be the last version chosen after selecting the
"Don't show this page anymore" box.  This feature can be turned back on from the file selection screen (see
Figures 3 and 4) by clicking on "Show Front Page" and then selecting "Show Front Page" when the start-up
page  appears.  Additionally, the user can toggle back and  forth between the  Basic Version, Advanced
Version, and Build a New File options from the file selection screen, as depicted in Figure  1-2.

-------
EMITS Conversion Tool
Figure 1-2: Toggling Between Basic, Advanced, and Build a File Versions
IS EMTS Conversion Tool (ECT)



BHIJ3IB
File | Help File List View Show Front Page Show Log WinZip
Go To Advanced Version
| •s | Go To Basic Version
Process Existing Files

Exit
rmat an Excel or delimited file for conversion to XML. For questions concerning compatibilty refer to Help/About ECT.
s) on the right panel and click on the Process File(s) button to process OR Select the Build a New File button.

A 1 Name
Size Modified
I Attribute


Process
Existing

     2.   A File Selection screen where  the user can select the  file to be processed.  Figure 1-3 displays the
         Basic Version and Figure 1-4 displays the Advanced Version.
Figure 1-3: File Selection Screen (Basic Version)
 ffl EMTS Conversion Tool (ECT)
   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 process OR Select the Build a New File button.

i d Error_Files
EB-d Good_Files
d History_Files
Eg-'-GS lnput_Files
d Val_Log
i EB d FinePrint files
id FormatXML
d My Google Gadgets
d My Music
: d My Pictures
• d My Videos
i Sid My Virtual Machines
id New Folder
• Ed PDF files
; E d TotarValidatorTool
Ei-d NetHood
: d PrintHood
d PrivaclE
d Recent
d SendTo
EE1 d Spark
EB d Start Menu
L-Pl Templates
.- ,ll r, .
Name ] Size Modified Attribute
s| BuyDenyTernplate.xls 30,720 3/10/2010 10:56:05 AM A
H BuyTernplate.xls 27,136 4/14/2010 3:49:52 PM A
S| BuyTemplate2.xls 30,720 3/10/2010 10:56:05 AM A
S] GenerateTemplate.xls 55,296 4/19/2010 11:44:35 AM A
1 RetireTernplate.xls 40,960 4/1 4/201 03: 49: 52PM A
1 SellTemplate.xls 33,792 4/1 4/201 03: 49: 52PM A
B SellTemplateCanceLxIs 37,376 3/9/2010 11 :00:27PM A
H SeparateTernplate.xls 39,424 4/14/2010 3: 49:52 PM A


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


    Files
    Input File(s) Folder:    [C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\lnput_Files
    *Good File(s) Folder: |C:\Documents and Settings\wgo\My DocumentsVEMTS Conversion Tool (ECT)\Good_Files
    **Bad File(s) Folder: jCADocurnents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT]\Error_Files
    Log File(s) Folder:   |C:\Documents and Settings\wgo\My DocumentsSEMTS Conversion Tool (ECT]Wal_Log
    History File(s) Folder: |CADocuments and SettingsVwgo^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

-------
EMITS Conversion Tool
By default, the files in the "Input_Files" folder will be displayed on the right-hand side of the File Selection
Screen.  The user can also use the folder navigation available on the left-hand side of the File Selection
Screen to find files in other folders. Either a single file or multiple files can be selected; if multiple files are
desired, the selection can be  done through the use of the control (CTRL) key.  Once the desired file(s)
is(are) selected, the "Process  Existing File(s)" button  should be clicked.  The File Processing Screen will
automatically appear once per file selected.  The user also has the option of clicking on "Build a New File,"
in which case it is not necessary to select an input file.
Figure 1-4: File Section Screen (Advanced Version)
H EMTS Conversion Tool (ECT) Q[H][Xj
File Help File List View Show Front Page
Welcome: wgo . This application will format an Excel
Step 81 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, app it



Step 82 - Select File(s)
Select a Folder on the left panel and File(s) on the rit
Show Log WinZip
or delimited file for conversion to XML For questions concerning compatibilty refer to Help/About ECT.

,rmat. Delimiters
if it is a tab, comma, or bar delimited format. (• Default <~ Tab f Comma
T Bar (~ Other: f~
ation will determine file type by it's extension.


ht panel and click on the Process File(s] button to process OR Select the Build a New File button.

U Error_Files A
: B--PJ Good_Files
i Pj History_Files
! ffl"€3 InpuLFiles
Cl Val_Log
S-Pj FinePrint files
I Pj FormatXML
•Pi My Google Gadgets
Pi My Music
Pj My Pictures
| Pj My Videos
El Pj My Virtual Machines
i Pj New Folder
[+! Q PDF files
+ Pj Totalv'alidatorTool
B-CJ NetHood
i_J PtintHood
Q PrivaclE
Cj Recent
Q SendTo
Bd Spark
S Pj Start Menu
;••• Pj Templates
4- r~-ป ii r, .
< HI m
Name | Size Modified | Attribute ]
'H BuyDenyTernplate.xls 30,720 3/10/2010 10:56:05 AM A
'H BuyTemplate.xls 27,136 4/14/2010 3: 4S:52PM A
'il BuyTernplateZxIs 30,720 3/10/2010 10:56:05 AM A
1 GenerateTemplate.xls 55,296 4/19/2010 11:44:35 AM A
3 RetireTemplate xls 40960 4/14/2010 3' 49' 52PM A
jl SellTemplate.Kls 33,792 4/14/2010 3: 49: 52PM A
'S| SellTemplateCanceLxIs 37,376 3/9/20101 1:00:27 PM A
1 SeparateTernplate.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:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)Mnput_Files Set Path
*Good File(s) Folder: |C:\Documents and Settings\wgo\My Documents^ MTS 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 File(s) Folder : |C:\Documents and SeHings\wgo\Mv Documents\EMTS Conversion Tool (ECT]\Val_Log Set Path
History File(s) Folder: | C:\Documents and Settings\wgo\My DocumentsVEMTS Conversion Tool (ECT)\History_Files
"Location of formatted output that has NO errors. ""Location of formatted output that has errors.
Set Path


A

-------
 EMITS Conversion Tool
This screen is similar to the File Selection Screen for the Basic Version, except for the addition of an extra
section at the top where users can specify the delimiters used for text-based input files.

     3.   A File Processing screen where data can be edited and the actual conversion to XML is initiated.  See
         Figures 1-5 and 1-6  (Basic Version) and Figure 1-7 (Advanced Version) below.
Figure 1-5:  File Processing Screen (Basic Version, Input File Selected)
  Step 82 - Enter Company Info
  User Login: ]ep3- Submittal Creation Date: 12010-06-11 -J Submission Comment
  Step 113 - Process And Writ.; to XML File

   Output File Options  FjjityStop Ftpcessin
  Progress:
                              J Lvadin-j input Data.1 data records read.
Figure 1-6:  File Processing Screen (New File Being Built)
  r BuyTransaction - Processing file:
  Process  Rows  Columns   Help  Show Log  WinZip
  Step 83 - Enter Company Info       		
 -UsefLagin: jj         ' Submitta! Creation Dale: 12010-04-19 "^"l  Submission Comment:
 1 Organisation ID: |
  Step tt4 - Select column to upload
  Add Hew Empty Ro'
               Copy Row(s) to New Row(s)   Delete Rowfs)
                                                ==> Show Legends <==
                                                                            Headei Infomation
                                                                            ^Application User ID: |
                                                                            Transmission ID: TBD
       "Transaction Partner
       Organization identifie
'Transaction Partnei
Organization Name
  Step tt5  Process And Write to XML File
    Output File Optloi
               E-i!t/Stop Recessing
  Progress:
                            Columns set to Recommended Defaults

-------
EMITS Conversion Tool
Figure 1-7: Processing Screen (Advanced Version)
Process Rows Columns Help Show Log WinZip
'•User Login: j - Submit! al Creation Date: 1 ฃ010-04-1 9 ~~~\ Submission Comment:
• Organisation ID: I
Add New Empty Row Copy Row(s| to Mew Row[s) Delete Row(s] Set Columns to Recommended Defaults Import/Export Company Column Mam
NOTontheinputfile.

f Transaction Partner Transaction Partner RIN Batch Fue! Assignment
1 4664 anneslurel 190 190 4 1

FM
Transaction Partner Oroanization Identifier Transition Partner Oigwizalicn ktant - | BalehVolume JBatoh Volume ^j
Assignment Code (Assignment Code ป | RINPriceAnount ]RIN PnceAmount _ปJ
FuelCode (fuel Code T| Transaction Del ail CommentTent JTran^action Detail Lซnment TSK! jrj
RINQuanlity |p.lN Quantity ^J FTDNumber ]FTD Number jrj
Trsn.-sctiOfiPBirtt-ujfOrganrsatrc.riHsim.j Ti-ariFaotii:,r, F-artner Org^riisatior, Nurr: T Gall an Rice Anoint [Gallon Pr ceAnount jปJ
RINYear |RINYear ^J Generate Organisation Identifier |Gener=te OigarasMmn Identifier •- I
BuyReasonCode JBuy Reason Code T | Batch NumberTent |Batch Number Tent _^J
Transaction Date [Transaction Date T| Generate Facility Identifier Generate Facility Identifier _rj
j Supporting Document Fields - Up to 2 sets
SupportingDocumentTeml Supporting Document Tent 1 -rj ^l Remaining FieUs ^J
Supporting Document NumberTentl Supporting Document Number Tent 1 t \
SupportingDocumentTent2 j supporting Document Text 2 jซJ



S lep S5- Process And Wiite to XML Fife —
Output File Options EHjt/Stop Processing
Process File
Piogiess:
Illllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll


-^Plicatior,UserlD: | t-1 Apply User Login Value
Transmission ID: TBD
-J
U^ ซ, *. ,ol^n h,.d.,. Ch.n3,, m,d, ™ll b. ,,fl..ซd ,„ ,h. „.„ ^u, S. ,nd

RIN Buy Reason RtN Price Gallon Price Transactioi
2009 60 0.23 2009-12-02



— nriatmtin^ ^nrrp P=r=,il Fi-IH- nrp rrnHi(nn=.ll- -pti-ml
BuyReason Codes _ปJ Acceptable combinations are-.
JAss.gnment Codes j-J Generate Organizer Identifier only.
Generate Organiser Identifier, Generate Facility Identifier
and Batch Number
SlJPoPpฐioina'|DOC'Jmenฃ De'a''2 F'dd* a'e Cฐnd'tlCin3llj'
If one item is present, then both fields must be present
Reason Code: If a reason code of 60 (cancel trade] is
present there may only be one data cow per file.
jiifl Facility Identifier must be 5 digits


	 yyyy • yyyy






iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiniiiiiiiii






























A
>
Compared to the basic processing screen, the advanced processing screen is different in the following ways:

   •   The data grid is always present (in the Basic Version, the data grid only appears if the "Build a New
       File" button is clicked on the File Selection Screen);

   •   There is a set of labels and drop-down menus where column headings can be mapped to the labels
       that will be written to the output XML; and

   •   There is a button which allows user-defined column names to be imported and exported.

  1.3  Transaction Types

The ECT can create XML files for all five of the transaction types supported by the EMTS:  generate,
separate, buy, sell, and retire.
   •   A generate transaction is to be used by organizations who produce renewable fuel;
   •   A separate transaction is to be used by parties who blend fuel and separate RINs;

-------
EMTS Conversion Tool
    •   A sell transaction is to be used by parties who have sold RINs;
    •   A buy transaction is to be used by parties who have bought RINs; and
    •   A retire transaction is to be used by parties who have retired RINs for any reason.

For detailed information on the data elements for each transaction, including allowed values, please see the
EMTS Transaction Instructions -- Section 6, "How Do I Report Transactions Using XML Files?"

  1.4  Required, Conditional, and Optional Fields

Fields are required, conditional, or optional.

    •   A required field is necessary for every transaction;

    •   A conditional field  is dependent on the data that was entered in previous fields  and may be
       required if certain conditions are met; and

    •   An optional field is not required by EPA, but may contain helpful descriptive information about the
       transaction.

  1.5  Setting Up the Input Files

The ECT (both  Basic and Advanced Versions) accepts file types  which are identified by the following
extensions:

    •   .txt - tab or bar delimited text;
    •   .csv - comma delimited text; and
    •   .xls - Excel spreadsheet

The Advanced Version also accepts text files which do not use commas, tabs, or bars as delimiters.

For these file types, the ECT accepts either a zipped or unzipped file (if zipped, the file extension will be
".zip").

Although the Basic Version accepts data in the  formats listed above, the basic EPA templates are only
available in Excel format.

Any row in an input file that has two hash symbols (#) at the start will be omitted from the conversion and
the first row that does not have "##" and is not blank will be assumed  to contain the column headings.
Figure 1-8 shows a sample  file in which one of the rows (line 5)  starts  with "##" and will  therefore be
ignored by the ECT. In this example, the ECT will take the column headings from Row 4  because this is the
first row that is  not blank and does not start with "##."

-------
EMTS Conversion Tool
Figure 1-8: Omitting a Data Line
a A B C D E
1
2
3
4
F
G
## Please refer to the "NOTES" tab if you need guidance or codes
##This template corresponds with ECT 1.0.0.0

Transaction ^ Transaction
Partner Partner RIN Batch F . „ ,
Organization Organization Quantity Volume
Identifier Name
5 ##1234 Bob's Ethanol r5000 r5000 r4
6 "2345 Marys Ethanol rGOOO rGOOO r4


1
Assignment R|N yegr
Code
r1
r1
r2010
r2010
  1.6  Transaction Data Elements in the ECT

The following sections describe, for each transaction, the elements that can be included in the files that are
input to the ECT. For each transaction, elements are grouped according to whether the ECT treats them as
required, conditional, or optional.   The element names presented here are equivalent to the standard
column headers defined by EPA and used in the basic Excel templates.

Note that the absence of an element treated as optional by the ECT can still cause the output XML to fail
validation when it is submitted to the EMTS; for instance, the ECT treats "Denaturant Volume" as optional
even though the EMTS may require this element depending on the value of "Fuel Code."

       1.6.1   Generate Transaction Data Elements

The following describes the generate transaction data elements.  Up to three  feedstocks and two co-
products may be specified in the ECT.

The following elements are required:

   •   Fuel Code;
   •   Process Code;
   •   Production Date;
   •   Fuel Category Code;
   •   Batch Volume;
   •   RIN Quantity;
   •   Generate Organization Identifier;
   •   Generate Facility Identifier;
   •   Batch Number Text;
   •   Feedstock Code 1;
   •   Renewable Biomass Indicator 1;
   •   Feedstock Quantity 1; and
   •   Feedstock Measure Code 1.
The following elements are conditionally required:

-------
EMTS Conversion Tool
    •   CoProduct Code 1 (required if CoProduct Detail Comment Text 1 is present);

    •   CoProduct Code 2 (required if CoProduct Detail Comment Text 2 is present);

    •   Feedstock Code 2, Renewable Biomass Indicator 2, Feedstock Quantity 2, Feedstock Measure Code
       2 (if any one is present, the others are required);

    •   Feedstock Code 3, Renewable Biomass Indicator 3, Feedstock Quantity 3, Feedstock Measure Code
       3 (if any one is present, the others are required); and

    •   Denaturant Volume (if ethanol is produced, this field is required).

The following elements are optional:

    •   Equivalence Value;
    •   Import Facility Identifier;
    •   Transaction Detail Comment Text;
    •   Generate Supporting Document Detail;
    •   Feedstock Detail Comment Text 1;
    •   CoProduct Detail Comment Text 1;
    •   Feedstock Detail Comment Text 2;
    •   CoProduct Detail Comment Text 2; and
    •   Feedstock Detail Comment Text 3.

       1.6.2  Separate Transaction Data Elements

This section describes the separate transaction data elements.

The following data elements are required:

    •   RIN Quantity;
    •   Batch Volume;
    •   Fuel Code;
    •   Transaction Date;
    •   Separate Reason Code; and
    •   RIN Year.

The following data elements are conditionally required:

    •   Transaction Detail Comment Text;

    •   Generate Organization Identifier (required if Generate Facility Identifier is present);

    •   Generate Facility Identifier (required if Batch Number Text is present);

-------
EMTS Conversion Tool
    •   Blender Organization Identifier (required if reason code is 40: Upstream Delegation for Blending);
       and
    •   Blender Organization Name (required if reason code is 40: Upstream Delegation for Blending).

The following data elements are optional:

    •   Batch Number Text; and
    •   Supporting Document Text, Supporting Document Number (if one is present, the other is required).

       1.6.3   Sell Transaction Data Elements

This section describes the sell transaction data elements.

The following data elements are required:

    •   Transaction Partner Organization Identifier;
    •   Transaction Partner Organization Name;
    •   RIN Quantity;
    •   Fuel Code;
    •   Assignment Code;
    •   RIN Year;
    •   Sell Reason Code; and
    •   Transfer Date.

The following data elements are conditionally required:

    •   Transaction Detail Comment;
    •   Generate Organization Identifier (required if Generate Facility Identifier is present);
    •   Generate Facility Identifier (required if Batch Number Text is present);
    •   RIN Price Amount (required if GallonPriceAmount is not present);
    •   Gallon Price Amount (required if RINPriceAmount is not present); and
    •   Batch Volume (required if the RIN is assigned).

The following data elements are optional:

    •   Batch Number Text;
    •   Matching Transaction Identifier;
    •   PTD Number;
    •   Supporting Document Text, Supporting Document Number (if one is present, the other is required);
       and;
    •   Public Supporting Document Text, Public Supporting Document Number (if one is present, the
       other is required).
                                                                                             10

-------
EMTS Conversion Tool
       1.6.4   Buy Transaction Data Elements

This section describes the buy transaction data elements.

The following data elements are required:

    •   Transaction Partner Organization Identifier;
    •   Transaction Partner Organization Name;
    •   RIN Quantity;
    •   Fuel Code;
    •   Assignment Code;
    •   RIN Year;
    •   Buy Reason Code; and
    •   Transfer Date.

The following data elements are conditionally required:

    •   Transaction Detail Comment Text;
    •   Generate Organization Identifier (required if Generate Facility Identifier is present);
    •   Generate Facility Identifier (required if Batch Number Text is present);
    •   RINPriceAmount (required if GallonPriceAmount is not present);
    •   GallonPriceAmount (required if RINPriceAmount is not present); and
    •   Batch Volume (required if the RIN is assigned).

The following data elements are optional:

    •   Batch Number Text;
    •   PTD Number;
    •   Supporting Document Text, Supporting Document Number (if one is present, the other is required);
       and
    •   Public Supporting Document Text, Public Supporting Document Number (if one is present, the
       other is required).

       1.6.5   Retire Transaction Data Elements

This section describes the retire transaction data elements.

The following data elements are required:

    •   RIN Quantity;
    •   Fuel Code;
    •   Assignment Code;
    •   Transaction Date;
    •   RIN Year; and
    •   Retire Reason Code.
                                                                                            11

-------
EMTS Conversion Tool
The following data elements are conditionally required:

   •   Transaction Detail Comment Text;

   •   Generate Organization Identifier (required if Generate Facility Identifier is present);

   •   Generate Facility Identifier (required if Batch Number Text is present);

   •   Compliance Year (if Retire Reason Code is  Demonstrate Annual Compliance (80), this field is
       required);

   •   Compliance Facility Identifier (if Retire Reason Code is Demonstrate Annual Compliance (80), this
       field may berequired); and

   •   Compliance Level Code (if Retire Reason Code is Demonstrate Annual Compliance (80), this field is
       required).

The following data elements are optional:

   •   Batch Number Text;
   •   Batch Volume;
   •   Compliance Facility Identifier;
   •   Compliance Level Code; and
   •   Supporting Document Text, Supporting Document Number (if one is present, the other is required).

  1.7  Data Validation Checks in the ECT

The ECT performs many (but not all) of the data validation checks needed to ensure that the output XML
file can be successfully processed by the EMTS.  Errors  found by the ECT are  written to the "Status"
message block above the progress bar at the bottom of the  screen and to the  log file. The following is a list
of checks that will be performed during processing.

   •   Checks that the "Enter Company Info" fields are filled in. All of these fields are required except
       "Submission Comment" Only the "User Login" is saved between file processing. Submittal creation
       date must be in the form ofYYYY-MM-DD.

   •   Checks the drop-down lists of column headers for the required, optional, and conditionally optional
       fields. The following will produce an error:

       --  For a required field, if the user has not selected a column  name from the drop-down list or
          provided data;

       --  For a conditional field or optional field, if the user has indicated that it should be included by
          selecting a column name from the drop-down list, but has not provided the corresponding data;
                                                                                            12

-------
EMTS Conversion Tool
      --  If there is no value selected on the drop-down list that corresponds to the column;

      --  If the value selected in the drop-down list does not match any of the column names; and

      -  If the same column heading is selected in multiple drop-down lists for different required fields.

      Checks the transaction data. The following will produce an error:

      -  If data is missing in a required field (note that some fields are conditionally required, meaning
          that if a certain value is present, then all the following fields are required);

      -  If "Assignment Code" has a value other than "1" or "2";

      -  If transaction codes contain letters;

      -  If "Transaction Partner Organization Identifier" is not four digits;

      -  If dates  not of the format YYYY-MM-DD.  If dates are of the format YYYY/M/D, YYYY-M-D, or
          MM/DD/YYYY the ECT will make the appropriate change which will be displayed in the data
          grid without any error messages;

      -  The year specified in the Transaction Date or Transfer Date is less than 2010;

      -  Transaction Date or Transfer Date has a value greater than that of the Submittal Creation Date;
          and

      -  If "RINYear" has a value prior to 2 010.
                                                                                             13

-------
Section 2:  Installing and Setting Up the Conversion Tool

This guide describes how to install the ECT, how to set up the input files, and how to configure the ECT.
Additional information is provided on the usage and customization of the ECT file system directories.

If you already have aversion of the Conversion Tool installed, you must uninstall the existing version of the
Tool before you install the new version. See Section 3 "Uninstalling the Conversion Tool" for instructions
on how to do so.

  2.1  System Requirements

The system requirements for running the ECT are as follows:

    •  MS Windows XP 2002 SP2  or later, Windows Vista, or Windows 7;
    •  MS Office version 2003 or later;
    •  A CPU of at least 2.0 GHz;
    •  At least 1.0 0 GB of RAM; and
    •  At least 900 KB of disk space.

Microsoft Excel is required for users who wish to use the basic EPA templates or create their own user-
defined files in Excel format.

  2.2  Obtaining the ECT and Transaction Templates

The ECT and the transaction templates are available at the following location:

http://www.epa.gov/otaq/fuels/renewablefuels/emtshtml/emtsconversiontool.htm

Two ECT files will be available at this location, in the form of Zip archives. The first file, "ECTvl.5.2.zip,"
contains the ECT itself, the five transaction templates that EPA has created for the five transaction types,
and the support files necessary for installation of the ECT and the templates.  These templates are also
available separately in the second file, "EPA Templates.zip".  These files can be saved anywhere the user
chooses.  The user will then need to use a utility  such as WinZip to extract the files. Figure 2-1 depicts the
WinZip screen that appears after the user has doubled-clicked the file "ECTv.l.5..2zip".
                                                                                             14

-------
 EMITS Conversion Tool
Figure 2-1: Using WinZip to Extract the ECT
WWinZip-ECTv1.5.2.zip
 File Actions View Jobs Options Help

   New     Open   Favorites   Add     Extract     Mail
                                             Encrypt   View
                                                                           '...;
                                                           Install    Wizard  View Style
                                                                                             "3 B  t|eJS*-l
                                                                       Modified
                                                                                        SEC  Ratio  Packed
                        O myMsiExec.bat
                                   Windows Inst... 12/5/2011 10:02 AM   1,219,534  22%  945,1...
                                   MS-DOS Bat... 9/6/2011 9:28 AM        69   4%     66
                                   Text Document 9/29/2011 3:20 PM      282  57%    122
                                   Install Applic...  12/5/2011 10:02 AM    482,304  53%  227,4...
Selected 0 files, 0 bjites
                                                     Total 4 files, 1,663KB
                                                                             ao
Note that users may see variations of the image in Figure 2-1.  The user should click the Extract button to
get to the window in Figure 2-2 below.
Figure 2-2: Specifying ECT Location
         Extract - C:\Documents and Settings\jlj\Desktop\epa rins-docs\Support\EPA EMTS ...  | ? IfXl
                -
              h>"
             Desktop
           My Documents
           My Computer
            My Network
              Places
                 Extract to:  C:\unzipped\ECT Extracted
         S ir^ Program Files
         B-ir^ unzipped
                   ECT Extracted
         fi ••{ฃ) wamp
         SHฃ) WINDOWS
      El ^ DVD-RAM Drive (D:)
      ffl 5ฃ n on 'foseriver.pqa. local1 (H:)
      (B"2ฃ i on 'roseriver.pqa. local' (I:)
      ffl"2ฃ I on 'hazel, pqa. local' (J:)
      + Ji software on 'Chv-fs1 (N:)
Files
   Selected files/folders
(*) All files/folders in archive
O Files:
Open Explorer window
Overwrite existing files
Skip older files
Use folder names
                                                                         a
                                                                                                    A
                                                                                                    v
                                                                                              Extract
                                                                                              Cancel
                                                                    Help
The user can choose to extract the files to any desired location, provided that the folder name does not
contain an ampersand (&). In the example above, a location of "C:\unzipped\ECTExtracted" has been
selected. Once the location has been selected, the user should click the "Extract" button.
                                                                                                              15

-------
 EMITS Conversion Tool
Upon doing so, a folder -- "ECTFullInstall" -- will be created under the selected location.

  2.3  Installing the ECT

After downloading the zipped ECT and extracting the files, the user must then install the application by
navigating to ECTFullInstall/Release and double-clicking the "setup.exe" file. Figure 2-3 depicts this folder
when the files have been extracted to "C:\unzipped\ECTExtracted".
Figure 2-3: "Setup.exe" File
       C:\unzippetttECTEx1racted\EctFulll nst a I l\Re lease
                                                                                           -  n  x
 File   Edit   View  Favorites  Tools   Help

 ^Back  '

Address
                                  ID Search  [JL-.  Folders
C: \unzipped\ECT Extracted\EctFullInstall\Release
                    
-------
EMTS Conversion Tool
Figure 2-4: ECT Setup Wizard
             iฃ EMTS Conversion Tool (ECT)
               Welcome to the EMTS Conversion Tool (ECT)
               Setup Wizard
               The installer will guide you through the steps required to install EMTS Conversion Tool (ECT) on your
               computer.
               WARNING: This computer program is protected by copyright law and international treaties.
               Unauthorized duplication or distribution of this program, or any portion of it, may result in severe civil
               or criminal penalties, and will be prosecuted to the maximum extent possible under the law.
                                                Cancel
< Back
Next>
The first installation step is to select the installation folder.   The default folder is C:\Program Files\US
EPA\EMTS Conversion Tool (ECT)\.  To select a different folder, click the Browse button (Note - the
following default  location is  preferred:  C:\Documents  and  Settings\(your  computer  name)\Start
Menu\Programs\US EPA\. The ECT must be installed to a location with  a drive letter in order to work
properly (i.e., C:\, D:\, etc.). The ECT "Help" menu describes a work-around to use if the ECT is not installed
to such a location. The ECT will not install correctly from a location with an ampersand (&) in the file path.
There is also the option to install the ECT for one user or for anyone who uses the computer (see Figure 2-
5).
                                                                                                  17

-------
EMITS Conversion Tool
Figure 2-5: Select Installation Folder
               m EMTS Conversion Tool (ECT)
                 Select Installation Folder
                 The installer will install EMTS Conversion Tool (ECT) to the following folder.
                 To install in this folder, click "Next". To install to a different folder, enter it below or click "Browse"
                   Folder:
                   |C:\Program Files\US EPA\EMTS Conversion Tool (ECT)\
             Browse...
                                                                                  Disk Cost...
                   Install EMTS Conversion Tool (ECT) for yourself., or for anyone who uses this computer:

                    f E_veryone
                    f* Just me
                                                      Cancel
< Back
Next>
              I j^ EMTS Conversion Tool (ECT)
                 Select Installation Folder
                 The installer will install EMTS Conversion Tool (ECT) to the following folder.
                 To install in this folder, click "Next". To install to a different folder, enter it below or click "Browse".
                   Folder:
                   C:\Documents and Settinqs\ name \btart Menu\Proqrams\US EPA
             Browse...
                                                                                  Disk Cost..
                                                      Cancel
< Back
Next;-
                                                                                                               18

-------
EMTS Conversion Tool
Nextyou will prompted to confirm the installation. Click the Next button (see Figure 2-6).

Figure 2-6:  Select Installation Folder
jฃ EMTS Conversion Tool (ECT)
Confirm Installation
The installer is ready to install EMTS Conversion Tool (ECT) on your computer.
Click "Next" to start the installation.

Cancel < Back

Q B
ita


1 Next > i

When the installation is complete, a success message will be displayed.  Click the Close button (see Figure
2-7).
                                                                                                19

-------
EMTS Conversion Tool
Figure 2-7: Installation Complete
             iฃ EMTS Conversion Tool (ECT)
               Installation  Complete
               EMTS Conversion Tool (ECT) has been successfully installed.

               Click "Close" to exit.
               Please use Windows Update to check for any critical updates to the .NET Framework.
                                               Cancel
< Back
Close
Once the application has been installed, the user can delete the "ECTFullInstall" folder if desired.

To  open the ECT,  navigate to the  installation directory (by default, C:\Program Files\US  EPA\EMTS
Conversion Tool (ECT)\ or Start Menu\All Programs\US EPA) and double-click the "EMTS Conversion Tool
(ECT).exe" file (see Figure 2-8).
                                                                                                 20

-------
 EMITS Conversion Tool
Figure 2-8:  Opening the ECT
   C:\Program FilesUJS EPAVEMTS Conversion Tool (ECT)
   File  Edit   View   Favorites   Tools  Help

   0Back  " Q  -  fv^ !  O Search     Folders  [771]'
  Address (ฃ) C:\Program Files\US EPA\EMTS Conversion Tool (ECT)
                                                                                                             v  H Go
    File and Folder Tasks  .*
    ^j Rename this hie
    g Move this file
    Q Copy this file
    ej Publish this file to the
       Web
    Q E-mail this file
    X Delete this file
                          *
                            help
P       I
 xls

Bป
                                                xls        EMTS
   EMTS     EXCEL.EXE  Interop.Exc... Microsoft.V...
Conversion ...
                          office.dll   Shortcut to  write_move.ini
                                   Applicati...
    Other Places

To create a desktop shortcut to open the ECT, right click on the "EMTS Conversion Tool (ECT).exe" file and
select Send To -^Desktop (create shortcut) (see Figure 2-9):
Figure 2-9:  ECT Desktop Shortcut
   File  Edit  View  Favorites  Tools  Help
           C; \Program Files\U5 EPA\EMT5 Conversion Tool (ECT)
                                                                                             L.EXE  Interop.Exc... Microsoft.V...
   Rename this file
   Move this file
   Copy this file
   Publish this file to the
   Web
   E-mail this File
X Delete this file
                                        Shortcut to  write_move.ini
                                        Applicati...
                                                                            WinZip
                                                                            Pin to Start menu
                                                                                             IJLl Compressed (zipped) Folde
                                                                                                Mail Recipient
                                                                                                My Documents
                                                                                              i DVD-RAM Drive (Dl)
   LIS EPA
   My Documents
   My Computer
   My Network Places
Note that in some cases the ECT set up may create a short cut on your desktop, however the short cut is a
short cut back to your desktop.  If this occurs, please delete short cut from your desktop.
                                                                                                                         21

-------
EMITS Conversion Tool
  2.4   Setting Up the ECT

        2.4.1   Directories

The installation will create a folder in the My Documents folder: "C:\Documents and Settings\\My
Documents\EMTS Conversion Tool (ECT)" (see Figure 2-10).
Figure 2-10: Default ECT Directories
it My Documents
 File  Edit  View  Favorites   Tools  Help

 @Back

Address
Folders
   Desktop
     d Downloads
   ffl Id EMTS Conversion Tool (E(
     d FormatXML
     |jฃJ My Data Sources
     Id My Music
     Id My Pictures
     O My Videos
•ฑ  j My Computer
*! *• j My Network Places
   •g) Recycle Bin
  Id EPA Support Tools

  d Certificate-ECMS-Portrait-Jili
  d Conversion tool tests
  id ECT Testing documents
a d EMTS
  d EMTSSchema
  Id EMTSSchemaAndXMLSamples
P

P

P
                                   Downloads
                                   FormatXML
                                   My Music
                                   My Videos
   Id New Folder
   d OTAQReg Testing
   (d other

                                                                                                       /'
ck ' O " 0
IJ Search
Igj Folders
&
Q My Documents
                                                         P
My Pictures
If the ECT has  previously been installed and uninstalled,  this  folder  should  already be  present  and
subsequent installations will not overwrite the folder.

The ECT will create a set of folders in the "EMTS Conversion Tool (ECT)" folder that are used by the ECT to
process files.  The following folders are created:

    •  Input_Files: Files to be converted;
    •  Good_Files: Successfully converted XML files;
                                                                                                        22

-------
EMITS Conversion Tool
    •   History_Files: "Build a File" data stored between processing;
    •   Bad_Files:  Unsuccessfully processed files; and
    •   Val_Log: Activity logs from attempts to process files.

Figure 2-11 shows these folders in their default location under the "EMTS Conversion Tool (ECT)" folder.
Figure 2-11: The Default ECT Directories
       Edit   View  Favorites  Tools  Help
                              5earch     Folders
 Address Ilir3) C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ELT)
    File and Folder Tasks    A
        Make a new folder
        Publish this folder to
        the Web
        Share this folder
/  History_Files
                                                                                                        23

-------
 EMITS Conversion Tool
Figure 2-12 shows the File Selection Screen with the ECT folders indicated.  The  folders in this example are
the default folders.
Figure 2-12: Location of the ECT Folders
    EMTS Conversion Tool (ECT)
   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.
                                                                                                                                -   n  x
    Step 111 - If using a delimited file specify delimiter.
    Start by putting your data in a compatible delimited format.
    The default method is to let this application figure out if it is a tab, comma, or bar delimited format.
    Otherwise, you may choose your own delimiter.

    This option is not needed if using an excel file, application will determine file type by it's extension.
 Delimiters

f-  Default

   Bar
f Tab

T Olher:
Comma
Select a Folder on the left panel and File(s] on the right panel and click on the Process Filel

LJ Error_Files A
! ffl -C3 Good_Files
••••Q History_Files
! B €3 Input Files
D VaLLog
i S Cl FinePrint files
•-Q ForrnatXML
Pi My Google Gadgets
CD My Music
f^l My Pictures
'• Q My Videos
i B Pi My Virtual Machines
; Q New Folder
1 H Q PDF files
: E O TotaFvalidatorTool
iii-O NetHood
i Q PrintHood
; CJ PrivaclE
iCj Recent
i CJ SendTo
H-Cj Spark
$••ฃ] Start Menu
I ~l Templates
4, ,-V. ,, n, .
< •Hi

Name | Size
m BuyDenyTernplate.xls 30,720
a! BuyTernplate.xls 27,136
Mi GenerateTemplate.xls 51,712
a RetireTemplate.xls 40,960
H SellTemplate.xls 33,792
.Si SellTemplateCanceLxIs 37,376
8] SeparateTernplate.xls 39,424
s] button to process OR Select the Build a New File button.
Modified 1 Attribute | Existing
3/1 0/201 01 0:56: 05 AM A Flle(sl
4/1 4/201 03: 49:52 PM A Or
4/1 4/201 03: 49:52 PM A
Build a New
4/1 4/201 03: 49: 52PM A File
4/1 4/201 03: 49:52 PM A
3/9/2010 11:00:27 PM A Or
4/14/2010 3:49:52 PM A
Exit


    Files
                        C:\Documents and Settings wgo xMy Documents'\EMTS Conversion Tool [ECT]\lnput_Files
        od File(s) Folder: |CADocuments and SettingsSwgo\My Documents\EMTS Conversion Tool (ECT)\Good_Files
    "Bad File(s) Folder: jCADocuments and SettingsVjgo\My Documents^EMTS Conversion Tool (ECT)\Error_Files
     ,og File(s) Folder:    C:\Documents and Settings\wgo\My Documents'\EMTS Conversion Tool (ECT)\Val_Log
               ) Folder: |CADocuments and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\History_Files

         "Location of hrrm^H"1 i'r l'''li i1 li itiNfl nir"''         ""Location of formatted output that has errors.
                                                                                                                             Set Path
                                                                                                                                        24

-------
 EMITS Conversion Tool
Any  of the  default folders  can be  changed by clicking on the  appropriate "Set Path" button.  This will
prompt the user to browse any permitted drive on the user's network to find and select the appropriate
folder thatwill be setup for processing, as indicated in Figure 2-13.
Figure 2-13: Folder Set-up Screen
  ' EMTS Conversion Tool (ECT)
  File  Help   File List View   5how Front Page   Show Log   WinZip

   Welcome: KKuhn . This application will format an Excel or delimited file for conversion to XML. For questions concerning compatibly refer to Help/About ECT.
   Step It I - If using a delimited file specify delimiter.
   Start by putting your data in a compatible delimited format.
   The default method is to let this application figure out if it is a tab, comma, or bar delimited format.
   Otherwise, you may choose your own delimiter.

   This option is not needed if using an excel file, application will determine file type by it's extension.
 Delimiters

'•'  Default

r  Bar
Tab

Other:
          Comma
urep Hi - seieei i-uei_sj
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 Build a New File button.

! E CD Application Data
: Pi Cookies
+ Pj Desktop
! IJ-PJ Local Settings
! B-Pj My Documents
: Pi Downloads
! 6-Pj EMTS Conversion Tot
! 	 j Error_Files
!_j Good_Files
Qj History_Files
; Q lnput_Files
: Pj Val Log
i Pi EmtsConversionTool
: Q] FormatXML
j -PJ My Data Sources
-••••Pi My Music
I Pj My Pictures
: Pj My Videos
+ _| NetHood
; ffl Pi personal
_] PrintHood
;• Pj Recent v
,!~
Name | Size | Modified
'=*! n r
=| EkiyTernpldie xhlitHMdlMHllBH
lil GenerateTempI;
m QTemplate.xls
^ RetireTemplate.
(1 SellTernplate.xls
S] SeparateTempli






| Attribute |









1 Q Q My Documents
El Downloads
Q ฃ) EMTS Conversion Tool (ECT)
Q Error_Files
Q Good_Files
ฃD History_Files
& Input_Files
El Val_Log
El EmtsConversionTool
< •HgH^^B
Make New Folder


OK




^m

A
i
>
Cancel


1




Process
Existing
File(s)

Or
Build a New
File
Or
Exit

i-nes
Input File(s) Folder: jCADocuments and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)Mnput_Files
*Good File(s) Folder: |C:\Docurnents and Settings"\kkuhn\My Documents\EMTS Conversion Tool (ECT)\Good_Files
"Bad File (s) Folder : | C:\Documents and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)\Error_Files
Log File(s) Folder : [CADocuments and Settings^kkuhn^My Documents\EMTS Conversion Tool (ECT)Wal_Log
History File(s) Folder: |C:\Documents and Settings\kkuhnSMy 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


-------
EMTS Conversion Tool
       2.4.2   Folder: Files to Process Folder
The first folder, entitled "Input File(s) Folder," is where the input files should be stored.  You cannot
process files that are not saved in this folder.

       2.4.3  Folder: Good File(s) Path

The second folder, entitled "Good File(s) Path," is where the files that the ECT was successful in processing
and converting will be saved. These files have been converted to XML and checked for any major input
errors (e.g., missing required fields) and deemed acceptable. The user can upload these converted files to
the EMTS.

       2.4.4  Folder: Bad File(s) Path

The "Bad File(s) Path" is where the ECT will save any files that the user has attempted to process that have
some  sort of major error and cannot be converted. Only data that has no major errors will be converted to
XML and saved in this folder; all data with errors will not be converted to XML. The user can then use the
comments provided by the ECT to amend the input file for re-processing.

       2.4.5  Folder: History File(s) Path

The "History File(s) Path" is where the ECT will save data from a Build a File execution.  If a user creates an
XML file using the ECT Build a File option that subsequently fails in EMTS, there will be an excel version of
the data file in the "History File(s) Path" that the user can upload in the ECT and edit.

       2.4.6  Folder: Log File(s) Path

The "Log File(s) Path" folder will contain a log that  details  all  of the successful and unsuccessful
conversions.  The log captures the date, time, file that is being processed, and the outcome of the  process.
Figure 2-14 displays a sample log file.
                                                                                               26

-------
EMITS Conversion Tool
Figure 2-14: ECT Log
B C:\Documents and Settings\wgo\My DocumentsVEMTS Conversion Tool (ECT)WalJ-og\ECTLogFHe_2010-06-14-23-09-1 g.tog
INI-U: (Ut Processing Summary
INFO: {0} -6/14/20101 1:10:09 PM
INFO: {0} Start writing to C:'\Documents and 8ettings\wgo\My Documents\EMT8 Conversion Tool (ECT)\Good Files\Generate1111 201 0-08-1 4-23-1 0-09.Mm
INFO: {0}
INFO' {0}
INFO: {0} Processing Data. Approx Records to be processed = 1
Finished processing Input Data. Records processed = 1 . 1 records were successfully processed.
Formatted to: XML file. Excel file
Compressed to: No compressions were selected.
B@S
A
INFO: {0} Use Company Info Values checked True
INFO: {0} Template file: C:\Documents and 9ettings\wgo\Local9ettings\Apps1,2.0\8L98CB35.Z03™HCX3AG.OJ2\emts..tion 6e8daabad98b805e 0001.0000 (83a4G5d327e8b08
INFO: {0}
INFO' {0}
INFO: {0} Template file: C:\Documents and SettingsVwgoVLocal SettingsWpps\2.0\6L98CB35.Z03\QOHCX3AG.QJ2\emts..tion 6e8daabad38b805e 0001.0000 f83a465d327e3b08
INFO: {0}
INFO: {0} -6/14/2010 11:10:1 7PM
INFO: {0} Begininq Processing File: C:\Documents and SettingsSwgoSMv DocumentsSEMTS Conversion Tool [ECT)Mnput Files\GenerateTemplate3.xls
INFO: {0}
INFO' {0}
INFO: {0} Columns found in record 3:
Fuel Code, Process Code, Production Date, Fuel Category Code, Batch Volume, Denaturant Volume, Equivalence Value, RIN Quantity,
Import Facility Identifier, Generate Organisation Identifier, Generate Facility Identifier, Batch Number Text, Transaction Detail Comment Text,
Feedstock Code 1, Renewable Biornass Indicator 1, Feedstock Volume 1, Feedstock Measure Code 1, Feedstock Detail Comment Text 1, Feedstock Code 2,
Renewable Biomass Indicator 2, Feedstock Volume 2, Feedstock Measure Code 2, Feedstock Detail Comment Text 2, Feedstock Code 3,
Renewable Biomass Indicator 3, Feedstock Volume 3, Feedstock Measure Code 3, Feedstock Detail Comment Text 3, CoProduct Code 1 ,
CoProduct Detail Comment Text 1 , CoProduct Code 2, CoProduct Detail Comment Text 2, CoProduct Code 3, CoProduct Detail Comment Text 3,
INFO: {0} -em/^Ol0 11:10: 17PM
INFO: {0} InputFileSuccessfullyOpened
INFO: {0}
INFO' {0}
INFO: {0} Finished Loading Input Data.1 data records read.
INFO: {0}
INFO: {0} Input file: \GenerateT emplate3.xls <><><>
INFO: {0}
INFO: {0}
INFO' {0}

INFO: {0} Process record 8 1
ERR : {1 } Element Name of Fuel Category Code is missing . Column Name = Fuel Category Code. Data Grid Column 85
ERR : {1} Element Name of Fuel Category Code must be numeric . Column Name = Fuel Category Code. Data Grid Column 85
INFO: {0} Element Name of Feedstock Code 2 value is empty . Column Name = Feedstock Code 2. Data Grid Column 820
INFO: {0} Element Name of Renewable Biomass Indicator 2 value is empty . Column Name = Renewable Biornass Indicator 2. Data Grid Column 821
INFO: {0} Element Name of Feedstock Volume 2 value is empty. Column Name = Feedstock Volume 2. Data Grid Column #22
INFO: {0} Element Name of Feedstock Measure Code 2 value is empty . Column Name = Feedstock Measure Code 2. Data Grid Column 823
INFO: {0} Element Name of Feedstock Code 3 value is empty . Column Name = Feedstock Code 3. Data Grid Column 825
INFO: {0} Element Name of Renewable Biomass Indicator 3 value is empty . Column Name = Renewable Biornass Indicator 3. Data Grid Column 826 v
rn' fi L 	 " " ' ""'''"' j 	 ~" 	 ? 	 ' i: " '''•'••'•••• ••'"•' r-:;i~ 	 •• ••" m\ >
Print Log Open Another Log Exit

The user can access the log by going through the C: drive to My Documents folder selecting the "EMTS
Conversion Tool (ECT)" folder and then accessing the "valjog" folder. Additionally, the user can access the
log under "Show Log" on the toolbar of the ECT at any point of the process (see Figures 2-15 and 2-16).
                                                                                            27

-------
 EMITS Conversion Tool
Figure 2-15: "Show Log" Function on the File Selection Screen
    EMTS Conversion Tool (ECT)
   File   Help   File List View   Show Front Page  (show Loo)  WinZip

   Welcome: KKuhn . This application will format an Excel or delimited file for conversion to XML. For questions concerning compatibly refer to Help/About ECT.

    Step 81  - If using a delimited file specify delimiter.
    Start by putting your data in a compatible delimited format.
    The default method is to let this application figure out if it is a tab, comma, or bar delimited format.
    Otherwise, you may choose your own delimiter.
Delimiters

  Default

  Bar
    This option is not needed if using an excel file, application will determine file type by it's extension.
Tab

Other:
           Comma
step uz. - seieci nieisj
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 Build a New File button.

+ _J Application Data
CJ Cookies
+ 	 | Desktop
Pj Favorites
EH-Pj Local Settings
B-CJ My Documents
!-CJ Downloads
B- P 1 EMTS Conversion To<
!•• Pi Error_Files
Pj Good_Files
: -Pj History_Files
;• t3 lnput_Files
CJ Val Log
Pj EmtsConversionTool
!•• CJ FormafXML
I -Pi My Data Sources
; PJ My Music
!•• Pi My Pictures
- CJ My Videos
S-CJ NetHood
+ Pi personal
CJ PrintHood
PJ Recent v
.< , 1 >!~
Name | Size
s BuyExample.xls 27,136
Ml BuyTemplate.xls 27,136
Mi GenerateTemplate.xls 51,712
1 GTernplate.xls 51,712

= RetireTemplate.xls 40,960
'i! SellTemplate.xls 33,792
= SeparateTemplate.xls 39,424














Modified I Attribute I
4/7/201 01:50:59PM A
4/12/2010 12:09:40 PM A
4/12/2010 12:09:40 PM A
4/5/201 01 2:22:52 PM A

4/12/2010 12:09:40 PM A
4/12/2010 12:09:40 PM A
4/12/2010 12:09:40 PM A















Process
Existing
File(s)
Or

Build a New
File



Or


Exit












r- lies
Input File(s) Folder: jCADocuments and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)Mnput_Files
*Good File(s) Folder: | CADocuments and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)\Good_Files
"Bad File(s) Folder : | CADocuments and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)'\Error_Files
Log File(s) Folder : |CADocuments and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)Wal_Log
History File(s) Folder |CADocurnents and Settings\kkuhn\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

                                                                                                                                        28

-------
 EMTS Conversion Tool
Figure 2-16:  "Show Log" Function on the Processing Screen
 x^ Gene rate Transaction - Processing file:
  Process  Rows  Columns  Help
 Step *3 - Enler Company Info       	^	
•User Login: [H       - Submittal Creation Date: 12010-02-01   Submission Comment: [
  Organisation ID:
 Step tt4 - Select column to upload
  Add Hew Empty Row
                                                                                                        Header Infomation
                                                                                                        "Application Use. ID: |^T~
                                                                                                        Transmission ID: TED
  ie e:t th= appropriate :olumn= l"on the drop-ido'. .'n_- belo'.1.' Refer :o :he l = g = ni on the niddle right a.- to '.'.'hether li = li_- a-e reqi.i red :r •-.:.[ RO.'.J .: a-- be jorted DV .;li.:l n; on :he column header I. hanger rriads '. .'ill b= rsnected in the --e.1.' oi.itpi.it tile and
   2.5  Setting File Options

To set various  output file options, click the "Output File Options" button on the File Processing screen (see
Figure 2-17).
                                                                                                                                 29

-------
 EMTS Conversion Tool
Figure 2-17: Output File Options Screen
 SI 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
        I   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
        C  Compress only the XML File for Node Submission/Transmission
        r~  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
        r 0 verride the default name of T tO rgl d_YVYY-M M -D D -H H -M M -S S where T t is the T ransaction Type.
         Overridden File Name:  [
            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)
        H  Display Processed File
                                                            OK
Most options chosen and set by the user are saved between application executions.  Those choices that are
NOT saved will be noted; otherwise, the user can assume that all the settings will be saved.  This includes
the override output file name; if the user does not return to this screen and enter a new name for each file
being processed, the file name previously entered by the user will be used for all files.
                                                                                                              30

-------
Section 3:  Uninstalling the Conversion Tool

This guide will discuss how to uninstall the EMTS Conversion Tool (ECT).  If a version of the Conversion
Tool is already installed, the user must uninstall the existing version of the Tool before installing a new
version.

Prior to installing the new version it is recommended that the user save a backup of the current version.  If
the ECT fails to completely uninstall, the new install  will fail.  Reinstalling the saved version,  and then
uninstalling again, will often fix this.

Please note that the user must completely exit the ECT application before attempting to uninstall the tool.
If the user has not completely exited the tool (i.e., if there are still processing screens up), the tool will not
completely uninstall even though the tool no longer appears in the "Add or Remove Programs" panel.  In
order to correct this, the user must re-install the version that was being used and uninstall it properly, as
noted in the previous paragraph.

To begin  uninstalling an existing version of the ECT, the user should access  the  "My Computer" link
available on the Start Menu (see Figure 3-1).
                                                                                              31

-------
EMITS Conversion Tool
Figure 3-1: "My Computer" link
                             Internet
                             Mozilla Firefox

                             E-mail
                           L' Microsoft Office Outlook
fcjjj e - texteditor


  Si  Microsoft Office Word 2007


      Command Prompt


      EMTS Conversion Tool (ECT)


      Microsoft Office Excel 2007


      Shortcut to
      sqldeveloper.exe
  / My Documents

 -ฃ\ My Recent Documents

'
                                                         My Pictures

                                                         My Music
            ter)
                                                         My Computer
                                                           1 Network Places
                                                      4* Control Panel

                                                     fl\ Set Program Access and
                                                       " Defaults

                                                         Printers and Faxes
From "My Computer", the user should look under the "System Tasks" tab on the left side of the window and
select "Add or remove programs" (see Figure 3-2).
                                                                                                      32

-------
EMITS Conversion Tool
Figure 3-2: "My Computer" Location
 ? My Computer
File   Edit   View   Favorites   Tools   Help

Qeack  •   Q  -
                                                                                                                  f
                                 Search    > Folders
 Address | "ij My Computer
                      ^H
    System Tasks

     !?| View system information
                                   Hard Disk Drives
        Change a setting
                                     Devices with Removable Storage
                                              DVD-R AM Drive (D:)
        My Network Places
        My Documents
        Control Panel
                                   Network Drives
                                                                                 h on Voseriver.pqa.local\root
                                                                                 (HO
                                            g on 'thornton.pqa.local' (G:)
     My Computer
     System Folder
                                              i on roseriver.pqa.locauroot (I:)
                                                                               j on hazel.pqa.local (J:)
                                                                                                                    33

-------
EMITS Conversion Tool
On the "Add or Remove Programs" window shown in Figure 3-3, the user should click on the record for the
EMTS Conversion Tool (ECT) and then press the "Change/Remove" button within the record.
Figure 3-3:  "Add or Remove Programs" Window
        Add or Remove Programs
                                                                            n  x
       Add New
       Programs
      Add/Remove
       Windows
      Components
      Set Program
      Access and
       Defaults
                   Currently installed programs:
                                       Show updates
Sort by: Name
                    H Adobe Reader 9.2

                    | Broadcom Gigabit Integrated Controller

                    ฃ=J Compatibility Pack for the 2007 Office system

                    \5jjjfCutePDF Writer 2,8
|j$ EMTS Conversion Tool (ECT)
   Click here for support information.
                       To change this program or remove it from your computer, click
                       Change/Remove,
,g(, FileMaker Pro 7

0FileZillaClient3.3,0.1

^ Google Chrome

•f Intel(R) Graphics Media Accelerator Driver

yy Java(TM) 6 Update 17
                    Rcitt I \>.ti=,\ lr.rlal-
                                ^ Tl f^ji
                                                                 Size   210,00MB

                                                                 Size     0.48MB

                                                                 Size   143.00MB

                                                                 Size     0,30MB
        Change/Remove
        ^^^^^m
         Size  272,00MB

         Size   15,88MB

         Size   67,41MB



         Size   91.04MB
                                                                                                         34

-------
EMTS Conversion Tool
The resulting screen (see Figure 3-4) prompts the user to "remove the application from this computer" by
clicking "OK". Doing so successfully uninstalls the EMTS Conversion Tool.
Figure 3-4:  "EMTS Conversion Tool (ECT) Maintenance" Window
             EMTS Conversion Tool (ECT) Maintenance
               EMTS Conversion Tool (ECT)
                 Choose the type of maintenance you need.
                           Restore the application to its previous state,
                     l   0 Remove the application from this computer.
                                            OK
Cancel

Note that uninstalling the ECT will not remove the "WRITE" folder or its contents, located by default at:

       C:\Documents and Settings\\My Documents\EMTS Conversion Tool (ECT)

For instructions on changing the location of the "WRITE" folder, please see Section 2 "Installing and Setting
Up the Conversion Tool".
                                                                                               35

-------
Section 4:  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 4-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 4-1: EMTS Conversion Tool Input File Directory
    EMTS Conversion Tool (ECT)
  File  Edit   View  Favorites  Tools  Help
Back '
              j
JD
                            Search
Folders
 Address  ฃ3 C:\Documents and 5ettings\wgo\My Documents\EMT5 Conversion Tool (ECT)
       Make a new folder
       Publish this Folder to
       the Web
       Share this folder
                                     •tj-roi Ftes;
             History_Files
                                     Val_Log
                                           Good Files
                                                                 HUB
                                                                       if
                                                                      Go
  4.1  Opening the Basic ECT

The ECT can be opened from the Start Menu. Upon starting the ECT, the start-up screen is displayed (see
Figure 4-2).
                                                                                                 36

-------
 EMITS Conversion Tool
Figure 4-2: Start-up Screen
    EMTS Conversion Tool (ECT) Front Page
                                                                                  -  n  x
   File   Help

                  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.
                    Go directly to Build a New XML File by-passing the file and folder selection displays.
                    Processing is the same for Advanced or Basic versions.
        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 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".


  4.2  Selecting Files

After clicking the "Go" button, the File Selection Screen appears (see Figure 4-3).
                                                                                                              37

-------
EMITS Conversion Tool
Figure 4-3: File Selection Screen
H EMTS Conversion Tool (ECT)

File Help File List View Show Front Page 5how Log WinZip
Welcome: wgo . This application will format an Excel or delimited file for conversion to XML.
Step ttl - Select File(s)
Select a Folder on the left panel and File(s) on the right panel and click on the Process Filel

r

00S
-or questions concerning compatibilty refer to Help/About ECT.
s] button to process OR Select the Build a New File button.

: -Cl Error_Files
LB Q Good_Files
L] History_Files
ffl €3 lnput_Files
Q Val_Log
B-Q FinePrint files
Q FormafXML
Pi My Google Gadgets
(~~l My Music
:• Q My Pictures
D My Videos
E Q My Virtual Machines
: Q New Folder
E Q PDF files
+ 	 1 TotalValidatorTool
+ •_] NetHood
CJ PrintHood
LJ PrivaclE
O Recent
Q SendTo
a-Cl Spark
ซ Q Start Menu
C~\ Templates v
Name
=• BuyDenyTennplate.Kls
=: BuyTernplate.xls
S; GenerateTemplate.Kls
a] RetireTernplate.xls
3 SellTemplatexIs
B SellTemplateCancel.xls
=', SeparateTernplate.xls



Size
30,720
27,136
51,712
40,960
33,792
37,376
39,424



Modified
3/1 0/201 01 0:56: 05 AM
4/1 4/2010 3: 49:52 PM
4/1 4/201 03: 49:52 PM
4/1 4/201 03: 49: 52PM
4/1 4/201 03: 49:52 PM
3/9/2010 11 :00:27PM
4/1 4/201 03: 49:52 PM



Input File(s) Folder: |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\lnput_Files
*Good File(s) Folder: |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT]\Good_Files
"Bad File(s) Folder : [C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\Error_Files
Log File(s) Folder : |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT]Wal_Log
Attribute ]
A
A
A
A
A
A
A


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



Set Path
Set Path
Set Path
Set Path
History File(s) Folder: [CADocuments and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)MHistory_Files
"Location of formatted output that has NO errors. ""Location of formatted output that has errors.
Set Path

4
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-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 4-8).
                                                                                                 38

-------
EMTS Conversion Tool
  4.3   Processing Files
The File Processing screen  is depicted in Figure 4-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-4:  File Processing Screen
 ' BuyTransaction - Processing file: BuyTemplate2.xls
  Process  Rows  Columns  Help  5how Log WinZip
  Step 82 -Enter Company Info     	^—^—

                                                                                     Header Infomation
                                                                                    "^plication Usei ID: |
                                                                                    Transmission ID: TED
  Step tt3 - Process And Wrile to XML File

   Output File Options  Bull/Slop Recessing
  Progress:
                       Finished Loading Input Data.1 data records read.
 •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••I
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 4-5).
Figure 4-5:  "Output File Options" Button
 Process Rows  Columns  Help Show Log  WinZip
 Step tt2 -Enter Company Info
m Dale: |2010-01-26  Subm
                                                                                Header Inlomation
                                                                                '.^plication User ID: |
                                                                                Transmission ID: TED
                                                                            ftf,f,\y User Login Value
  StepJ*3 - Process And Write to XML File

  (I Output File Options J) EnWSlop Processing

    Recess File
  Progress:
                      Finished Loading Input Data.3dat
 Illlllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllllll
On the Formatted Output File Options screen (see Figure 4-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
the file being processed to the end of the new file name. Once a user updates the Formatted Output File
                                                                                                        39

-------
 EMTS Conversion Tool
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 4-6: Formatted Output File Options Screen
 BH Formatted Output File Options
                File t/pe 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 (i( 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
        f~  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.
         OverriddenFileName: | El atchQ neG eneratej
        	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 4-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.
                                                                                                            40

-------
EMTS Conversion Tool
Figure 4-7:  "Next file" Button
 ' BuyTransaction - Processing file: Buy6izoBlenders.xls
 Process  Rows  Columns  Help  Show Log  WinZip
               Into
 Step 82 - Enter
 * User Login: ~'
              ' Submittal Creation Dale: 2010-02-01   Submission Cor
                                                                Header Intonation
                                                                '/^plication User ID: |epa
                                                                Transmission ID: TED
                                                                                                        Is*1 ฃf,f,\y User Login Vali
  Step tt3 Process And Write to XML File
             EKii/Stop FVocessing
    Rooess File  Q  Newt file  ^

  Progress:
Finished Loading Input Daca.1 data records read.
  4.4  Creating New Files

If the "Build a New File" button is clicked on the Start-up Screen (see  Figure 4-2) or the File Selection
Screen (see Figure 4-3), a screen will appear asking the user to specify the transaction type (see Figure 4-
8). Note that the user can also click on the "Build a New File" button that is available on the start-up screen
(see Figure 4-2).
Figure 4-8: Selecting the Transaction Type
                             Choose the Transaction Type
                           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 4-
9).
                                                                                                                41

-------
EMTS Conversion Tool
Figure 4-9:  File Processing Screen
  Process  Rows  Columns Help  Show Log  WinZip
  Step S3 - Enter Company Info     	-^^^^
 • User Login: \\       • Sjbmitlal Creation Date: 20113-0^13 ~ I Si
 •Step IM - Select column to upload
 Add New Empty Rol*  Copy Row|s| to NWr P.ol*r[s) |  Delete P.ow|s] |
                                        Header Infomation
                                        '^plication User l[>. |
                                        Transmission ID: TED
                                                                                         ^ Apply User bjgin Value
> Show Legend; <== \
  Step lib - Process And Write to XML File
  Progress:
 • ••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••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.

  4.5   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 4-10).
                                                                                                        42

-------
 EMTS Conversion Tool
Figure 4-10:  A Successfully Processed File
 Step tt3 - Process And Write to XML File
                                  Recessing Data. Approw Records to
                                  Finished processing Input Dat.
                                   Formatted to: XML file.
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):<...>,".  Figure 4-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 4-11:  An Unsuccessfully Processed File

    Step tt3 - Process And Write to XML File
      Output File Options
Recessing
        Process File
    Progress:
 Status
Missing or incorrect value for required element (s) in record (s): 1,
Missing or incorrect value for formats element (s) in record (s): 1,
Processing Data. ApproH 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 4-12). The log displays both informational messages  (indicated by a label of
"INFO" at the beginning of a row) and error messages (indicated by a label of "ERROR" at the beginning of a
row). The log 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.
                                                                                                    43

-------
EMTS Conversion Tool
Figure 4-12: Errors Reported in Log File
IS C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)WalJ-og\ECTLogFile_2010 06 14-22-28 00... [
INFO:
INFO:
INFO:
ERR:
ERR:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
ERR:
ERR:
INFO:
I N Fl~l •
INrU.
INFO:
ERR:
I M Ffl •
INrU.
ERR:
I M FTl •
INrU.
in}
{0}
{0}
{1}
{1}
{0}
{0}
{0}
{0!
{0}
1(1}
{0}
{0}
m
{i}
{0}

in}
<1)

111
1 M1-
lUr



Process record 8 1
Element Name of Fuel Category Code is missing . Column Name = Fuel Category Code. Data Grid Column 85
Element Name of Fuel Category Code must be numeric . Column Name = Fuel Category Code. Data Grid Column B5
Element Name of Feedstock Code 2 value is empty . Column Name = Feedstock Code 2. Data Grid Column 820
Element Name of Renewable Biomass Indicator 2 value is empty . Column Name = Renewable Biomass Indicator 2. Data Grid Column 821
Element Name of Feedstock Volume 2 value is empty . Column Name = Feedstock Volume 2. Data Grid Column 822
Element Name of Feedstock Measure Code 2 value is empty . Column Name = Feedstock Measure Code 2. Data Grid Column 823
Element Name of Feedstock Code 3 value is empty . Column Name = Feedstock Code 3. Data Grid Column 825
Element Name of Renewable Biomass Indicator 3 value is empty . Column Name = Renewable Biomass Indicator 3. Data Grid Column 826
Element Name of Feedstock Volume 3 value is empty . Column Name = Feedstock Volume 3. Data Grid Column 827
Element Name of Feedstock Measure Code 3 value is empty . Column Name = Feedstock Measure Code 3. Data Grid Column 828
Missing data for required fields on record(s): 1, Record will not be processed.
Non Numeric found, 'codes' must me numeric, incorrect format for fields on record(s): Record will not be processed.


Processing Summary!
Missing or incorrect value for required element(s) in record(s): 1 ,

Missing or incorrect value for formats elernent(s) in record(s): 1 ,


Print Log Open Another Log

3ฎฎ
A

















=


V
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.

  4.6  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 4-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.

Figure 4-13: Processing Next File
  Step S3 - Process And Write to XML File
l~ Status
Output File Options Erat/Stop Recessing Recessing Data. ฃppron Records to be processed = 1
FVocess File KT Newt File |)
Drogress:
Formatted to: XML file.
Compressed to: No compressions were selected.
1 records were successfully processed.


-------
Section 5:  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 5-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 5-1:  EMTS Conversion Tool Input File Directory
   EMTS Conversion Tool (ECT)
  File  Edit   View  Favorites  Tools   Help
Back '
                         O Search  [0 Folders
 Address
           : \Documents and Settings\wgo\My Documents\EMTb Conversion Tool (ECT)
       Publish this folder to
       the Web
       Share this folder
                                     ฃrraL.Fjesj
                               History_Files
                                     Val_Log
                                                             Good Files
ฃ        I Input_Files   )
                                                                                        -
                                                                                         /'
                                                                                              Go
  5.1  Opening the Advanced ECT

The ECT can be opened from the Start Menu. Upon starting the ECT, the start-up screen is displayed (see
Figure 5-2).
                                                                                                45

-------
 EMITS Conversion Tool
Figure 5-2: Start-up Screen
    EMTS Conversion Tool (ECT) Front Page
                                                                                  -   n  x
   File   Help

                 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.
                    Go directly to Build a New XML File by-passing the file and folder selection displays.
                    Processing is the same for Advanced or Basic versions.
        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 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".


   5.2  Selecting Files

After clicking the "Go" button, the File Selection Screen appears (see Figure 5-3).
                                                                                                              46

-------
EMITS Conversion Tool
Figure 5-3: File Selection Screen
File Help File List View Show Front Page
Welcome: wgo . This application will format an Excel
Step HI If using a delimited file specify de
Start DJJ putting your data in a compatible delimited fc
The default method is to let this application figure on
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 compatibilty refer to Help/About ECT.

rrnat. Dellmiters
if it is a tab, comma, or bar delimited format. (• Default f* Tab <~ Comma
T Bar r 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 Build a New File button.

LJD Error_Files
B Q Good_Files
: Q History_Files
H -ฃ3 Input Files
U Val_Log
[* Pj FinePrint files
Pj FormarXML
:--C| My Google Gadgets
Q) My Music
Pj My Pictures
\- C3 My Videos
& CJ My Virtual Machines
Pj New Folder
+ _| PDF files
E Pj TotarValidatorTool
H--PJ NetHood
i -PJ PrintHood
Q PrivaclE
Pj Recent
Pj SendTo
ffl-Pj Spark
a-Pj Start Menu
••Pi Templates v
< '"" 1 >
Name Size Modified Attribute
f| BuyDenyTernplate.xls 30,720 3/1 0/201 01 0:56:05 AM A
H BuyTemplate.xls 27,136 4/14/2010 3: 49: 52PM A
H BuyTernplate2.xls 30,720 3/10/2010 10:56:05 AM A
1 GenerateTemplate.xls 51,712 4/1 4/201 03: 49: 52PM A
S| RetireTernplate xls 40960 4/1 4/201 0 3 49 52 PM A
a] SellTemplate.xls 33,792 4/14/2010 3: 49:52 PM A
1] SellTemplateCanceLxIs 37,376 3/9/2010 11:00:27 PM A
1 SeparateTernplate.xls 39,424 4/1 4/201 03: 49:52 PM A

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





rues
nputFile(s) Folder: |C:\Documents and Settings\wgo\My Documents^EMTS Conversion Tool (ECT]Mnput_Files Set Path
'Good File(s) Folder: [CADocuments and Settings\wgo\My Documents^ MTS 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 • |C:SDocuments and Settings\wgo\My Documents^ MTS Conversion Tool (ECT)Wal_Log Set Path
History File(s) Folder: [C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)lJHistory_Files
"Location of formatted output that has NO errors. ""Location of formatted output that has errors.
Set Path


A
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 5-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 5-4) when "Process Existing
                                                                                                 47

-------
 EMITS Conversion Tool
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 5-16).
   5.3    Processing Files
The  File  Processing Screen is  depicted  in  Figure  5-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 5-4:  File Processing Screen
   Process  Rows  Columns  Help  Show Log  WinZip
   Step H3 - Enter Company Info      	j^^^^
  •User Login:  [        • Submittal Creation Oats: j 2010-04-19
  Step U4 - Select column to upload
   AJd New Empty Row   Copy Rovjfs] to Hei,7 Rovvfs]  Delete Row(s)   Set Columns to Recommended Defaults   Import/Export Company Column Names
  Select the appropriate columns from the drop-downs below. Refer to the legend on the middle right 3* to vjhether held_- ar= required o
  MOT on the input file.
                                                                       t. Rows can be sorted by clicking on the column header Chariot^ mad^ visll fae reHeaed in the new output file and
    Required Field:
   • FuelCode
   • BatchVolume
   T Fuel Category Code
   * Ft eduction Dale?
   • RocessCode
   * RINQuantity
   * Generate Facility Identifier
    Batch Number Ten!
Fuel Code
Batch Volume
Fuel Category Code
Reduction Date
Ftocess Code
RIN Quantity
Generate Facility Identifier
B-sMh Number Tent
3
3
3
3
3
3
3
3
   Optional Fields
   DenalurantVolume
   EquivalenceValue
Denaturant Volume
                         | Equivalence Value
                         j Generate Organization Identifier    T-|
   Transaction Detail Comm
   Import Facility Identifier
                         IT,,,
                            j ti'.'i! Qi i !il r-.i-,irrir>nt Tent   T
                         [import Facility Identifier
                     CoProduct Fields-Up
                      CoProduciCodel
                      CoProduct Detail CommentTeKtl
                      CoRoductCode2
                      CoRoduotDetailCommentTeKt2
                      Co Product CodeS
                      CoProduetDelailCommentTentS
| Co Product Code I
CoFroduct Detail Comment Ten
|CoRoduclCode2
                 3
CoRoductCode3
Feedstock Fields - Minimum =
" Feedstock Code!
* Renewable Biomass I ndica to r
1 Feedstock Volume 1
1 Feedstock Measure Code 1
• Feedstock Detail CommentTe
" Feedstock Code2
                                                                                                           : t.-J-,iiimijrr, = 3 sets
|Feedstock Code 1
                                                                * Feedstock Measure Code2
                                                                1 Feedstock Detail CommentTeHt2
                                                                * Feed stock Code3
                                                                1 Renew able Biomass Indicators
                                                                ' FeedstockVolume3
                                                                1 Feedstock Measure CodeS
                                                                ' Feedstock Detail CommentTeHt3
Feedstock Volume 1        "T]
Feedstock Measure Code 1      -r
Feedstock Detail Comment Tent 1   TJ
I Feedstock Code 2         ^
I Renewable Biomass Indicator 2    TJ
| Feedstock Volume 2        ^
|Feedstock Measure Code 2     ~*\
|Feedstcck Detail Comment TeHt 2   -rl
| Feedstock Code 3         ~^\
[Renewable Bioma^ Indicator 3   ~^\
I Feedstock Volume 3         -r I
Feedstijcl.- Measure Code 1     V]
[Feedstock Detail Comment Text 3  V]
   Step 85 - Piocess And Write to XML File
    Output File Options  E^it/Stop Recessing
                             Finished Loading Input Data.1 data records read.
   Progress:
  •••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••I
                                                                                                                                              48

-------
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.

  5.4  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-5).

Figure 5-5: Selecting Recommended Default Headers
 Step tt4 - Select column to upload
  Add New Empty Row
Copy Row(s) to New Row(s)
Delete Row(i
Set Columns to Recommended Defaults
Import/Export Cor
 Select the appropriate columns from the drop-downs below. Refer to the legend on the mlJdly light dt LU Whether fields are required or not. Row
 NOT on the Input file.

The drop-downs will be populated with the recommended default headers (see Figure 5-6), and will match
the column headers of input files that use the recommended defaults (see Figure 5-7).

Figure 5-6: Drop-downs that Must Match the Columns
Hequired Fields
1 Transaction Partner Organisation Identifier
* AssignmentCode
1 Fuel Code
1 RIN Quantity
1 Transaction Partner Organisation Name
' RINYear
* Buy Reason Code
1 Transaction Date
Transaction Partner Organisation Ident T |
Assignment Code T |
Fuel Code T |
RIN Quantity T |
Transaction Partner Organisation Nam f |
RIN Year _rj
Buy Reason Code T |
Transaction Date T |

Supporting Document Fields - Up to 2 sets
SupportingDocumentTeHt"!
Supporting Document NumberTeHt 1
Supporting DocumentTent2
SupportingDocumentNumberTeKt2

Supporting Document TeHt 1 T |
Supporting Document Number Tent 1 *r |
Supporting Document Tewt 2 T |
Supporting Document Number Tent 2 T |
Optional Fields
BatchVolume
RINPriceAmount
TransactionDetailCommentTeKt
PTD Number
Gallon Price Amount
GenerateOrganisationldentifier
BatchNumberTent
Generate Facility Identifier
All Remaining Fields
Batch Volume
RIN Price Amount
Transaction Detail Comment TeHt
PTD Number
Gallon Price Amount
d
d
d
d
d
Generate Organisation Identifier T |
Batch Number Tewt
Generate Facility Identifier
r
d
d
d

                                                                                               49

-------
EMTS Conversion Tool
Figure 5-7:  Matching Default Columns to Labels
                    EH BuyTiansaction - Processing file: BuyExample.xls
                      Process   Rows   Columns   Help   Show Log   WinZip

                      Step tt3 - Enter Company Info
                     1 User Login:

                     1 Organization ID:
                      Step tt4 - Select column to upload
                    [ 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
                                 Transaction Partner
                                 Organization Name
ractic.n Partner Organisation Idefr^30'10" Parlner Organization IdentjJ)
                               Assignment iJode               T
                       * Assignment L03e
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 5-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.
                                                                                                        50

-------
EMTS Conversion Tool
Figure 5-8:  Matching User-Defined Column Headers to Labels
                    H BuyTransaction - Processing file: BuyExample.xls
                      Process   Rows   Columns    Help   Show Log   WinZip
                      Step tt3 - Enter Company Info
                      : User Login: epa
                                            [ Submittal Creation Date:  2010-02-01
                                                                          Submission Comme
                     1 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.
                       #    (  Trade ID    J

                      1      Q&9-I	^
Transaction Partner
Organization Name
                                         EPA Fuels
RIN
Quantity
Bat>
Voli
                                                                     2000
                      (^Transaction Partner Organisation Identified*
                      1 Assignment Lode

                      1 FuelCode

                      1 RIN Quantity

                      1 Transaction Partner Organisation Name

                      1 RINYear

                      1 Buy ReasonCode
               Supporting Document Number TeKt 1  A i
               Supporting Document Number Te:-it 2
               Supporting Document Tent 1
               Supporting Document TeKt 2

               transaction Date
                Dsaction Detail Comment Tent
                      Partner Organisation Hป"ซ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.
                                                                                                        51

-------
 EMTS Conversion Tool
   5.5  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 5-9).
Figure 5-9:  Import/Export Company Column Names Button
งง By/Transaction - Processing file: BuyExample.xls
  Process   Rows  Columns   Help   Show Log   WinZip
  Step S3 - Enter Company Info        —-^—
 :'Usertj>gin: |epa        • Submittal Creation Date: |2010-02-01   Submission Comment:

 * Organization ID:
  Step tt4 - Select column to upload

  Add New Empty Row

Copy Row[s) to New Row(s) |  Delete Row[s)  | Set Columns to Recommended Defaults | (^JmportJEKporl Company Column Names: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 5-10).
                                                                                                               52

-------
EMTS Conversion Tool
Figure 5-10: Column Name Import/Export Screen
 US 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 5-11).
Figure 5-11: Saving Profile with User-Defined Column Names
                       Change the name if desired
                         Profile File Name
                                                                   OK
                                                                  Cancel
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 5-12).
                                                                                              53

-------
EMTS Conversion Tool
Figure 5-12: Company Column Names Screen with Saved Profile
 US 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.

  5.6  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 5-13).
Figure 5-13: "Output File Options" button
  Step tt5  Process And Write to XML File
  f	'    ;—4.
   Output File Options JJ Bull/Stop Processing
    *—
     Recess File
  Progress:
      Status
                               Finished Loading Input Data.3 data records read.
                                                                                                   54

-------
 EMTS Conversion Tool
On the Formatted Output File Options screen (see Figure 5-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 5-14: Formatted Output File Options Screen
 ffl] Formatted Output File Options
               File type XML is the ONLY option required for submission/transmission

        File Type(s)
        1^ XML - This is the ONLY option required for subrnission/transmission
          Excel - For your use only, not to be transmitted (i( 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.
        OverriddenFileName:  | B atchQ neG eneratej
            Do NOT include the Folder (Path) name. The "Good Files" folder is assumed.
       -Other File Qption(sj
          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 5-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.
                                                                                                       55

-------
EMTS Conversion Tool
Figure 5-15: "Next file" Button
  Step 85 - Process And Write to XML File
   Output File Option;
Ewit/Stop Processing
                                  Status
     Recess File
                                  Finished Loading Input Data.5 data records read.
  Progress:
  5.7   Creating New Files

If the "Build a New File" button is clicked on the Start-up Screen (see Figure 5-2) or the File Selection
Screen  (see Figure 5-3), a screen will appear asking the user to specify the transaction type (see Figure 5-
16).
Figure 5-16: Selecting the Transaction Type
                           Choose the Transaction Type
                         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 5-
17).
                                                                                                        56

-------
 EMITS Conversion Tool
Figure 5-17: File Processing Screen
  Process Rows  Columns  Help  Show Log  WinZip
  Step S3 - Entei Company Info     	^^^^
 "User Login; \\        *Submiltal Creation Date: [2010-0-1-19
 * Organisation ID: [
  Step 04 - Select column to upload
  Add New Empty Row  Copy RGW(S) lo New Rowfs)
                                                   Headei Intonation
                                                  ^plication User ID: |
                           " V .apply User Login Value
                                           ==> Show Legends ซ==
  Select the appropriate tokimn:r From (he drop-downs below Refer to the legend on the middle tight as to whether fields -are required or n
  NOT on the input file.
                                                                        cried by clicking on the column header. Changes made will be resetted in the n
   Required Fields
   FuelCode
   Batch Volume
   Fuel Category Code

   Production Date
   Process Code
   RINQuanlily
   Ge n er ate Fa c i lity 1 de ntifie r
   3;t;hMi.:mberTeHl
   Optional Fields
  De na tu r an I Volume
  EquivalenceValue
  GenerateOrganizadon Identifier
       i Detail CommentTew
CoProducr Fields - Up K
 CoPfoductCodel
 CoFVoduot Detail Comm
 Co Product Code2

 Co Product Detail Cornrn
 CoRoductCode3
 Co Ptodutt Detail C-omm
Feedstock Fields - Minimum = 1 se
" Feedstock Code 1

' Renewable Biamass Indicator!
" FeedstochVolumel

* Feedstock Measure Code 1
" Feedstock Detail CommenETentl
1 Feedstock Code2

1 Renewable Biomasshdicaor 2
' FeedstocWolume2
* Feedstock Measure Code2

" Feedstock Detail CommentTent2
' Feedstock CodeS

" Renewable Biomass Indicaior3
" FeedstockVolumeS
* Feedstock Measure CodeS

' Feedstock Detail CommenlTentS
  Step it!-. - Process And Write to XML File

   Output File Options  Exit/Stop Recessing
  Piogress:
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.
                                                                                                                                57

-------
EMTS Conversion Tool
  5.8  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 5-18).
Figure 5-18:  A Successfully Processed File
 Step tt5 - Process And Write to XML File
  Output File Options
^Kit/Stop Rocessi
     Rocess File
Recessing Data, ^ppron 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.
 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 5-19).


-------
 EMITS Conversion Tool
Figure 5-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 f \



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 ^ 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 5-20:  Errors Reported in Log File
ffl C:\Documents and Settings\wgo\My DocumentsXEMTS Conversion Tool (ECT)WalJ-Og\ECTLogFile_201 0-06-1 4-... Q@ฎ
CoProdu
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
ERR:
INFO:
ikirn.
<
ct Detail (
{0}
{0}
{0!
ill}
{0}
{0}
{0}
(0}
{0}
{0}
ill}
ill}
1}
{0!
fnl
:omment Tent 1 , CoProduct Code 2, CoProduct Detail Comment Tent 2, CoProduct Code 3, CoProduct Detail Comment Text 3, A
-6/14/2010 11:20: 07PM
Input File Successfully Opened
Finished Loading Input Data.1 data records read.
Input file: \GenerateTemplate4.xls <><><>
Process record tt 1
Element Name of Batch Volume is missing . Column Name = Batch Volume. Data Grid Column 86
Element Name of Feedstock Code 2 value is empty . Column Name = Feedstock Code 2. Data Grid Column 020
Print Log Open Ac

v
>
other 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.

  5.9   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 5-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.
                                                                                              60

-------
EMTS Conversion Tool
Figure 5-21:  Processing Next File
  Step tt5 - Process And Write to XML File
Output File Options
Process File
Bfit/Stop Processing
^** ' ~****
H.:>;.;t file
\fc__ __*
)
  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.
                                                                                                                    61

-------