|
To update the records of a table in your database, it is required that the table has a primary key column (the column containing unique id that identifies each record in the table).
- Prepare all the records you would like to update in a CSV file.
Note: Please make sure the data for primary key column in your CSV file matches those unique ids in the original table.
- Login to your One Admin console, click on the CSV Import link, and complete the step 1 (Load CSV) and step 2 (Connect Database).
- When you're in the third step 'Match Column', scroll down to the bottom of the page, and check 'Update records using Primary Key' option.
- Select the primary key field of your existing table from the first drop down list. Then choose which column in your CSV file that matches the primary key field, from the drop down menu next to 'with Column'.
- Click 'Next' to complete the data import.
|
