473,322 Members | 1,510 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Paper Document Handling and Indexing.

zmbd
5,501 Expert Mod 4TB
Looking for a few examples of paper document management.

What I've found on the internet are either nothing along the lines of what I'm after, or they are commercial applications. I initially started out with a library template; however, that has quickly fallen apart as it wasn't designed with this material in mind.

I inherited 7x4-Drawer file cabinets, 3x3Shelf Bookshelves, 3 banker boxes (originally 8 banker boxes) of mixed stuff, and a hodgepodge of unknown logbooks and binders.

I have text/reference books, white/research papers, catalogs, and the many (and I mean many many many) file folders that contain a month’s work of data for each type of data group (just for reference say: daily batch sheets; daily final sheets; daily test a results; daily test b results; and daily test c results). Often the white/research papers are in hanging folders within the file cabinets either in their own folder or mixed in with the “daily_*” in the monthly folders.

As I said earlier, I started out with a library type database template. It just didn't work as well as I would have liked, it doesn't handle the monthly hanging file folders with the daily batch/test documents well. What I need to track is the information within the document(s) and the location - the hanging monthly files are the worst to track in that a single day's information may be pulled by a management member and then another will pull the entire month's information - currently tracked via sticky-note on the cabinet drawer! Oh, and to make this extra special, the data is routinely removed for archive or the shredder. The Lib-DB handled the bookshelves very well… and treating the monthly stuff as a newspaper type item it was handling the daily stuff… OK, but not great.

I then started looking at the "Dublin Core Metadata Element Set", which sounded promising - but seems suited more for a flat-file using xml; however, the online is like reading modular furniture assembly instructions and the one reference file I downloaded is in "rdf" format and I can't seem to find a reader for it and Notepad just doesn’t do it justice.

So, slightly overwhelmed with tons of data ... now I'm looking around to see what else is out there as a starting point, even just a general schema-outline to get an idea of the tables, as I really don't see the company purchasing a commercial product for my little enterprise and the library database is a tad difficult to use for this situation.
Jan 28 '13 #1
2 1378
Seth Schrock
2,965 Expert 2GB
Sounds huge, but maybe my simple understanding can trigger something for you. I've not seen the library sample database so I have no idea exactly what you have tried either, but I'll make a stab at where I think you are having the issue.

As far as what information that is in the documents, I'm not sure what you are keeping track of. Is it the same information for each type of document? If the information is the same, then everything should be able to go into the same table with an additional field to specify the type. Hopefully this is possible as I think this would make the checking in and out easier. If not, no big deal.

You mention the problem of one person taking a single day, and then another person could take the whole month. Not sure if this is important or not, but the person who takes the whole month, are they missing the day that was taken earlier? If so, then I think that the file containing the whole month needs to be seen by the database as a group of separate days instead of one record. My idea for how to check this out is to enter a date range of records to pull instead of selecting a record to pull. So for example, lets say I take the file for 1/12/13 and then you take the month of January. So when you check out mine, you just specify 1/12/13 and assign it to me. You then check out the month of January and specify the range of 1/1/13 to 1/31/13. When it pulls this range, I would use an update query that has a WHERE clause of Checked_IN_Status = "IN" to update them to be assigned to you. Mine wouldn't be included in this list because mine would have a status of "OUT".

I'm sure I'm over simplifying this, but I know from experience, most of the times that I get overwhelmed with trying to figure something out, I need someone to simplify it for me to see clearly. Hopefully something I've said has triggered an idea. Let me know if I totally missed your question :)

Sorry, I don't have any sample databases to offer you, but if my idea sounds interesting, I could whip something up to demonstrate what I was thinking of.
Jan 29 '13 #2
zmbd
5,501 Expert Mod 4TB
Seth,
Yes the project seems quite large.
Documents... as noted are a mixed bag of information.
Take the Bookshelves: The textbooks range from chemical, physics, and engineering to microbiological. Some just reference tables, some with theory, and yet others that offer testing methods only. The library circulation program handles this material fairly well and the binders too as they are usually in that same realm as the books. The Testing folders, within a folder, the same paperwork for a given test for a given month.

As you've noted, I handle each paper within the monthly folder as an individual dated periodical within the library program. I had to add the largest numbr or queries.
I guess that overall the circulating library database does an adequate job of it, once I added a few queries and reports to handle the otherwise 100's of hand entries to checkout/in individual papers.

I'm not really in love with the categories, even though I've changed them.
I'm not really in love with the document ID's as they are based on the Dewey decimal and "periodicals" are not handled the best via this system
I really do not have a good location of documents via the DDs in that the monthly folders cycle thru the file cabinet drawers (as one empties due to archive, another fills and when full the next is cycled thru and so on; thus, the labels continually move as to what is where and if I need to relocate a document from one file cabinet or folder to the next, then I must issue a new DDN specific to that drawer/binder/folder, location otherwise I won't be able to locate it.
Jan 29 '13 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: C | last post by:
Hi, I currently use MS Indexing Service to search my htm and aspx pages. I recently downloaded the IFilter tool from Adobe. When I now do a search it still does not pick up any text in my...
2
by: Dan Williams | last post by:
Does anyone know of any Windows software to scan the same paper document and enter the results to an SQL Server database? We have a Photocopier machine that can automatically scan several...
2
by: Brian Idzik | last post by:
I've successfully setup a xhtml 1.0 strict page with Mozilla & Netscape to display links in a toolbar into an internal <div id='content'> within the same document. The toolbar uses some...
3
by: chandra.somesh | last post by:
Hi I am having problem indexing large amount of textual data(in range of 200,000 to 1 million). I tried using map container but the compiler just hanged upon entering the data. On bit of...
108
by: Bryan Olson | last post by:
The Python slice type has one method 'indices', and reportedly: This method takes a single integer argument /length/ and computes information about the extended slice that the slice object would...
1
by: Tim Schaefer | last post by:
Hi, I'm looking for some independent comments on this white paper either here or off-line. http://otn.oracle.com/deploy/performance/pdf/CWP_9IVSDB2_PERF.PDF If you want to contact me...
0
by: volume | last post by:
Hi all, In an effort to try to impress the boss, I would like to log accounting information to an Excel spreadsheet using C# and .NET. This would be a mockup only, not a real solution - yet! We...
6
by: Bob Alston | last post by:
I am looking for others who have built systems to scan documents, index them and then make them accessible from an Access database. My environment is a nonprofit with about 20-25 case workers who...
3
by: Chung Leong | last post by:
Here's the rest of the tutorial I started earlier: Aside from text within a document, Indexing Service let you search on meta information stored in the files. For example, MusicArtist and...
44
by: Kulgan | last post by:
Hi I am struggling to find definitive information on how IE 5.5, 6 and 7 handle character input (I am happy with the display of text). I have two main questions: 1. Does IE automaticall...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.