Upload Data - Revision history

Jeff at 15:14, 17 February 2022

2022-02-17T15:14:30Z

← Older revision		Revision as of 15:14, 17 February 2022
Line 8:		Line 8:
	#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).		#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).
	#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).		#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).
	#Delete all columns which you do not wish to update <strong>with the exception of the ''RecordNo'' column</strong>. Without the ''RecordNo'' column all rows will be inserted into the database as '''new''' records.		#Delete all columns which you do not wish to update <strong>with the exception of the ''RecordNo'' column</strong>. Without the ''RecordNo'' column all rows will be inserted into the database as '''new''' records. <strong>Note: The <i>RecordNo</i> column must be included - without values records will be inserted as new records; with values the records will be updated with the modified data.</strong>
	#Review your data and make necessary changes.		#Review your data and make necessary changes.
	#Save file in a <code>.csv</code> format with an easy to remember file name		#Save file in a <code>.csv</code> format with an easy to remember file name

Jeff at 21:10, 17 June 2020

2020-06-17T21:10:05Z

← Older revision		Revision as of 21:10, 17 June 2020
Line 1:		Line 1:
			[[Main_Page\|Main Page]]
	<strong>NOTE: This module is deactivated by default due to its potential for permanent damage to your data. Please contact us at ''info@goldenretrieverapp.com'' if you would like to discuss activating this module for your account or any of your users.</strong>		<strong>NOTE: This module is deactivated by default due to its potential for permanent damage to your data. Please contact us at ''info@goldenretrieverapp.com'' if you would like to discuss activating this module for your account or any of your users.</strong>
	[[File:Uploads.png\|thumb\|none]]		[[File:Uploads.png\|thumb\|none]]

Jeff at 18:05, 17 April 2020

2020-04-17T18:05:50Z

← Older revision		Revision as of 18:05, 17 April 2020
Line 1:		Line 1:
	<strong>NOTE: This module is deactivated by default due to its potential for permanent damage to your data. Please contact us at ''info@goldenretrieverapp.com'' if you would like to discuss activating this module for your account or any of your users.</strong>		<strong>NOTE: This module is deactivated by default due to its potential for permanent damage to your data. Please contact us at ''info@goldenretrieverapp.com'' if you would like to discuss activating this module for your account or any of your users.</strong>
			[[File:Uploads.png\|thumb\|none]]
	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.		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 [https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Downloading_Records_in_CSV_File Downloading Records in CSV File] for directions.		''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 [https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Downloading_Records_in_CSV_File Downloading Records in CSV File] for directions.
	<strong>Steps</strong>		<strong>Steps</strong>
	#From the '''Admin Portal''' download and backup a copy of your database on your computer.~~[[File:Uploads.png\|thumb\|none]]~~		#From the '''Admin Portal''' download and backup a copy of your database on your computer.
	#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).		#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).
	#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).		#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).

Jeff at 18:05, 17 April 2020

2020-04-17T18:05:02Z

← Older revision		Revision as of 18:05, 17 April 2020
Line 3:		Line 3:
	''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 [https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Downloading_Records_in_CSV_File Downloading Records in CSV File] for directions.		''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 [https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Downloading_Records_in_CSV_File Downloading Records in CSV File] for directions.
	<strong>Steps</strong>		<strong>Steps</strong>
	#From the '''Admin Portal''' download and backup a copy of your database on your computer.		#From the '''Admin Portal''' download and backup a copy of your database on your computer.[[File:Uploads.png\|thumb\|none]]
	[[File:Uploads.png\|thumb\|none]]
	#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).		#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).
	#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).		#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).

Jeff at 18:04, 17 April 2020

2020-04-17T18:04:47Z

← Older revision		Revision as of 18:04, 17 April 2020
Line 4:		Line 4:
	<strong>Steps</strong>		<strong>Steps</strong>
	#From the '''Admin Portal''' download and backup a copy of your database on your computer.		#From the '''Admin Portal''' download and backup a copy of your database on your computer.
	[[File:~~Uploades~~.png\|thumb\|none]]		[[File:Uploads.png\|thumb\|none]]
	#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).		#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).
	#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).		#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).

Jeff at 18:04, 17 April 2020

2020-04-17T18:04:35Z

← Older revision		Revision as of 18:04, 17 April 2020
Line 4:		Line 4:
	<strong>Steps</strong>		<strong>Steps</strong>
	#From the '''Admin Portal''' download and backup a copy of your database on your computer.		#From the '''Admin Portal''' download and backup a copy of your database on your computer.
	[[File:Uploades.png\|none~~\|thumb~~]]		[[File:Uploades.png\|thumb\|none]]
	#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).		#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).
	#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).		#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).

Jeff at 18:04, 17 April 2020

2020-04-17T18:04:14Z

← Older revision		Revision as of 18:04, 17 April 2020
Line 4:		Line 4:
	<strong>Steps</strong>		<strong>Steps</strong>
	#From the '''Admin Portal''' download and backup a copy of your database on your computer.		#From the '''Admin Portal''' download and backup a copy of your database on your computer.
			[[File:Uploades.png\|none\|thumb]]
	#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).		#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).
	#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).		#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).

Jeff at 18:02, 17 April 2020

2020-04-17T18:02:02Z

← Older revision		Revision as of 18:02, 17 April 2020
Line 1:		Line 1:
			<strong>NOTE: This module is deactivated by default due to its potential for permanent damage to your data. Please contact us at ''info@goldenretrieverapp.com'' if you would like to discuss activating this module for your account or any of your users.</strong>
	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.		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 [https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Downloading_Records_in_CSV_File Downloading Records in CSV File] for directions.		''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 [https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Downloading_Records_in_CSV_File Downloading Records in CSV File] for directions.
	<strong>Steps</strong>		<strong>Steps</strong>
	#~~Download and backup a copy of your database from~~ the '''Admin Portal'''.		#From the '''Admin Portal''' download and backup a copy of your database on your computer.
	#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).		#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).
	#Review data and make necessary changes.		#Delete the ''Date'' column as Excel will change the date format (which will cause data loss and break functionality in the Admin Portal).
	#Save file in a <code>.csv</code> with an easy to remember file name		#Delete all columns which you do not wish to update <strong>with the exception of the ''RecordNo'' column</strong>. Without the ''RecordNo'' column all rows will be inserted into the database as '''new''' records.
			#Review your data and make necessary changes.
			#Save file in a <code>.csv</code> format with an easy to remember file name
	#Back in the '''Admin 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 .
Line 11:		Line 14:
	#Click <code>Update Database</code> to upload your changes.		#Click <code>Update Database</code> to upload your changes.
	<br>		<br>
	It is also possible to insert new records into your database. To do this simply ensure that the ''record number'' field is empty.		As mentioned above in step 4, it is also possible to insert new records into your database. To do this simply ensure that the ''record number'' field is empty.

	''<strong>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.</strong>'''		''<strong>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.</strong>'''

Dave at 15:45, 17 April 2020

2020-04-17T15:45:38Z

← Older revision		Revision as of 15:45, 17 April 2020
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]]

Jeff: 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..."

2020-04-17T15:40:06Z

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..."

New page

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 [https://wiki.goldenretrieverapp.com/index.php?title=Data_Management#Downloading_Records_in_CSV_File Downloading Records in CSV File] for directions.
Steps
#Download and backup a copy of your database from the '''Admin Portal'''.
#Open the <code>.csv</code> file in your spreadsheet program (LibreOffice, MS Office, etc.).
#Review data and make necessary changes.
#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]]
#Select the database to upload to .
#Select the modified <code>.csv</code> file.[[File:Modifications2.png|thumb|none]]
#Click <code>Update Database</code> 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.'''