- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-10-2024 05:01 AM
Hi,
Are there any data quality tips should we consider upon preparing uploading data using the Easy import feature with an Excel?
Currently experiencing an issue that field data is not completely uploaded. As example the field should contain the text below, but only the first 2 lines are uploaded. Text in red is not uploaded, (no error message either):
1) Runbooks
2) Failover test report
- Failover test report system x
- Tickets failover Network (during changes)
Same kind of text in another field was completely uploaded. So what are we missing?
1) Evidence:
- system x.
- Meeting (minutes, agenda) supplier
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2024 01:17 PM
Update on this issue, the max_length of the target field was correct, however during import the field had a limited length in the staging (import) table causing the cutt-off. Increasing the value at the staging table, solved it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-10-2024 05:31 AM - edited 07-10-2024 05:32 AM
Hi @AstridJ ,
you might wanna check the max_length of the field in which you want to populate this data.
Steps:
- Right click on the field > Configure Dictionary
- check the max length field, and increase it's value as required.
Thanks.
Hope it helps.
If my response turns useful, mark if helpful and accept solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-10-2024 06:06 AM
Hi @HrishabhKumar ,
Thanks for your reply. Max length is set on 4000 so that is not causing the issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-18-2024 01:17 PM
Update on this issue, the max_length of the target field was correct, however during import the field had a limited length in the staging (import) table causing the cutt-off. Increasing the value at the staging table, solved it.