meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
applications:add [2023/01/12 21:35] – joetulenkoapplications:add [2023/02/08 15:54] (current) – joetulenko
Line 1: Line 1:
-In this tutorial I will be teaching users our best practices for adding data to ICE-D through the admin+====Adding data to ICE-D from the Admin Page==== 
 + 
 + 
 +{{ :applications:ade_i.jpg?nolink |}} 
 + 
 + 
 +In this tutorial we will be teaching users our best practices for adding data to ICE-D through the admin
 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:add-special-cases|a page with notes on some less common data entry cases]] if what you are looking for is not covered here.
 +
 +\\
 +\\
 ---- ----
  
-**Step 1.** Begin the tutorial by navagating to the admin page (https://version2.ice-d.org/admin/) on the+**Step 1.** Begin the tutorial by navigating to the admin page (https://version2.ice-d.org/admin/) on the
 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:
 +
 +{{ :applications:ade_1.1.png?nolink |}}
  
 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, I am going to focus only on the four most relevant tables for users adding new 10Be simple exposure entries (Regions, Sites, Samples and Be10 Al26 Quartz). Furthermore, these four tables +tutorial, for simplicity, we are going to focus only on the four most relevant tables for users adding new 10Be simple exposure entries (Regions, Sites, Samples and Be10 Al26 Quartz). Furthermore, these four tables 
-have more columns/attributes beyond those necessary to calculate exposure ages but I am going to focus+have more columns/attributes beyond those necessary to calculate exposure ages but we are going to focus
 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**  |  unique id generated **//for//** a **REGION** and **//referenced//** in **SITES** table  | 
- +|  **SITES -> SAMPLES**  |  unique id generated **//for//** a **SITE** and **//referenced//** in the **SAMPLES** table  | 
-SITES -> SAMPLES | unique id generated for a SITES and referenced in SAMPLES table +|  **SAMPLES -> BE10/AL26 QUARTZ**  |  unique id generated **//for//** a **SAMPLE** and **//referenced//** in **BE10 AL26 QUARTZ** table  |
- +
-SAMPLES -> BE10/AL26 QUARTZ | unique id generated for a sample and referenced in BE10 AL26 QUARTZ table+
  
 Note that unique ids are generated by the database/admin window on ICE-D and users will not be Note that unique ids are generated by the database/admin window on ICE-D and users will not be
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 - Sites, Samples and Be10 Al26 Quartz - the admin page allows users to directly +For the remaining tables except Sites and Publications - Samples, Be10 Al26 Quartz, Sample Publication matches - the admin page allows users to directly upload excel spreadsheets. For each table, we are including a screenshot of the basic columns needed to set up proper table relations and allow for calculating simple exposure ages using the version 3 Cronus Earth calculator.
-upload excel spreadsheets. For each table, I am including a screenshot of the basic columns needed to set +
-up proper table relations and allow for calculating simple exposure ages using the version 3 Cronus Earth +
-calculator.+
  
-**IMPORTANT: If you miss any of these entries your samples will not show up properly +**IMPORTANT: If you miss any of these entries your samples will not show up properly 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 amend your entries for the error to go away.)** 
-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 your entries for the error to go away.)**+\\ 
 +\\ 
 + 
 +====SITES==== 
 +{{ :applications:ade_3.1.jpg?nolink |}} 
 + 
 +\\ 
 +\\ 
 + 
 +====SAMPLES==== 
 +{{ :applications:ade_3.2.jpg?nolink |}} 
 + 
 +\\ 
 +\\ 
 + 
 +====Be10 Al26 QUARTZ==== 
 +{{ :applications:ade_3.3.jpg?nolink |}} 
 + 
 +\\ 
 +\\
  
 ---- ----
  
-**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 (or manually enter) them into their respective ICE-D tables in the admin page. We will show what it looks like to import entries for the Samples table, but the process is essentially the same for other tables that work for importing.
-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/fields to help with manual data entry. 
-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 table in the admin page. You will see a list of sample entries arranged latest to first. There should be an import button near the top of the page, select that button.
  
 The page displayed should look similar to the screenshot below: The page displayed should look similar to the screenshot below:
 +
 +{{ :applications:ade_4.1b.jpg?nolink |}}
 +
 +\\
 +\\
  
 Note here that all of the columns with their respective titles show up on this page in the order they 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 I outline in this tutorial,+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. 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 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 down menu select .xlsx (this works for other file formats such as csv, but xlsx is the simplest to work with
-so I suggest sticking with that file format).+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 Once you have done this, you can hit the submit button, which takes you to a preview page before the
-submission is complete. In the example below, I am creating two new sites for the Revelation Mountains +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. 
-Region (id 354) in the Alaska, Alaska Range. They are late Holocene moraines, so under the ’what’ column +
-I put moraine, and in the name, I use the geographic term NSR (north swift river; from the publication) +
-and age/stratigraphic terms Late Holocene 4 and Late Holocene 5 (4 assuming to have some stratigraphic +
-relationship to 5).+
  
-In this example, each entry is highlighted in green and columns with filled in information are shown +On the preview page, if you uploaded successfully, there should be green highlighted rows with all of the entry info you uploaded. Double check each entry to make sure all of the information is correctly entered. Once you are satisfied with the preview page, hit confirm import. This should send you back to the Samples table and you should see your individual samples added to the table! Nice.
-along with empty fields for columns where information was not entered. If your preview page looks any +
-different from this do not proceed until you figure out what went wrong.+
  
-Note here that the admin page auto-generated two new unique Site ID’s 5033 and 5034. When I go +Go through and add the remaining tables (e.g., Be10 Al26 Quartz, Publications, sample publication matches, etc.) to the database.
-to add samples, I will need to update my Samples spreadsheet to include these ids for whichever samples +
-belong to each respective site. +
- +
-Once you are satisfied with the preview page, hit confirm import. This should send you back to the +
-Sites table and you should see your sites added to the table! Nice. +
- +
-Go through and add the remaining two tables (Samples and Be10 Al26 Quartz) to the database. When +
-you are done, there is one final step to ensure that the samples are correctly added to the database.+
  
 +\\
 +\\
 ---- ----
  
-**Step 5.** If you were to check version2.ice-d.org right now for your samples they would not show up. This +**Step 5** When you are done uploading/manually entering data, check the ICE-D webpage to make sure all of your data entry is correct! The webpage calculates exposure ages using the version 3 calculator, the default production rate and two scaling schemes (St and LSDn). If those calculations do not show up you may have missed a necessary column or made an error in your data entry. If it is an easy fix you can edit any Sites, Samples, or Be10 Al26 Quartz entry directly in the admin by selecting the entry and editing information displayed on the page. If it the error looks really messy, no worries just email Greg or Joe and we can help sort it out.
-is because there is a final step that needs to be done to tell ICE-D which specific database application +
-these new samples belong to, such as ICE-D Greenland, ICE-D Alpine, etc. +
- +
-Navigate back to the Sites table in the admin page and select a site that you just created. It should +
-take you to a page where all of the information you entered for the site is displayed (and editable; check +
-the entries now to make sure everything is correctly entered). +
- +
-Scroll to the very bottom of the page and you should see a separate section titled ApplicationSite Relationships. Similar the previous discussion about table relations, a site entry can belong to +
-multiple applications. For example, the Boundary Stream Tarn Site (id 4897) from Aaron Putnam et. +
-al.’s production rate calibration in New Zealand is an alpine glacier moraine and also a production rate +
-calibration site. Thus, in each Sites page, users need to specify which application the site belongs to by +
-adding the application(s) in the drop down menus in the Application-Site Relationships section.+
  
-In the BST example shown below, there are two entries listed, one for production rate calibration (id 
-5) and the other alpine (id 2). 
  
-Be sure to do this for all of the sites you created! And once you have done so, go check the ICED webpage to make sure all of your data entry is correct! The webpage calculates exposure ages using 
-the version 3 calculator, the default production rate and two scaling schemes (St and LSDn). If those 
-calculations do not show up you may have missed a necessary column or made an error in your data entry. 
-If it is an easy fix you can edit any Sites, Samples, or Be10 Al26 Quartz entry directly in the admin by 
-selecting the entry and editing information displayed on the page. 
 Hint: ICE-D also prints out sample information in the version 3 exposure age calculator format. Check 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. here first to see if there are any obvious errors.
  
 +\\
 +\\
 ---- ----