GitHubContribute in GitHub: Edit online

CSV Import

CSV Import can be found in the section SETTINGS >> CONNECTION >> Integrations. Note: To access this section Admin permissions are needed.

The basic documentation for both CSV Import and Export can be found here: Targetprocess Guide

To get predefined sets of CSV files and JSON examples please click here: Targetprocess Github

Integration users import

In order to import integration users the following code must be added to the JSON mapping:

{
          tpFieldName: 'IsIntegration',
          csvColumnName: 'IsIntegration',
          skipTpValidation: true
        }

Importing files with date, time, and timezones

When importing data, including dates, the system behaves differently depending on the date format in the CSV file and on the local Targetprocess timezone. It is recommended to import dates without including the time.

Targetprocess doesn't show the complete time and date on the user interface (UI), but you can access it through API.

Examples of the imported date, time and timezones:
*Note that "Targetproces local time" refers to the timezone of the server where the Targetprocess account is hosted, not the timezone of the user's web browser.

Targetprocess local timezone* Date format CSV Input Results in Targetprocess
00:00 Date without timezone and time 2023-08-25 2023-08-25T00:00:00-00:00
00:00 Date without timezone but with time 2023-08-25T06:00:00 2023-08-25T06:00:00-00:00
00:00 Date with timezone and time in UTC (ending with Z) 2023-08-25T14:00:00Z 2023-08-25T14:00:00-00:00
00:00 Date with timezone and time other than UTC 2023-08-25T00:00:00+10:00 2023-08-24T14:00:00-00:00
-08:00 Date without timezone and time 2023-08-25 2023-08-25T00:00:00-08:00
-08:00 Date without timezone but with time 2023-08-25T06:00:00 2023-08-25T06:00:00-08:00
-08:00 Date with timezone and time in UTC (ending with Z) 2023-08-25T14:00:00Z 2023-08-25T06:00:00-08:00
-08:00 Date with timezone and time other than UTC 2023-08-25T00:00:00+10:00 2023-08-24T06:00:00-08:00
+08:00 Date without timezone and time 2023-08-25 2023-08-25T00:00:00+08:00
+08:00 Date without timezone but with time 2023-08-25T06:00:00 2023-08-25T00:00:00+08:00
+08:00 Dates with timezone and time in UTC (ending with Z) 2023-08-25T14:00:00Z 2023-08-25T22:00:00+08:00
+08:00 Date with timezone and time other than UTC 2023-08-25T00:00:00+10:00 2023-08-24T22:00:00+08:00

Limitations

  • The maximum number of relations that can be used in an import mapping is: 10
    (9 relations can be assigned to the entity)
  • The maximum file size for an import .csv file is: 15MB
    (If the .csv file contains 5 columns, the approximate number of rows is 20k)
  • The Import rate is limited to max.: 240 records per minute (create/update)
  • Import operations cannot be executed in parallel. One import operation is executed at a time.