Rob, First, twain dot net does not appear to be correct.
Please send me your source. I have worked in the area of scanning and PDF production, and might pick up some tips. On Fri, 22 Jul 2011, Robert Porter wrote: > 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 <[email protected]> 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 > <[email protected]>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: [email protected] [mailto:u2-users- > > > [email protected]] 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 > > > [email protected] > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > > U2-Users mailing list > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > Regards, ....Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: [email protected] company e-mail: [email protected] voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
