- Phone Support
Home → Hershey's Issues and Solutions → Transcript Module → Duplicate file exists
9.16. Duplicate file exists
Issue:
"I'm having a problem with our Transcript Module. We are getting an error when we try to import. It says duplicate file exists s:starrs\index\ts\00062283_00321688.tif
Also the same for 00062400_000130009.tif
00062398_000157725.tif"
"I'm having a problem with our Transcript Module. We are getting an error when we try to import. It says duplicate file exists s:starrs\index\ts\00062283_00321688.tif
Also the same for 00062400_000130009.tif
00062398_000157725.tif"
Resolution:
"used this query to find the images that had multip transcripts pointing to them:
SELECT DISTINCT TRANS_PAGE.image_path, COUNT(TRANS_PAGE.image_path) AS duplicates
FROM TRANS_PAGE INNER JOIN
TRANSCRIPT ON TRANS_PAGE.transcript_Id = TRANSCRIPT.transcript_id
WHERE (TRANSCRIPT.imagesys_date IS NULL)
GROUP BY TRANS_PAGE.image_path
HAVING (COUNT(TRANS_PAGE.image_path) > 1)
FROM TRANS_PAGE INNER JOIN
TRANSCRIPT ON TRANS_PAGE.transcript_Id = TRANSCRIPT.transcript_id
WHERE (TRANSCRIPT.imagesys_date IS NULL)
GROUP BY TRANS_PAGE.image_path
HAVING (COUNT(TRANS_PAGE.image_path) > 1)
Then cleared out all the duplicates. "
This page was: Helpful |
Not Helpful