Long Name truncated

[Marco Pasqua]

Hi,

i want to put long name into Name field (contract table). I've changed the max lenght value to 1.000 but when i load data through excel the name is getting truncated to 40 characters or something like that.

What should i check/fix?

thank you in advance

Marco

[Musab Rasheed]

Hi,

Show dictionary of field please.?

Regards

[sonali panda1 · Accepted solution]

If you had tried to import that excel earlier before updating the field size or tried with a trial data, then the staging table for that field would have got the size of 40 or whatever it was loaded. You need to update the staging table field size to 1000 to allow to import.

[panda1]

com.glide.loader.verify_target_field_size 

check whether there is this system attribute

Set true

If not, create this system property

[Community Alums]

Hi @Marco Pasqua ,

Try to change the max length to 256 first and then try to put it to a bigger value after.

It seems that if you don't put it to 256 first, the change will not occur at the database end (which you cannot change yourself).

As changing from 40 chars to say 400 requires a change to the field data type.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep