Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

exportDataset needs to populate alternate_filename #161

Open
patkyn opened this issue Aug 30, 2021 · 3 comments
Open

exportDataset needs to populate alternate_filename #161

patkyn opened this issue Aug 30, 2021 · 3 comments
Assignees

Comments

@patkyn
Copy link

patkyn commented Aug 30, 2021

Refer: AtlasOfLivingAustralia/data-management#732 (example 2).

As discussed with @sbearcsiro, in order for image sync to link back the images, the alternate_filename can be used to match back to the original url when original_filename when the url differs

images=# select original_filename, alternate_filename from image where image_identifier = '2adce2cd-9c8f-43fc-be2f-8d8badf783ce';
                       original_filename                        |                                           alternate_filename                                            
----------------------------------------------------------------+---------------------------------------------------------------------------------------------------------
 NSW_Trip_Mutawintji_May_2014_RAW-_0967-CR2_DxO_DeepPRIME_2.jpg | {https://biocollect.ala.org.au/image?id=NSW_Trip_Mutawintji_May_2014_RAW-_0967-CR2_DxO_DeepPRIME_2.jpg}
(1 row)
sbearcsiro added a commit that referenced this issue Sep 7, 2021
 - Move static export dataset SQL to config
 - Add alternate filename column to export dataset endpoint query
@sbearcsiro sbearcsiro self-assigned this Sep 7, 2021
sbearcsiro added a commit that referenced this issue Oct 28, 2021
- Move static export dataset SQL to config
 - Add alternate filename column to export dataset endpoint query
@patkyn
Copy link
Author

patkyn commented Sep 19, 2022

After discussion with @djtfmartin, the exportDataset should output the alternative_filenames and original_filenames as identifier to the same imageID in the export for eg:

fileName1,uuid1
alternativeFileName1,uuid1

@yasima-csiro
Copy link
Contributor

The solution need to be modified to have image records for original file name and each alternative_filenames as below.

uuid -1 | original_filename
uuid -1 | alternate_filename-1
uuid -1 | alternate_filename-2

@yasima-csiro
Copy link
Contributor

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants