Changes between Version 37 and Version 38 of HowToUploadData

Timestamp:

04/13/11 10:09:35 (2 years ago)

Author:

halleb3@…

Comment:

--

HowToUploadData

@@ -4 +4 @@
 = Uploading Data =
 
- * Dowloadable [wiki:VideoTutorials Video Tutorials]
+ * Downloadable [wiki:VideoTutorials Video Tutorials]
 
- * [http://metpetdb.rpi.edu/metpetweb/help/HowToUploadData.html]
-  '''Note: this is under construction. This wiki is the best resource.'''
+ * Downloadable Bulk Upload [wiki:HowToUploadData#Examples Data Templates]
 
-There are 3 types of bulk uploads: Sample, Chemical Analysis, and Images. These must be done from a Microsoft Excel spreadsheet (.xls file). Only the first worksheet in a .xls workbook file (first tab at bottom left) will be uploaded, so be certain that the first sheet in the saved .xls file you are uploading contains the data you want uploaded for the correct type of upload.
+There are 3 types of bulk uploads: Sample, Chemical Analysis, and Images. These must be done from Microsoft Excel spreadsheets (.xls file). Only the first worksheet in a .xls workbook file (first tab at bottom left) will be uploaded, so be certain that the first sheet in the saved .xls file you are uploading contains the data you want uploaded for the correct type of upload.
 
 All uploaded data will initially be private. They may then be [wiki:HowToMakePublic made public] once they are in MetPetDB. You are encouraged to check your uploaded data before making it public, as once it is public it is viewable and downloadable by other MetPetDB members.
@@ -15 +14 @@
 == Upload Tactics ==
 
-MetPetDB recommends preparing '''a single excel file''' with a suite of data you would like to upload (''the alternative would be an individual file for each of samples, chemical analyses, and images'').  The single file should have separate worksheets for samples, chemical analyses, and images, labeled as such.  In this case, on each step of the upload process described below, you may browse for the same file, uploading a re-saved version of the file with the appropriate worksheet as the first (on top).  In microsoft excel, worksheets can be dragged to the top by their tab.
+'''For new users:''' MetPetDB recommends uploading an individual .xls spreadsheet for each of (1) samples, (2) chemical analyses, and (3) images. See the templates attached to this page for annotated examples of how to get started with your own data.
 
-This method allows all data for upload of a suite of samples to MetPetDB to be organized with a single file (apart from the individual image files), e.g. [attachment:ExampleUploadSheet.xls].
+'''For experienced users:''' An alternative approad is to prepare '''a single excel file''' with a suite of data you would like to upload (''as opposed to individual files for each of samples, chemical analyses, and images'').  The single file should have separate worksheets for samples, chemical analyses, and images, labeled as such.  In this case, on each step of the upload process described below, you may browse for the same file, uploading a re-saved version of the file with the appropriate worksheet as the first (on top).  In microsoft excel, worksheets can be dragged to the top by their tab. This method allows all data for upload of a suite of samples to MetPetDB to be organized with a single file (apart from the individual image archive.zip).
 [[BR]][[BR]]
 
@@ -25 +24 @@
 Watch the downloadable [wiki:VideoTutorials Video Tutorial].
 
-First you need to prepare a sample upload worksheet in .xls format ([attachment:ExampleUploadSheet.xls download an example]). An upload worksheet contains data arranged in columns, each with an [wiki:UploadHeaders appropriate header]. The first row is reserved for the column headers. Each additional row should contain data for each sample to be uploaded. Only some fields are required in order to upload your samples, as indicated [wiki:Sample here], but we encourage you to be thorough to maintain a database that is as versatile as possible.
+First you need to prepare a sample upload worksheet in .xls format ([attachment:SampleTemplate.xls download a template]). An upload worksheet contains data arranged in columns, each with an [wiki:UploadHeaders appropriate header]. The first row is reserved for the column headers. Each additional row should contain data for each sample to be uploaded. Only some fields are required in order to upload your samples, as indicated [wiki:Sample here], but we encourage you to be thorough to maintain a database that is as versatile as possible.
 
 
@@ -36 +35 @@
    * [wiki:SampleObject#NonNumerics Non-numeric abbreviations] for mineral modes
  * Detailed descriptions of [wiki:SampleObject sample attributes].
- * Tips on [wiki:LocatingSamples Locating your Samples] (finding Latitudes and Longitudes).
+ * Tips on [wiki:LocatingSamples Locating your Samples] (finding latitudes and longitudes).
  * [wiki:UploadHeaders#Samples List of accepted headers].
 
 Now you can upload the spreadsheet.
- 1. Save the excel file ''with your samples worksheet on top'' (the farthest tab to the left).
+ 1. Save the excel file ''(with your samples worksheet on top''--the farthest tab to the left).
  2. Log in to MetPetDB.
  3. Click '''Upload Data''' (on the page menu bar).
@@ -48 +47 @@
  7. Check to see which headers were matched to MetPetDB. Check if you have any errors by clicking the '''errors''' tab. If you have an error or made a mistake with a header, edit and save your spreadsheet, save it, and re-upload.
  8. If you have no errors and all of your headers are matched by MetPetDB, you are ready to submit your data to MetPetDB. Click '''Submit Data'''.
- 9. Navigate to '''My Samples''' to see that your samples have uploaded. Or, alternatively, find your new samples with a search. In this case it will help to input your screen name as the owner to exclude published samples and the samples of others.
+ 9. Navigate to '''My Samples''' to see that your samples have uploaded. Or, alternatively, find your new samples with a search. In this case it will help to input your user name as the owner to exclude published samples and the samples of others.
 [[BR]]
 
@@ -69 +68 @@
 === Prepare Image Upload Spreadsheet ===
 
-The image upload spreadsheet must have the image data are on the first worksheet. An upload spreadsheet contains data arranged in columns, each with an [wiki:UploadHeaders#Images appropriate header]. The first row is reserved for the column headers. Each additional row should contain data for each image to be uploaded. Only some fields are required in order to upload your images, as indicated below, but we encourage you to be thorough to maintain a database that is as versatile as possible ([attachment:ExampleUploadSheet.xls download an example]).
+The image upload spreadsheet must have the image data are on the first worksheet. An upload spreadsheet contains data arranged in columns, each with an [wiki:UploadHeaders#Images appropriate header]. The first row is reserved for the column headers. Each additional row should contain data for each image to be uploaded. Only some fields are required in order to upload your images, as indicated below, but we encourage you to be thorough to maintain a database that is as versatile as possible ([attachment:ImageTemplate.xls download a template]).
 
  * Be sure your data follows the requirements for [wiki:Image images].
@@ -109 +108 @@
 Watch the downloadable [wiki:VideoTutorials Video Tutorial].
 
-First you need to prepare a chemical analyses upload worksheet in .xls format ([attachment:ExampleUploadSheet.xls download an example]).
+First you need to prepare a chemical analyses upload worksheet in .xls format ([attachment:AnalysisTemplate.xls download a template]).
 
 The first row is reserved for the column headers. The second row is reserved for units (chemical analysis and precision). Each additional row should contain data for each [wiki:ChemicalAnalysis analysis] to be uploaded. Only some fields are required in order to upload your data, but we encourage you to be thorough to maintain a database that is as versatile as possible. 
@@ -139 +138 @@
 
 
-== Example Spreadsheets == #Examples
+== Data Templates == #Examples
 
-Below are some example files that are ready to be uploaded to MetPetDB. If you already have these sample numbers in My samples, you must delete them to test the upload interface.
+Below are templates with example data that are ready to be uploaded to MetPetDB. If you already have these sample numbers in My samples, you must delete them to test the upload interface.
 ----
 [wiki:WikiStart Home] | [wiki:HowToUploadData Uploading] | [wiki:HowToViewData Viewing Data] | [wiki:Search Search] | [wiki:HowToMakePublic Making Public] | [wiki:Lists] | [wiki:SampleObject Sample Attributes] | [wiki:ChemicalAnalysisObject Chemical Analysis Attributes] | [wiki:ImageObject Image Attributes] | [wiki:XMLObject XML Output] | [http://metpetdb.rpi.edu/ To MetPetDB]