In company C we have 3400 customers.
Each customer needs to have a new secondary address added.
Same address information for all.
1. Is inserting into tciaddr and using the new addrkey then inserting into tarCustAddr (via direct database calls) an option?
2. Is there a way using dataporter that would be easier than prior approach?
3. Something else better than either option?
4. Bonus question - can the contact information be added programmatically as well?
Thank you.
Go to System Manager Maintenance and use Assisted Company Setup with "Other" "Any" as the source system. When you choose Customer and click the Migrate button, one of the staging tables is StgCustAddr. If you enter the customer ID, address Id etc. here, it should add these addresses to the customers for you. Same with Contact (StgContact).
I created a new customer address, with an associated contact in SOA demo company. In my example I actually added a contact and an address in the StgCustAddr table - it is shown below.
Darrick
Hi Darrick and thanks.
We've not used Assisted Company Setup before.
Following your instruction got "stuck" as can't find the "migrate" button.'
We are in version 2017.
Thanks in advance.
Set Source System to Other Any:
Have I missed something? Yours shows a migration link, mine does not.
Do I have to be in SOA?
