MiLa's avatar
Former Staff
8 years ago

Import/Export Assistant: Update enabled fields to be disabled by importing blank record

In AR 2016, when exporting data, normally for boolean fields it uses X to denote Y or Enabled, and {blank} for N or Disabled.


In this case, I attempted to update a large number of item's Use Desc. On Invoice field, from Enabled to Disabled, by using deleting the X and leaving the field {blank}.

The log did say all transactions imported, but nothing actually was. I tested the same thing in clearwater which only has a few items which worked fine.


Changing the field from {blank} to N worked flawlessly the next time I imported the data.


So I suggest having exported and imported boolean fields standardised to Y or N as they do work.


"Proper Value for Boolean Fields for Import and Export"

1 Comment

  • Status changed:

    Thank you for the idea. Unfortunately, this request has had no support from the community since it was submitted, so we are moving this idea to the Archived status. For more information on Idea Statuses, please read this article: Changes to our Idea Exchange pages