Metadata Pulldown AG

[sjanssen2]

Hi @EmbrietteH ,
you mentioned that the metadata pulldown is not working when you try to retrieve data for our potential new collaborator. Can you elaborate what exactly is going wrong right now?
We are close to switch to the new scrubbed DB version, such that testing will be much easier. Maybe you can send me a list of barcodes for which you want to obtain metadata?!

[EmbrietteH]

The issue is that if someone has taken a secondary survey (i.e., fermented foods survey) the main survey pulldown won't work for that individual-that person's barcodes only pull down with the fermented foods survey. This is bad since production of participant results requires the main survey pulldown. The attached file contains barcodes from the fermented foods survey that pulldown for fermented foods survey but don't appear in the main pulldown.
survey_3_md.txt

[sjanssen2]

Hey @EmbrietteH to do the debugging, I need the barcode file which you provide to labadmin to do the pulldown, not only the erroneous result of the pulldown.

[EmbrietteH]

I email you a file. You can also copy the barcodes from the pulldown into a text file and use that as input.

[sjanssen2]

We need a more reliable way to restore information in ag.ag_kit_barcodes !

[wasade]

restore?

[sjanssen2]

we currently relay on the tuple of ag_login_id and participant_name to identify the human sources for which more than one survey exists. Since Jose's scrubbing script scrambles those names independently, the test DB does not contain any ag_login_id, participant_name tuples with more than one survey :-(