1. Data Management Guide
  2. Loading CSV Data via the User Interface

Loading CSV Data via the User Interface

This section describes how to import a CSV file using the Oracle Transportation Management user interface.
Note: There are limits on importing CSVs. When importing via the user interface, there is a 50MB limit. However, when importing via integration, there is a 100MB limit.
  1. Sign in to Oracle Transportation Management.
  2. Choose Business Process Automation > Integration > Integration Manager.
  3. Click Upload an XML / CSV Transmission.
  4. Select the file to upload. The upload will transfer files from your local machine to the server.
    Note: You must select a CSV file. This CSV file cannot make reference to external files for CLOB columns. If you need to use external CLOB files, use the zip file format described in the Uploading a Zip File and CSV Export Screens sections.
  5. Click Upload and Oracle Transportation Management displays the page for importing the file. If you select a file other than a CSV file, a different page will open.
  6. If it is not already selected, select i from the command list.
  7. Leave the dataDir as is.
  8. Leave the dataFileName as is.
  9. The xvalidate drop-down list allows you to turn off verbose diagnostic messaging. To leave messaging on, the value in the field should be Y, which is the default.
  10. In the encoding field, select the appropriate encoding type for your CSV file. If your file contains standard ASCII characters, then it can be encoded as ISO-8859-1. If it contains non-standard, international characters, then it should be encoded as UTF-8.
  11. Click Run and Oracle Transportation Management displays a results page.

To read more about interpreting error messages, see the Introduction to CSVUtil Response Messages section.