If you wish to preserve the formatting of an address through an import you will want to:
- Set the Destination - Address - Quality
- Set the Value - Unverified: Skip Validation
This will set a Quality on the address to be 1. Addresses that have been validated against the USPS database get quality of 0.
When an address is imported and Address - Quality is not mapped, the address will import with a Quality of 2. Addresses with a Quality of 2 will run through the address standardization process that runs nightly or on-demand administratively.
The Preserve formatting check box is a way to set an address to a quality of 1, so it does not run through the address standardization process, but can also be differentiated between addresses that have. You will not see it stay checked for addresses - This is by design. If an address is going to be updated for any reason the checkbox needs to be rechecked to indicate the update needs to be preserved as well. The address verification happens every time an address is updated/created.
The Preserve formatting check box is a way to set an address to a quality of 1, so it does not run through the address standardization process but can also be differentiated between addresses that have.
You will not see it stay checked for addresses - This is by design. If an address is going to be updated for any reason, the checkbox needs to be re-checked to indicate the update needs to be preserved. The address verification happens every time an address is updated/created.
Addresses should only be updated if the update is to the same address, such as a correction to the address. If you were adding a new address to the record, you would not want to change an existing address to that new address but create a new one.
You can always filter/export on quality in a query.
