I'm looking for a way to assign sequential batch numbers to documents. I need to assign a batch number to sets of 400 documents, increasing the batch number by 1 for every 400 documents. For example, documents with entryID's 1 through 400 would be assigned batch# 1, 401 through 800 batch# 2 and so on. I'm thinking this could be done via a stored procedure or query but am looking for ideas.
Question
Question
Laserfiche Challenge, Assigning "batch" numbers
Answer
Thinking about this in terms of entry ids is the wrong approach. Entry ids are not guaranteed to be sequential (there can be gaps in some circumstances) and they are global, so that you don't know that other users can have their documents in the range.
Hi Brian,
Thanks for the feedback. I do agree with you in most cases. In this instance, the repository is dedicated to a single document type and is not shared across the organization. I'm basically looking for a way to track new documents, since the documents are all going to be single page docs, i'm looking for a way to "batch" in sets of 400.
Replies
How is the batch of documents defined? Is it in Laserfiche already and you're looking to reprocess existing documents? Are you looking for a process to handle new documents?
Hi Miruna,
Thanks for your response. These will be new documents and will be scanned in via a Quickfields session exclusively. I was hoping to use something like Bates Numbering but am unsure of that because I think the Bates numbering would reset each time it was used.