Re: [Tracker] Cleanup of sqlite files

[Jamie McCracken <jamiemcc blueyonder co uk>]

Laurent Aguerreche wrote:
> Le vendredi 06 octobre 2006 Ã 00:26 +0100, Jamie McCracken a Ãcrit :
> > Laurent Aguerreche wrote:
> > > Le jeudi 05 octobre 2006 Ã 11:02 +0100, Jamie McCracken a Ãcrit :
> > > > Laurent Aguerreche wrote:
> > > >
> > > > > I propose a patch that works for Evolution.
> > > > Thast great
> > > >
> > > > just one thing :
> > > >
> > > > could you add the uri field to the MailMessage struct please (we also 
> > > > dont need the ExtraFields stuff).
> > > Done.
> > thanks have now applied
> >
> > > > > For Thunderbird, I can't currently figure out what "ID" in uris is...
> > > > > I'm investigating.
> > > > is it not the MessageID field of the email?
> > > I am not sure. Beagle seems to parse Inbox.msf files to find IDs.
> > I looked around but could not find any info on the format of 
> > thunderbird's email uri
> >
> > FWIW, Im 99% sure the MessageID email field is used in the uri because 
> > looking at the mbox file its the only value unique for an email and the 
> > combination of folder + messageID is globally unique.
>
> It is possible but I don't find id...
>
>
> > Im also sure the msf files are indexes to the mbox file and contain 
> > message Ids in them
>
> Indexed to the mbox file?
>
> Beagle seems to use these files: Mork files. But they are really awful:
> http://en.wikipedia.org/wiki/Mork_(file_format)
>
> I hope there is code somewhere to parse those files...
>
> Currently I am waiting Beagle for indexing Thunderbird's emails and then
> know what URIs look like.

okay great!

> > note it seems only the latest versions of thunderbird support the email 
> > uri (I get "email is not a registered protocol" if I use email:///)
> >
> > so for now use the folder name (ie Inbox) + MessageId as the uri
>
> $ thunderbird
> "mailbox:///home/laurent/.mozilla-thunderbird/idk93817.default/Mail/Local Folders/Inbox;number=1"
>
> But number is?
>
>
> > Btw thunderbird handler does not index vfolders. thunderbird stores the 
> > email for a vfolder in the corresponding vfolder mbox and *not* the 
> > Inbox file.
> >
> > Your code only looks for Inbox and Sent but it should look for all files 
> > without an extension in that folder to pick them up (and they can be 
> > created or deleted too!)
>
> I don't understand. Thunderbird doesn't store all emails in Inbox and
> Sent?

Depends. If you right click on local folders and create a new folder and 
then apply filter rules to move matching incoming mails to them then no 
it wont store them in Inbox.

EG I have a folder called tracker in Local Folders and all mails that 
contain tracker in the subject line are stored there. These are stored 
in the file  "Local Folders/tracker" and not in Inbox.

All the mbox files in that directory have no extension so it should be 
possible to pick them up. (and ignore default ones like Drafts and 
Unsent etc)


--
Mr Jamie McCracken
http://jamiemcc.livejournal.com/