search

sfg-taxonpages / plecoptera

1 stars 1 forks source link

Arcynopteryx dichroa common name #13

Closed redewalt closed 6 days ago

redewalt commented 11 months ago

The common name "Holarctic Springfly" did not transfer for this species. Is there a wider issue?

redewalt commented 10 months ago

I have noticed several common names missing from Plecoptera SF. It is present for some and absent for others. It seems we will have to import them again. How is this best accomplished.

klausriede commented 10 months ago

this is standard SQL , using the respective tables (old vs new), connected via an ID or eventually name, using the UPDATE function.

mjy commented 10 months ago

@klausriede we do not use SQL directly, it's too easy to break the validation and semantics by doing that. TaxonWorks has an ORM that we work through if we have to batch operate on the data.

@redewalt I do not have a full answer, but please see filters, I believe we can check for things with/out common names, if not we will add that shortly.

hhopkins77 commented 10 months ago

@mjy I have never worked with common names before. Can you tell me where in TW I enter common names?

mjy commented 10 months ago

OTU -> Quick form.

hhopkins77 commented 10 months ago

Ah ha. Got it.

hhopkins77 commented 10 months ago

@mjy Update: I have checked this and two other Plecoptera species for missing common names. All have 2 or more OTUs, only one of which has the common name. This would seem to indicate that the multiple OTU issue is a big one, and that TaxonPages is not drawing data from the best (ie: the correct) OTU (not sure about that wording).

klausriede commented 10 months ago

What is an ORM? In any case you could/should validate migration results via the simple SQL routine I suggested. It is too tedious for us users to find the many mistakes, and it also does not look good for the outside world....

hhopkins77 commented 6 days ago

I have cleared the migration issue that I believe was preventing some common names from showing. Should you find any more missing common names, please report the species name and the associated common name and it will be checked.