I just (this week) took a couple C# projects and created an executable callable by AccuTerm that interacts with a scanner and converts to JPG,BMP,TIF or PDF. It places the files in a network directory on the UV server which the calling program (UV side) picks up stores in a more secure location and attaches it back to the accession (for those outside of the lab, an accession is like an invoice - it holds groups of tests and results for a patient). The whole C# scanning side was using open-source TWAIN (twaindotnet) and PDF (PSFSharp) libraries and took < 2 days to work out. Let me know directly if you're interested in it and I can email the VS2008 project with executable. It's fairly flexible with many command line options like -adf/-noadf (auto document feeder), -bw / -color, -border/-noborder (auto border detect - if the scanner supports it), -ui/-noui (twain user interface), and my personal favorite -locked (locks all the controls on the gui to stop users from messing with settings!), etc. I can also send a snippet of how we're calling it from AccuTerm, but that's pretty trivial and documented in the AccuTerm help pretty well. Just email me if you want it... roporter -at ochsner -dot- org Rob Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful.
>>> John Thompson <jthompson...@gmail.com> 7/22/2011 10:34 AM >>> I would say its more dependent on the OS than the database. There are a lot of good free tools out there for PDF's, images, etc. on Linux. Most of the windows server stuff I've seen, you need a license for. There is also two ways to look a the whole scene of document management too. 1) Do you want to store actual images (ala PDF's, tiffs, etc.)? 2) Do you want to store the data that the documents contain and use that data to "reprint" or populate a from when you need it? The 2nd way is more flexible and easier to search through because its database driven. The 1st way is more annoying in my opinion, and usually gets used when a company has to have, the actual image of the document itself (for legal reasons or whatever). I would say SQL, etc. is no different than U2 when it comes to document management. Its all the tools around the database that is going to help get the job done for you. Use the database you know best :) On Fri, Jul 22, 2011 at 11:16 AM, George Gallen <ggal...@wyanokegroup.com>wrote: > I would store the pdf's in separate location (on or off the server) under a > unique > UV assigned filename. > > Then in the U2 database, store the original name, unique name, pathname and > any other > information. > > I'd use off server storage in case your disk space runs out, you won't > chance > crashing your U2 server. > > You can always connect your server to that location either via SMB / NFS / > mapped drive > so it can still appear to U2 as a local file if you need to get the actual > pdf data. > > > > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman > > Sent: Friday, July 22, 2011 11:10 AM > > To: U2 Users List > > Subject: [U2] Document Management > > > > Does it make any sense to use a U2 database to save scanned pdf's? > > That is... > > > > Does it make any sense to save small blobs in a U2 data base? > > > > Would a Type 1 file be best? > > > > Are there any advantages to using MS-SQL, MySQL, or some other database > > technology? > > > > --Bill > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users