Transform map is cutting off?

sgodinho · ‎01-15-2020

Hello all,

I am having difficulty with my transform map. It is only importing part of the data stored in Excel. The limit on the scope/description field is set to 4000, so I'm not quite sure what the problem is.

The Excel template has fields that go from column A to AR. So long as each cell contains less than maybe 40 characters, it seems to go through to the end okay. Any cell that contains more data gets cut off though. Is this supposed to be happening?

Any suggestions would be greatly appreciated!

Andrew Barnes - · ‎01-15-2020

Greetings Sgodinho,

Your transform map field length is the limiting factor. You can verify that this is the cause by looking at those field lenghts or even inspecting one of the import set rows. Adjust the field lenght yourself or add the property from com.glide.loader.verify_target_field_size - https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/import-sets/refer...

-Andrew Barnes
Join me at Developer Blog

View solution in original post

sgodinho · ‎01-15-2020

Thank you, SN community!