helendallas / FRC_FBIS

Freshwater research Centre FBIS Data Consolidation Management
0 stars 0 forks source link

Check algal master list and revise as needed #215

Closed helendallas closed 1 year ago

helendallas commented 3 years ago

@KSnaddon to check Algal master list and revise as needed. @helendallas to show Kate how to download csv file, to check with excel file, then update on Taxon Management as needed.

helendallas commented 2 years ago

Please keep this ticket update, thanks

And include the master file as an upload.

helendallas commented 1 year ago

List updated by Kate

FINAL FBIS Algal Master List 4 Nov 2022.xlsx

Helen still checking, plan to test on testing then FBIS production on monday

helendallas commented 1 year ago

On testing - before re-uploading of algal master list image

helendallas commented 1 year ago

I ran a test upload on testing but experienced some issues. Have logged a ticket for Dimas. This will have to wait until he has resolved the issue.

helendallas commented 1 year ago

Several test files added to FBIS 2 dropbox folder, including:

helendallas commented 1 year ago

@KSnaddon @Janette-Lumley

I decided to go ahead and check and upload new algal master list as time was ticking. Essentially it required a bit of detective work. The workflow was as follows - for future ref.

  1. prepare new master list, checking all existing taxa and fixing to ensure no duplicates etc
  2. Uploading to FBIS testing site. Checked error file.
  3. Downloading Algal master list CSV from Taxon Management
  4. Comparing this with the uploaded master list to pick us issues (checked number of taxa, etc).
  5. Issues picked up included where . var was still in and hadn't been updated. Only about 6 issues.
  6. Fixed these issues in taxon management on FBIS production. and on master list if need be.
  7. Uploaded master list to FBIS production. Checked error file.
  8. Corrected two problem taxa in Taxon Management - issue with incorrect parent.
  9. Uploaded master list again to production.
  10. 100% success. final master file and success file available here and on dropbox

FINAL FBIS Algal Master List 2023_03_03 Uploaded.xlsx

success_FINAL_FBIS_Algal_Master_List_2023_03_03_Uploaded_PtIby5z.xlsx