ForumsMessage Boards
Customer Emails
Amanda Rose, modified 3 Years ago.
Customer Emails
Post Date: 10/1/20 (Silver, 51 Posts) Recent PostsWe want to bulk load some data to add to our customer records, and I am considering using the Business Relation Excel Integration load file
The fields that we want to populate are:
ad_mstr.ad_email and ad_mstr.ad_email2
contact.contactEmail
In the BR Excel Integration load file the following email columns are present:
tAddress.AddressEMail
tContact.ContactEmail
If I simply add a new column to the Business relation load file for tAddress.AddressEMail2, with the email be added to ad_mstr.ad_email2?
Han Yun, modified 5 Years ago.
Re: Customer Emails
Post Date: 10/19/20 (Silver, 34 Posts) Recent PostsHi Amanda,
The Address table only has one Address Email, you can not update the admstr.ademail2 from Business Relation Excel Integration.
Amanda Rose, modified 5 Years ago.
Re: Customer Emails
Post Date: 10/20/20 (Silver, 51 Posts) Recent PostsHi, Yun, we are using 2015EE and the Database Definitions document has both email fields in ad_mstr. The tabel "Address" only has AddressEMail, but that does not seem to be the table updated with BR Excel Integration
Han Yun, modified 5 Years ago.
Re: Customer Emails
Post Date: 10/25/20 (Silver, 34 Posts) Recent PostsHi Amanda,
The BR Excel Integration can only load on Address Email, you could raise an Enhancement request for that.
Message place holder