SAINT setting to treat empty cells as empty

adierl

09-12-2012

Would be good to have a setting for SAINT import to treat empty cells as empty and not as "keep old value". Currently you have to overwrite empty strings with "~empty~" to delete values.

5 Comments (5 New)
5 Comments

nic_cm

10-12-2012

I do like it the way it is, although I see benefits in the motion.

 

This should definitely be an option instead of a default setting. I see all sort of legacy processes tied to the current behaviour with lots of SC clients.

benjamingaines2

12-12-2012

My concern with this is simply that things might get overwritten a LOT. But it's a good idea and something I'll pass along to the SAINT development team. Keep the comments coming!

adierl

12-12-2012

Keep the default as it is now, so nothing breaks. Optionally I can intentionally change the handling.

adamhaining

12-12-2012

Yeah I like this one, but maybe have it be a setting that the user can turn on (not something that has to be done by Client Care).

jmborange

18-03-2013

At least there is a workaround with the ~empty~ value. The bigger problem is if you are submitting a value of "0". This will be regarded as "NULL" instead of "0".