Cardbox for email archives
Discussion of the use of Cardbox to archive emails
Discussion of the use of Cardbox to archive emails
If you want to discuss using Cardbox to archive email messages then please reply to this message.
Is there a similar program for archiving Outlook emails in Cardbox?
I would also be interested in a soluition on this.
Log time ago I programmed such a thing in VBA Outlook 2000 macro's which was very useful.
For Outlook, there is half a solution at http://www.cardbox.com/support/kb/emailOutlook.htm
This is an Outlook macro that exports the contents of an Outlook folder in Cardbox's "External" format, from which Cardbox can import it into a database. The web page also contains the format file for that database.
LIMITATIONS: As it stands, the sample macro can only handle received emails, not sent ones. Bert, you will find that you don't get security warnings... so perhaps you could investigate ways of improving the macro to get round more of Outlook's limitations?
I deliberately haven't gone into the question of how to play an Outlook macro from within Outlook. We make Cardbox, not Outlook, and if we had written Outlook we would have written it differently!
Interesting! That is challenging!
The macro as displayed did in my situation work after two changes:
(Outlook 2000 220.127.116.1111)
Is is an interesting macro (but I will still search a solution for saving msg files including attachments). But that is future.
Thanks and regards
I have lately been working on a solution of my own to the problem of archiving emails and attachments in Cardbox.
I am using a separate program to download the emails with attachments from Outlook.
This program will download emails from Outlook in a variety of formats. My chosen format is comma delimited. There was a problem with this initially as unlike most download formats available in Amber Outlook Converter the CDL download did not download the attachments. At my request this has now been changed.
The attachments are downloaded to a sub-folder of the folder to which the CDL is downloaded. There is still one remaining problem, which the suppliers are again working to overcome, namely that the CDL format, unlike the other formats, does not include the name of the attachment in the records.
This has the advantage of getting round the potential problem of duplicate attachment names. It will then be easy to identify and open the relevant attachment directly from Cardbox.
I use a very similar procedure for dealing with electronic documents.
This may not be a solution for anyone else, but I thought I would share it nevertheless.
Mary, that sounds excellent. I've downloaded the trial version of the Amber Eudora Converter and given it a quick test. To convert a Eudora folder you open it, select all the messages, choose an output format and say "Save As".
- There's an inconvenience in that the actual text of a message uses "%c%n" to separate the lines, and so the records need to be batch-edited in Cardbox after they've been loaded.
Nevertheless this is a very sound strategy: we concentrate on Cardbox and email specialists concentrate on email conversion.
There's another "half a solution", which needs no external programmes. Simply export the folder of your choice from Outlook to an Access database (File, Import/Export). You can tell Outlook to export only soecific fields in the same way that Cardbox exports only the fields that you choose. Read the database into Cardbox and you're done.
I have solved this problem when testing with the following Cardbox macro:
The line and paragraph formatting of the original is then retained.
It would be quite easy to build this into the Load Email script.
Re: Using Access
Using the Amber Email conversion programs, which can, like Cardbox, be driven by an external Script, the whole operation of downloading the emails, loading them into Cardbox, identifying the attachments etc could be controlled by a single external script. The script could be called from within Cardbox using a Cardbox macro to launch it.
Incidentally what drove me towards Amber Outlook in the first place was the fact that if you export emails from Outlook the date field is not included in the specific fields for export, and the date is not actually exported (I have tried this with various Outlook export formats, though not with Access).
Has anyone else encountered that problem and found an easy way around it?
Mary, I don't use Access either. You don't need to have it to export from Outlook to an Access database. But I'm afraid this format too does not contain the date. So I guess it's was a worthless suggestion :)
Without actually trying it, the omission of the date in Outlook downloads is not something one would anticipate. I cannot understand the logic behind the date not being downloaded. It is a fairly crucial part of an email for all sorts of reasons.
Update to my earlier email:
The CDL download format
Re: Cardboss's test of Amber Eudora Converter
I have previously downloaded all my emails from Outlook so that I could at least have a good way of searching them. All the dates reproduced accurately, so I have no idea why this problem is occurring. I double checked my file by searching for 31/12/1899 and found no records. Would it have to do with the format of "sent" dates in Eudora? If interested in using the Amber converter program it would be worth discussing it with Yernar Shambayev (ProcessText Group) [ firstname.lastname@example.org ]. As you can see, they are very quick at responding to problems and suggestions for improvements.
I have Martin of Cardbox to thank also of course, as about a year ago he adapted Cardbox to read multi-line CSV files in order to facilitate me for the purpose of importing my emails.
Now all I have to do is put the final touches to my script and download my emails again, with attachments.
Regards to all.
If this is what you really need... email@example.com
|© 2010 Cardbox Software Limited|