Import Wizard

[Frank]

A while back I found a post, didn't bookmark it and now I can't find it again, where someone created an import wizard for importing data into ServiceNow. This isn't Easy Import, it was a customization to simplify the process. The developer would set up a transform map in advance and the user would enter destination table, expected data format, (Excel, CSV), import set table, transform map with a few other fields. When they submitted the form, it would run the transform map and load the data. Since using import sets is not available to all users, this was a way to give them access. I believe it sends users an email on the success or failure of the import.

Does anyone recall seeing this post? I'd like to reference it again.

Thanks,

Frank

[Alikutty A]

Also here is official training & documentation link on import sets. The training one is good, you can learn it step by step

https://developer.servicenow.com/app.do#!/training/article/app_store_learnv2_importingdata_kingston_importing_data/app_store_learnv2_importingdata_kingston_importing_data_objectives?v=kingston

How to import data - https://docs.servicenow.com/bundle/london-platform-administration/page/administer/import-sets/reference/import-sets-landing-page.html

[Frank]

Hi Alikutty,

I can create the transform map, etc, what I'm looking for is what someone created to allow users without the rights to use the transform map to upload data. All the backend work would be done ahead of time.

Thanks,

Frank

[Alikutty A]

Ok, I think I got what you are talking about.

Check this "Consumerize" Data Imports to Non-ServiceNow Administrators and see if this is what you are looking for?

Thanks!

[Frank]

I don't think that's the post. It was several months ago. I remember a configuration table was created. Here's the user input form I created from the post. It's a little different from what the author created, but it should be close.

[Frank · Accepted solution]

Hey Everyone,

Thanks for all the help, I found the article! My bad it wasn't in the community but in SN Guru. For those that are interested, here's the link,

Simplifying Data Imports from Third Parties. Credit where credit is due, the article was written by Jacob Anderson.

Thanks again,

Frank