Import .csv file from midserver, to Servicenow and to create report

Sriram28
Tera Contributor

‎07-09-2024 04:47 AM

hello team,

 

Requirement : customers have csv file data in their system. So, they want that data to be imported/loaded into ServiceNow  and create a report from it.

 

Note : this should be done on daily basis.

 

How we can achieve this ?

 

thanks in advance

0 Helpfuls
  • 861 Views
2 REPLIES 2

Mark Manders
Tera Patron

‎07-09-2024 05:01 AM

The file is placed on the MID server daily? Do you already have the import of the file to ServiceNow setup? Because then it would just be a datasource, create the import table and transform map and run a report against the data.

What kind of data is it? In what table are you putting the data?

0 Helpfuls

Sriram28
Tera Contributor
In response to Mark Manders

‎07-09-2024 06:51 PM

@Mark Manders 

 

Thanks for your response.

 

Yes, file is placed in midserver daily.

No, we have not imported the file to ServiceNow setup.

The data is in excel/csv format.

 

Could you please help me what method in data source should be used for this kind of requirement ?

 

Sriram28_0-1720576088132.png

 

if any related documentation also, please provide.

 

Thanks in advance

 

 

0 Helpfuls