Why does only 40 characters get imported when using an import set?

senon
Tera Sage

I am trying to import data from an Excel file using an import set in sn_customerservice_case.

I'm importing text into the subject and description fields in CASE, but the text that is over 100 characters long is only importing 40 characters.

What is the cause of this?

Best regards

senon

1 ACCEPTED SOLUTION

 

This property is not present by default you need to add manually.

Also as mentioned in ref thread, take a look in source & target table max length.

View solution in original post

8 REPLIES 8

BryanS413339635
Tera Guru

The max length set on some import set table string fields is 40 characters. This can be changed by going to the import set>import set rows>right click on the field, configure dictionary, and then modify the max length to what you need.

Tell me more about it.

I got to the Import Set > Import Set Rows.

I right clicked on the field, but the configure dictionary is not showing up.

Am I doing the right thing?

find_real_file.png

 

Hi

Open that import set rows record. Then right click on relevant field and you will find Configure dictionary option.

 

find_real_file.png

Regards
Deepen shah
aavenir.com

Hi,Deepen shah

Thanks you, I was able to find the Configure dictionary.
But the max length of the target field was 160 and 4000.

It's not 40 characters. I still don't know why I can only import 40 characters.

 

senon