SAINT setting to treat empty cells as empty | Community
Skip to main content
AndreasDi1
Level 7
Dec 9, 2012 12:33 PM UTC
New

SAINT setting to treat empty cells as empty

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 replies

    jmborange
    jmborange
    New Participant
    Mar 19, 2013 2:10 AM UTC

    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".

    Translate
    adamhaining
    adamhaining
    Level 3
    Dec 12, 2012 11:13 PM UTC

    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).

    Translate
    AndreasDi1Author
    Level 7
    Dec 12, 2012 2:32 PM UTC

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

    Translate
    benjamingaines2
    benjamingaines2
    Employee
    Dec 12, 2012 1:54 PM UTC

    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!

    Translate
    nic_cm
    nic_cm
    Level 4
    Dec 11, 2012 3:19 AM UTC

    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.

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...