My OperaThe My Opera forums have been replaced with forums.opera.com. Please head over there to discuss Opera's products and features
See the new ForumsYou need to be logged in to post in the forums. If you do not have an account, please sign up first.
Export mail to CSV
Opera is a fantastic mail client and RSS reader. Kudos to the team for allowing you to export your individual mails in .mbs format.I've spent the last few weeks trying to find ways to collate RSS feeds and export them into a spreadsheet format, and there is NO SIMPLE WAY of doing this that doesn't require at least a passing familiarity with Python or similar.
After evaluating options from Google Reader, Yahoo Pipes, Microsoft Outlook, etc., etc. I've finally settled on using Opera as my RSS reader, exporting my RSS feed content as an .mbs and converting the .mbs to .csv using a commercial application called Aid4Mail. This allows me to manipulate my RSS content with columns for sender, date/time, content, etc.
It would really make my week if I was able to do this directly from within Opera
3. November 2011, 14:33:22 (edited)
Originally posted by ervler:
This allows me to manipulate my RSS content with columns for sender, date/time, content, etc.
Could you expand on this further? What do you mean by "manipulate" exactly?
Are you just using the spreadsheet to analyze the data? Or, are you just sorting the entries? If the latter, what sorting options are missing in Opera that don't allow you to do this in Opera?
Also, by "csv", what specific csv format? There are zillion different ways to handle escapes and newlines and quotes etc. in CSV files.
For example, with a body of:
Line1 "Line2" Line3 \test\n
do you want this:
To,Subject,Body, test@example.com,test,"Line1 “Line2” Line3 \test\n"
or this:
To,Subject,Body, test@example.com,test,"Line1\n\"Line2\"\nLine3\n\\test\\n"
?
I'm looking for a way of sticking my mail content specifically into a spreadsheet format. Any CSV or Excel format would do.
It is useful for two reasons:
1) Provides a format-agnostic way of backing up and transferring your mail
2) It allows you to perform analyses on the content e.g. text mining and analytics (e.g. sentiment analysis)
I've spent a lot of time trying to work this out, and while Opera's existing functionality is far better than many other options, it still only gets me part of the way and I need to use commercial software to cover the final step.
Here's the earlier thread (between you and me funnily enough) that I started on this topic: http://my.opera.com/community/forums/topic.dml?id=1091702
It is useful for two reasons:
1) Provides a format-agnostic way of backing up and transferring your mail
2) It allows you to perform analyses on the content e.g. text mining and analytics (e.g. sentiment analysis)
I've spent a lot of time trying to work this out, and while Opera's existing functionality is far better than many other options, it still only gets me part of the way and I need to use commercial software to cover the final step.
Here's the earlier thread (between you and me funnily enough) that I started on this topic: http://my.opera.com/community/forums/topic.dml?id=1091702