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?

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