EMTS Conversion Tool (ECT) User's Guide
SEPA
United States
Environmental Protection
Agency
-------
EMTS Conversion Tool (ECT) User's Guide
Compliance and Innovative Strategies Division
Office of Transportation and Air Quality
U.S. Environmental Protection Agency
SEPA
United States
Environmental Protection
Agency
EPA-420-B-10-037
August 2010
-------
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 10
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 fcontl
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 Fuels Reporting Forms Page:
h ttp://epa.gov/o taq/regs/fuels/rfsforms. h tm.
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].
United States
Environmental Protection
Agency
-------
EMTS Conversion Tool
Figure 1-1: Start-up Screen
HJ] EMTS Conversion Tool (ECT) Front Page
File Help
Convert a delimited text file or Excel file to EMTSXMLfile (files can be zipped).
r Advanced Version
- n x
Go
This version allows the flexibility 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.
-------
EMTS Conversion Tool
Figure 1-2: Toggling Between Basic, Advanced, and Build a File Versions
H EMTS Conversion Tool (ECT)
00S
1 File | Help File List View Show Front Page Show Log WinZip
Go To Advanced Version
| "* \ Go To Basic Version
Process Existing Files
Build A New File
Exit
jrmat an Excel or delimited file for conversion to XML. For questions concerning compatibly refer to Help/About ECT.
!s) on the tight panel and click on the Process File(s] button to process OR Select the Build a New File button.
A| 1 Name | Size
Modified | 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)
H 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
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--CJ Error_Files
: ES-Cj Good_Files
; d History_Files
I Sl-Gi lnput_Files
: d VaLLog
ffld FinePrint files
d FormatXML
! d My Google Gadgets
d My Music
d My Pictures
i -d My Videos
B d My Virtual Machines
id New Folder
| ffl d PDF files
!ฑ d TotaK/alidatorTool
+ LJ NetHood
!--d PrintHood
d PnvaclE
d Recent
d SendTo
ffi d Spark
Eld Start Menu
; d Templates v
< ' >
Name I Size | Modified I Attribute I
= BuyDenyTemplate.xls 30,720 3/10/2010 10: 56: 05 AM A
S BuyTemplate.xls 27,136 4/14/2010 3: 49: 52PM A
1 BuyTemplate2.xls 30,720 3/10/2010 10: 56: 05 AM A
H GenerateTemplate.Kls 55,296 4/19/2010 11:44:35 AM A
H RetireTemplate.xls 40,960 4/14/2010 3: 49: 52PM A
H SellTemplate.xls 33,792 4/14/2010 3: 49: 52PM A
1 SellTemplateCancelxIs 37,376 3/9/2010 11:00:27 PM A
H SeparateTernplate.xls 39,424 4/14/2010 3: 49: 52PM A
Process
Existing
File(s)
Or
Build a New
File
Or
Exit
Files
InputFile(s) Folder: |C:\Documents and Settings\wgoSMy DocurnentsSEMTS Conversion Tool (ECT)\lnput_Files
*Good File(s) Folder: [C:\Documents and Settings\wgo\My Docurnents\EMTS Conversion Tool [ECT)\Good_Files
"Bad File(s) Folder: (C:\Docurnents and Settings\wgo\My Docurnents\EMTS Conversion Tool (ECT]\Error_Files
Log File(s) Folder: |C:\Documents and Settings\wgo\My Docurnents\EMTS Conversion Tool (ECT)\Val_Log
History File(s) Folder: |C:\Documents and Settings'iwgoSMy 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
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 filefsj
is(are] selected, the "Process Existing File(sJ" 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)
HI 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.
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:
C Co
jlep 11^ - b elect I ne(Ej
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.
Cl Error_Files f-
E Q Good_Files
Cl History_Files
E-Q lnput_Files
Cl Val_Log
E-ffiS FinePrint files
Q FormatXML
Cl My Google Gadgets
Cl My Music
Cl My Pictures
Cl My Videos
fi Cl My Virtual Machines
Cl New Folder
E Cl PDF files
+ Cl TotalvalidatorTool
E-Cl NetHood
i -Cl PrinlHood
Cl PrivaclE
!-Cl Recent
Cl SendTo
IS -Cl Spark
ffl-Cl Start Menu
i-Pl Templates v
< i ~ "mi ' ^^HI m\
Name Size | Modified | Attribute
H BuyDenyTemplate.xls 30,720 3/10/2010 10: 56: 05 AM A
B BuyTemplate.xls 27,136 4/14/2010 3: 49: 52PM A
3 BuyTemplate2.xls 30,720 3/10/2010 10: 56: 05 AM A
1 GenerateTemplate.xls 55,296 4/19/2010 11:44:35 AM A
H Retire! emplate.xls 40,960 4/14/2010 3: 49: 52PM A
B SeHTemplate.xls 33,792 4/14/2010 3: 49: 52PM A
a SellTemplateCanceLxIs 37,376 3/9/2010 11:00:27 PM A
1 SeparateTemplate.xls 39,424 4/14/2010 3:49:52 PM A
Process
Existing
File(s)
Or
Build a New
File
Or
Exit
r flies
Input File(s) Folder: |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT]\lnput_Files
*Good File(s) Folder: [CADocuments and Settings\wgo\My Docurnents\EMTS Conversion Tool (ECT)\Good_Files
"Bad File(s) Folder : |C:\Documents and Settings\wgo\My Docurnents\EMTS Conversion Tool (ECT]\Error_Files
Log File(s) Folder : |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)Wal_Log
History File(s) Folder: |CADocuments and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\History_Files
"Location of formatted output that has NO errors. ""Location of formatted output that has errors.
Set Path
Set Path
Set Path
Set Path
Set Path
-------
EMTS 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)
GenerateTransaction - Processing file: GenerateTemplate.xls
Process Rows Columns Help 5how Log WinZip
Step 82 - Enter Company Info ^^^^
"User Login: |epa
* Organization ID: |
- Submittal Creation Dale 201C Ob I I - Submission Comment:
I Header Infomation
Application User ID: |epa
Transmission ID: TED
^ply User Login Valu
Step 113 - Process And Write to XML File
Output File Options Exit/Scop Recessing
Progress:
Finished Loading Input Data.1 data records read.
Figure 1-6: File Processing Screen (New File Being Built)
BuyTransaction - Processing file:
Process Rows Columns Help Show Log WinZip
Step tt3 - Enter Company Info
"Usei Login: [j - Submiltal Creation Date: 12010-04-13 V] Submis
* Organization ID: |
Step tt4 - Select column to upload
Add New Empty Row | Copy Row(s] to New Row(s] | Delete Row(s] |
==> Show Legends <==
Header Infomalion
"^plication User ID: |
Transmission ID: TBD
17 A,
Step 115 Process And Write to XML File
I f r
Output File Options Exit/Stop Rocessing
Progress:
Columns set to Recommended Defaults
-------
EMTS Conversion Tool
Figure 1-7: Processing Screen (Advanced Version)
Process Rows Columns Help 5how Log WinZip
Step il'J -Entei Company Info
User Login:
* Organization ID:
Step B4 - Select column to upload
Add Hew Empty Row I Copy Row[s] to Hew Row(s)
- Submufion Lorn merit
Header Inlomoti
'Application User ID: \
Transmission ID: TBD
I* Apply User Login Value
Set Columns to Reojmmended Default; Import/Ei-iFort Company Column Ham.
Select the appropriate columns from the drop-downs below. Refer to the legend on the middle right as to whether fields a
NOT on the input file.
t. Rows can be sorted by clicking on the column header. Changes made will be reflected in the n.
Transaction Partner Organisation Identifier
Assignment Code
FuelCode
RIHQuantity
Transaction Partner Organisation Name
RIHVear
Buy Reason Code
Transaction Date
SupportmgDocumentTexl 1
SupportingDocLimentNumberTextl
Supporting DocumentText2
SupportmgDocumentNumberTextS
[Transaction Partner Organization Iden
[Assignment Code
JFjel Code
JRIN Quantity
Transaction Partner Organization Nam
RINYear
|Buy Reason Code
[Transaction Date
[Supporting Document Text 1
Supporting Document Number Text 1
(Supporting Document Texts
[supporting Document Number Text 2
'1
3
'1
3
-1
-1
-1
^
-I
-1
'1
j-d
Batch Volume
RINPriceAmount
Tiansaction Detail CommentText
PTDHumber
Gallon RiceAmount
Ge nera te Or ga n is at ion Id en tif le r
Batch Humber Tent
Generate Facility Identifier
All Remaining Fields
(Batch Volume
1 R IN Price Amount
[Transaction Detail Comment Tent
|FTD Number
Gallon Ftice Amount
Generate Organization Identifier
Batch Number Text
| Generate Facility Identifier
1
3
d
3
_d
d
3
d
3
3
"Required Fields Optional Fields
Originating Source Detail Fields are conditionally optional.
Acceptable combinations are1
(*JI three elements absent.
Generate Organizer Identifier only.
Generate Organiser Identifier and Generate Facility only,
Generate Organizer Identifier. Generate Facility Identifier
and Batch Number
Supporting Du.tument Derails Fields are conditionally
optional.
If one item is present, then both fields must be present.
Reason Code: If a reason code of BO (cancel trade) is
Field Formats: All Organization Identifiers must be 4 digits
All Facility Identifiers must be 5 digits
AirCcides1 must be numeric.
Date Formats; Must be WYY-MM-DD and not > the
Submittal Creation Date. Formats of yyyy-m-d,yyyy/mm/dd.
yyyymmdds, or mldlyyyy hh'mm:?? will b= converted.
Step tt5 Process And Write to XML File
Piogre:
Finished Loading Input Data.1 data records read.
I
I
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
1
2
3
4
5
6
A B C D E
## Please refer to the "NOTES" tab if you need guidance or code
##This template corresponds with ECT 1.0.0.0
Transaction ^ Transaction
Partner Partner RIN Batch
Organization Organization Quantity Volume
Identifier Name
##1234 Bob's Ethanol "5000 "5000 "4
"2345 Marys Ethanol "6000 "6000 "4
F
s
i
Assignment
Code
r1
T\
G
^
RIN Year
"2010
"2010
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 Volume 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 Volume 2, Feedstock Measure Code 2
(if any one is present, the others are required];
Feedstock Code 3, Renewable Biomass Indicator 3, Feedstock Volume 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;
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;
Separate Reason Code; and
RIN Year.
The following data elements are conditionally required:
Supporting Document Text, Supporting Document Number (if one is present, the other is required];
Generate Organization Identifier (required if Generate Facility Identifier is present];
Generate Facility Identifier (required if Batch Number Text is present];
Blender Organization Identifier (required if reason code is 40: Upstream Delegation for Blending];
and
-------
EMTS Conversion Tool
Blender Organization Name (required if reason code is 40: Upstream Delegation for Blending].
The following data elements are optional:
Batch Number Text; and
Transaction Detail Comment Text
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
Transaction Date.
The following data elements are conditionally required:
Supporting Document Text, Supporting Document Number (if one is present, the other is required];
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;
PTD Number; and
Transaction Detail Comment Text.
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;
10
-------
EMTS Conversion Tool
RIN Quantity;
Fuel Code;
Assignment Code;
RIN Year;
Buy Reason Code; and
Transaction Date.
The following data elements are conditionally required:
Supporting Document Text, Supporting Document Number (if one is present, the other is required];
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; and
Transaction Detail Comment Text.
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;
RIN Year; and
Retire Reason Code.
The following data elements are conditionally required:
Supporting Document Text, Supporting Document Number (if one is present, the other is required];
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, this field is required];
-------
EMTS Conversion Tool
Compliance Facility Identifier (if Retire Reason Code is Demonstrate Annual Compliance, this field
is required]; and
Compliance Level Code (if Retire Reason Code is Demonstrate Annual Compliance, this field is
required].
The following data elements are optional:
Batch Number Text;
Batch Volume;
Compliance Facility Identifier;
Compliance Level Code; and
Transaction Detail Comment Text.
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 of YYYY-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;
~ 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];
12
-------
EMTS Conversion Tool
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 is less than 2010;
Transaction Date has a value greater than that of the Submittal Creation Date; and
If "RINYear" has a value prior to 2010.
-------
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 a version 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.00 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/oms/renewablefuels/epamts.htm
Two ECT files will be available at this location, in the form of Zip archives. The first file, "ECTvl.0.1.1.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.0.1.1.zip".
-------
EMTS Conversion Tool
Figure 2-1: Using WinZip to Extract the ECT
File Actions Options Help
New Open Favorites Add Extract Encrypt View Install Wizard
Name
Type
Modified
Size Ratio Packed CRC Attributes Path
&ECT InstaUer.rnsi j Windows Ins... 8/16/2010 11:10 AM 6,940,672 4% 6,642,571 56648efb A EctFullInstall\Release\
9setup.exe Install Applic.,, 8/16/2010 11:10 AM 430,592 50% 214,661 40021352 A EctFullInstall\Release\
Selected 0 files, 0 bytes
Total 2 files, 7,199KB
OO
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
Extract to: C:\unzipped\ECT Extracted
Desktop
i)
My Documents
My Computer
My Network
Places
BMr^ Program Files
B Ir"! unzipped
ECT Extracted
Sl-lr^i wamp
rj ฃ) WINDOWS
El ^ DVD-RAM Drive (D:)
ฉ 'ฃ$, n on 'roseriver.pqa. local' (H:
El jฃ ' on 'roseriver.pqa.local' (I:)
$96 i on 'hazel.pqa.local' (J:)
El 2ฃ software on 'Chv-fs' (N:)
Files
Selected files/folders
ฉ All files/folders in archive
O Files:
Q Open Explorer window
O Overwrite existing files
D Skip older files
0 Use folder names
SJ H
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
-------
EMTS 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:\unzippe d VEC T Ext racte d\Ect F u 111 nsta I l\Re lease
- n x
File Edit View Favorites Tools Help
Search
C:\unzipped\ECT Extracted\EctFullInstall\Release
File and Folder Tasks A
Make a new folder
Publish this folder to
the Web
Share this folder
EctFullInstall
My Documents
J My Computer
Go
The EMTS Conversion Tool Setup Wizard will guide the user through the steps required to install the ECT.
Click the Next button to continue (see Figure 2-4]:
-------
EMTS Conversion Tool
Figure 2-4: ECT Setup Wizard
iff 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. 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].
-------
EMTS Conversion Tool
Figure 2-5: Select Installation Folder
iff 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 FilesMJS EPAVEMTS Conversion Tool (ECT)\
Browse..
Disk Cost...
Install EMTS Conversion Tool (ECT) for yourself, or for anyone who uses this computer:
(~ Everyone
(* Just me
Cancel
< Back
Next>
Next you will prompted to confirm the installation. Click the Next button (see Figure 2-6].
-------
EMTS Conversion Tool
Figure 2-6: Select Installation Folder
iff 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
Next>
When the installation is complete, a success message will be displayed. Click the Close button (see Figure
2-7].
-------
EMTS Conversion Tool
Figure 2-7: Installation Complete
iff 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 (ECTJ\J and double-click the "EMTS Conversion Tool (ECTJ.exe" file (see Figure 2-8].
-------
EMTS Conversion Tool
Figure 2-8: Opening the ECT
C:\Program FilesMJS EPAUMTS Conversion Tool (ECT)
File Edit View Favorites Tools Help
Search Folders [TTg1~
Address Q C:\Program Files\US EPA'iEMTS Conversion Tool (ECT)
Rename this file
Move this file
Copy this file
Publish this file to the
Web
E-mail this file
Delete this file
I Go
J J -J
help sys xls
EMTS
Conversi...
EMTS EXCEL.EXE Interop.Exc,,, Microsoft,V.,
Conversion ,,,
office.dll Shortcut to write_move.ini
Applicati...
To create a desktop shortcut to open the ECT, right click on the "EMTS Conversion Tool (ECTJ.exe" file and
select Send To -^Desktop (create shortcut] (see Figure 2-9]:
Figure 2-9: ECT Desktop Shortcut
C:\Program FilesUJS EPMEMTS Conversion Tool (ECT)
File Edit View Favorites Tools Help
I O Search . Folders
Address ฃj C:\Program Files\US EPA\EMTS Conversion Tool (ECT)
US EPA
lฃj My Documents
My Computer
My Network Places
help
EMTS
Conversi.,
&
office, dll Shortcut to writejnove, ini
Applicati..,
1
L.EXE Interop.Exc.., Microsoft,V..
Cut
Copy
Create Shortcut
Delete
Rename
Properties
j Mail Recipient
^J My Documents
^ DVD-RAM Drive (D:)
21
-------
EMTS 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
** My Documents
File Edit View Favorites Tools Help
Search
- n x
*
Address
Folders
J_J My Documents
Desktop
Downloads
B IQ EMTS Conversion Tool (E<
P3! FormatXML
[5] My Data Sources
Ir^i My Music
Ir3) My Pictures
O My Videos
+ ^ My Computer
+ *_J My Network Places
$ Recycle Bin
Ir^ll EPA Support Tools
Q Certificate-ECMS-Portrait-Jil.
i^> Conversion tool tests
Ir3^ ECT Testing documents
E E) EMTS
Q EMTSSchema
ฃ) EMTSSchemaAndXMLSamples
a (ฃ3
II ฃ) New Folder
Q OTAQReg Testing
El other
<
Downloads
FormatXML
My Music
/ / My Videos
Go
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;
-------
EMTS 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 (ECTJ" folder.
Figure 2-11: The Default ECT Directories
Edit View Favorites Tools Help
G Search Folders
Address ll'r^l C:\Documents and Settings\wgo\My Docurnents\EMTS Conversion Tool (ECT)
File and Folder Tasks A
Make a new folder
Publish this folder to
the Web
Share this folder
-------
EMTS 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
ffl 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. For questions concerning compatibility 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.
This option is not needed if using an excel file, application will determine file type by it's extension.
Delimiters
'' Default
f Bar
Tab
Other:
(~ Comma
biep B^ - select 1 nels|
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.
Q Error_Files
ffl-Pj Good_Files
i-Pj HistorjJ_Files
ft 3 lnput_Files
CJ Val_Log
i ffl-Pj FinePrint files
;-Q ForrnatXML
Pj My Google Gadgets
("~l My Music
i -Pi My Pictures
\ Pj My Videos
! EE -PJ My Virtual Machines
Q New Folder
ffl Q PDF files
: ffl Q TotalValidatorTool
B-CJ NetHood
Cl PrintHood
Pj PrivaclE
; CJ Recent
Q SendTo
ฃ] Pj Spark
S-Pj Start Menu
Pi Templates v
< ->..- ! >-
Name ] Size
H BuyDenyTemplate.xls 30,720
H BuyTernplate.xls 27,136
Id GenerateTemplate.xls 51,712
ij| RetireTernplate.xls 40,960
H SellTemplate.xls 33,732
1 SellTemplateCancelKls 37,376
rf SeparateTemplate.xls 39,424
Modified | Attribute |
3/1 0/201 01 0:56:05 AM A
4/1 4/201 03: 43: 52PM A
4/1 4/201 03: 43: 52PM A
4/1 4/201 03: 43: 52PM A
4/1 4/201 03: 43: 52PM A
3/9/201 01 1:00:27 PM A
4/1 4/201 03: 43: 52PM A
Process
Existing
File(s)
Or
Build a New
File
Or
Exit
|C:\Documents and Settingฃ\wgo\My Docurnente\EMTS Conversion Tool (ECT)\lnput_Files
od File(s) Folder: |CADocuments and Sethngs\wgo\My Docurnents\EMTS Conversion Too! (ECT)\Good_Files
**Bad File(s) Folder : |C:\Documents and SeHings\wgo\My Docurnenfcs\EMTS Conversion Tool (ECT)\Error_Files
ile(s) Folder C:\Documents and Settings\wgo\My Docurnents\EMTS Conversion Tool (ECT)\Val_Log
Folder: |C:\Documents and Settings\wgo\M^ Documents\EMTS Conversion Tool [ECT]\Histori)_Files
Location of formatted output that has error
"Location of formatted
Set Path
Set Path
24
-------
EMTS 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 that will be set up for processing, as indicated in Figure 2-13.
Figure 2-13: Folder Set-up Screen
EMTS Conversion Tool (E'
File Help File List View 5how Front Page 5howLog 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 tt1 - If using a delimited file specify delimiter
Start by putting your data in a compatible delimited format.
_ n x
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
Bar
Tab <~ Comma
Other: f
Files
step ซ<ฃ - select i-ue|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.
+ LJ Application Data
;-ฃD Cookies
i fi-ฃ] Desktop
! ffl ED Local Settings
i FI-Pl My Documents
i Qj] Downloads
! FI-Pl EMTS Conversion To<
:-r~l Error_Files
fj Good_Files
CJ History_Files
; t3 lnput_Files
Q Val Log
1 "1 ErntsConversionTool
Q FormatXML
i'-Pl My Data Sources
(L) My Music
-Q My Pictures
Q My Videos
ffl-ฃ3 NetHood
ffl-Pl personal
C3 Recent v
< - - - ^
Name | Size | Modified
WPMH M Browse For Folder
^^:ilLIJf^ll]i]!=U=l'JE::
i! GenerateTempli
S| GTemplate.xls
g RetireTemplate.
a| SellTemplate.xls
H SeparateTernpl;
| Attribute
L?JL
1
1 - LJ My Documents
lฃ) Downloads
Q d EMTS Conversion Tool (ECT)
d Error_Files
d Good_Files
d History_Files
d Input_Files
d Val_Log
d ErntsConversionTool v
|< ) a~
Make New Folder
OK Cancel
Process
Existing
File(s)
Or
Build a New
File
Or
Exit
InputFile(s) Folder: |CADocuments and Settings\kkuhn\My Docurnents\EMTS Conversion Tool (ECT]\lnput_Files
*Good File(s) Folder: |C:\Documents and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)\Good_Files
**Bad File(s) Folder: |CADocuments and Settings\kkuhn\My Docunnents\EMTS Conversion Tool (ECT)\Error_Files
Log File(s) Folder:
History File(s) Folder: |C:^Documents and Settings^kkuhnVMy 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
|CADocuments and Settings\kkuhn\My Documents'^MTS Conversion Tool (ECT]Wal_Log
Set Path
Set Path
25
-------
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 FilefsJ 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 FilefsJ 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.
-------
EMTS Conversion Tool
Figure 2-14: ECT Log
H C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)Wal_Log\ECTLogFilE_2010-06-14-23-09-15. log
Processing Nummary
-6/14/201011:10:09 PM
Start writing to CADocurnents and Settings\wgo\My DocumentsVEMTS Conversion Tool (ECT)\Good_Files\Generate1111_2010-06-14-23-10-09.xml
INI-LI: tOJ
INFO: {0}
INFO: {0}
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.
INFO: {0}
Use Company Info Values checked True
Template file: CADocurnents and Settings\wgo\Local Settings\Apps\2.0\6L98CB35.Z03\QOHCX3AG.OJ2\ernts..tion_6e8daabad98b805e_0001.0000
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
{nl
{0}
{0
{0}
II I,
{0}
{11}
{0}
{0}
{0}
{111
{ill-
.I83a465d327e8b08
Template file: CADocurnents and Settings\wgo\Local SettingsWpps\2.0\6L98CB35.203\OOHCX3AG.OJ2\ernts..tion_6e8daabad98b805e_0001.0000_f83a465d327e8b08
-6/14/2010 11:10:17 PM
Begining Processing File: CADocurnents and Settings\wgo\My DocumentsVEMTS Conversion Tool (ECT)M nput_Files\GenerateTernplate3.xls
Columns found in record 3:
Fuel Code, Process Code, Production Date, Fuel Category Code, Batch Volume, Denaturant Volume, Equivalence Value, RIN Quantity,
rnport Facility Identifier, Generate Organization Identifier, Generate Facility Identifier, Batch Number Tent, Transaction Detail Comment Text,
Feedstock Code 1, Renewable Biomass Indicator 1, Feedstock Volume 1, Feedstock Measure Code 1, Feedstock Detail Comment Tent 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:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
ERR:
ERR:
INFO:
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
INFO: {0}
iMcn. Jnx
{111
{111
ill!-
{0}
ill!-
{0}
{0}
{0}
{Ml
{111
{0}
{0}
{1!
{1}
-6/14/201011:10:17 PM
Input File Successfully Opened
Finished Loading Input Data.1 data records read.
Input file: \GenerateTemplate3.xls <><><>
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 85
Element Name of Feedstock Code 2 value is empty. Column Name = Feedstock Code 2. Data Grid Column S20
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 B22
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
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].
-------
EMTS Conversion Tool
Figure 2-15: "Show Log" Function on the File Selection Screen
HI EMTS Conversion Tool (ECT)
File Help File List View Show Front Page Qhow Log) WinZip
Welcome: KKuhn . This application will format an Excel or delimited file for conversion to XML. For questions concerning compatibilty refer to Help/About ECT.
Step #1 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
ff Default T Tab
r Bar <~ Other:
Comma
step u^ - select 1 neisj
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.
+ d Application Data
i d Cookies
i ffl fi Desktop
d Favorites
i EH Q Local Settings
| fi-d My Documents
i'-Pl Downloads
i B"d EMTS Conversion Tot
!--d Error_Files
d Good_Files
i-d History_Files
- ta lnput_Files
d Val Log
('I EmtsConversionTool
d FormatXML
1 i My Data Sources
i n My Music
r-d My Pictures
L d My Videos
+ _] NetHood
+ | personal
d PrintHood
d Recent v
< 1 ' >i~
Name | Size Modified Attribute I
1 BuyExample.xls 27,136 4/7/2010 1:50:59 PM A
BuyTemplate.xls 27,136 4/1 2/201 01 2: 09: 40PM A
H GenerateTemplate.xls 51,712 4/12/2010 12:09:40 PM A
1 GTemplate.xls 51,712 4/5/2010 12:22:52 PM A
a] RetireTemplate.xls 40,960 4/1 2/201 01 2: 09: 40PM A
1 SellTemplate.Hls 33,792 4/1 2/201 01 2: 09: 40PM A
H SeparateTernplate.xls 39,424 4/1 2/201 01 2: 09: 40PM A
Process
Existing
File(s)
Or
Build a New
File
Or
Exit
Files
Input File(s) Folder: |C:\Documents and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)Mnput_Files
*Good File(s) Folder C:\Documents and Settings\kkuhn\My Docurnents\EMTS Conversion Tool (ECT)1iGood_Files
*Bad File(s) Folder: |C:\Docurnents and Settings\kkuhnWy Documents\EMTS Conversion Tool (ECT)\Error_Files
Log Filers) Folder' |C:\Documents and Settings\kkuhn\My Documents\EMTS Conversion Tool [ECT)\Val_Log
History File(s) Folder: |C:\Documents 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.
28
-------
EMTS Conversion Tool
Figure 2-16: "Show Log" Function on the Processing Screen
ffl Generate Transaction - Processing file
Process Raws Columns Help
Step tt3 -Enter Company Info
* User Login:
* Organisation ID:
Step H4 - Select column to upload
Submiltal Creation Date: 12010-02-01 Submission Commer
Header Infomation
"Application User ID: [epa
i ID: TED
Add Hew Empty Roi
Copy Row[s) to New Row(s] Delete Row[s]
Show Legends
:put lib arid
t the appropr a:e :olumnj |--om lh= droi-do', ,'n_- lj = l:',', Re|- = r :o :he legend :n lh= midils r g-'t E_- to ',','het--e- Neld= are required or not Ro',','_- : an ze .-:rt = d ljr' :li':t ing :n the column --e = d = r Lhange.- made ,',' II ze re'lecied
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].
-------
EMTS Conversion Tool
Figure 2-17: Output File Options Screen
Formatted Output File Options
- n x
File type XML is the ONLY option required for submission/transmission
File Type(s)
! XML - This is the ONLY option required for submission/transmission
Excel - For your use only, not to be transmitted (if transmitted, it will be ignored.)
r~ Tent - 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
("" 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 Override the default name of TtQrgld_YYYY1-MM-DD-HH-MM-SS where Tt is the Transaction Type.
Overridden File Name: f
Do NOT include the Folder (Path) name. The "Good Files" folder is assumed.
Other File Option(s)
Use Recommended Names for Column Headers. Tent or Excel file only)
f" 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.
-------
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].
-------
EMTS Conversion Tool
Figure 3-1: "My Computer" link
Internet
Mozilla Firef ox
E-mail
'' Microsoft Office Outlook
e - texteditor
ฃi Microsoft Office Word 2007
Command Prompt
EMTS Conversion Tool (ECT)
Microsoft Office Excel 2007
Shortcut to
sqldeveloper.exe
J My Documents
My Recent Documents
My Pictures
My Music
^^*y
ter)
My Computer
My Network Places
Control Panel
Set Program Access and
Defaults
.l 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
-------
EMTS Conversion Tool
Figure 3-2: "My Computer" Location
? My Computer
File Edit View Favorites Tools Help
Qflack Q -
Search i " Folders
Address j| My Computer
Hard Disk Drives
System Tasks
7) View system information
Add or remove programs_^>
Change a setting
Devices with Removable Storage
DVD-R AM Drive(D:)
My Network Places
My Documents
Control Panel
Network Drives
h on 'roseriver.pqa.local\root'
(H:)
g on 'thornton.pqa.local' (G:)
My Computer
System Folder
i on 'roseriver.pqa.local\root' (I:)
j on 'hazel.pqa.local' (J:)
33
-------
EMTS 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 (ECTJ and then press the "Change/Remove" button within the record.
Figure 3-3: "Add or Remove Programs" Window
A Add or Remove Programs
Add New
Programs
Add/Remove
Windows
Components
o
Set Program
Access and
Defaults
Currently installed programs:
Show updates
Sort by: Name
v
!a Adobe Reader 9,2
| Broadcom Gigabit Integrated Controller
jJ3 Compatibility Pack for the 2007 Office system
ง& CutePDF Writer 2.3
|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
OFileZillaClient3,3.0,l
ฃ Google Chrome
H Intel(R) Graphics Media Accelerator Driver
J?| Java(TM) 6 Update 17
Size 210.00MB
Size 0.48MB
Size 143.00MB
Size 0.30MB
Change/Remove
^^^^^m
5ize 272.00MB
5ize 15.38MB
5ize 67.41MB
Size 91.04MB
-------
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,
r*/ ฉ Remove the application from this computer.
OK
Cancel
More Information.,.
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".
-------
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
s
Search Folders
Address Q C:\Documents and 5ettings\wgo\My Documents\EMTS Conversion Tool (ECT)
History_Files
Val_Log
Good Files
-
t
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
-------
EMTS 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 EMTSXMLfile (files can be zipped).
r Advanced Version
Go This version allows the flexibilty that the Basic version doesn't.
Build a New File
Go
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].
-------
EMTS Conversion Tool
Figure 4-3: File Selection Screen
ffl EMTS Conversion Tool (ECT)
- n x
File Help File List View Show Front Page 5how Log WinZip
Welcome: wgo . This application will format an Encel or delimited file for conversion to XML. For questions concerning compatibly refer to Help/About ECT.
Step It I Select File[s]
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 Pi Error_Files
E Pj Good_Files
I Pi History_Files
E-ฃ3 lnput_Files
^ Pj VaLLog
El-IB FinePrint files
Pj FormatXML
Pi My Google Gadgets
LJ My Music
! Pj My Pictures
Pj My Videos
S-Pj My Virtual Machines
i Pj New Folder
S Pj PDF files
B Pj TotalvalidatorTool
E--CJ NetHood
Pj PrintHood
LJ PrivaclE
Pj Recent
Q SendTo
ffl-Pj Spark
+ _| Start Menu
-Pi Templates v
< .---. ^
Name Size Modified Attribute
B BuyDenyTemplate.Kls 30,720 3/10/2010 10:56:05 AM A
1 BuyTemplate.Kls 27,136 4/14/2010 3: 49: 52PM A
H GenerateTemplate.nls 51,712 4/14/2010 3:49:52 PM A
rf RetireTemplate.Kls 40,960 4/14/2010 3:49:52 PM A
y SellTemplate nls 33792 4/14/2010 3" 49'52 PM A
1 SellTemplaleCanceLxIs 37,376 3/9/2010 11:00:27 PM A
H SeparateTemplate.Kls 39,424 4/14/2010 3: 49: 52PM A
Process
E wisting
File(s)
Or
Build a New
File
Or
EKit
Files
Input File(s) Folder: |C:\Documents and Settings\wgo\My Docurnents\EMTS Conversion Tool (ECT]\lnput_Files
'Good File(s) Folder: |C:\Documents and Settings\wgo\My Docurnents\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: IC:\Documents and Settings\wgo\My Docurnents\EMTS Conversion Tool (ECT)Wal_Log
History File(s) Folder: (CADocuments and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\History_Files
"Location of formatted output that has NO errors. ""Location of formatted output that has errors.
Set Path
Set Path
Set Path
Set Path
Set Path
The user should select the desired filefsj and click the "Process Existing FilefsJ" 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 FilefsJ" 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].
-------
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
Process Rows Columns Help 5howLog WinZip
Step tt2 - Enter Company Info
:.i I -I r HHIi,in - H|H JCMO-CM-rn - SuUm.. uii LI. iiii
Headei Infomation
"^plication User ID: |
Transmission ID: TED
Step tt3 - Process And Write to XML File
Output File Options Enit/Stop Recessing
Progress:
Finished Loading Input Dala.1 data records read.
The ECT uses the following default settings when processing files: the output file is an uncompressed XML
file, and the output file name is formatted as "TtOrgId_YYYY-MM-DD-HH-MM-SS" where "Tt" is the
transaction type (i.e., Generate] and "Orgld" is the four-digit ID entered in the "Organization ID" field. To
change these default settings, the user should click the "Output File Options" button (see Figure 4-5].
Figure 4-5: "Output File Options" Button
Eo BuyTransaction - Processing file: Buy Example! .xls
Process Rows Columns Help 5how Log WinZip
Step tt2 -Enter Company Info
1 * User Login: | * Submillal Creati'-'n [>at*- 2010-01-26 Submission Com
' Organisation ID:
Header Inlomation
Transmission ID: TBD
Ppply User Login Value
StepJK - Process And Write to XML File
j Output File Options [ Exil/Slop Recessing
Progress:
Finished Loading Input Data.3 data records read.
I
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
-------
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
Formatted Output File Options
File type XML is the ONLY option required for submission/transmission
File Type(s)
! XML - This is the ONLY option required for subrnission/transmission
Excel - For your use only, not to be transmitted (if transmitted, it will be ignored.)
F~ 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.
Overridden File Name: |BatchQneGeneratej
Do NOT include the Folder (Path) name. The "Good Files" folder is assumed.
Other File Option(s)
Use Recommended Names for Column Headers. Text or Excel file only)
l~~ Display Processed File
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.
-------
EMTS Conversion Tool
Figure 4-7: "Next file" Button
B uyTransactio n - Processing file: BuyBizoBlenders.xls
Process Rows Columns Help Show Log WinZip
Step ป2 -Enter Company Info
:" User Login: |lH * Submittal Creation Date: |2010-02-01 Submission Comment:
* Organisation ID:
Step U3 - Process And Write to XML File
>Header Information
'/^plication User ID: |e
mission ID: TBD
Output File Optio
Enil/Stop Processing
Process File I Nenl fib J)
Piogiess:
Finished Loading Input Data.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
ansaction Tyi
- n x
Select the transaction type from the drop-down pick list below for file:
Select Transaction Type:
Enter Skin this file
Once the user selects the transaction type and clicks "Enter," the File Processing screen appears (Figure 4-
9].
-------
EMTS Conversion Tool
Figure 4-9: File Processing Screen
Process Rows Columns Help Show Log WinZip
Step 113 Enter Company Info
* User Login: |j Submiltal Creation Date. I'010-04-13 Submii.-|.jn Comment;
* Organization ID1
Step tt4 - Select column to upload
Header Intonation
Application User ID: |
ID: TED
k Apply User Login Value
Add New Empty Row | Copy Row[s| to Hew Row|s| | Delete Row(s]
Step 115 Process And Write to XML File
Output File Options Exit'Stop Piocessing
Pi ogress:
o Recommended Defaults
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].
-------
EMTS Conversion Tool
Figure 4-10: A Successfully Processed File
Step 83 - Process And Write to XML File
Output File Options
ฃwit/Stop Rocess'
Progress:
Recessing Data. Approw Records to
Finished processing Input [
Formatted to: XML file.
Records processed
2 records were successfully processed
No compressions were selected
Upon successful processing, the output XML file is written to the following directory:
C:\Documents and Settings\\My Documents\EMTS Conversion Tool (ECT]\Good_Files
If processing is not successful, the screen will display a message that includes, "Missing or incorrect value
for required element(s] in record(s]:<...>,". 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
^wit/Stop FVocessing
Rocess 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,
F-Vocessing Data. Appron 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.
-------
EMTS Conversion Tool
Figure 4-12: Errors Reported in Log File
H! C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)Wal_Log\ECTLogFile_2010 06 14-22-28 00...
INFO:
INFO-
ERR:
ERR:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
ERR:
ERR:
INFO:
INFO1
INFO:
ERR:
1 M Ffl
INru.
ERR:
1 M Ffl
INrU.
{0}
!ni
IUJ
IN}
11}
{1}
{0}
{0}
!lj}
I'M}
{0}
{0}
[ru-
in}
{1}
{1}
{0}
In!
i.U.i
11.1}
fl>
fl'i
1 IT-
iur
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 85
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 Summaryl
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
jiuiLj|
A
=
'
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
Status
Output File
Rocess
-"regress:
Options
File
But/Stop
1C
Recessing
Next file
)
Recessing Data. .ApproK Records to be processed = 1
Finished processing Input Data. Records processed = 1.
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 ' | iJ Search
Folders
Address _} C:\Documents and 5ettings\wgo\My Documents\EMTS Conversion Tool (ECT)
File and Folder Tasks *
J Make a new folder
Publish this folder to
the Web
Share this folder
Good Files
/ History_Files
if I Input_Files )
Val_Log
- n x
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
-------
EMTS 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 EMTSXMLfile (files can be zipped).
r Advanced Version
Go This version allows the flexibilty that the Basic version doesn't.
Build a New File
Go
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].
-------
EMTS Conversion Tool
Figure 5-3: File Selection Screen
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 cornpatibilty refer to Help/About ECT.
Step ttl - 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
S- Default
r Bar
Tab
Other:
Comma
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.
LJ Error_Files
IJ--CJ Good_Files
| O History_Files
[j --ฃ3 lnput_Files
^ Cl VaM-og
El-Si FinePrint files
-Pj FormatXML
-Pi My Google Gadgets
Pi My Music
Pi My Pictures
Pj My Videos
B Cj My Virtual Machines
Q New Folder
B- Pj PDF files
a Pj TotaK/alidatorTool
[J--O NetHood
| Pj PrintHood
LJ PrivaclE
!-Pj Recent
LJ SendTo
[i--Pj Spark
fi Pj Start Menu
! --Pj Templates v
< 1 >l
Name | Size | Modified
H BuyDenyTemplate.xls 30,720 3/10/2010 10: 56: 05 AM
1 BuyTemplate.xls 27,136 4/14/2010 3: 49: 52PM
1| BuyTemplate2.xls 30,720 3/10/2010 10: 56: 05 AM
B GenerateTemplate.xls 51,712 4/14/2010 3: 4S:52PM
= RetireTemplate xls 40360 4/14/2010 3" 43'52 PM
1 SellTemplate.xls 33,792 4/14/2010 3: 49: 52PM
H SellTemplateCanceLxIs 37,376 3/9/2010 11:00:27 PM
SeparateTemplate.xls 39,424 4/14/2010 3: 49:52 PM
Attribute | Exist
A FfcM
A Or
A
Build a New
A File
A
A ฐ<
A
A Exit
Files
Input File(s) Folder: |C:\Documents and Settings\wgo\My Docurnents\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 Docurnents\EMTS Conversion Tool (ECT]\Error_Files
Log File(s) Folder: |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT]Wal_Log
History File(s) Folder: |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\History_Files
"Location of formatted output that has NO errors. ""Location of formatted output that has errors.
Set Path
Set Path
Set Path
Set Path
Set Path
The user should select the desired filefsj and click the "Process Existing FilefsJ" 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
-------
EMTS 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 5how Log WinZip
Step 93 -Enter Company Info
User Login: | - Submiltal Creation Data: |2ulQ-0'l-l9 T] Sub mission Comment:
Step 84 Select column to upload
Header Infomation
"^plication User ID: |
ID: TBD
Apply User Login Value
Add New Empty Row Copy Ron [si to Hew Roi'j[s] Delete Row[s] Set Columns to Recommended Defaults Import/Export Company Column Hames
Select the =i|jp ..pridlH column; hum tlr= J op-dowru below Rsh=i lo th = l=g-=iiU on ih* i nJJI- nJit =i_- tu w-i.=-triซi h'=IJ= are required or not Rows can be sorted bv eliding on the column header Changes made ui I be reflected ir the new output file and
NOT on the input tile.
1 Fuel Category Code
Reduction Date
= RINQuantity
* Genet ate Facility Identitiei
Batch Humber Tent
| Fuel Category Cede
I Co Product Deta
| Production Date
|coProduct Code 2
Is
|RIN Quantity
| Generate Facility Identifier
| Batch N
Optional Fields
Denatur ant Volume
EquivalenceValue
GenerateOiganisatronldentifier
Transaction Detail CommentTent
Imp or t Facili ty Identifier
|Denaturart Volume
(Generate Organization Identifier
{Transaction Detail
Import Facihtv Identifier
Co Roduct Detail CommentTeHt2
Co Roduct CodeS
|coProduct Detail Con
I Co Product Code 3
jCoProduct Detail Con
RenewableBfcmasslndioaloil
" FeedstockVolumel
' FeedstookMeasureCodel
' FeedstockDetailCommentTeKtl
" FeedstockCode2
' Renewable B iom ass Indies to r2
" FeedstockVolume2
' FeedstockMeasureCode2
" FeedstockDetailCommentTeKt2
' FeedฃtockCode3
1 Renewable Bioma55 Indicators
1 FeedstockVolumeS
* FeedstockMeasureCodeS
' FeedstockDetailCommentTeHtS
Faedstock Volume 1
Feedstock Detail Cor
73
:aedstock Code 2
Feedstock Volume 2
-ซt'J;t'.".- kensure L I
Feedstock Detail Comment TeHt 2 T \
Feedstock Volume 3
F.-T,1 -t,-,rI f.T.-.-uir. r-,,-1,-. 'I
Feedstock Detail CommantTewl3 T|
Step B5 - Piocess And Write lo XML File
Output File Options ^nit/Stop Recessing
Progress:
Finished Loading Input Data 1 data records read
mmiimmmiimimiiimiimiiii
-------
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 Hew Empty Row
Copy Row(s) to Hew Row(s)
Delete Row(:
Set Columns to Recommended Defaults
Import/Export Cor
Select the appropriate columns from the drop-downs below. Refer to the legend on the middle liyht Ji. tu (MleLheTfields are required or not. Row
HOT 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
Required Fields
' Transaction Partner Organisation Identifier
Assignment Code
' Fuel Code
' R IN Quantity
'Transaction Partner Organization Name
[ R IN Year
' BuyReasonCode
Transaction Date
pansaction Partner Organisation Idem T |
[Assignment Code T |
| Fuel Code T |
|RIN Quantity
Transaction Partner Organisation Nam ^ |
RIN Year
| Buy Reason Code
Transaction Date
Supporting Document Fields - Up to 2 sets
SupportingDocumentTent1
SupportingDocumentNumberTent1
Supporting DocumentTent2
Supporting Document NumberTewt2
Supporting Document Tent 1
Supporting Document Number Tent 1 T |
Supporting Document Tent 2
Supporting Document Number Tent 2 T- |
Uptional Fields
BatchVolume
RINPrice Amount
Transaction Detail CommentTent
PTD Number
Gallon Price Amount
Generate Organization Identifier
BatchNumberTeHt
Generate Facility Identifier
All Remaining Fields
| Batch Volume
|RIN Price Amount
Transaction Detail Comment Tewt
FTD Number
Gallon Price Amount
|ijenerate Organisation Identifier
| Batch Number Tent
| Generate Facility Identifier
r
d
d
d
d
jj
d
d
d
d
-------
EMTS Conversion Tool
Figure 5-7: Matching Default Columns to Labels
Process Rows Columns Help Show Log WinZip
Step tt3 - Enter Company Info
1 User Login:
[ Submittal Creation Date: |2010-02-01
Organization ID:
Step #4 - Select column to upload
Add New Empty Row Copy Row(s) to New Row(s)
Submission Comme
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
Required
saction Partner Organisationdnfjeฃjj^^lion ^^' Organization Identr
Assignment Code
Assignment Code
If the recommended column headers are not used in the input file, the user will need to select the
appropriate column headers in the drop-down menus. In Figure 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.
-------
EMTS Conversion Tool
Figure 5-8: Matching User-Defined Column Headers to Labels
BuyTransaction - Processing file: BuyExample.xls
Process Rows Columns Help 5how Log WinZip
Step B3 - Enter Company Info
User Login: epa
1 Organization ID: |
Step tt4 - Select column to upload
: Submittal Creation Date: 2010-02-01
Submission Comme
Add Hew Empty Row
Copy Row(s) to Hew Row(s) Delete Row(s) Set Colui
Select the appropriate columns from the drop-downs below. Refer to the legend on the rr
NOT on the input file.
Transaction Partner
Organization Name
EPA Fuels
RIN
Quantity
Bat.
Voli
2000
^Transaction Partner Organisation Identifier.
Assignment Loae
Fuel Code
* RINQuanrity
1 Transaction Partner Organization Name
1 RINYear
1 BuyReasonCode
Supporting Document Number Tent 1
Supporting Document Number Text 2
Supporting Document Text 1
Supporting Document Tent 2
A \
transaction Date
Transaction Detail Comment Tent
Transaction Partner Organization Na.
Buy Reason i
Note that information that is manually written into the data grid does not modify the input file. To save this
information to an Excel spreadsheet, the user must select the Excel file type by selecting the "Output File
Options" button under "Process and Write to XML File" near the bottom of the screen.
For required fields, a column name must always be chosen from the corresponding drop-down list. For
conditional fields and optional fields, selecting a non-null column name from the corresponding drop-down
list indicates that the field should be included in the output XML. Otherwise, the field will not be included
in the output XML, even if data for this field is visible in the grid.
-------
EMTS Conversion Tool
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
ffl BuyTransaction - Processing file: BuyExnmple.xls
Process Rows Columns Help Show Log WinZip
Step tt3 - Enter Company Info
-User Login: |epa - Submittal Creation Date: \2010-02-01 Submission Comment:
x Organization ID: |
Step tM - Select column to upload
Add New Empty Row Copy Row(s] to New Re-
wfc)
Delete Row(s] Set Columns to Recommended Defaults Import/EHport Company Column Names
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.
The Company Column Names dialog box will be displayed (see Figure 5-10].
-------
EMTS Conversion Tool
Figure 5-10: Column Name Import/Export Screen
IS Company Column Names
Exit Options Help 5how Log
Export to Existing Profile
Delete Profile
Import Profile
Exit
After clicking the "Export New Profile" button, the user will be prompted to specify a name and location for
the profile (see Figure 5-11].
Figure 5-11: Saving Profile with User-Defined Column Names
L..^JL-it-L.-J.t-mfJ.L^.L.JJrJ.l.J...^.^l^.l.Jlllll
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].
-------
EMTS Conversion Tool
Figure 5-12: Company Column Names Screen with Saved Profile
IS Company Column Names
Exit Options Help 5how Log
CADocuments and Settings\wgo\My Documents\EmtsConversionTool\Generar.eTransacr.ion20Q911314440.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
Output File Options I Exit/Stop R>
ocessing
Process File
Progress:
Status
Finished Loading Input Data.3 data records read.
-------
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
SI 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 submission/transmission
Excel - For your use only, not to be transmitted (if transmitted, it will be ignored.)
l~ Text - For your use only, not to be transmitted (if transmitted, it will be ignored.)
File Compression (using WinZip32)
(* Do Not Compress any Files
(" Compress only the XML File for Node Submission/Transmission
'""" Compress All Output File Types Selected Above (XML, Excel, Text) - It is NOT necessary to include Excel or Text in the compression.
Override Output File Name
The time stamp will still be appended, EMTS does not allow spaces in the file name.
Overridden File Name: |BatchOneGenerate|
Do NOT include the Folder (Path) name. The "Good Files" folder is assumed.
Other File Qption(s)
Use Recommended Names for Column Headers. Text or Excel file only)
Display Processed File
OK
After specifying the output file options, the user should click the "Process File" button. Note that if multiple
files have been selected for processing, only one file is processed at a time. In this case, a "Next file" button
will be visible next to the "Process File" button (see Figure 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.
-------
EMTS Conversion Tool
Figure 5-15: "Next file" Button
Step 85 - Process And Write to XML File
Output File Options
Exit/Stop Recessing
Status
Process File
Next 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
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 5-
17].
-------
EMTS Conversion Tool
Figure 5-17: File Processing Screen
Process Rows Columns Help Show Log WinZip
Step 83 -Enter Company Into -^^^
" User Login: ||
1 Organization ID |
Step tt4 - Select column to upload
Add New Empty Row Copy Row(s] to New Rmv(s]
Submiltal Creation Dale: 2010-04-19 - Submission Comment:
Header Infomatioi
Application User ID: \~
17 ฃ4>f>ly User Login Value
Select the appropriate column? from the drop-down.- below Refer to the legend on the middle right a.- to whether Held; are required or not. Row? can be sorted by clicking on the column header Changes made will be reflected in the new output file and
NOT on the inpul file.
Required Fields
Fuel Code
Batch Volume
Fuel Category Code
Ron ess Code
RINQuantity
Generate Facility Identifier
Batch NLimberTem
Optional Fields
DenaturantVolume
EquivalenoeValue
Generate QrganiEation Identifier
Transaction Detail CommentTent
Import Facility Identifier
CoRoduct Fields - Up to 3 s,
Co Product Code 1
Co Product Detail CommentT
CoRoduclCode2
Co Product Detail Comment!
Co Product Code3
Co RoductDetail CommentT
Feedstock Fields - Minimum = 1 set, Manimum = 3 sets
1 Feedstock Code 1
" RenewableBiomasshdicatorl
* Feedstock Volume 1
1 Feedstock Measure Code 1
- FeedstockDetailCommentTeKtl
* Feedstock Code2
' Renewable Biomass Indicator2
1 FeedstockVolume2
1 Feedstock Measure Code2
' Feedstock Detail CommenlTent2
' Feedstock Code3
* Renewable Biomass Indicators
- FeedstockVolumeS
1 Feedstock Measure Code3
* Feedstock Detail CommenlTeKlS
Step H5 - Process And Wiite to XML File
Output File Options ฃnit)Stop Processing
D Recommended Defaults
Illlllllllllllllllllllllllllllllllllllllllllllllllllllll
Note that in this version of the File Processing Screen, there are no drop-down menus with column headers,
since the default column headers will always be used when the user elects to build a new file.
The user should first fill in the "Enter Company Info" portion of File Processing Screen. The company
information required includes:
User Login (case sensitive and must be the same as the EMTS login];
Organization ID (EPA assigned, four-digit ID]; and
Submittal Creation Date.
Under the "Enter Company Info" section, a data grid is displayed. The user should enter the transaction
data in the grid and click the "Process File" button.
-------
EMTS Conversion Tool
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 Wiite to XML File
Output File Options
F-Kit/Stop Rocessi
FVo
: File
Recessing Data. Approw Records to be processed = 2
Finished processing Input Data. Records processed = 2. 2 records were successfully processed.
Formatted to: XML file.
Compressed to: Ho 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 (ECTJ\Good_Files
If processing is not successful, the screen will display a message that includes, "Missing or incorrect value
for required element(sj in record(sj: <...>, refer to columns marked". In addition, the appropriate cell(sj in
the data grid will change color to indicate where the error has occurred (see Figure 5-19].
-------
EMTS 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 i
"Batch
Volume
^ . ^
T
Denaturant
Volume
Equivalence
Value
1.0
"RIN
Am 01
1900
Required Fields
1 Fuel Code
BatchVolume
1 Fuel Category Code
1 Reduction Date
1 RocessCode
1 RINQuantity
1 Generate Facility Identifier
1 Batch NumberTeHl
Fuel Code
Batch Volume
d
d
Fuel Category Code T |
Production Date ^
Process Code
d
RIN Amount T |
Generate Facility Identifier
Batch Number Tent
Denaturant Volume
Equivalence Value
Generate Organization Identifier
Transaction Detail CommentTeKt
Import Facility Identifier
All Remaining Fields
Denaturant Volume
d
d
d
Equivalence Value T- |
Generate Organization Identifier
Transaction Detail CommentTeKt
d
d
mport Facility Identifier T \
d
Co Roduct Fields - Up to "3 sets
Co Roduct Code 1
Co Roduct Volume 1
Co Roduct Measure Code "i
Co Roduct Detail Comment Vent 1
Co Roduct Code2
Co Roduct Volume2
Co Roduct Measure Code2 1
CoRoductDetailCommentText^
Co Roduct CodeS
Co Roduct VolumeS
Co Roduct Measure CodeS
Co Roduct Detail CommentTeKtS
| Co Product Code 1 T |
| Co Product Volume 1 T |
| Co Product Measure Code 1 T |
| Co Product Detail Comment TeKt 1 T |
| Co Product CodeS T |
| Co Product Volume 2 T |
| Co Product Measure Code 2 T |
| Co Product Detail Comment TeKt 2 T |
I Co Product CodeS T |
I Co Product Volume 3 T |
I Co Product Measure Code 3 T |
| Co Product Detail Comment TeKt 3 T |
\
Step tt5 - Process And Write to XML File
Output File Options
But/Slop Rocessing
Rocess File
Status \
Missing or incorrect value For required elements) in record(s): y**refer to columns
Rocessing Data. Approw Records to be processed = 1 ^^ i , ,
Finished processing Input Data. Records processed = 1.
1 records were found with errors., these Mies 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 5-20].
-------
EMTS Conversion Tool
Figure 5-20: Errors Reported in Log File
Hi C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\Val_l_og\ECTLogFile_2010-
"oProdu
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
ERR:
INFO:
ikirn.
<
ct Detail
{0}
{rii-
il]}
{0}
{u!
in}
{0}
{0}
{0}
ill}
{0}
{0!
m
ill}
rm
"omment Text 1 , CoProduct Code 2, CoProduct Detail Comment Text 2,
-6/14/20101 1:20:07 PM
Input File Successfully Opened
Finished Loading Input Data.1 data records read.
Input file: \GenerateTemplate4.xls <><><>
06-14-... Q(n)ฎ
CoProduct Code 3, CoProduct Detail Comment Text 3,
Process record tt 1
Element Name of Batch Volume is missing . Column Name = Batch Volume. Data Grid Column ttG
Element Name of Feedstock Code 2 value is empty . Column Name = Feedstock Code 2. Data Grid Column 820
Print Log OpenAnothe
V
>
r Log Exit
This viewer includes buttons which allow the user to print the log and to select another log file for viewing.
Clicking "Exit" closes the log viewer.
If a selected input file is not successfully processed, the ECT will still attempt to create an output XML file.
This file will be located in the following directory:
C:\Documents and Settings\\My Documents\EMTS Conversion Tool (ECT]\Error_Files
Only the data rows with no errors will be written to the output file. Data rows that contain errors will not
be converted to XML.
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.
-------
EMTS Conversion Tool
Figure 5-21: Processing Next File
Step tt5 - Process And Write to XML File
Status
Output File Options I But/Stop Processing I Processing Data, ^pprow Records to be processed = 1
Process File
Progress:
Finished processing Input Data. Records processed =1.1 records were successfully processed.
Formatted to: XML file.
Compressed to: No compressions were selected.
------- |