Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

SAINT setting to treat empty cells as empty

Avatar

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

806 likes

Total Posts

188 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

806 likes

Total Posts

188 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
adierl
Level 10

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

Avatar

Avatar
Boost 50
Level 5
nic_cm
Level 5

Likes

71 likes

Total Posts

57 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 5
nic_cm
Level 5

Likes

71 likes

Total Posts

57 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
nic_cm
Level 5

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.

Avatar

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
Level 8
benjamingaines2
Level 8

Likes

271 likes

Total Posts

874 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
benjamingaines2
Level 8

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!

Avatar

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

806 likes

Total Posts

188 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
adierl
Level 10

Likes

806 likes

Total Posts

188 posts

Correct Reply

0 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
adierl
Level 10

12-12-2012

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

Avatar

Avatar
Boost 50
Level 5
adamhaining
Level 5

Likes

95 likes

Total Posts

51 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Level 5
adamhaining
Level 5

Likes

95 likes

Total Posts

51 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
adamhaining
Level 5

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

Avatar

Avatar
Boost 1
Level 1
jmborange
Level 1

Like

1 like

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
jmborange
Level 1

Like

1 like

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
jmborange
Level 1

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