Importing multiple data file (XLS/CSV) in ServiceNow Tables

Importing Multiple Data File ServiceNow Case Study, Fidel

Importing multiple data file (XLS/CSV) in ServiceNow Tables

With our scheduled script each data Source have their Scheduled Import Set to import the data in file attachment to the targeted table.

Challenges

  • In ServiceNow, when multiple files attached to the Data Source and Scheduled Data Import executed the first attached file data is imported in the targeted table.
  • Other files are not considered while doing the data transform.
  • We have more than files coming from email and need to import in the tables.

Solution

  • In this case what we have done is, we have used the Parent Data Source and the number of child Data Sources that can actually hold the single attachment.
  • Here, we have written as Scheduled Script that actually gets the attachments from Parent Data Source and attaches corresponding attachments to the Child Data Sources.
  • Then, each Data Source have their Scheduled Import Set to import the data in the Service Now targeted tables.

Results

Client has more than a file in email attachment and corresponding data is imported in the tables, so as to correct reports values are populated from the tables.

If anyone facing the same issue, please reach us. We are open to support.
Reach us at salesfidel@fideltech.com