search

AtlasOfLivingAustralia / image-service

Image repository and tiling services
https://images.ala.org.au
0 stars 17 forks source link

Image bulk export CSV service contains occurrenceId field twice #79

Closed ansell closed 4 years ago

ansell commented 4 years ago

The image bulk export CSV service contains the occurrenceId field twice, but only one of the columns with that label are populated consistently.

$ head -n 2 images-export.csv 
dataResourceUid,occurrenceID,identifier,creator,created,title,format,license,rights,rightsHolder,references,title,description,extension,recognisedLicense,dateDeleted,md5hash,fileSize,width,height,zoomLevels,imageIdentifier,occurrenceID
dr1010,"",https://images.ala.org.au/image/proxyImageThumbnailLarge?imageId=c17dd7e0-e14f-4978-b7ef-5acdce5e63f7,,2012-05-28 09:09:30,,image/jpeg,,,,https://images.ala.org.au/image//image/c17dd7e0-e14f-4978-b7ef-5acdce5e63f7,,,jpg,,,055d85eab895ae868b3d25b2aeb15c82,1025415,2592,1944,5,c17dd7e0-e14f-4978-b7ef-5acdce5e63f7,3580f1df-6c9b-4522-8a70-62f8aaf1b228
djtfmartin commented 4 years ago

Fixed. Was a problem with the stored procedure.

ansell commented 4 years ago

This appears to be fixed by the change to the stored procedure linked to this issue.