Celigo Data Loader

Category : Uncategorized

In the Tools menu we also have Data Loader, which allows us to build integration flow where we upload files into inegratorio, in that process it goes import into a different system

When we click the Data Loader in the source, a window pops up.

After entering the name and Uploading the file,here we selected a JSON file, then click Save or Save & Close. Here whenever we need to run this flow, each time we have to upload a new file into integratorio. This is helpful for the processes where we need to do some manipulations on data or calculations on excel sheets and upload once in a month into the accounting system.

Here we have completed the source of the Data Loader. Now we can specify the Destination.

When we click the Add destination a window pops up. Here we select NetSuite as destination.

Here we are adding a Sales Order in the NetSuite using the JSON file uploaded in the Data Loader Source. After entering all the details. Click Save.

After successfully saving the destination details we need to map the fields. For this click on the Plus (+) icon in the Destination which shows a mapping icon, click on the mapping icon.

Clicking the mapping icon pops up a window for mapping. Here we need to map against corresponding fields and click  Save or  Save & Close.

After saving, we can run.

When we click the run button, first time it uses the file we uploaded. As we have already discussed, whenever  we need to run this flow again, we need to upload the file once more. Since all the mappings exist, we need to upload the file and run only the flow. After Successfully running the flow, new Sales Order will be generated in the NetSuite account.

Now let us look into the contents of  Run Dashboard.

We can see the total count of the successes, records Ignored, Errors, Resolved all within each instance of a flow running.

Success  is the sum of all the different imports for all the records that are imported through the imports.

Ignore count will be the number of records that are not run, not included in run or marked as ignored.

Error count of the number of errors occurred, when we click the error, helps us to view the error, details and whether to resolve or retry it.

Resolved contains the  number of records marked as resolved.

Pages contain the number of pages of records processed.If there are large files, then it is divided into multiple pages, so each step can handle small data at a time.

Duration contains the total time duration to run and  duration for each step.

Completed contains the time and date  when each individual step is completed or whole integration is completed.

Action helps either to Download diagnostics for the flow or Download File uploaded or Run flow again when each individual step is completed or whole integration is completed.