Re: [Evolution-hackers] Labels when using Evolution EWS

[Andrew Seguin <aseguo gmail com>]

Thanks for your response,

I used your tip regarding the SQL query, it was helpful to get a clean
list of labels as Evolution saw them (which was identical to how
Outlook saw them, but I had forgotten to add a couple).
All my labels were categorized/labeled with simple English terms,
a-zA-Z was the only character range in use.
For the archives, I used: sqlite3 folders.db "SELECT labels FROM
'inbox'  WHERE labels NOT LIKE ''" | sed "s/ /\n/g" | sort | uniq # to
get a simple list

I managed to figure out a workaround for my situation at least:

My labels all start with a capital letter. I set the labels on one
mail via Evolution, with labels that come originally from Outlook and
of which one is normally colored red in Outlook. After, I peaked at
that mail through the Outlook web interface - it showed the label, but
not the color, and I noticed it didn't have a capitalized first letter
("Solutions" became "solutions"). It seems the case wasn't respected
while the mail was sync'd back to exchange. Funny thing is that the
full Outlook client treated "solutions" just as "Solutions" in terms
of search folders and category color without problem. In the Inbox
cache of Evolution, the labels were properly listed with a first
letter capital.

I changed my labels in Outlook to start with a lower case (selecting
all mails to make sure they were updated), recreated the list of
labels in Evolution to match, and the labels now show up.

This leaves me wondering if this is expected or not? What little of
the Evolution-EWS code I read that was closely working with the
labels, I don't see that it should have influenced the case, so - is
it Evolution or the Web services interface Exchange that might be the
one changing the case? I will try in the near future to debug this a
little further and I'll open a bug if I can bring this down to
something within Evolution's code.


Again thanks for the tips,
Andrew



On Thu, Jan 5, 2017 at 5:08 PM, Milan Crha <mcrha redhat com> wrote:
> On Thu, 2017-01-05 at 15:55 +0100, Andrew Seguin wrote:
> > I tried creating labels in Evolution with the same names as those
> > used in Outlook, without any difference in Behavior.
>
>         Hi,
> right, that's the way it works. The Labels column in the message list
> shows only those labels which are known to the evolution. There is
> currently no way to show all known labels, or which are set up on a
> particular message, in the UI.
>
> Going very low level, as you indicated that you can read the code,
> search your
>    ~/.cache/evolution/mail/
> folder for the one which contains a folder-tree file, that's for your
> EWS account. Beside this folder-tree file is a folders.db file, where
> is stored the information you can see in the message list, including
> the labels. Open this folders.db file and check what the 'labels'
> column in respective tables contain. You can do also something like:
>
>    $ sqlite3 folders.db "SELECT labels FROM inbox WHERE labels NOT LIKE ''"
>
> The labels are separated by a space. Once you've defined the same in
> the evolution then it should start to recognize them. There are issues
> with encoding and spaces/underscores, though your examples seem to be
> simple ASCII letters only.
>
>         Hope it helps,
>         Milan
> _______________________________________________
> evolution-hackers mailing list
> evolution-hackers gnome org
> To change your list options or unsubscribe, visit ...
> https://mail.gnome.org/mailman/listinfo/evolution-hackers