Start a new topic

Importing zeroes into an action attribute

I've set up Importomatic to import some action attributes, one of which is a number field. However I find that if the number I'm importing is 0, it gets dropped.


I've attached a copy of the Excel file I'm importing from (which shows the zero) and the action that gets created (which doesn't).


I've tried reformatting the field in Excel as text instead of a number and that made no difference. Any ideas if there is a way I can ensure that it will import the zeroes?

1 Comment

Never mind - I've just realised this is a problem with Raiser's Edge and not ImportOmatic!


"Unfortunately, this field can't have 0 entered as a value however you can use the Comments field instead which will store 0 as a value."


From https://kb.blackbaud.com/articles/Article/64329

Login or Signup to post a comment