Why data is not picking from excel column

[Atik]

Hi All,

I am importing the data from excel via transform script where I am generating the RITM's, where everything is working fine, Only one thing I am facing which i observed while importing the data. Lets say there is a column on excel description which I am mapping to short variable "description" which is multiline text variable.

Now what is happening lets for example on excel column text is something like below
"This is for Test line 1, Test line 2" and it is only picking "This is for Test" is being captured, and remaining text is not being picked up. 

I'm trying to understand what might be causing the issue, Could someone please help me to troubleshoot or guide me how to resolve it?

Thanks in advance!

Atik Bagwan

[kaushal_snow · Accepted solution]

Hi @Atik ,

The column in the import set table (the staging table ServiceNow creates when you import) may have its Max Length set low. If the source cell is longer than that, it gets truncated before/when entering the import set table...Even if import‐set column is okay, the target variable / field (in this case a multiline text or HTML field) may have limits (e.g. 255 chars, or some other limit) that are smaller than what you expect. So data might be cut off when copying from the import set row to the target......

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[kaushal_snow · Accepted solution]

Hi @Atik ,

The column in the import set table (the staging table ServiceNow creates when you import) may have its Max Length set low. If the source cell is longer than that, it gets truncated before/when entering the import set table...Even if import‐set column is okay, the target variable / field (in this case a multiline text or HTML field) may have limits (e.g. 255 chars, or some other limit) that are smaller than what you expect. So data might be cut off when copying from the import set row to the target......

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[kaushal_snow]

also, there is a system property com.glide.loader.verify_target_field_size which, when enabled, allows the import set table field sizes to grow to match the target field sizes, helping avoid truncation....

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.

[Atik]

Hi Kaushal,

Thanks for your response!

Actually I am generating the RITM via Cart API. So I don't where to do this setting, I have script written as 2 places only, one is On before and On After. So could you please help me where exactly I need to do this settings.

Thanks,

Atik

[Ankur Bawiskar · Accepted solution]

@Atik 

so how does the data look into staging table?

If it's coming as This is for Test then only that will get transformed.

Try increasing the length of that import set staging field to 100/200 as the text might be getting truncated.

After increasing the field length load data again.

If my response helped please mark it correct and close the thread so that it benefits future readers.