QuickBooks Import-- Addresses

Problem

When importing vendors from QuickBooks, the addresses display with non-printing characters instead of carriage returns.

Caught By

Turtlesoft testing.

Workaround

None in 4.1 or earlier.

Solution

This problem will not occur when using Goldenseal accounting software version 4.2 or later.

We have modified the Replace All command, so you can fix the bad data from earlier versions. Follow these steps:

  1. Choose Material Suppliers from the Accounts menu.
  2. Locate a record that shows the non-printing characters (probably displayed as squares).
  3. Select one of the non-printing characters (click and drag through it, so it is highlighted).
  4. Choose Copy from the Edit menu.
  5. Choose Replace All from the Edit menu.
  6. Click on the Replace popup field, and choose Text in Field.
  7. Click on Address in the list of Fields to Replace.
  8. Click in the Find Text field.
  9. Choose Paste from the Edit menu. It should put in the non-printing character.
  10. Click in the Replace With field.
  11. Type ^p (for the ^ character, hold down the Shift key and type a 6).
  12. Click OK.
  13. Goldenseal will fix the Address field in all found records.

Technical Details

Programmer note-- code changes in CQuickbooksTranslator::AdjustImportValue and DB_PersistentObject::ReplaceFieldText