What is the best way for importing excel files for non-admin users?

[peter_repan]

Hi guys,

I'm interested in your opinions and thoughts how would you implement functionality of importing excel files for non-admin user.

Some points:

- it must be possible through CMS

- it must be possible for users with specific role

- after upload, system must execute the import process - load data, run transform

- it must be possible to provide (immediate) feedback to the user if the upload was successful or not with a simple message

I found one solutions here: ServiceNow: allowing non-administrator users to perform mass data load • Aspediens - European Servic...

But we would like to not show the out-of-the-box screen of import status to the user.

Any other ideas?

[Daniel Draes]

You could try to leverage the code from this link https://community.servicenow.com/message/836505#836505. Here one uses an inbound email with attachment to launch the transform process. The same should be possible to be used within a workflow on a catalog item.

I would hesitate though with the immediate feedback. If the import takes a little longer to process (you never know how big the file are they send) this is not ideal. I would recommend to inform the user either via email or other means.

[mrswann]

I have built a solution which ingests via email however this is not acceptable due to the content riding out on emails

If you are not concerned with the content/security of email this may be a good solution for you.

I was reading this: https://fruitionpartners.eu/blog/2011/05/23/mass-data-load/   but it dates from 2011 and no longer valid. edit we just linked to the same URL, I forgot aspedians were acquired by FP.

I will check your other links above as we need an authenticated user to upload via SSL but they should not be an admin

[mrswann]

This looks good on Share ServiceNow Share