I've written a document manager where you can either load an document(PDF, Word, Image, Scan) into SQL server as a binary object and then load it up/display it accordingly. Initiall this was using VFP as a back end but this proved to be unworkable the size of the Blobs... our Document Database currently sits at 4Tb.
I've just added QR Code recognition so the paperwork that is filled has a QR code assigned to it identifying the job etc and once filled in it is scanned and then the QR recognition program posts it against the correct job. We moved away from having a database of documents held in discrete folders and an index database pointing to the document location in those folders as it was both insecure (documents could get deleted or moved without the index being updated) and fairly slow when lots of folders were cascaded etc. SQL sorts out the problem and means the data stays secure. Is that the sort of thing you want to do? Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Desmond Lloyd Sent: 16 August 2013 16:43 To: ProFox Email List Subject: VFP9: Document Management Good morning, Has anyone attempted to manage PDF's from a VFP application? Let's say a manufacturing system where everything is tracked by some sort of order number (Manufacturing and/or purchasing). I imagine a kind of "behind the scenes" kind of thing where a selection to print to the document manager or printing in general would output a PDF to a specific place on the server. Resulting in a set of documents being made available for a specific manufacturing or purchase order. Perhaps the creation of an index that would maintain a listing of the documents for the particular order. One could then link to the set of documents from a specific order display or via a separate "document management' interface. Thoughts, possible recommended tools for outputting the PDF, Displaying the PDF.... Regards, Desmond 8-)# --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
