Using the CSV Utility

Use the CSV utility to send and receive data in CSV (comma separated value) format. You can use the utility to send any type of integration data but the most important function is to send rate records to Oracle Transportation Management. It also supports unloading data as a script of insert statements.

The CSV utility performs the following actions:

  • Import data to Oracle Transportation Management in CSV format.
  • Export data from Oracle Transportation Management in CSV format.
  • Update and delete data using CSV files.
  • Suppress unique key constraint violations when inserting data.
  • Suppress "no data found" constraint violations when updating/deleting data.
  • Embed multiple CSV files within a single XML transmission.
  • Perform import and export functions from Oracle Transportation Management Web screens.
  • Export data to a browser instead of a file.
  • Export data in a single domain.

Related Topics