Re: [U2] Document Management

2011-07-25 Thread Bob Rasmussen
Doug, If your solution is 100% web-based, are you doing scanning on the web client? If so, how do you accomplish that? On Sun, 24 Jul 2011, Doug Averch wrote: [ad] We wrote a document management system about 5 years ago. We sell it with our CRM system as a way to store documents, images,

Re: [U2] Document Management

2011-07-25 Thread Doug Averch
Hi Bob: Most documents you receive today are from emails, XML, CSV, Excel, Word, or even X-rays. Even if you receive a paper document almost every office has a copier and scanner were the documents are deposited on a network drive. They are already digital so you can find them on the network or

Re: [U2] Document Management

2011-07-24 Thread Ross Ferris
Tony, Drop me an email - we have a system in Visage that might fit the bill. Actually we have done a few different varieties around the same theme, and have integrated aspects of this across our R5 ERP system, so people can store an original faxed order and a scanned copy of signed invoice for

Re: [U2] Document Management

2011-07-24 Thread Kathleené M Hunter
: Sunday, July 24, 2011 6:39 AM To: U2 Users List Subject: Re: [U2] Document Management Tony, Drop me an email - we have a system in Visage that might fit the bill. Actually we have done a few different varieties around the same theme, and have integrated aspects of this across our R5 ERP system, so

Re: [U2] Document Management

2011-07-24 Thread Doug Averch
[ad] We wrote a document management system about 5 years ago. We sell it with our CRM system as a way to store documents, images, contracts and emails. The document management system, however, can be sold stand alone as well. It is 100% Web based and can run on Universe or Unidata. One of our

Re: [U2] Document Management

2011-07-23 Thread Jeff Schasny
Check out 1mage http://www.1mage.com/ On Fri, Jul 22, 2011 at 3:17 PM, Tony Gravagno 3xk547...@sneakemail.com wrote: It looks like your responses, including mine here, are unanimous - it's preferred to store blobs outside the DB and metadata inside.  I see no benefits to storing blobs in the

Re: [U2] Document Management

2011-07-23 Thread Scott Richardson
Hello U2-ers, Has anyone checked out the CoStar product from KeyNet, Inc? http://www.keynetinc.com/ Sorry, I'm a little late into this thread - but, from what I've been reading in the thread, sounds like you should all be checking out this company and product. They've been doing this for a

[U2] Document Management

2011-07-22 Thread Bill Brutzman
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

Re: [U2] Document Management

2011-07-22 Thread John Thompson
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

Re: [U2] Document Management

2011-07-22 Thread Robert Porter
-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

Re: [U2] Document Management

2011-07-22 Thread Holt, Jake
. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, July 22, 2011 10:35 AM To: U2 Users List Subject: Re: [U2] Document Management I would say its more dependent on the OS than the database

Re: [U2] Document Management

2011-07-22 Thread Rick Nuckolls
I would not store blobs directly in a U2 file. All it would take is one use of ED and an inadvertent “file” to corrupt it. Using a plain WRITE statement to put a blob into a type 1 or 19 file may well corrupt it. An alternative using U2 is to use the sequential file statements of WRITEBLK

Re: [U2] Document Management

2011-07-22 Thread Wols Lists
On 22/07/11 17:46, Holt, Jake wrote: 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 :) ** The filestream option in sql server is

Re: [U2] Document Management

2011-07-22 Thread Brian Leach
Actually, Wol's right: the filestream option in SQL Server is just an entry point into the regular Windows file system, so in effect it's no different from using a type 19 directory. Brian ** The filestream option in sql server is designed specifically for this task. But how does it manage

Re: [U2] Document Management

2011-07-22 Thread Wols Lists
On 22/07/11 18:11, Brian Leach wrote: Actually, Wol's right: the filestream option in SQL Server is just an entry point into the regular Windows file system, so in effect it's no different from using a type 19 directory. I didn't know that :-) So if you're using a filesystem that's naff at

Re: [U2] Document Management

2011-07-22 Thread Bob Rasmussen
- 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

Re: [U2] Document Management

2011-07-22 Thread Robert Porter
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

Re: [U2] Document Management

2011-07-22 Thread Tony Gravagno
It looks like your responses, including mine here, are unanimous - it's preferred to store blobs outside the DB and metadata inside. I see no benefits to storing blobs in the DB and lots of reasons not to do so. I wrote a blog a while back on signature capture, which I implemented much like Rob