Post processing options for Real Jock mail download

  • Posted by a hidden member.
    Log in to view his profile

    Dec 14, 2011 7:10 PM GMT
    After Chris makes the text file download available, I was thinking of some options to process the text file and create an easy to use, powerful app to manage the mail. If there are any unique identifiers associated with each email, then occasional text downloads could be made and the app could ensure to not store duplicates.

    First thing that came to mind was MS Access, but the problem is it doesn't run on the Mac.

    With Filemaker Pro Advanced Version 11, you can build an application that will run on either a PC or Mac. You can distribute the runtime without limits so there are no license issues for the users. With the one license for the development environment, the system can be installed on two machines, e.g. a Mac and a PC, required to compile the application into a runtime version for each OS. Then the runtimes can be freely distributed. The cost on Amazon is $290.

    Another option would be to use something like MySQL.

    I could build this, but was thinking to put the idea out there in case someone else has more time and motivation to do it. I think the time and $290 investment might be recouped by charging a few dollars per copy or distributing as shareware, with optional donations.
  • Posted by a hidden member.
    Log in to view his profile

    Dec 18, 2011 2:47 AM GMT
    Just make the text file format match a Unix mailbox file.
    And allow separate download for sent & received.

    Then us Unix geeks could:

    mail -f rjinbox
    or
    mail -f rjsent

    What more could you possibly want? (:
  • Posted by a hidden member.
    Log in to view his profile

    Jan 11, 2012 7:32 AM GMT
    Notice that the message at the bottom of the inbox said:
    Click here to request a text file containing your old emails.

    After which:
    Your request for a text file containing your old emails has been received. A link to the file will show here within the next 48 hours.

    Any word on the format?
    For how long is that link valid?
    Will that include all emails in the mailbox currently or just emails older than 180 days?
    What is the long term strategy? Either in 180 days or 1 day when there are now more emails about to expire?
  • Posted by a hidden member.
    Log in to view his profile

    Jan 15, 2012 5:23 PM GMT
    Caesarea4 saidJust make the text file format match a Unix mailbox file.
    And allow separate download for sent & received.

    Then us Unix geeks could:

    mail -f rjinbox
    or
    mail -f rjsent

    What more could you possibly want? (:

    If the text format doesn't match a Unix mailbox file, it would be interesting to consider some text processing program to put it in that format. Also, do you know if there are any programs with identical functionality that run natively on the Mac or PC? I guess the Mac with its OS kernel would not be too much of a leap, but interacting from the Mac interface would be nice.

    ADDED: Just saw my file is available and downloaded it but have not analyzed it in detail. First line indicates format:

    SENDER,DATE,SUBJECT,BODY

    Only saw one email from me indicating me as the sender, but not indicating recipient. Also just loaded it in Mac TextEdit, so for what it's worth areas of unreadable characters.
  • Posted by a hidden member.
    Log in to view his profile

    Jan 16, 2012 12:49 AM GMT
    Yeah, saw that but didn't really have a chance to study it.

    I'm going to miss the "view mail history". icon_sad.gif
  • Posted by a hidden member.
    Log in to view his profile

    Jan 16, 2012 1:17 AM GMT
    TheGuyNextDoor saidWow,, I just download the file.. it's ONE Long Sentence... that's over 4 years old.
    One long sentence!

    I think it can be parsed, but I just looked at in TextEdit, which is not designed to analyze it by any means. There are some characters that don't show up, so don't know what the whole thing looks like, but I would have preferred each message to include both sender and recipient. If it is as it appears, at least for the only 1 sent message, it only had the sender, me.
  • Posted by a hidden member.
    Log in to view his profile

    Jan 16, 2012 2:02 AM GMT
    There are embedded newlines (n) and returns (r) in the file, which is a comma delimited list with text fields protected (within) quote marks.

    Just tried and you can import into into Excel (Data, From Text", Comma Delimited, Comma).

    * It appears only to be the inbox, not sent email.
    (So I guess the "to" field isn't vital, unless it was group email?)

    * Unread emails are not included.
    (Sometimes I don't bother reading "You have been..." messages.)

    * Sort is by Sender.

    * Emails in Hebrew aren't showing right, but that could be an Excel issue.

  • Posted by a hidden member.
    Log in to view his profile

    Jan 16, 2012 2:32 AM GMT
    There were two emails that I sent that somehow were included. Also noticed nothing prior to late May 2010.