Transform map is cutting off?

[sgodinho]

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!

[Shelby2]

Check out the following, maybe they will help:

https://community.servicenow.com/community?id=community_blog&sys_id=68bc2a25dbd0dbc01dcaf3231f96199f

https://community.servicenow.com/community?id=community_question&sys_id=c11103e5db98dbc01dcaf3231f96...

Please mark helpful or correct if I have provided useful information.

[AbhishekGardade]

Hello sgodinho,

It seems issue with the field length of transform map field where you are importing first the data from excel. Try increasing length of the the field created on transform map field,

Please mark as Correct Answer and Helpful, if applicable.
Thank You!
Abhishek Gardade

[Andrew Barnes - · Accepted solution]

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

[sgodinho]

Andrew - thank you so much for the link to the import set properties...I ended up implementing a few of them, but the com.glide.loader.verify_target_field_size property worked perfectly for this particular problem!