Alumni bulk import

[MadhurM]

I have used an excel file with the headers personal email, first name and last name. The data in the last name isn't getting captured when I load the data. I am using the Imported Alumni [sn_asc_user-imp] table as recommended by the documentation. Any suggestions on how to rectify this?

[Vinod54 · Accepted solution]

Hello @MadhurM ,
It could be data type mismatch or any other reason. Please review the import logs and share the key information from the log to answer precisely. 

Recommendation: Download the table template and use it with the excel sheet data to avoid such issues. 

1. Type sn_asc_user_imp.list in the application navigator and enter
2. Right-click any column header in the list view
3. Select Import → this will give you an option to Download Template
4. The downloaded Excel file will have the exact column headers ServiceNow expects
5. Fill your data into that template and re-import

If this answered your question, please hit Helpful and Accept as Solution

Thanks,

Vinod Kumar M

[MadhurM]

it was creating new fields that were not pre existing and it assigned the type based on the data sent so it was of the wrong type and I removed the fields and used it again to set the correct type. Thank you.