Creating CSV data

Use this information to create CSV text that can be loaded by the Load CSV action or passed through ION for automated integrations.

Note: We do not recommend that the CSV be loaded using dbimport or the Import to Database function on Administration Console. If you use these methods, foreign key values are not assigned corresponding internal values.
  1. Select Payroll Administrator > Deduction Maintenance > One Time Deductions > One Time Deduction Import.
  2. For an existing item, set the Import Status to Not Processed and update the item. For a new item, on the Not Processed tab, click Create.
  3. Set the Import Group to a new distinct value.
  4. Look up foreign key values and assign corresponding internal values.
    • Include the fields with values that are intended to be set in the headers row and column data.
    • You can use Excel to create the file, but the file must be saved as CSV.
    • If you are using copy and paste to populate the CSV Input Data field, then open and copy the CSV text using a plain text editor. Do not use Excel to copy and paste the text.
  5. Click Save.