Re: [SL] Associate scanned images with invoice?

[C. D. H. <Du...@Du...>]

Mark Lubratt wrote:
> I just suggested almost the exact same thing on the feature request  
> part of the SL website.  I'd like to store PDFs of received POs from  
> our customers and have them linked to our sales order..
>
> Dieter didn't sound too interested. He said that would take up too  
> much space in the db. He also suggested that you can store the  
> scanned images on the server in the HTTP tree and put a hyperlink in  
> the notes section of your transaction.  Then, when you do a report,  
> include the notes and you'll have a link to the scanned image.
>
> I agree with you though.  I'd like it in the database with the  
> safeguards the db provides above and beyond what the file system  
> gives you (including backup).
>
> Mark
>
> On Dec 4, 2006, at 10:04 AM, Mark Bucciarelli wrote:
>
>   
>> Is anybody stored scanned images of receipts and associating them
>> with customer invoices?  I bill for expenses sometimes and would
>> like to have a complete record on file.
>>
>> If not, any clever ideas for a way to do this without much fuss?
>>
>> I'd like to put images in the db, so the built-in backup function
>> really get's me backup of all data.
>>
>> Thanks
>>     
I never understand the argument about storing images / blobs in the 
database.  Yes, they are big.  Yes, they do take up alot of space.  But 
if you don't store them in the database, and you end up storing them on 
a share somewhere what are you saving?  Just the overhead of the 
indices?  Maybe a little more.  And you're having to add more software 
into the mix to manage them.  I'd gladly trade a little extra space to 
make something easier or to manage.  While I don't want to store scanned 
images of receipts my vote would be to put them in the database.  While 
we're at it allow images of parts, and explosion diagrams / parts lists 
for assemblies!

Dunc