Uploading a ZIP File
In addition to the CSV files, your zip file must include a control file called csvutil.ctl to tell Oracle Transportation Management how to process the files. The control file specifies the sequence in which the CSV files should be processed, and specifies the parameters to use when processing each file.
-dataFileName activity.csv -command i
-dataFileName activity2.csv -command i
The above control file says to process the file activity.csv using the insert command, then process the file activity2.csv, also using the insert command.
If you are performing an insert or update on a table with a CLOB column, you may specify the ext_fname pseudo-column before the CLOB column’s name. Any external files referenced in the column should be filenames relative to a directory in the ZIP file with the same name as the table (except for being in lowercase).
Uploading a zip file is the same as uploading any other file. Use the "Upload an XML/CSV" Transmission button accessed via Business Process Automation > Integration > Integration Manager.
After uploading your zip file, once processing is complete, you are prompted to download a “results” zip file.
Click Save to save the “results” zip file to your local workstation.
The csvutil.log file in the “result” zip file contains the log from processing all the CSV files in the zip file that you uploaded. Additionally, if any of the -command lines specify one of the exporting commands (xcsv, xcsvwpd, xcsvwcd, xcsvwpcd), the result file will contain files named by the -dataFileName parameter containing the exported data. If the exported tables have a column of type CLOB, subdirectories named after the table will be in the ZIP file, containing the individual external files for the CLOB fields in each record; the external file names in the .csv files will be relative to those directories.