Installing and Setting Up the Conversion Tool
This guide describes how to install the ECT, how to set up the input files, and how to configure the ECT.
Additional information is provided on the usage and customization of the ECT file system directories.
If you already have aversion of the Conversion Tool installed, you must uninstall the existing version of the
Tool before you install the new version. See the document "Uninstalling the Conversion Tool" for
instructions on how to do so.
System Requirements
The system requirements for running the ECT are as follows:
• MS Windows XP 2002 SP2 or later, Windows Vista, or Windows 7;
• MS Office version 2003 or later;
• A CPU of at least 2.0 GHz;
• At least 1.0 0GB 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.
Obtaining the ECT and Transaction Templates
The ECT and the transaction templates are available at the following location:
http://www.epa.gov/oms/renewablejuels/epamts.htm
Two ECT files will be available at this location, in the form of Zip archives. The first file, "ectzip," 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, "epatemplates.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 1 depicts the WinZip screen
that appears after the user has doubled-clicked the file "ECT.zip".
&EPA
United Stoics
Environmental Protection
Agency
EPA-420-B-10-011b
May 2010
-------
EMTS Conversion Tool
Figure 1: Using WinZip to Extract the ECT
8 WinZip - ECT.zip
File Actions View Jobs Options Help
- n ix
JW
»»,
New Open Favorites Add Extract Mail Encrypt View Install Wizard View Style
Address
Name
Ir"! publish
Type Modified Size
Folder 11/24/2009 11:59 AM
:older: \
Total 17 files, 3,428KB
GO
Note that users may see variations of the image in Figure 1. The user should select the [ECT.zip] file on the
left side of the WinZip window then click the Extract button to get to the window in Figure 2 below.
Figure 2: Specifying ECT Location
Extract to: C:\unzipped\ECT
ffl-fr^l drivers
1386
EHr°i Java
ffl Q oracle
Program Files
Subversion
unzipped
-—~
My Documents
FeesAndCompliance
WINDOWS
O Open Explorer window
Overwrite existing files
HH Skip older files
Use folder names
Selected files/folders
0 All files/folders in archive
O Files:
My Network
Places
-------
EMTS Conversion Tool
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\ECT" has been selected. Once
the location has been selected, the user should click "Extract".
Upon doing so, a folder -- "publish" -- will be created under the selected location.
Installing the ECT
After downloading the zipped ECT and extracting the files, the user must then install the application by
double-clicking on the setup.exe file. This file will be found in the "publish" folder that is created under the
target extraction location. Figure 3 depicts this folder when the files have been extracted to
"C:\unzipped\ECT". The setup.exe file has been circled in Figure 3.
Figure 3: "Publish" Folder
File Edit View Favorites Tools Help
@
Back
£) Search [[- Folders [Tj-
Address Q C:\unzipped\ECT\publish
Publish this folder to
the Web
Share this folder
f
Go
„.
f MT5 Conversion Tool i
EMT5 Conversion Tool
(ECT)_1 _0_0_8 .application
Application Manifest
EMT5 Conversion Tool
(ECT).application
Application Manifest
The user will then be prompted to verify the request to install the application, and after verification, the
application will execute. Once the application has installed, the user can delete the "publish" folder if
desired.
The installation will add an item to the Start Menu under "EMTS Conversion Tool (ECT)"; from this point
on, the user can execute the ECT from the Start Menu (see Figure 4). Reinstalling the application will result
in the loss of settings. By default, the ECT front page will appear after installation is complete. At this point,
the user can either continue with running the ECT, or exit and start the ECT again at a later time.
-------
EMTS Conversion Tool
Figure 4: Start Menu
Internet Explorer
Shortcut to
sqldeveloper.exe
Windows Media Play
( . Remote Assistance
Q Windows Media Player
^ Windows Movie Maker
^> Windows Search
EMTS Conversion Tool (ECT)
Setting Up the ECT
Directories
If this is the first time the ECT is being installed, the installation will create a folder "C:\Documents and
Settings\\My Documents\EMTS Conversion Tool (ECT)" (see Figure 5).
-------
EMTS Conversion Tool
Figure 5: The "EMTS Conversion Tool (ECT)" Folder, Where the Default ECT Directories are Located
File Edit View Favorites Tools Help
Go
J^T Desktop
. J Downloads
El lr°l EMTS Conversion Tool (E(
,^| ForrnatXML
irPl My Data Sources
IP3) My Music
IP3) My Pictures
O My Videos
+ j My Computer
1+1 * J My Network Places
rl' Recycle Bin
IP3) EPA Support Tools
£31
,^ Certificate-ECMS-Portrait-Jili
_^ Conversion tool tests
Ir3) ECT Testing documents
El (£) EMTS
l£) EMTSScherna
^ EMTSSchemaAndXMLSamples
FormatXML
My Music
My Videos
My Data Sources
My Pictures
S IrJ) New Folder
i j OTAQReg Testing
(£l other
<
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 under the "EMTS Conversion Tool (ECT)" folder as soon as it is
downloaded and the setup executable is run. These folders are used by the ECT in order to process files
and consist of:
• A folder that holds the input files to be converted;
• A folder to which the successfully processed files are written;
• A folder in which any "Build a File" data is stored from execution to execution;
• A folder to which the unsuccessfully processed files are written; and
• A folder to which the activity log is saved.
-------
EMTS Conversion Tool
Figure 6 shows these folders in their default location under the "EMTS Conversion Tool (ECT)" folder.
Figure 6: The Default ECT Directories
Fib Edit View Favorites Tools Help
( ) Back - y Search Folders [7j] -
Address Q C:\Docurnents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)
File and Folder Tasks A
Publish this folder to
the Web
Share this folder
-------
EMTS Conversion Tool
Figure 7 shows the File Selection Screen with the ECT folders indicated. The folders in this example are the
default folders.
Figure?: Location of the ECT Folders
EMTS Conversion Tool (ECT)
File Help File List View Show Front Page Show Log WinZip
Welcome: wgo . This application will format an Excel or delimited file for conversion to XML. For questions concerning compatibiltiJ refer to Help/About ECT.
- n x
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
r Bar
Tab
Other:
Comma
jeep ut_ - ^eieci rnem
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- Si Error_Files
4 CJ Good_Files
1 ~\ History Files
ffl-Q lnput_Files
•-CJ Val_Log
IB-lsJI FinePrint files
CJ FormaKML
-CJ My Google Gadgets
n My Music
-CJ My Pictures
Q My Videos
L+ Q My Virtual Machines
2j New Folder
+ _| PDF files
+ LJ TotalvalidatorTool
B-CJ NetHood
-CJ PrintHood
-CJ PrivaclE
CJ Recent
Q SendTo
B-CJ Spark
ffi-Cj Start Menu
-CJ Templates ji
Name | Size | Modified | Attribute
Process
Existing
H BuyDenyTernplate.xls 30,720 3/10/2010 10:56:05 AM A Flle(s)
1 BuyTemplate.xls 27,136 4/1 4/201 03: 49: 52PM A
H GenerateTemplate.xls 51,712 4/1 4/201 03: 49:52 PM A
H RetireTernplate.xls 40,960 4/14/2010 3:49:52 PM A
H SellTemplate.xls 33,792 4/1 4/201 03: 49:52 PM A
H SellTemplateCanceLxIs 37,376 3/9/2010 11:00:27 PM A
H SeparateTernplate.xls 39,424 4/1 4/201 03: 49:52 PM A
Or
Build a New
File
Or
Exit
- Files —
Input Filel
|C:\Documents and Settings\wgo\My Documents^EMTS Conversion Tool (ECT)\lnput_Files
File(s) Folder: |C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\Good_Files
**Bad File(s) Folder: |C:\Documents and Settings\wgo\My Documents^EMTS Conversion Tool (ECT)\Error_Files
.og File(s) Folder: (C:\Documents and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)Wal_Log
) Folder: |CADocuments and Settings\wgo\My Documents\EMTS Conversion Tool (ECT)\History_Files
"Location of formatted niil|iT|i III il in 111 i nm ""Location of formatted output that has errors.
-------
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 setup for processing, as indicated in Figure 8.
Figure 8: Folder Set-up Screen
EMTS Conversion Tool (ECT)
File Help File List View Show Front Page Show Log WinZip
Welcome: KKuhn . This application will format an Excel or delimited file for conversion to XML. For questions concerning compatibly refer to Help/About ECT.
Step It I - If using a delimited file specify delimiter.
Start by putting your data in a compatible delimited format.
The default method is to let this application figure out if it is a tab, comma, or bar delimited format.
Otherwise, you may choose your own delimiter.
i _IDUX
This option is not needed if using an excel file, application will determine file type by it's extension.
Delimiters
'•' Default
r Bar
Tab
Other:
Comma
Step tt2 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.
E d Application Data
i d Cookies
;+i d Desktop
d Favorites
EB d Local Settings
:-: d My Documents
Id Downloads
i E}d EMTS Conversion Tot
id Error_Files
id Good_Files
Id History_Files
t3 lnput_Files
; d Val_Log
i--fjU EmtsConversionTool
\ d FormatXML
Id My Data Sources
;d My Music
i d My Pictures
: d My Videos
S d NetHood
IB d personal
id PrintHood
id Recent
Name
Size | Modified
| Attribute
= GenerateTempli
S| GTemplate.xls
^ RetireTemplate.
a] SellTernplate.xls
S| SeparateTempli
Q O My Documents
El Downloads
Q EJ EMTS Conversion Tool (ECT)
£=| Error_Files
Q Good_Files
El History_Files
Q Input Files
ElVaUog
El EmtsConversionTool
v
Make New Folder
Process
Existing
File(s)
Or
Build a New
File
Or
Exit
i-nes
Input File(s] Folder: |CADocuments and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)Mnput_Files
*Good File(s) Folder: |CADocurnents and SettingsSkkuhnVMy Documents\EMTS Conversion Tool (ECT)\Good_Files
"Bad File(s) Folder : |CADocuments and Settings\kkuhn\My DocumentsSEMTS Conversion Tool (ECT)\Error_Files
Log File(s) Folder • [C:\Documents and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT]\Val_Log
History File(s) Folder: |CADocuments and Settings\kkuhnSMy DocumentsVEMTS 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
Folder: Files to Process Folder
The first folder, entitled "Input File(s) Folder," is where the input files should be stored. The folder
information is saved between executions.
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.
Folder: Bad File(s) Path
The "Bad File(s) Path" is where the ECT will save any files that the user has attempted to process that have
some sort of major error and cannot be converted. Only data that has no major errors will be converted to
XML and saved in this folder; all data with errors will not be converted to XML. The user can then use the
comments provided by the ECT to amend the input file for re-processing.
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.
Folder: Log File(s) Path
The "Log File(s) Path" folder will contain a log that details all of the successful and unsuccessful
conversions. The log captures the date, time, file that is being processed, and the outcome of the process.
Figure 9 displays a sample log file.
-------
EMTS Conversion Tool
Figure 9: ECT Log
File Edit Format View Help
INFO:
INFO:
INFO:
INFO:
INFO:
- 1/27/2010 3:23:23 PM
Begining Processing File: c:\Documents and settings\
\My Documents\EMTS conversion Tool (ECT)\Input_Files\5ellTest_den-
Columns found in record 2:
Transaction Partner organization Identifier, Transaction partner organization Name, RIN Quantity, Batch volume, Fuel code, Assignment code,
RIN Year, sell Reason code, RIN Price Amount, Gallon Price Amount, Transaction Date, PTD Number, Transaction Detail comment Text,
supporting Document Text 1, supporting Document Number Text 1, supporting Document Text 2, supporting Document Number Text 2,
Generate organization Identifier, Generate Facility Identifier, Batch Number Text,
INFO: -[0} - 1/27/2010 3:23:23 PM
INFO: -[0} input File successfully opened
INFO: {0}
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
Finished Loading Input Data.l data records read.
Processing can not continue.
Finished processing Input Data. Records processed
Input file: \5ellTest_deny.xls <><><>
Missing or incorrectly formatted required fields: The following COMPANY INFO (step 3) elements are missing but must be pi
Missing or incorrectly formatted required fields: The following COMPANY INFO (step 3) elements are missing but must be pi
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
input file: \5ellTest_deny.xls <><><>
- 1/27/2010 3:23:34 PM
Start writing to c:\Documents and settings\
\My Documents\EMTS conversion Tool (ECT)\Good_Files\sell9999_2010-01-27-15-
Record * 1 written to XML file.
- 1/27/2010 3:23:34 PM
start writing to c:\Documents and settings\
\My Documents\EMTS conversion Tool CECT)\Good_Files\sell9999_2010-01-27-15-
Processing Data. Approx Records to be processed - 1
Finished processing Input Data. Records processed =1. 1 records were successfully processed.
Formatted to: XML file,
compressed to: No compressions were selected.
INFO: {0}
INFO: {0} input file: \sellTest_deny.xls <><><>
INFO: {0}
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
Missing: Transaction Partner organization Identifier
- 1/27/2010 3:24:04 PM
Missing data for required fields on record(s): 1, Record will not be processed.
Missing or incorrect value for required element(s) in record(s): 1, refer to columns marked
processing Data. Approx Records to be processed = 1
Finished processing Input Data. Records processed = 1.
1 records were found with errors, these files can not be loaded to the server.
INFO:
INFO:
INFO:
INFO:
INFO:
INFO:
Input file: \5ellTest_deny.xls <><><>
- 1/27/2010 3:24:37 PM
Start writing to c:\Documents and settingsX
\My Documents\EMTS conversion Tool (ECO\Good_Files\sell9999_2010-01-27-15-
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 on the toolbar of the ECT at any point of the process (see Figures 10 and 11).
-------
EMTS Conversion Tool
Figure 10: "Show Log" Function on the File Selection Screen
S EMTS Co n ve rsio n Too L ( ECT) _ C
[1®
File Help File List View Show Front Page (show Log) WinZip
Welcome: KKuhn . This application will format an Excel or delimited file for conversion to XML. For questions concerning compatibility refer to Help/About ECT.
Start by putting your data in a compatible delimited f
The default method is to let this application figure ou
Otherwise, you may choose your own delimiter.
This option is not needed if using an excel file, appl
Jtmat. Dellmlters
t if it is a tab, comma, or bar delimited format. (T Default 1™ Tab <" Comma
T Bar r Other:
nation will determine file type by it's extension.
Select a Folder on the left panel and File(s) on the right panel and click on the Process File(s) button to process OR Select the Build a New File button.
4-C] Application Data
(_J Cookies
B-O Desktop
n Favorites
El O Local Settings
FI-Pl My Documents
: Q Downloads
B"Q EMTS Conversion To<
Q Error_Files
Q Good_Files
; Q History_Files
£j InpuLFiles
^ Cl Val Log
1 1 EmtsConversionTool
Uffl FormafXML
| My Data Sources
!•• n My Music
Q My Pictures
L Q My Videos
+ LJ NetHood
+ 1 1 personal
•-Q PrintHood
!-Pl Recent
i (—, r- .• -r
< >
Name | Size Modified | Attribute |
a| BuyExample.xls 27,136 4/7^2010 1:50:59 PM A
H BuyTemplate.xls 27,136 4/12/2010 12:09:40 PM A
H GenerateTemplate.xls 51,712 4/12/201012:09:40 PM A
1 GTemplate.nls 51,712 4/5/2010 12:22:52 PM A
H RetireTemplate.xls 40,960 4/12/2010 12:09:40 PM A
Ml SellTernplate.xls 33,792 4/12/201012:09:40 PM A
H EeparateTemplate.xls 39,424 4/12/2010 12:09:40 PM A
Process
Existing
File(s)
Or
Build a New
File
Or
Exit
rues
Input File(s] Folder: jCADocumentsand Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)Mnput_Files Set Path
'Good File(s) Folder: |C:\Documents and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)\Good_Files Set Path
"Bad File(s) Folder : |C: \Documents and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)\Error_Files Set Path
_og F le(s) Folder : |C:\Documents and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)Wal_Log Set Path
1 History File(s) Folder: |CADocurnents and Settings\kkuhn\My Documents\EMTS Conversion Tool (ECT)\History_Files
| "Location of formatted output that has NO errors. ""Location of formatted output that has errors.
Set Path
^
-------
EMTS Conversion Tool
Figure 11: "Show Log" Function on the Processing Screen
S Generate Transaction - Processing file:
Process Rows Columns Help
Step 113 -Enter Company Info
WinZip
* User Login:
" Organisation ID: |
Step H4 - Select column to upload
Add Hew Empty Row
'Euti-mtt-dl Lre-d:n:n ['ate: 12010-02-01 Submission Comment:
Header Infomation
"Application Use. ID: |^T~
Transmission ID: TBD
Lopu Row[s] to N='.'.' Row(s] Delete Row[s) Show Legends
i!ee:t th = appro::.ria:e lolumnj f-on :he drop-down,- below Refer :o :he leqenc on the ruddle right a.- to vihether M = li.- s-e requ red :r -o: R .:",','= car be .-orted iv eld ni on :he .:olumr header Lhanqe.- mads ', ,'ill b= reflected in the -'=/,' output tie and
Setting File Options
To set various output file options, click the "Output File Options" button on the File Processing screen.
Figure 12: Output File Options Screen
B Formatted Output File Options
File type XML is the ONLY option required for subrnissionftransrnission
File Type(s)
!• XML - This is the ONLY option required for submission/transmission
f~ 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
r 0 verride the default name of T tO rgl d_YYrY-M M -D D -H H -M M -S S where T t is the T ransaction Type.
Overridden File Name: [
Do NOT include the Folder (Path) name. The "Good Files" folder is assumed.
OtherFileOption(s) —
Use Recommended Names for Column Headers. Text or Excel file only)
f" Display Processed File
OK
-------
EMTS Conversion Tool
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.
------- |