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/02/08 15:51] – joetulenko | applications:add [2023/02/08 15:54] (current) – joetulenko | ||
---|---|---|---|
Line 5: | Line 5: | ||
- | In this tutorial | + | 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 14: | Line 14: | ||
and one of us 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: | + | Also see [[applications: |
\\ | \\ | ||
Line 27: | Line 27: | ||
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 100: | 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 except Sites and Publications - Samples, Be10 Al26 Quartz, Sample Publication matches - the admin page allows users to directly upload excel spreadsheets. For each table, | + | 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, |
**IMPORTANT: | **IMPORTANT: | ||
Line 127: | Line 127: | ||
---- | ---- | ||
- | **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. I 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. | + | **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. |
**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/ | **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/ | ||
Line 146: | Line 146: | ||
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 |