Page 1 of 1

Show Birthday of Adressbook in Calender produces Failure

Posted: Sun Jul 31, 2011 11:34 pm
by khartmann

I'm just looking about the problem, that the system (3.7.26) don't like to display birthdays of the adressbook in the calender. the database is just set up new and i imported the datas by csv-files. the permissions are given too.

if i follow other boards, sth is going wrong in some database-fields. the system-brought tools (database clearing etc) don't help.

may be s.o. knows a solution to this:

Notice: A non well formed numeric value encountered in /var/www/.../go3/modules/calendar/json.php on line 647

Notice: A non well formed numeric value encountered in /var/www/.../go3/modules/calendar/json.php on line 647
{"write_permission":true,"comment":"","calendar_id":"2","calendar_name":"User1","permission_level":"4","title":"User1","results":[{"id":0,"name":"Geburtstag: Person1","description":"Person1 wurde heute 34","time":"01.01.1970","start_time":"2011-09-08 00:00","end_time":"2011-09-08 23:59","background":"EBF1E2","day":"Montag 29.08.2011","read_only":true,"contact_id":"449"},{"id":1,"name":"Geburtstag: Person2","description":"Person2 wurde heute 28","time":"01.01.1970","start_time":"2011-09-17 00:00","end_time":"2011-09-17 23:59","background":"EBF1E2","day":"Montag 29.08.2011","read_only":true,"contact_id":"810"},{"id":2,"link_count":"0","name":"Aufgabe: Job1","description":"Aufgabenliste: user1","time":"00:00","start_time":"2011-08-31 00:00","end_time":"2011-08-31 23:59","background":"EBF1E2","day":"Donnerstag 28.07.2011","read_only":true,"task_id":"2"},{"id":3,"link_count":"0","name":"Aufgabe: job2","description":"Aufgabenliste: user1","time":"00:00","start_time":"2011-08-31 00:00","end_time":"2011-08-31 23:59","background":"EBF1E2","day":"Donnerstag 28.07.2011","read_only":true,"task_id":"9"}],"count":4,"mtime":0,"count_events_only":0}

Klaus Hartmann

Re: Show Birthday of Adressbook in Calender produces Failure

Posted: Tue Aug 02, 2011 1:33 pm
by WilmarVB
Hello KHartmann,

1) Could you copy-paste a piece of the original CSV with one of those birthday records in it?
2) Did any event import succesfully from the CSV into GO?

Re: Show Birthday of Adressbook in Calender produces Failure

Posted: Wed Aug 03, 2011 11:21 pm
by khartmann
Hello Wilmar,

I exported the data with GO 2.18 in a CSV-File, seperated by ";" and the values in "".

The date seperator ist a "." in GO 3.7 for Germany in displaying dates. When I have a look into the records, the birthday is displayed correctly.

Fields of the csv-file:
"Titel";"Vorname";"2. Vorname";"Nachname";"Initialen";"Geschlecht";"Geburtstag";"E-Mail";"Land";"Bundesland";"Stadt";"Postleitzahl";"Stra├če";"Hausnummer";"Telefon";"Telefon berufl.";"Fax";"Fax berufl.";"Mobil";"Firma";"Abteilung";"Funktion";"Kommentar";"Gruppe"

Example-Data, which caused the error.

Title ist the GO3.7 Database, Table ab_contacts
id link_id user_id addressbook_id source_id first_name middle_name last_name initials title sex birthday email email2 email3 company_id department function home_phone work_phone fax work_fax cellular country state city zip address address_no comment iso_address_format color sid ctime mtime salutation email_allowed files_folder_id

record of the GO 3.7. Database (copied from the printpreviem of phpmyadmin)
449 NULL 1 4 0 Prename Name M 1977-09-08 0 +99-999-9999999 Comment DE NULL NULL 1311805548 1311805548 1 584

2) I havent imported any datas into the calender.