search

humlab-sead / sead_bugs_import

SEAD bugs import
2 stars 0 forks source link

Import error: Flagged TDatesRadio #25

Closed roger-mahler closed 4 years ago

roger-mahler commented 4 years ago

Latest Bugs import has 290 flagged inserts of "Unknown" dating lab for geochronology. All of these have have an unknown lab in BugsCEP (null, blank, 'Unknown' or " context 'probably' 1").

The flagging is disabled in Bugs Import since all of them have been given dating lab "Unknown" which is OK.

with bugs_values as (
    select *, string_to_array(translate(bugs_data, '{}', ''), ',') as decoded_bugs_data
    from bugs_import.bugs_errors
    where TRUE
) select decoded_bugs_data[10], count(*)
  from bugs_values
  where TRUE
    -- and array_length(data, 1) = 7
    -- and message = 'Association type not found'
  and message like 'FLAGGED:%'
  and bugs_table = 'TDatesRadio'
  group by decoded_bugs_data[10]