CSV import for onboarding

[ajkiessl]

Our initial onboarding will have something like 67 Units and 120+ GUIUsers. We have this data in a CSV. We could write a script that can parse this CSV and create GUIUsers and Units and link them up in the database.

[ajkiessl]

Here is the CSV in OneDrive: https://pennstateoffice365.sharepoint.com/:f:/r/sites/SoftwareDevelopmentTeam-DevTeam/Shared%20Documents/Dev%20Team/PDF%20Remediation%20Tool?csf=1&web=1&e=ue0ind

[jrpatterson]

My team can either drop in the file into the pod so it can be loaded or if you want to load it locally and give us the dump file we can move it into the db:

mysqldump -u [username] -p [database_name] [table_name] > [output_file].sql

[ajkiessl]

Ok thanks, I think to avoid db data conflicts it would be best to drop the file into the pod and run the script. We'll need to remember to delete the file after the script is run.