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]

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.