Data in import set table but can not be transformed into target table

[Cheng Luo]

I am using a dev instance dev64918.service-now.com to load some system configuration data from xml file into cmdb using import set. After loading, I can see the import set table was updated with records properly. However when I tried to use transform map(field map) to transform those data into target table(user defined). I can see the record in import set table was changed into Processed state. However the target table was still empty. Screen shot for the import set table and transform record attached. Anyone can help on this?

[Sohail Khilji]

HI,

check the below point:

Did you run the transform map ?

Are your fields mapped properly (check for field types)

Is the file getting attached to the data source before the transform begins. Can you check the import set table whether the data is loaded into this table worked or not ?

Make sure the loaded file header contains right info as needed ?

I hope the answer helps, You can thank me by Marking the answer ✅ Correct or 👍 Helpful.

Thanks,

MF Sohail Khilji.

LinkedIn > https://www.linkedin.com/in/mf-sohail-khilji/

[Cheng Luo]

The first screen shot is the import set table with 4 records. The file was attached to the data source, thus each time I do the import, there is 1 new record to be imported into the import set table.

[Cheng Luo]

Hi, Sohail

The first screenshot attached is the data being imported into the import set table.

The second screen shot below is the definition page of transform map. I check the 2 fields mapping, the filed type do have a match.

Transform history record with Complete state. There is 1 insert in the record.

However when checking the target table, there is no data there.

[shloke04]

One thing to note here is Record got Inserted as if you notice there is no Submit button on the last screenshot you have attached above.

Only Update and Delete button is present which clearly indicates record is not a new one and got created.

issue is with your Transform mappings here. Can you confirm the Field Mappings are defined correctly here.

Also can you past screenshot of your Import set Dictionary table here so that we can compare if source and target fields are selected corretly.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke