Easy import doesn't import

[matt_staples]

I'm creating a table for use in a multivalue list (similar to the Watch list field). I've created the table and given it the single field of 'LU Strategy theme'. I then followed the Easy import instructions at Easy Import - ServiceNow Wiki. I added the values into the Excel document and uploaded the file back into ServiceNow. It validates successfully and i click 'Complete Import'... and then it returns me to the Table's list view with no entries showing in it. I've tried it several times with the same result.

It does appear to create a second table titled 'Imp Tmpl U Lu Strategy Theme' where the new records are showing, but they're not in the intended table. Is there an extra step i'm missing? The Easy Import page doesn't seem to mention one.

(The directions of the excel file state i don't have to include all fields, but does this include number/sysID?)

(Just to note,   this import is more of a test import, hence why it only has four entries. I'm setting this up for an import with about 500 entries)

[Michael Fry1]

I read this as, your trying to import choices into a field on a newly created table. Not sure Easy Import can do it that way. When you download the spreadsheet from Import, all of the field values are set on the spreadsheet for you so you can't set any choices that do not exist already.

[matt_staples]

Hi Michael. Thanks for this but i don't think it's the case. I've created the table myself and created a column within that. That column shows up in the import spreadsheet i download through Import. I then add my records/choices to the spreadsheet and upload it back to ServiceNow. Easy import acknowledges the records during validation (as shown in the screenshot) but then doesn't add them to the table.

[Michael Fry1]

I would try inactivating the ACLs that got created with the new table.

[matt_staples]

I had already tested it with elevated permissions but i've now deactivated all associated ACLs and the same thing is occurring.

I would at least expect an error message if there were permissions errors or i was doing something. According to the import log it thinks it does it successfully.