Purpose:

The folks working on the ICE-D project have released version 2 of the database (ICE-D Version 2) and are ready to start getting community contributions again!

We are scheduling this workshop to debut the new database, show the contributors at the University at Buffalo how to connect with and view the new database on their own personal computers, and then teach contributors how to use the new, sleek admin page on the version 2 website to add data!

There will also be opportunities to discuss and brainstorm useful and impactful applications using the ever-growing ICE-D (e.g. data manipulation, visualization and analysis in Matlab, and geospatial analysis in GIS software).

Itinerary:

The workshop is planned to take place April 11-13 (Mon - Wed) depending on availability of UB Students and ICE-D workshop organizers. exact timing of events TBD.

Schedule and goals:

1) Get connected to the new database through SQL clients and Matlab

2) Get contributors set up with add/edit/remove privileges for relevant tables on the ICE-D version 2 admin page

3) Applications demonstrations (Matlab and GIS) and brainstorming of new applications, community feedback, etc.

Please don't hesitate to email any of the workshop organizers if you have any questions (Joe Tulenko, Greg Balco, and/or Ben Laabs).

04-11-2022 Notes Day 1

users successfully added as standard_editors. However users can't view tables that have import/export options but they can still add individual entries one at a time. I also did not figure out how to do bulk uploads so for now we are going to stick with individual entries for now.

After the workshop, I was able to successfully do a bulk upload for the sites table, but using the same “csv file open in a text editor” method for the samples table, I noticed that you do NOT need to include the id column. The web app generates unique ids for samples without the user needing to acknowledge the id column

Somewhat related, I noticed that in the samples page, the samples are listed by their name but their unique ids are not listed anywhere. Unlike the sites and regions table where unique ids are listed.

This could/should be an item for the ICE-D team to discuss offline.

04-12-2022 Notes Day 2