The Field being Truncated. How can i solve this?

[Vaishnavi35]

Hi,

I have two custom fields created on the Test Case form.

Process Area and Description - Both are String type fields.

These fields are getting truncated. Initially the length was 40 i made it 50000.

When I copy paste from Excel sheet. Its perfect.

But when I load the data its getting Truncated!!

In Excel,

In Servicenow, (Its completely truncated)

PLEASE HELP!

Thanks in Advance,

Vaishnavi

[Ashley Snyder1]

Did you increase the size of the field on the import set table as well? More than likely it's being truncated there and that's why you see the issue on the data load. So two parts, expanding the field on the target table and on the import set table.

[Vaishnavi35]

Hi Ashley,

I have not used the Traditional Import Set method.

Pulled the Template from the LIST View and imported/loaded the data in the same way!

Do I need to add any attribute?

[Ashley Snyder1]

The load still creates an import set table, you should be able to locate the import set table during the load, or by navigating to the import set. System Import Sets > Import sets > find the one that matches what you created and you'll see the import set table.

I ran mine twice in my PDI and it looks like it used the same import set table each time.

[Vaishnavi35]

Where do i exactly go and check?? Can you please help 😞

When i click on that, a form is opened. Its Truncated there as well