search

gbif-norway / helpdesk

Please submit your helpdesk request here (or send an email to helpdesk@gbif.no). We will also use this repo for documentation of node helpdesk cases.
GNU General Public License v3.0
3 stars 0 forks source link

Excel spreadsheet for DwC datasets #77

Closed vidarbakken closed 2 years ago

vidarbakken commented 2 years ago

A macro based spreadsheet in excel is made for DwC datasets. It is possible to define datasets for Occurrence and Sample-Event. It is also possible to connect MeasuremensOrFacts (including Extended MeasuremensorFacts) and SimpleMedia data. When completed the datasets can be exported to tab-text files. It is also possible to make templates of the setup of the different sheets. The templates can later be imported and used in the spreadsheet.

vidarbakken commented 2 years ago

I have made a simple user manual for the excel spreadsheet. To be improved! https://www.dropbox.com/s/0wovc96w3qmswl4/GBIF_DwC_Data.pdf?dl=0

rukayaj commented 2 years ago

@vidarbakken I think it would be great if you could make a github repository and add the spreadsheet to that so we have access to the latest version of it as well!

vidarbakken commented 2 years ago

This is the latest version. The function to transfer waypoints from Google Maps is improved. Now it is possible to get both the locality name and the coordinates from a waypoint. The information is fetched from the the URL-link. A also tried norgeskart.no as the map system, but Google Maps works better.

The link to the latest version is: https://www.dropbox.com/s/z8gs70bvogxxy1q/GBIF_DwC_Data_Tool_1_0_Beta%20.xlsb?dl=0

It is not allowed to attach such files (*.xlsb) in GitHub.

vidarbakken commented 2 years ago

Last version from today: https://www.dropbox.com/s/l3wnz25yrt15j5x/GBIF_DwC_Data_Tool_1_1_Beta_Dist%20.xlsb?dl=0

rukayaj commented 2 years ago

It is not allowed to attach such files (*.xlsb) in GitHub.

Oh yes I forgot about that! Ok I guess dropbox is best for it while it is still getting tested. When you feel like it's ready we can link to it from the simple excel generator and/or the GBIF.no services page.

rukayaj commented 2 years ago

I have uploaded this version https://www.dropbox.com/s/l3wnz25yrt15j5x/GBIF_DwC_Data_Tool_1_1_Beta_Dist%20.xlsb?dl=0 to here https://static.gbif.no/dwc-generator.xlsb.

Also added it to the GBIF.no services page. So I guess we can close this issue?

dagendresen commented 2 years ago

If the Excel tool maybe is published in e.g. Zenodo or OSF - together with a user manual? - it could get a DOI to enable easier citation if useful. An abstract presented at TDWG could also provide a nice software citation anchor :-) Anyway, the static.gbif.no also looks nice.

rukayaj commented 2 years ago

Great idea, it would be perfect to have it in Zenodo - and then Vidar can more easily manage the versions too. What do you think @vidarbakken ?

rukayaj commented 2 years ago

All done!

vidarbakken commented 2 years ago

A second version is published in Zenodo (1.2 beta). Today I have updated the spreadsheet with dynamicProperties which is saved in json format. The date registration is also extended to cover date periods. These two last updates are not yet published. They need some more testing before publishing.

dagendresen commented 2 years ago

In Zenodo at: https://doi.org/10.5281/zenodo.5886995