Configuring the Upload Data from CSV File widget

  1. Click Configure Widget.
  2. Specify this information:
    Title
    Specify a widget title. Ensure that the field is unlocked.
    API Program
    Select the required API from the list.
    Program Transaction
    Select a standard transaction applicable to the specified API from the list.
    Which row contains the Headings?
    Select the row number that should be processed as the header of the transaction data.
    Does row 2 contain information?
    Select whether the second row contains descriptions to be excluded in the processing and uploading of the transaction data. This field only becomes available when you set Which row contains the Headings to 1.
    Further rows to skip?
    Specify additional row numbers that the widget should exclude in the processing and uploading of the transaction data.
    Note: You can specify multiple rows for exclusion using a comma (,) separator, for example 2,3,4.
    Column separator
    Leave this blank to use the default separator that is semi-colon (;).
    Note: You may also specify a different separator, for example comma (,). Although once you have selected a different column separator, it should always be used for the same file.
  3. Click Save.
  4. To download the file, click More (...) > Create CSV > Mandatory fields only. Depending on the API program that you selected, mandatory fields may vary. You can also select All fields from the context menu if you want to see all data fields in the CSV file.
  5. Upload the file to the widget through the drag and drop functionality or through the upload files hyperlink.
  6. Click Upload. In the Upload CSV dialog, review the uploaded file and the data that is presented. You can set up the display of records per page and choose between 5, 10, 25, or 100 records.
  7. When necessary, you may stop the uploading process by clicking Stop. If the uploaded file contains failed records, the number of failed records is displayed on the widget. You can check the list of errors on the widget by clicking View results or export the error logs summary by clicking the Download results button in the list title bar to get a spreadsheet copy of the results.