search

UGS-GIO / rockcore

UGS Core Research Center Inventory web application that compiles a large data set of rock core data and displays it on an interactive web map
https://geology.utah.gov/apps/rockcore/
0 stars 0 forks source link

Muddy Creek #1 photo issue #36

Closed marthajensen closed 2 years ago

marthajensen commented 2 years ago

What happened?

Mike noticed that the Muddy Creek #1 (43-015-30361-S000) photos are not visible on the UCRC web app - I checked in the UCRC main photos folder, and it looks like this is the correct pathway: M:\Shared drives\UGS_UCRC\UGS_Shared Core Photos Archive Dec 2021 - Main core photo folder\Web Server Downsized\Moved_To_Server\4301530358S000_Muddy_Creek_1\Muddy Creek 1 Processed Can these be added to the web app at some point?

What did you expect to happen?

To see the correct photos

Browser Version

Chrome Version 96.0.4664.45 (Official Build) (64-bit)

marthajensen commented 2 years ago

@klcummings

The photos are now fixed in the app.

The photos for Muddy Creek #1 weren't showing for a couple of reasons. First, the data did exist, but the spreadsheet of photos had never been added to the photo table. The second reason was that the spreadsheet of photos had two syntax errors in the file name, path and fileurl fields. See below

Folder name had spaces in the spreadsheet, but actually had underscores in the server folder name (path, fileurl field):

4301530358_Muddy Creek 1 was replaced with 4301530358S000_Muddy_Creek_1

AND

The '_" (underscore) between top depth and bottom depth in the file name field needed to be changed to "-" (dash)

If you are updating a version of the database on your end, please make these changes. I will add the changes to our Survey 123 database.