Massimo Arnaudo
|
 Posted 2011-12-21 - 17:35
Hello,
i have a Funambol server with i can sync my contacts.
I made a test, so i have created a new Contact in my Funambol (First Name, Last Name, telephone number) and added new records in the table fnbl_pim_contact_item:
INSERT INTO `pippo`.`fnbl_pim_contact_item` (`contact`, `type`, `value`) VALUES ('-252305', '1', '01'), ('-252305', '2', '02'), ('-252305', '3', '03'), ('-252305', '4', '04'), ('-252305', '5', '05'), ('-252305', '6', '06'), ('-252305', '7', '07'), ('-252305', '8', '08'), ('-252305', '10', '10'), ('-252305', '11', '11'), ('-252305', '12', '12'), ('-252305', '13', '13'), ('-252305', '14', '14'), ('-252305', '15', '05'), ('-252305', '16', '16'), ('-252305', '17', '17'), ('-252305', '18', '18'), ('-252305', '19', '19'), ('-252305', '20', '20'), ('-252305', '21', '21'), ('-252305', '22', '22'), ('-252305', '23', '23'), ('-252305', '27', '27'), ('-252305', '28', '28'), ('-252305', '29', '29'), ('-252305', '30', '30'), ('-252305', '31', '31');
after that i synced Memotoo and i have found this result:
TYPE_HOME_TELEPHONE_NUMBER = 1; 01 telefono casa
TYPE_HOME_FAX_NUMBER = 2; 02 fax casa
TYPE_MOBILE_TELEPHONE_NUMBER = 3 03 mobile lavoro
TYPE_EMAIL_1_ADDRESS = 4; 04 email casa
TYPE_WEB_PAGE = 5; empty
TYPE_HOME_WEB_PAGE = 6; 06 web casa
TYPE_BUSINESS_WEB_PAGE = 7; 07 web lavoro
TYPE_INSTANT_MESSENGER = 8; empty
TYPE_BUSINESS_TELEPHONE_NUMBER = 10; 10 telefono lavoro
TYPE_BUSINESS_FAX_NUMBER = 11 11 fax lavoro
TYPE_COMPANY_MAIN_TELEPHONE_NUMBER = 12; empty
TYPE_ASSISTANT_NUMBER = 13; empty
TYPE_PAGER_NUMBER = 14; 14 cercapersone
TYPE_CALLBACK_NUMBER = 15; empty
TYPE_EMAIL_2_ADDRESS = 16; 16 email work
TYPE_BUSINESS_LABEL = 17; empty
TYPE_OTHER_FAX_NUMBER = 29; empty
TYPE_OTHER_LABEL = 19; empty
TYPE_CAR_TELEPHONE_NUMBER = 20; 20 telefono auto
TYPE_PRIMARY_TELEPHONE_NUMBER = 21 empty
TYPE_HOME_2_TELEPHONE_NUMBER = 22; 22 mobile casa
TYPE_EMAIL_3_ADDRESS = 23; 23 email altro
TYPE_TELEX_NUMBER = 27; empty
TYPE_RADIO_TELEPHONE_NUMBER = 28; empty
TYPE_OTHER_FAX_NUMBER = 29; 29 fax altro
TYPE_OTHER_TELEPHONE_NUMBER = 30; 30 telefono altro
TYPE_BUSINESS_2_TELEPHONE_NUMBER = 31; empty
So my first question is: why there are so many empty values?
After that i changed the value in the field Busines Phone, from '10' to '-10' and sync again with the Funambol server.
Now the values in the table fnbl_pim_contact-item are changed a lot!
Query SQL: SELECT * FROM `fnbl_pim_contact_item` WHERE `contact` = -252305 LIMIT 0, 30 ;
Righe: 27
contact type value
-252305 [->] 1 01
-252305 [->] 2 02
-252305 [->] 3
-252305 [->] 4 23
-252305 [->] 5 05
-252305 [->] 6 06
-252305 [->] 7 07
-252305 [->] 8 08
-252305 [->] 10 10-
-252305 [->] 11 11
-252305 [->] 12
-252305 [->] 13 13
-252305 [->] 14 14
-252305 [->] 15 15
-252305 [->] 16 04
-252305 [->] 17 17
-252305 [->] 18 18
-252305 [->] 19 19
-252305 [->] 20 20
-252305 [->] 21
-252305 [->] 22
-252305 [->] 23 16
-252305 [->] 27 27
-252305 [->] 28 28
-252305 [->] 29 29
-252305 [->] 30 30
-252305 [->] 31
So my second question, why the key->values in the fields '04','16','23' were reversed?
Best regards
Massimo
|
Search a post 
, Netvibes
, Windows Vista
, Apple Dashboard
, ...