add the swedishRank to all the records

[mathieuLU]

add the swedishRank to all the records

[mathieuLU]

Now the swedish rank is (almost) on every single survey in BioCollect.
It was already present for 44k species observations
My script added 1 992 958 new swedish ranks :) based on the species list

Only 10 rows are missing, I will fix these and try to understand what happened. details are coming soon.

[2022-02-03 09:39:27] INFO : Script starts.
[2022-02-03 09:39:27] INFO : php script/editRecordsAddSwedishRank.php
[2022-02-03 09:39:27] ERROR : No lsid/dyntaxa for Sterna hirundo/paradisaea
[2022-02-03 09:39:27] INFO : No lsid for Gavia stellata/arctica, dyntaxa instead
[2022-02-03 09:39:27] INFO : Species list dr158 obtained. 385 elements
[2022-02-03 09:39:27] INFO : Species list dr159 obtained. 31 elements
[2022-02-03 09:39:27] INFO : Species list dr160 obtained. 11 elements
[2022-02-03 09:39:27] INFO : Species list dr167 obtained. 12 elements
[2022-02-03 09:49:33] ERROR : No guid for activityId#a937474c-6e9c-4458-bc7f-4fb447a18990 and (list: )
[2022-02-03 09:49:33] ERROR : No guid for activityId#ba33d1b6-545b-48c1-9979-83b73d6ef0af and (list: )
[2022-02-03 09:49:33] ERROR : No guid for activityId#631a0883-b1bb-4582-b2f1-3233699279ee and (list: )
[2022-02-03 09:49:33] ERROR : No guid for activityId#0208bb3e-f7d1-465e-8227-ff8903e46601 and (list: )
[2022-02-03 09:49:38] INFO : no species info for Alca tordaUria aalge/guid#:266926 => maybe the guid changed ?
[2022-02-03 09:49:56] INFO : no species info for Melanitta stejnegeri/guid#:10056448 => maybe the guid changed ?
[2022-02-03 09:49:57] INFO : no species info for Gavia immer/adamsii/guid#:266775 => maybe the guid changed ?
[2022-02-03 09:49:57] INFO : no species info for Sibirionetta formosa/guid#:9235549 => maybe the guid changed ?
[2022-02-03 09:50:30] ERROR : No guid for activityId#ae278d8a-8429-4dc0-a74c-38cf0f06ce9f and (list: )
[2022-02-03 09:50:30] INFO : no species info for Anser fabalis fabalis/guid#:7191106 => maybe the guid changed ?
[2022-02-03 09:50:31] INFO : 1992968 missing swedishRank.
[2022-02-03 09:50:31] INFO : 1992958 added swedishRank.
[2022-02-03 09:50:31] INFO : 44037 ok swedishRank.

[ekol-ali]

Sounds good!
If you give me the list of the 10 "missing" records, I could proabably give you some idea of why it failed...

[mathieuLU]

i fixed the 5 with empty list :

[2022-02-03 09:49:33] ERROR : No guid for activityId#a937474c-6e9c-4458-bc7f-4fb447a18990 and (list: )
[2022-02-03 09:49:33] ERROR : No guid for activityId#ba33d1b6-545b-48c1-9979-83b73d6ef0af and (list: )
[2022-02-03 09:49:33] ERROR : No guid for activityId#631a0883-b1bb-4582-b2f1-3233699279ee and (list: )
[2022-02-03 09:49:33] ERROR : No guid for activityId#0208bb3e-f7d1-465e-8227-ff8903e46601 and (list: )
[2022-02-03 09:50:30] ERROR : No guid for activityId#ae278d8a-8429-4dc0-a74c-38cf0f06ce9f and (list: )

for these 5, the problem was only the empty row saved : when someone adds a new row and do not write anything in it. It should not be allowed. related to that bug as well => #209

I manually edited and removed these 5 elements

now i will check the other 5

[mathieuLU]

fixed for the last 5 as well ;-)

So i added the rank for the birds observations. If I remember well you don't need it for the other blocks (mamals, amphibians, owls, etc..), right ?

[ekol-ali]

I have asked Fredrik and Martin about your lasst question.

[ekol-ali]

Fredrik and Martin both like to have rank on the other lists/species data as well, including the possibility to sort on rank when looking at data.

[mathieuLU]

The script => https://github.com/Lund-University-Biodiversity-data/convert-SFT-SEBMS-to-MongoDB/blob/master/script/editRecordsAddSwedishRank.php

new issue for other animals lists
#213