Easy import template text trunacted during import

TomDickson
Tera Contributor

I'm using the Easy Import Template to create new records in the alm_hardware table and encountering an issue with reference fields such as Model and Location. In my Excel template, the values I provide exactly match existing records in the respective reference tables. However, during import, the values appear to be truncated, and I receive an error stating that the entry does not match any existing record.

I’m unsure why this is happening, as the character limit on the Easy Import seems to be shorter than the actual field length defined on the target table, which prevents valid matches. Is there a way I can change this? 

 

-Apologies if this is posted in the wrong place.

1 ACCEPTED SOLUTION

@TomDickson 

1. Yes, you need to create that system property if it doesn't already exist.

2. Increasing the field length on the staging table will work as expected. However, this is a workaround rather than a permanent solution. If you're confident that the character length will not exceed 150 in the future, you can proceed with the second approach—modifying the field length directly on the staging table.

Regards,

Siva 

View solution in original post

6 REPLIES 6

@J Siva Perfect, thank you for this. I have created the system property, and it is working across multiple tables which I've tested it on. Really appreciate the help.

@TomDickson  Glad it helped.