Field data not completely uploaded using Easy import feature

AstridJ
Tera Guru

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!

1 ACCEPTED SOLUTION

AstridJ
Tera Guru

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.  

View solution in original post

3 REPLIES 3

HrishabhKumar
Kilo Sage

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.

Hi @HrishabhKumar ,

Thanks for your reply. Max length is set on 4000 so that is not causing the issue. 

AstridJ
Tera Guru

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.