Imported data but name is cut off

[John Vo1]

I created a table and imported my excel file.  But when I check the accounts in my table some of the names are cut off.  How can I fix this issue?  

[Mark Stanger]

You need to check the 'Max length' on the dictionary entries on your import set table and your target table to make sure they are long enough.

[Brad Tilton]

Hi John,

That usually happens when the max length of the field in the import table is shorter. By default a lot of the string fields will be 40 characters. I would check the length of the supplier name field dictionary entry in your import table first.

[John Vo1]

I updated that to 200 and it's still truncated.  Do I need to load data again for it to update?

[Brad Tilton · Accepted solution]

Yep you'll need to reload the data so you get the whole string in there.