Update account id attribute via csv file in prod

[NishkalaPuli]

Hi,

After deploying the app and running recon, we have got approx 1 lakh accounts. We now have to update the accountId attribute for each of the account via a csv upload option. The csv has 2 columns (accountname,accountid)

When I did this in preprod, it created a new account and suspended the previous existing account.

we reconcile only firstname, lastname and email. accountId does not get stored anywhere in the target.

can anybody tell me the process to upload the accounts carefully via csv ?

Thanks

[naveenss]

Hi @NishkalaPuli  while uploading the accounts, keep the configurations like below

Please see the sample csv attached. 

Note: perform the operations in batches. For example, test it with 10 accounts first, validate if all the data is correct and then perform for all. 

Let me know in case of any questions. 

[rushikeshvartak]

• If account id is stored in accounts custom property or name you can move using enhanced query it will be faster
• select accountkey as accounts__primarykey,customproperty1 as accounts__accountid from accounts where endpointkey=1 and status=1 and accountid is null