Export data into an excel sheet from multiple tables from Service Now Instance.

Madhumita3
Kilo Contributor

‎07-29-2020 04:09 AM

Hi All,

I am looking for a functionality in Service Now Platform wherein I am looking for the below two functionalities:

1. Export the data of multiple tables to a excel sheet from our Service Now instance. 

2. Import the data to multiple Service Now table from a single excel sheet.

The Service Now version that we are currently using is in "Orlando" version.

Please, let me know if we have any current functionality in Service Now. 

Any help would be highly appreciated!

 

Regards,

Madhu

0 Helpfuls
  • 2,961 Views
3 REPLIES 3

johnfeist
Mega Sage

‎07-29-2020 04:24 AM

Hi Madhumita,

To export data from multiple tables, you need to create a view where you can do the joining you would normally do in a SQL query.  Here's the link to the documentation on creating views.

As far as importing goes, you need to do a bunch of scripting as under Orlando you can only connect an import set to one table.  The good news is that Paris has the functionality to do exactly what you need.  You might consider upgrading your PDI to give it a try.

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

 

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

Madhumita3
Kilo Contributor
In response to johnfeist

‎07-29-2020 04:37 AM

Hey John,

Thanks a lot for your reply 🙂

I will work on the solution provided by you.

 

 

0 Helpfuls

DirkRedeker
Mega Sage

‎07-29-2020 05:20 AM

HI

If you are trying to export your data from multiple tables from ServiceNow to multiple TABs in your Excel sheet, this will not be possible.

Exporting will always result in having ONE TAB in Excel.

That's why John proposed the database view solution (which joins all the tables).

But in some cases, it will not be possible to even JOIN the tables, because the even do not have any relation at all. That way, your cannot use the view solution.

In that case, you will end up creating multiple files (one per table) and importing them to ServiceNow as well.

Anyhow, the table by table approach is much simpler and not that error prone. You should really think about going the separate tables way.

If you have a main table that you want to export, and you need only "a few" additional tables, the view is fine. But if you have multiple tables, where you (even maybe) want all fields to be exported/imported, I stromgly recommend, NOT to go with the View path.

Let me know if that answers your question and mark my answer as correct and helpful.

Enjoy & BR

Dirk