Easy Import Truncating Reference field value to 32 characters

[reagz]

Hi All,

I have an issue using 'easy import' that has only recently caused problems, when importing an excel file where the reference field value is greater than 32 characters.

I have two tables:

Table 1 - Category Super Group

Field - Super_Group (String Field (set as Display)... length = 200)

Table 2 - Category Product Group

Field - Product_Group (String field ... length = 100)

Field - Super_Group (Reference field to Category Super Group table ... length defaults to 32)

When I use easy import to load an excel file into the Category Product Group table .... records where Super_Group is greater than 32 characters are being truncated to 32 characters on load and therefore when completing the load, these records are missing the Super_Group reference value (since the values setup in the Category Super Group table are longer than 32 characters).

I am hoping there is an easy fix so I can continue to use the easy import.

Any assistance would be greatly appreciated!!!

Thx

[Community Alums · Accepted solution]

any time you import stuff, you've got a target table and an import table. The import table is where the data sits before it's transformed by a transform map and put into the target table.

I'd check your import table and see if the field length is truncated there. I have had this happen before, where the field length on the target table is quite large, but the data gets truncated because the import table is only taking the first X characters.

[reagz]

Thank you so much .... that was it!!!  Ugh .... I didn't realize the import table would dynamically set the field lengths based on the fields from the destination table ... and since it is a reference field, the length was defaulted to 32.

Thanks again, you saved me a lot of time investigating this issue!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[Community Alums]

Happy to help.

[SriChaitanV]

How do you solve this now??