You are viewing limited content. For full access, please sign in.

Question

Question

How can I search for images over 16384 pixels wide or tall?

asked on September 21, 2015

The answer to this question, https://answers.laserfiche.com/questions/73188/Is-there-page-length-limit-to-Photodocs , has led me to another.

When I reprocess an entry with PhotoDocs and the entry has a page over the 16384 pixel limit, PhotoDocs does not import that page. When I return the document to the repository, the ignored pages are silently sent to the Recycle Bin. I happened to notice this because I was working with a set of 33 entries that all had 11 pages, but PhotoDocs showed only 361 entries instead of 363.

I would like to search the repository for any entries that have these "oversize" pages so that I can set them aside for separate processing.

I am using LF Client 9.2.0.472.

Thank you for your time.

Regards,

Ed Turner

0 0

Answer

SELECTED ANSWER
replied on September 21, 2015

Laserfiche doesn't have a built-in way to search for images with certain dimensions, but you can use a direct SQL query of your repository's database. The "doc" table in a database for a LF repository contains one row per page. There are columns which store the width and height of any corresponding image file, in pixels. Please note that for a variety of reasons these columns might not be filled in correctly for all pages, but it's a good place to start.

Here's a sample query which will return all the entry IDs for documents which have an image page with a dimension that exceeds 16384:

 

SELECT DISTINCT t.tocid
FROM doc d JOIN toc t ON d.tocid = t.tocid
WHERE toc_flags & 2048 = 0 AND pagenum >= 0 AND img_size > 0
AND (img_width > 16384 OR img_height > 16384)
2 0
replied on October 21, 2015

Thank you very much Michael! This opens up a number of powerful queries to locate issues we are having with specific data.

0 0

Replies

replied on September 23, 2015

Thank you very much, Michael. I don't have direct access to the database, so I've passed the SQL on to those that do. Once I get a response from them I'll pass along the feedback.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.