12-28-2022 10:06 AM
We have thousands of records that have email addresses in the location but not in the customer profile. Who has the authority to copy data from one database table to another?
Solved! Go to Solution.
12-31-2022 01:13 PM
Yeah, currently the best way to do a bulk database edit would be to have the Success Manager submit a data task to the data engineers. I’d recommend a clear and detailed request along with an excel sheet with the necessary information. So if you want to copy email addresses from locations to customers, I would recommend exporting a list of the location IDs with associated email addresses. This can be pulled from a custom report on the Locations dataset. The request can then be something like “copy the email addresses from these locations and if the email address doesn’t already exist, paste into the customer ID on which this location is attached.
Make sure you only include email addresses you really want copied. For example, you may not want to paste tenant email addresses on the customer/bill to record.
For transparency, data task requests can take a few weeks to process once received.
12-29-2022 09:06 AM
You would have to ask your CSM... they should be able to set that up for you
12-30-2022 06:12 AM
My CSM only ever refers me to the community. Not really helpful, but we'll try again.
12-31-2022 01:13 PM
Yeah, currently the best way to do a bulk database edit would be to have the Success Manager submit a data task to the data engineers. I’d recommend a clear and detailed request along with an excel sheet with the necessary information. So if you want to copy email addresses from locations to customers, I would recommend exporting a list of the location IDs with associated email addresses. This can be pulled from a custom report on the Locations dataset. The request can then be something like “copy the email addresses from these locations and if the email address doesn’t already exist, paste into the customer ID on which this location is attached.
Make sure you only include email addresses you really want copied. For example, you may not want to paste tenant email addresses on the customer/bill to record.
For transparency, data task requests can take a few weeks to process once received.