Exporting Data as a Zip File
This section illustrates how to export a zip file containing one or more CSV files.
- First, create a
csvutil.ctl
file containing the commands for exporting your files.A csvutil.ctl file may contain the following commands:
-dataFileName activity_out.csv -command xcsv -tableName ACTIVITY -dataFileName location_out.csv -command xcsv -tableName LOCATION -whereClause "rownum < 10"
- Next, create a zip file containing the csvutil.ctl file.
- Once your zip file is created, you can upload the zip file as you would upload any other file to Oracle Transportation Management through the Business Process Automation > Integration > Integration Manager > Upload an XML/CSV Transmission.
- Press Save to save the “results” zip file to your local workstation.
- Open the zip file to see that the zip file contains two CSV files in this case, one corresponding to each command in the csvutil.ctl file. If the exported table(s) include a column of type CLOB, subdirectories named after the tables will exist in the zip file and will contain the individual external files for the CLOB values.
- The zip file also contains a log file containing information regarding the execution of CSVUtil.