newdevs:code:import_csv_into_db
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
newdevs:code:import_csv_into_db [2023/02/27 13:26] – [Importing the Data] tlittle | newdevs:code:import_csv_into_db [2023/02/27 13:28] – [Finessing the Data Prior to Import] tlittle | ||
---|---|---|---|
Line 7: | Line 7: | ||
**Notes:** | **Notes:** | ||
* If the table you're wanting to insert into uses an org, you'll want to edit your CSV file first to use the org IDs from Concerto. | * If the table you're wanting to insert into uses an org, you'll want to edit your CSV file first to use the org IDs from Concerto. | ||
- | * Don't include the column for ID from your production data--delete that. | + | * Don't include the column for ID from your production data. |
* If there are duplicate key constraints, | * If there are duplicate key constraints, | ||
Line 14: | Line 14: | ||
This assumes that Column A is the no-dupe column (name, in this case) and Column B is the org. So basically, count the number of times that the name in A2 appears with the same org that's in B2. Then if we fill that down the entire column, if you get anything above a 1 you have a dupe that you can filter for and remove. | This assumes that Column A is the no-dupe column (name, in this case) and Column B is the org. So basically, count the number of times that the name in A2 appears with the same org that's in B2. Then if we fill that down the entire column, if you get anything above a 1 you have a dupe that you can filter for and remove. | ||
+ | **TIP:** If you're not sure if your table includes a uniqueness constraint, here's a grep of Evergreen for the word " | ||
===== Importing the Data ===== | ===== Importing the Data ===== | ||
newdevs/code/import_csv_into_db.txt · Last modified: 2024/06/13 10:52 by sleary