1 - Data Migrations Checklist

The following is a semi-profanity-ridden attempt at explaining one way to do data migrations while following best practices. It is rather long and laced with colorful language. If you have read it already, or if you want to avoid the profanity, you can consult the following checklist in the google doc below.

Note that all elements are considered mandatory.

If you're doing data migrations, either use this script developped by Geff (read the readme): https://github.com/SFXD/PSCSV

Or, if you prefer excel, open a blank workbook, Import the source file via data from text/csv, then save it as a both the construction excel, and a NEW csv file after doing your changes in formula columns. That way when you change the source file you can just open the construction book again and resave.