08-20-2011 10:27 AM
Okay, this is a good conversation.
John had a couple more questions that have not yet been address in this thread:
" - If I wanted to purge older attachments, what is the best way to do this?"
" -Can I just delete raw files, which I assume would simply leave an orphaned file reference somewhere in the database, or is there a better way?"
I would like to hear any comments you might have on these two issues Mike.
LESSON LEARNED: You need to back WITH attachments if plan to import/export data to a new DB.
08-20-2011 06:49 PM
I have a client with 70k plus of attachments and after the backup would not finish then resorted to backing up seperately and we have tested a restore. I think Sage has failed in this area badly as there are some practial limits and now with the SQL version being some 6 years old some clients do have 20k plus attachments and it is becoming unworkable while there is no mention of limits in documentation.
My own feelings moving forward is in two parts
a) Backup database without attachments
b) The attachment folder needs to be better in either creating a folder based on record ID and putting relevant documents in this folder somthing like iTunes does for Artists when it stores songs which means you do not push the boundaries of the operating system. These need to then be backed up.
In regards to storing emails this is becoming a problem for everyone. I find one of the best methods is to drag the email directly from Outlook to a folder and by doing so maintain it is Outlook format although I wonder what email system might we be using in 5 years from now.
As far as storing the message in plain text I do not find this a suitable method as this does not maintain the context of the original email.
08-21-2011 02:29 AM
pbuchtmann wrote:As far as storing the message in plain text I do not find this a suitable method as this does not maintain the context of the original email.
Actually, it maintains it the same as attaching the email, except the emails are searchable
08-29-2011 04:27 AM
Mike in plain text you cannot open the email and forward directly or reply in the original context that it was received was what I was pointing out
08-29-2011 12:53 PM
08-29-2011 05:48 PM
Mike I find that many clients are finding they need to either clean up their Outlook because of the size but also don't have exchange server so are beginning to delete from Outlook and so having in ACT as an Outlook message is a big bonus BUT
Because of the design of keeping all attachment sin a single folder this does cause its own issues
08-29-2011 06:03 PM
08-29-2011 06:10 PM
But... having it in ACT means any user can view the email and replay or forward it.
Having in it Outlook means a user can read the text but cannot reply or forward the original email - not can he see the attachments (unless hte user manually attaches the attachments to ACT of course).
Just me take on it...rd
08-29-2011 06:12 PM