• Replies 2 replies
  • Subscribers 338 subscribers
  • Views 33 views
  • Users 0 members are here
Related

Importing constituents with two addresses

Matthew Hodge
$organization

Hi all,

I've got a list of schools to be imported for our Education team, but all the records have two addresses - a physical and a postal address.

Does anybody have anything out there which can do an import with two addresses on it?

 

Cheers,

 

Matt

Parents
  • $organization

    I would approach it as a mini-conversion and import the new constituents via new records into T_CUSTOMER, T_ADDRESS, and TX_CUST_SAL at a minimum. That way you can import as many addresses as you want.

    I don't know of a single program/utility that will do that, but if you're comfortable with SQL, I could share some code that will do it, if you like.

Reply
  • $organization

    I would approach it as a mini-conversion and import the new constituents via new records into T_CUSTOMER, T_ADDRESS, and TX_CUST_SAL at a minimum. That way you can import as many addresses as you want.

    I don't know of a single program/utility that will do that, but if you're comfortable with SQL, I could share some code that will do it, if you like.

Children
No Data