David C. Rankin wrote:
Listmates,
We have global and sub categories for attorneys and cases like:
Clients
Bertin
Joint-RG
Rankin
Auto
Commercial
Family
Products
MedMal
In the addressbook category tab, the category listing is messed up so
you get duplicates of the same thing with (1) the category title listing
the sub, indented, as it should and (2) then a second listing of the
category in “global, sub” format below. For example, the Joint-RG
category gets listed in the category list both as:
“Joint-RG”
“Clients, Joint-RG”
This bug is fairly recent, I don’t know exactly when it was introduced,
but I bet it was in the past few weeks in trunk svn. Here is a
screenshot that will show what is going on (picture worth 1000 words):
http://www.3111skyline.com/download/screenshot/egw/egw_catlist_duplicated.jpg
I couldn’t get it all in one screenshot so I have one above and one
below to show the behavior. Let me know if I need to file a bug report
or if posting will be good enough. Thanks!
uwered wrote:
We get the same failure with my trunc-installation of eGW.
The failure exists until we sync via FUNAMBOL with MS-Outlook.
After some tests we found out, that the sync generate the category “main,
sub” when
the eGW-entry has market “main” and “sub”.
If the eGW-entry has only one category all is OK.
It seems to be a bug, but how resolve it ? No Idea
Greetings
Uwe
I have also forwarded this to the funambol folks so they can take a
look at the issue.
I don't know about resolving the bug, but here is how I cleaned up the
egw_categories table. First all of the extra funambol main,sub
categories have been added under the cat_appname column with the value =
‘addressbook’. Why this was done when my funambol was set to
"egw->Funambol only’ doesn’t make sense. To fix your egw_categories
table, take a look at new categories that were created with the following:
select cat_appname, cat_name from egw_categories where
cat_appname = ‘addressbook’;
This unordered select will show all the new categories at the bottom of
the list.
NOTE, if you have added any addressbook categories, the will be listed
as well.
Since you can't just delete all entries with the cat_appname =
‘addressbook’, I used the following delete command to remove the 29
entries created by funambol. It took about 5 queries to remove them all.
Use a query like this:
delete from egw_categories where cat_appname = ‘addressbook’ &&
cat_name like ‘Vendors,%’;
NOTE the ',' included after 'Vendors'. This will prevent you from
deleting your addressbook category of vendors, but will get rid of all
the newly ‘Vendors, XYZ sub cat’. Just look at your egw_categores table
and modify the delete query as needed.
Funambol devs, is there a way we can prevent Funambol from adding
“main,sub” entries to the egw_categories on sync that would be great.
Right now, it can really cause problem with the additions. Let me know
if we can help.
–
David C. Rankin, J.D., P.E.
Rankin Law Firm, PLLC
510 Ochiltree Street
Nacogdoches, Texas 75961
Telephone: (936) 715-9333
Facsimile: (936) 715-9339
www.rankinlawfirm.com
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
