Use ImportAction to import records and related records
I am using ImportAction to import a list of registrants and addresses. Each registrant can have a physical address and mailing address. The csv file looks something like:
My tables look like:
The documentation shows how to use relationships for lookups of existing relationships but I'm not certain how to create new ones. During the import process, I would like to create new addresses if the registrant does not exist, or update the addresses if the registrant does exist.
I know I can do this without using ImportAction but I like the ability to map columns during the import process.
Thanks!
firstname,lastname,phys_address,phys_city,phys_state,mail_address_mail_city,mail_state,yobMy tables look like:
firstname,lastname,phys_address_id,mail_address_id,yobThe documentation shows how to use relationships for lookups of existing relationships but I'm not certain how to create new ones. During the import process, I would like to create new addresses if the registrant does not exist, or update the addresses if the registrant does exist.
I know I can do this without using ImportAction but I like the ability to map columns during the import process.
Thanks!
