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.


-------