Administrators can easily import data into Skedulo from anywhere that supports CSV files.
Creating an import task
In order to import your data, you must first create an import task.
To create an import task:
- On the Data Loading page, click Create Task.
- From the task menu, select Import.
Fill in the task details to specify whether you want to insert new or update existing records, and to specify into which object you want to import the records.
- Select an Operation Type. You can choose to create new records or update existing records.
- Insert — Select this option to create new records.
- Update — Select this option to update existing records.
- From the Object dropdown list, select the object into which you wish to import the data.
- Click Browse and locate the CSV file you want to import.
- Click Continue.
Map your CSV columns to your Skedulo fields. Fields are ordered based on the columns in the CSV file, and any fields that match existing Skedulo fields will map automatically.
Use the quick find at the top of the selection dropdown to search through your Skedulo fields.
The final step is the Review page, which provides a brief summary of the task details. If required, change the date and time formats, and select a time zone.
Click Create Task to save your task and run it immediately.
When updating data, you must provide the Skedulo record UID(s) you wish to update.
There are two ways to locate the ID of a Skedulo record:
- Run an export operation to retrieve object data (records). Each row in the export will contain a “UID” column which is the record ID.
- Use GraphQL to query the object and return the UID in the response. To learn more about GraphQL queries, please see GraphQL queries.
The task is running (importing or exporting data).
The task has finished running and all the records are processed (with or without errors).
The task has stopped because: