Card Import Update not Removing Existing Data

Question

I'm trying to use the import assistant to update the 3 Custom Fields in existing Card records (both Customers and Suppliers in separate CSV file imports). I'm matching cards using their Record ID (obtained from previous exports). Some cards have existing data in the Custom Fields that need to be removed while others just need to be updated.

After the imports I find that that those fields that needed updating were updated successfully but where there is existing data that needed to be removed, i.e. the corresponding column of the import file was left empty, the existing data is not removed. No errors were reported.

davidl50 · Accepted Answer

Thanks Gavin.&nbsp; I found a workaround but updating the fields with a space.

gavin12345 · Answer

Hi&nbsp;DavidL50&nbsp;&nbsp;This is a 'quirk' in MYOB's importing that has been around since year dot. You can replace a field entry with a new entry, however cannot clear an existing entry.&nbsp;RegardsGavin&nbsp;

Forum Discussion

Card Import Update not Removing Existing Data

2 Replies

Related content

Removing Online Payments

Importing Invoices

Importing issue

Update existing cards with new salesperson

Entitlement Cap Removal

Importing bank statements

Importing failing

Import