Import set Custom table not showing in Existing table during import

[kailashthiyagar]

I m trying to create an import set to load data into custom table. I m using Fuji Release of Service now

When i navigate to Import Sets --> Load Data and then choose "Existing table", the dropdown doesnt show my custom table option. I dont know whether making it as an extensible one would be of any help but i did that and even after that, it doesnt show up in the existing table list

What needs to be done??

In the list view of my custom table header, i did right click and i have an option to do an import over there, was it the only way where we can import data to the custom table?

Please advise

[veena_kvkk88]

Hi Kailash,

The actual servicenow tables you use don't show up on the existing tables dropdown. When you are importing data, there is an intermediate table that needs to be created - it's called import set table. That is what shows up on the existing tables. For a new table, you need to create the import set table. If you have already imported data once before, then that import set table you created then will show up in the dropdown. Hope I was clear. For more info, please refer to this link: Importing Data Using Import Sets - ServiceNow Wiki

The diagram in the 1st section should explain what I said.

[kailashthiyagar]

Thanks veena.kvkk88 .. Its clear.. One more query... If i create a new import set table, then i will end up in doing one import to my custom table "A".. Isnt it? If so, how would i do that?

There was no direct mechanism to import the data into my custom table A?

[kailashthiyagar]

Thanks veena.kvkk88   i think i have got answer.. will try in office tomo and let you know.. Thanks..

[veena_kvkk88 · Accepted solution]

Sure. I assume you said you got the answer to your next question? Just in case you didn't - here's how it works. Assuming you are doing a file import (If not, refer to data sources section in the given link)

-> Load data: Create/select an import set table -- select the file you want to import from (csv or xls or xml) -- submit

-> Create transform map: This is where you select your target table. This would be your custom table in this case. In the related links, click auto-map matching fields. This will submit your transform map and create field maps. i.e. mapping the fields from your file to your target table's fields. Verify if everything looks good. If something is missing or needs to be changed, you can always click on the mapping assist link in the related links and manually maps them yourself.

-> Once the above step is done, click transform. This will import all the data into your target table.

Please let me know if you have questions.

If I've answered your question, please mark my answer as correct. Thanks