- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-01-2025 08:57 PM
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.
Solved! Go to Solution.
- Labels:
-
Data Foundations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-04-2025 05:30 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-04-2025 08:44 PM
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-04-2025 08:46 PM
@TomDickson Glad it helped.