meta data for this page
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
applications:add [2023/01/12 21:31] – joetulenko | applications:add [2023/02/08 15:54] (current) – joetulenko | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | In this tutorial | + | ====Adding data to ICE-D from the Admin Page==== |
+ | |||
+ | |||
+ | {{ : | ||
+ | |||
+ | |||
+ | In this tutorial | ||
page on the ICE-D website. In the past, we had folks from the community add data directly to the database | page on the ICE-D website. In the past, we had folks from the community add data directly to the database | ||
through SQL clients such as Heidi and Sequel Pro, but users will now be adding data in excel spreadsheet | through SQL clients such as Heidi and Sequel Pro, but users will now be adding data in excel spreadsheet | ||
Line 6: | Line 12: | ||
Before beginning, be sure to contact Greg Balco (balcs@bgc.org) or Joe Tulenko (jtulenko@bgc.org) | Before beginning, be sure to contact Greg Balco (balcs@bgc.org) or Joe Tulenko (jtulenko@bgc.org) | ||
- | and they will get you set up as a standard editor on the ICE-D admin page. | + | and one of us will get you set up as a standard editor on the ICE-D admin page. |
+ | |||
+ | Also see [[applications: | ||
+ | \\ | ||
+ | \\ | ||
---- | ---- | ||
- | **Step 1.** Begin the tutorial by navagating | + | **Step 1.** Begin the tutorial by navigating |
ICE-D website. Use the credentials given to you either by Greg or Joe to log in. You should see a page | ICE-D website. Use the credentials given to you either by Greg or Joe to log in. You should see a page | ||
similar to the one below: | similar to the one below: | ||
+ | |||
+ | {{ : | ||
You will notice there are several links to various ICE-D tables on the left side of the screen. In this | You will notice there are several links to various ICE-D tables on the left side of the screen. In this | ||
- | tutorial, for simplicity, | + | tutorial, for simplicity, |
- | have more columns/ | + | have more columns/ |
only on those that are necessary to calculate simple exposure ages (and make proper table relations; more | only on those that are necessary to calculate simple exposure ages (and make proper table relations; more | ||
on that below). | on that below). | ||
Line 23: | Line 35: | ||
you don’t add column data now, people like me will have to fill in your blanks later. | you don’t add column data now, people like me will have to fill in your blanks later. | ||
+ | \\ | ||
+ | \\ | ||
---- | ---- | ||
Line 32: | Line 46: | ||
Our four most important tables for 10Be simple exposure ages: | Our four most important tables for 10Be simple exposure ages: | ||
- | • REGION | + | **• REGION** |
- | • SITES | + | **• SITES** |
- | • SAMPLES | + | **• SAMPLES** |
- | • BE10 AL26 QUARTZ | + | **• BE10 AL26 QUARTZ** |
are related in the following way: | are related in the following way: | ||
- | REGION -> SITES | unique id generated for a REGION and referenced in SITES table | + | | **REGION -> SITES** |
- | + | | **SITES -> SAMPLES** | |
- | SITES -> SAMPLES | unique id generated for a SITES and referenced in SAMPLES table | + | | **SAMPLES -> BE10/AL26 QUARTZ** |
- | + | ||
- | SAMPLES -> BE10/AL26 QUARTZ | unique id generated for a sample | + | |
Note that unique ids are generated by the database/ | Note that unique ids are generated by the database/ | ||
Line 74: | Line 86: | ||
those 5 samples to the new publication. | those 5 samples to the new publication. | ||
+ | \\ | ||
+ | \\ | ||
---- | ---- | ||
Line 86: | Line 100: | ||
find the unique id for that Region since you will need it for the Sites table.) | find the unique id for that Region since you will need it for the Sites table.) | ||
- | For the remaining tables | + | For the remaining tables |
- | upload excel spreadsheets. For each table, | + | |
- | up proper table relations and allow for calculating simple exposure ages using the version 3 Cronus Earth | + | |
- | calculator. | + | |
- | **IMPORTANT: | + | **IMPORTANT: |
- | and you may cause an error on the ICE-D web page (don’t worry you won’t kill ICE-D, you | + | |
- | just need to ammend | + | \\ |
+ | \\ | ||
+ | |||
+ | ====SITES==== | ||
+ | {{ : | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | ====SAMPLES==== | ||
+ | {{ : | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | ====Be10 Al26 QUARTZ==== | ||
+ | {{ : | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
---- | ---- | ||
- | **Step 4.** Once you have these three excel tables set up, one by one import them into their respective | + | **Step 4.** Once you have these three excel tables set up, one by one import |
- | ICE-D tables in the admin page. I will show what it looks like to import entries for the Sites table, but | + | |
- | the others look more or less the same. | + | |
- | Navigate to the Sites table in the admin page. You will see a list of sites arranged latest to first. There | + | **NOTE: STANDARD EDITORS CANNOT BULK IMPORT SITES DUE TO RESTRCITIONS ON WHICH APPLICATIONS THEY HAVE ACCESS TO. SITE ENTRIES MUST BE MADE ONE AT A TIME!** We recommend creating an excel page for sites (similar to the other tables like samples, be10al26 Quartz, etc.) to keep track of each site and their attributes/ |
- | should be an import button near the top of the page, select that button. | + | |
+ | **ANOTHER NOTE:** Please be sure when manually entering sites that you specify which application(s) the sites belong to. This is a required step and if it is skipped, your data will not show up on the ICE-D webpage. | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | Navigate to the Samples | ||
The page displayed should look similar to the screenshot below: | The page displayed should look similar to the screenshot below: | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | |||
+ | Note here that all of the columns with their respective titles show up on this page in the order they | ||
+ | need to be entered. If there is additional info you want to add besides the info we outline in this tutorial, | ||
+ | refer to the import page for column names and order. | ||
+ | |||
+ | Choose the file you wish to import (be sure that it is saved as a .xlsx file), and from the format drop | ||
+ | down menu select .xlsx (this works for other file formats such as csv, but xlsx is the simplest to work with | ||
+ | so we suggest sticking with that file format). | ||
+ | |||
+ | Once you have done this, you can hit the submit button, which takes you to a preview page before the | ||
+ | submission is complete. If you run into an error on the preview page, try to read what the error is and amend your excel sheet, then re-upload. If something is still wrong, email Greg or Joe. | ||
+ | |||
+ | On the preview page, if you uploaded successfully, | ||
+ | |||
+ | Go through and add the remaining tables (e.g., Be10 Al26 Quartz, Publications, | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | ---- | ||
+ | |||
+ | **Step 5** When you are done uploading/ | ||
+ | |||
+ | |||
+ | Hint: ICE-D also prints out sample information in the version 3 exposure age calculator format. Check | ||
+ | here first to see if there are any obvious errors. | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | ---- | ||
+ | |||
+ | As always, please don’t hesitate to contact Greg Balco (balcs@bgc.org) or Joe Tulenko (jtulenko@bgc.org) | ||
+ | if something gets horribly messed up or if there is any confusion, you have questions, etc. We are always | ||
+ | welcoming suggestions from the commmunity as well so please email us if you have suggestions that may | ||
+ | improve ICE-D. | ||
+ | |||
+ | Thanks for following along! | ||
+ |