The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Storing Approved documents readonly
Posted: 01 Feb 10 4:32 PM
|
I have a requirement to "electronically" approve documents in SLX and then once approved they become read-only. Just wondering what would be the best way to accomplish this. Do I convert to a PDF and save to an attachment folder and password protect these when saving? Or can I stream the document into a blob field which I don't allow updating. Or are there other options you can suggest?
Thanks in advance
Leon
SLX V7.2 LAN |
|
|
| |
| |
|
Re: Storing Approved documents readonly
Posted: 18 Jun 10 1:58 AM
|
Any recommendations on compressing the data when streaming the files in? I believe SQL 2008 does this at the database level so should i even worry if we will eventually migrate to 2008. Or is there a standard way to compress/decompress?
Thx
Leon |
|
|
|
Re: Storing Approved documents readonly
Posted: 18 Jun 10 2:11 AM
|
Have you sized your DB growth with this approach?
How big is your typical document once Converted to PDF and Compressed? How many documents do you expect to store yearly?
Do you have enough space to hold such table in your DB Server?
Now, regarding Compressions, I have used the ICSharpZipLib in the past to Compress/Decompress documents using Standard Zip compression (although it supports additional Compression schemes). |
|
|
|
Re: Storing Approved documents readonly
Posted: 20 Jun 10 8:03 PM
|
Thanks Raul - I'm expecting most docs should be less than half a MB however it is possible there will be some quite large PDF's (not supposed to be a lot of them) Estimated up to 1000 docs /year. Just thinking worst case scenario and impact on performance (if any) and anything I should be aware of or plan for in the event size and amount of documents are underestimated. Hardware is not an issue for us at this stage.
|
|
|
|
Re: Storing Approved documents readonly
Posted: 24 Jun 10 8:36 PM
|
Am I able to open a file from a stream without saving it to a physical location first? I'm using the below code.
Thx - Leon
If rs.RecordCount > 0 Then
Set stream = CreateObject("ADODB.Stream")
With stream
.Type = adTypeBinary
.Mode = adModeReadWrite
.Open
'write field value to stream
.Write rs.Fields("APPROVEDVERSION").Value
'*****save stream to a file*****
.SaveToFile strfilename , adSaveCreateOverWrite
.Close
End With
Set stream = Nothing
OpenStreamECM = strfilename
End If
|
|
|
|