For a few years, we have been exporting our Adagio Customer database and importing it into Purolator to create a database of our customers to ship to. Recently Purolator updated their system and importing has become more difficult. Adagio AR uses Address Line 1, 2 & 3, however, Purolator wants to import it as Street#, Street# Suffix, Street Name, Street Type, Street Direction, all as separate fields. It would take an exorbitant amount of time to rearrange all of our customers addresses to make this work and even more difficult it would be to keep our customer database in Adagio consistent going forward so that we can import it into Purolator. Any suggestions/ideas on a better way to accomplish this? We don't have time to maintain 2 databases. Thanks.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario