Helpdesk - #178854 NT DEPWS - dr361 dr362

[rosemaryjoconnor]

New uploads: DEPWSFloradata_2023.csv and DEPWSFaunadata_2023.csv into ALA SFTP /upload/ftp-nt/.

[rosemaryjoconnor]

Collectory

Test

• dr361: s3://ala-uploads-source-data-production/uploads-server-sync/ftp-nt/upload/ftp-nt/DEPWSFaunadata_2023.csv

• dr362: s3://ala-uploads-source-data-production/uploads-server-sync/ftp-nt/upload/ftp-nt/DEPWSFloraadata_2023.csv

Prod

• dr361: sftp://upload.ala.org.au:ftp-nt/DEPWSFaunadata_2023.csv

• dr362: sftp://upload.ala.org.au:ftp-nt/DEPWSFloradata_2023.csv

[rosemaryjoconnor]

dr361 - DEPWS Fauna: Successful in databox. Preingestion Production successful. Wait for overnight index to check.

dr362 - DEPWS Flora:62,509 duplicate catalogNumbers in the data file. Have extracted all duplicates and sent to user to check

[rosemaryjoconnor]

Check for updates on 17/07/2023

[rosemaryjoconnor]

User notified again regarding duplicate catalogNumbers. Have to wait for a new dataset

• 1,038,862 total records
• 976,353 unique catalogNumber records
• 62,509 duplicate catalogNumber records

[rosemaryjoconnor]

Duplicate data problem solved. Databox load successful. Preingestion prod successful waiting for Index