Re: [Tracker] Cleanup of sqlite files

[Laurent Aguerreche <laurent aguerreche free fr>]

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.


> 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?

> However its not an urgent fix as Gnome uses Evolution in the desktop so 
> getting that perfect is more important.
>
> We also need to support at some point IMAP for Evolution as emails will 
> not be held locally in the Inbox in thoses cases (Beagle already handles 
> these).

Yes...



Laurent.