Home | Uploading | Viewing Data | Search | Making Public | Lists | Sample Attributes | Chemical Analysis Attributes | Image Attributes | XML Output |  To MetPetDB

---

Uploading Data

• Dowloadable Video Tutorials
• Download a .pdf about bulk uploading your data. Note: this is under construction. This wiki is the best resource.

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.

All uploaded data will initially be private. They may then be 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.

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. ExampleUploadSheet.xls.

1. Upload your samples

Watch the downloadable Video Tutorial.

First you need to prepare a sample upload worksheet in .xls format (download an example). An upload worksheet contains data arranged in columns, each with an 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 here, but we encourage you to be thorough to maintain a database that is as versatile as possible.

• What types of data must/can be included with your samples.
  • Lists of set data types:
    • Regions
    • Rock Types
    • Metamorphic Grades
    • Minerals
    • Non-numeric abbreviations for mineral modes
• Detailed descriptions of sample attributes.
• Tips on Locating your Samples (finding Latitudes and Longitudes).
• 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).
2. Log in to MetPetDB.
3. Click Upload Data (on the page menu bar).
4. Select the Samples radio button.
5. Choose your spreadsheet by clicking browse.
6. Click Upload. This will tell you if there are errors with your data, and how many samples will be added to MetPetDB.
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.

2. Upload your images

Watch the downloadable Video Tutorial. Video is outdated - Images now uploaded in 2 steps (see below).

Image upload is performed by uploading a metadata spreadsheet plus a compressed group of images (the image archive.zip). Images are referenced to a sample number which is required and possibly to a subsample, which is not required. Note: The sample must be uploaded/added first, before images can be uploaded.

Prepare Images

• The same image file may be uploaded to more than 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.
• The current size limit is 50 megabytes per image.
  • Images may be included in subdirectories/subfolders within the image archive.zip. This requires that the image upload spreadsheet contains the path information for the images (e.g. [subfolder name]/image.png). See below for how to prepare the image upload spreadsheet.

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 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 (download an example).

• Be sure your data follows the requirements for images.
• Lists of set data types:
  • Subsample Types
  • Image Types
• Detailed descriptions of image attributes.
• List of accepted headers.
• Be sure the image worksheet is on the top of the workbook (drag tab to the far left).
• Save the file.

Prepare Archive (.zip) File

Download an example archive.zip .

1. Select all of the images and subfolders to compress.
2. Compress/create the Archive (.zip).

• If you have archiving software, this is commonly done (built into windows and in Mac OSX) by selecting/highlighting the files to be archived, right-clicking on one of them, and choosing "create archive of...".
• If you compress a folder as opposed to the image files themselves, the images must contain [image folder name]/ as the beginning of their path within the image upload spreadsheet (the image file location is referenced to the top of the archive and not to directories within).

Upload Image Spreadsheet and Archive.zip

1. Log in to MetPetDB.
2. Click Upload Data (on the page menu bar).
3. Select the Images radio button.
4. Choose your image upload spreadsheet (.xls) by clicking browse.
5. Click Upload. This will tell you if there are errors with your metadata, and how many images will be added to MetPetDB.
6. 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, and re-upload.
7. If you have no errors and all of your headers are matched by MetPetDB, you are ready to upload the image archive.zip to MetPetDB. Click browse.
8. Find the image archive.zip and click Upload. If all of the expected images are successully added, you will receive a message to this effect. Otherwise you will receive a message with which images were excluded/missing and were not uploaded.
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.

3. Upload your chemical analyses

Watch the downloadable Video Tutorial.

First you need to prepare a chemical analyses upload worksheet in .xls format (download an example).

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

• Be sure your data follows the requirements for chemical analyses.
  • Lists of set data types:
    • Subsample Types
    • Minerals
    • Elements
    • Oxides
    • Non-numeric abbreviations for measurements
• Detailed description of chemical analysis attributes.
• List of accepted headers.
• If you intend to include a reference image, it must be uploaded first. See "How to Upload Images".
• Please note that chemical analyses must be in weight percent or ppm.

Now you can upload your chemical analyses.

1. Save the excel file with your chemical analyses worksheet on top (the farthest tab to the left).
2. Log in to MetPetDB.
3. Click Upload Data (on the page menu bar).
4. Select the Chemical Analyses radio button.
5. Choose your spreadsheet by clicking browse.
6. Click Upload. This will tell you if there are errors with your data, and how many analyses will be added to MetPetDB.
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.

Example Spreadsheets

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.

---

Home | Uploading | Viewing Data | Search | Making Public | Lists | Sample Attributes | Chemical Analysis Attributes | Image Attributes | XML Output |  To MetPetDB