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