Upload Data: Difference between revisions

From Golden Retriever Wiki

(Created page with "For large amounts of data it is sometimes advantageous to download your data for editing in a spreadsheet program (on a computer) and then uploading the edited records into th...")
 
No edit summary
Line 6: Line 6:
#Review data and make necessary changes.
#Review data and make necessary changes.
#Save file in a <code>.csv</code> with an easy to remember file name
#Save file in a <code>.csv</code> with an easy to remember file name
#Back in the '''Admiin Portal''' select Database Modifications.[[File:Modifications1.png|thumb|none]]
#Back in the '''Admin Portal''' select Database Modifications.[[File:Modifications1.png|thumb|none]]
#Select the database to upload to .
#Select the database to upload to .
#Select the modified <code>.csv</code> file.[[File:Modifications2.png|thumb|none]]
#Select the modified <code>.csv</code> file.[[File:Modifications2.png|thumb|none]]

Revision as of 15:45, 17 April 2020

For large amounts of data it is sometimes advantageous to download your data for editing in a spreadsheet program (on a computer) and then uploading the edited records into the database. The Uploads→Database Modifications option allows you to upload changes to your database.

This module can seriously mess up your data. You take on all risk by utilizing this module. The Golden Retriever team will not be responsible if the data you upload detrimentally effects your users. However, the Golden Retriever team will assist you in anyway we can if something should go wrong. We advise you to download a copy of all data in the selected database prior to making any changes with this module. See Downloading Records in CSV File for directions.

Steps

  1. Download and backup a copy of your database from the Admin Portal.
  2. Open the .csv file in your spreadsheet program (LibreOffice, MS Office, etc.).
  3. Review data and make necessary changes.
  4. Save file in a .csv with an easy to remember file name
  5. Back in the Admin Portal select Database Modifications.
  6. Select the database to upload to .
  7. Select the modified .csv file.
  8. Click Update Database to upload your changes.


It is also possible to insert new records into your database. To do this simply ensure that the record number field is empty.

NOTE: This module can seriously mess up your data. You take on all risk by utilizing this module. The Golden Retriever team will not be responsible if the data you upload detrimentally effects your users. However, the Golden Retriever team will assist you in anyway we can if something should go wrong. We advise you to download a copy of all data in the selected database prior to making any changes with this module.'