Changes between Version 11 and Version 12 of HowToUploadData

Timestamp:

06/10/09 13:58:14 (4 years ago)

Author:

halleb3@…

Comment:

--

HowToUploadData

@@ -7 +7 @@
 All uploaded data will initially be private. They may then be published once they are in My Samples. You are encouraged to check your uploaded data before making publishing it, as once it is published it cannot be edited or deleted, except by the system administrator.
 
+== 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.
+
+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. '''ValhallaComplexData.xls'''
+
 == 1. Upload your samples == #Samples
 
-First you need to prepare a sample upload spreadsheet in .xls format. [attachment:ExampleSheet_samples.xls Example]
- * Be sure your data follows the requirements for [wiki:Sample samples]
- * [wiki:SampleObject Detailed description of sample attributes]
+First you need to prepare a sample upload spreadsheet in .xls format. An upload spreadsheet 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.[attachment:ExampleSheet_samples.xls Example]
+
+ * What type of data must/can be included with your [wiki:Sample samples].
+ * Detailed descriptions of [wiki:SampleObject sample attributes].
  * [wiki:UploadHeaders#Samples List of accepted headers]
 
 Now you can upload the spreadsheet.
  1. Log in to MetPetDB.
- 2. Navigate to '''My Samples'''.
- 3. Click '''Upload Data''' (top-right of the page).
- 4. Select the '''Samples''' radio button.
- 5. Choose your spreadsheet.
- 6. Click '''Upload'''. This will tell you if there are errors with your data, and how many samples will be added to MetPetDB. If you have an error, edit and save your spreadsheet, and re-upload.
- 7. Once you have no errors, you are ready to submit your data to MetPetDB. Click '''Submit Data'''.
- 8. Navigate to '''My Samples''' to see that your samples have uploaded.
+ 2. Click '''Upload Data''' (on the menu bar).
+ 3. Select the '''Samples''' radio button.
+ 4. Choose your spreadsheet by clicking '''browse'''.
+ 5. Click '''Upload'''. This will tell you if there are errors with your data, and how many samples will be added to MetPetDB. If you have an error, edit and save your spreadsheet, and re-upload.
+ 6. Once you have no errors, you are ready to submit your data to MetPetDB. Click '''Submit Data'''.
+ 7. Navigate to '''My Samples''' to see that your samples have uploaded. Or, alternatively, find your new samples with a search.
 
 
 == 2. Upload your images == #Images
 
-Image upload is performed by compressing a folder containing the images ''plus'' a metadata spreadsheet. [wiki:Image Images] are referenced to a sample number and a [wiki:Subsample subsample], which are required. ''Note: The sample must be uploaded/added first, before images can be uploaded.''
+Image upload is performed by compressing a folder containing the images ''plus'' a metadata spreadsheet. [wiki:Image Images] are referenced to a sample number which is required and possibly to a [wiki:Subsample subsample], which is not required. ''Note: The sample must be uploaded/added first, before images can be uploaded.''
 
 
@@ -33 +39 @@
 === Prepare Images Spreadsheet ===
 
-The image upload spreadsheet must be titled “image_upload.xls”. Be sure the image data are on the first worksheet of the upload spreadsheet. 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. For an example see this [attachment:image_upload.2.xls Example 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:image_upload.2.xls Example Spreadsheet].
 
  * Be sure your data follows the requirements for [wiki:Image images].
- * [wiki:ImageObject Detailed description of image attributes]
+ * Detailed descriptions of [wiki:ImageObject image attributes].
  * [wiki:UploadHeaders#Images List of accepted headers]
 
-=== Prepare Zip Folder ===
+=== Prepare Zip File ===
 
 [attachment:ExampleImages.zip Example Zip Folder]
 
- * The compressed folder must not contain subdirectories.
- * All image files must have unique file names that are also unique to their respective subsample's list of image files. 
+ * Compress the image folder with the image upload metadata spreadsheet.
+ * All image files must have unique file names for their particular sample.
+ * The same image file may be uploaded to more then one sample (e.g. a map with multiple sample locations).
  * Filenames should be cataloged in the accompanying image upload spreadsheet. 
  * Acceptable image formats are: .jpg , .gif , .tif , and .png.