Importing RITMs from Excel File not getting all columns

[Patrick Maxwell]

I'm attempting to import about 250 new RITMs from an excel file. When I import the file into the instance it only gets 2 of the columns information. I'm assuming this is because the 2 columns it gets are the default servicenow variables (State and Item) while the other variables are catalog item variables. From what I read it should still import the information into this and I will be required to use a transformation mapping script to get the catalog item variables into the correct location when they get out of the staging table. Is this correct or am I doing something wrong with my import?

 

[Patrick Maxwell]

When I import the excel file I get the following message

The following fields have been ignored, because they don't exist on the destination table: Name, Email, Phone Number, Org Code, Requester Site, Mission Area, BOT Number, Reason for Request, Business Process, Problem Statement, Process Name, Operational Capabilities, BCR/PTR Number, LT BCR/PTR Status, LT Received Date, LT Assigned Developer, Actual Start Date, Actual Completion Date, LT Executive Notes, ROM, ALOE

[Patrick Maxwell · Accepted solution]

Solved by using answer on this forum post