Use this process when you need to correct, replace, or update a large amount of data in a custom table.
Export the existing custom table data as a backup.
- Go to Analytics > Reports > Add new > use a template > and run the report using the custom table's designated report template.
- Tip: add a column for work email, it will help you later.
- Export and save the file.
(Important) Rename the current custom table for distinction.
- Go to System Settings > People's data fields > and rename the table (for example, change Custom table to Custom table (incorrect data)).
Create a new custom table and add the fields (columns) you need in the new table.
- Make sure the structure matches the data you plan to import.
- You can name the table and the fields like they were before.
Archive the old custom table.
- All data stored in the old table will be archived with it.
Import the corrected data into the new custom table.
- Update the exported backup file with the correct data.
- Verify that all columns in the file match the fields in the new custom table.
- Use the Import table data tool to import the file into the new custom table.