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?

 

[Kris Moncada]

Hi @Patrick Maxwell ,

Could post a screenshot of the excel doc and the Transform map you used to process the excel data?

[Patrick Maxwell]

Here is a picture of the excel file. I've blanked out a few columns but they are just strings of the user's names and email addresses. I don't have my transform map script made yet since it should not be required to get the data from the excel doc into the staging table as far as I know. I think it should only be needed to get the data from the staging table into the correct catalog variables when I move to the correct table

 

[Ankur Bawiskar]

@Patrick Maxwell 

for each RITM record you need to have variable information in the excel.

I assume each column in excel to be the value for the variables present in respective catalog items

[Patrick Maxwell]

Each row in the excel document is creating a new RITM and this is working as expected. Each column should be a variable but I don't believe the data is getting moved into my instance unless I'm not understanding where the data should be stored. My understanding of the transformation map was that the data was needed to be in my instance for the script to have any effect.