Question

Comparing page count to field value

Laserfiche

Updated July 9, 2015

asked on July 9, 2015

We exported about 500,000 files from another DM system and imported them in to Laserfiche. One of the fields we created and populated on the LF template attached to all those docs was a page count value from the old DM system, i.e. the number of pages that should have been in the exported document. We're finding discrepancies now between what actually got exported (an exporter bug from what we've seen so far) and the actual pages that are in the documents stored in Laserfiche.

I need to find all the docs with missing pages, and thought I could create an advanced search to simply compare the Laserfiche page count to the field containing the page count from the old system, but no luck. Doing something like [Pages] <> LF:PageCount doesn't work.

Short of using Workflow, anyone have any suggestions on an easy way to compare the Laserfiche page count with my [Pages] template field on a per-doc basis to generate a list of incomplete docs?

0 0

Replies

replied on July 9, 2015

If workflow is out of the question, then my recommendation would be to add the two columns in a search pane, Page Count and your metadata field with page count in them. Make sure to only have those two selected as each field can increase load time and 500k items is a lot. You may need to break it into subfolders. Then, File --> Export List --> Save as a CSV and then load into Excel. From there use the Excel Remove Duplicates button.

3 0

replied on July 9, 2015

Great suggestion, thanks! I created a workflow to pull the info but running it against 500,000 docs was going to take a really long time, so I cancelled it and tried your idea. Took maybe 30 minutes to export everything I needed and check all 500,000 docs, so a great timesaver.

Now if you just had a fast way for me to fix the 6,784 docs that have missing pages I'd be all set!

Thanks again!

Geoff

0 0

You are not allowed to follow up in this post.

Question

Question

Comparing page count to field value

Replies

Sign in to reply to this post.