kartoza / django-bims

https://testing.healthyrivers.kartoza.com
GNU Affero General Public License v3.0
12 stars 19 forks source link

CSV file for Odonata Map data #2488

Closed helendallas closed 3 years ago

helendallas commented 3 years ago

image

https://testing.healthyrivers.kartoza.com/map/#site-detail/taxon=&search=Chlorolestes%20fasciatus&siteId=&collector=&category=&yearFrom=&yearTo=&months=&boundary=&userBoundary=&referenceCategory=&spatialFilter=&reference=&endemic=&conservationStatus=[]&modules=33&validated=&sourceCollection=[%22fbis%22]&abioticData=&ecologicalCategory=&rank=&siteIdOpen=&orderBy=name&polygon=

Some issues:

basisOfRecord = Sampling method = Photographic record (please add space between words)

RecordedBy in VM needs to become Collector/Owner in FBIS (so in this case Diedericks G) In a way the Owner needs to be OdonataMap Virtual Museum and Collector needs to be Diedericks G as image

locality - there are extra letters e.g. b'farm Berlyn 506; 16.6 km N of Graskop'

Authors - should be Underhill L Year - 2021 - this should be updated automatically depending on the date of the update Source - should be OdonataMap Virtual Museum, FitzPatrick Institute of African Ornithology, University of Cape Town (See ticket #2478 )

dimasciput commented 3 years ago

@helendallas author and year are not available for source reference database, I can add it but it will take half a day to a full day.

helendallas commented 3 years ago

@dimasciput Okay, no problem just include Source, as per ticket #2478 Dont worry to add it for now, just focus on correcting other issues highlighted above, thanks

helendallas commented 3 years ago

@dimasciput Still need to fix

RecordedBy in VM needs to become Collector/Owner in FBIS (so in this case Diedericks G) In a way the Owner needs to be OdonataMap Virtual Museum and Collector needs to be Diedericks G

At the moment Collector/owner are all given as OdonataMAP VM

dimasciput commented 3 years ago

@helendallas yes i haven't done this yet, it's still in progress. Please only test the review column.

helendallas commented 3 years ago

@dimasciput Sorry I misunderstood. I thought this would be fixed with ingestion into the live site, especially since this will be a regular ingestion of the same data

dimasciput commented 3 years ago

@helendallas I encountered some issues here with the collector name, it seems they don't have same format :

So it's very hard for me to parse this string into correct user object. I can just make them as one user regardless of the format. What do you think?

helendallas commented 3 years ago

@dimasciput Okay, tricky.

Do you mean bring in as they are regardless of format. That would be fine I think. Since the filter now is Owner only, and not collector, it wont make it messy

dimasciput commented 3 years ago

@helendallas okay cool, I'll update it right away

dimasciput commented 3 years ago

Hi @helendallas , regarding this request for csv

@dimasciput Still need to fix

RecordedBy in VM needs to become Collector/Owner in FBIS (so in this case Diedericks G) In a way the Owner needs to be OdonataMap Virtual Museum and Collector needs to be Diedericks G

At the moment Collector/owner are all given as OdonataMAP VM

Should I put collector name in the collector/owner field? And where should I put the owner? Keep in mind that this will affect other modules download.

image

helendallas commented 3 years ago

@dimasciput If there is only one field Collector/Owner, then because of the messiness of the data, I suggest we just make it OdonataMAP VM, rather than each collector name.

The user then needs to go to the VM record to see who collected the data......

If these were separate we could include both.

Lets keep it simple for now.

Does that makes sense.

dimasciput commented 3 years ago

@helendallas fixed in the site visit form image

helendallas commented 3 years ago

@dimasciput Thanks, looks fine