maemo.org - Talk

maemo.org - Talk (https://talk.maemo.org/index.php)
-   Applications (https://talk.maemo.org/forumdisplay.php?f=41)
-   -   [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar (https://talk.maemo.org/showthread.php?t=40408)

fw190 2010-05-17 10:40

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Still the same error. I can't sync :(

zombiepig 2010-05-17 10:41

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
From my quick testing this afternoon recurring events seem to be working great! Your effort is really appreciated :)

lorelei 2010-05-17 10:45

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by kirano (Post 662115)
thanks will try out as soon as possible, about which database I should import to, I have one which is named "n900" is this the one to choose if I want to add it to my n900 calendar software?

The calendar named "N900" is the default calendar of the device (i.e. the one also named N900 in the calendar application).

If I'm not mistaken, it's called something else when using other languages for the OS, but I'm not 100% sure about that..

lorelei 2010-05-17 10:47

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by fw190 (Post 662141)
Still the same error. I can't sync :(

What was the error again? I can't find a detailed description in this thread (but maybe I missed something)

thanks

stobbsc 2010-05-17 11:27

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
HI all,
this is a great app :-) well done.
Two questions.
Is it possible to sync tasks?
Also I've noticed that smart calendars don't sync for example the birthday calendar?

Thanks
Chris

fw190 2010-05-17 11:29

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Error:

Traceback (most recent call last):
File "/usr/bin/erminig", line 153, sync_all_profiles(widget=<gtk.ToolButton object at 0x40b8b6e8 (GtkToolButton at 0x4b49b8)>, data=<hildon.StackableWindow object at 0x40b8be40 (HildonStackableWindow at 0x444060)>)
id = i[0]
do_profile_sync(id, data)
variables: {'data': ('local', <hildon.StackableWindow object at 0x40b8be40 (HildonStackableWindow at 0x444060)>), 'id': ('local', 2), 'do_profile_sync': ('global', <function do_profile_sync at 0x40bc5d30>)}
File "/usr/bin/erminig", line 100, do_profile_sync(id=2, data=<hildon.StackableWindow object at 0x40b8be40 (HildonStackableWindow at 0x444060)>)
if not google_api.switch_account(
google_accounts.get_account_by_id(profile['remoteAccountId'])):
return
variables: {'profile': ('local', {'lastUpdate': 0, 'direction': 0, 'lastLocalUpdate': 0, 'remoteSourceTitle': None, 'remoteAccountId': None, 'enabled': 1, 'localSource': u'1', 'remoteSource': u'0', 'localSourceTitle': u'N900', 'id': 2}), 'google_accounts.get_account_by_id': ('global', <function get_account_by_id at 0x407d11f0>)}
File "/usr/share/erminig/google_accounts.py", line 64, get_account_by_id(id=None)
"WHERE id = ?", (id,))
row = dblayer.getRows(cur)[0]
return (row['username'], row['password'], id)
variables: {'dblayer.getRows': ('global', <function getRows at 0x407d1070>), 'cur': ('local', <sqlite3.Cursor object at 0x407ca9e0>), 'row': (None, None)}
IndexError: list index out of range

fw190 2010-05-17 11:41

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
I've deleted the profile and created a new one. And now it works but when I try to download my calendar from google it shows that sync went ok but in N900 calendar there are no entries.

lorelei 2010-05-17 11:47

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by fw190 (Post 662209)
I've deleted the profile and created a new one. And now it works but when I try to download my calendar from google it shows that sync went ok but in N900 calendar there are no entries.

Yes, this is the correct solution in this case.

for the fact that there are no entries, try to close and re-open the calendar application: it may not have realized that new events got added. Alternatively try to switch to another month or week and back, this should make entries visible. (this is not an erminig bug, but rather a maemo calendar lack of feature :))

lorelei 2010-05-17 11:49

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by stobbsc (Post 662190)
Is it possible to sync tasks?
Also I've noticed that smart calendars don't sync for example the birthday calendar?

task sync is not possible, since Google does not expose an API for their task implementation.

smart calendars are not supported yet in Erminig. I will have to check if it is possible to sync those too. This may come in the next major release (but no firms plans for the moment..)

fw190 2010-05-17 12:07

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by lorelei (Post 662220)
Yes, this is the correct solution in this case.

for the fact that there are no entries, try to close and re-open the calendar application: it may not have realized that new events got added. Alternatively try to switch to another month or week and back, this should make entries visible. (this is not an erminig bug, but rather a maemo calendar lack of feature :))

I've made some tests. It can upload something to google calendar but it doesn't download anything. I've tried to switch to an other month but no good.

lorelei 2010-05-17 12:14

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by fw190 (Post 662235)
I've made some tests. It can upload something to google calendar but it doesn't download anything. I've tried to switch to an other month but no good.

Do you have a very large number of entries in google calendar? You may have hit a limitation in the number of events that Google offers to download....Can you have a look at months many years back in maemo calendar to see if some events are there?

thanks

fw190 2010-05-17 12:19

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
I had to reflash the phone so my calendar is empty and the google calendar has about 50 entries, some of the repeat monthly, and some just once in a year.

lorelei 2010-05-17 12:36

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by fw190 (Post 662258)
I had to reflash the phone so my calendar is empty and the google calendar has about 50 entries, some of the repeat monthly, and some just once in a year.

very odd. Can you take a look at the event log after a sync? (erminig's menu -> Log)
Before that please remove the profile and re-create it, so that it will sync all events

thanks

fw190 2010-05-17 13:39

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by lorelei (Post 662284)
very odd. Can you take a look at the event log after a sync? (erminig's menu -> Log)
Before that please remove the profile and re-create it, so that it will sync all events

thanks

strange. I already did what You wrote twice. Now when I did it for the third time to show You the log it went ok. So- IT WORKS :) huraaaaaaaa

lorelei 2010-05-17 13:55

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by fw190 (Post 662398)
strange. I already did what You wrote twice. Now when I did it for the third time to show You the log it went ok. So- IT WORKS :) huraaaaaaaa

Great. My bet is that the problem stems from poor/unreliable internet connection (as you already mentioned in this thread previously)....now in which way it affects Erminig I'm not entirely sure.

pmd 2010-05-17 20:09

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by lorelei (Post 560911)
I realize that the button at the bottom of the main window are not completely intuitive. Here is a screenshot with the action associated with each button:

http://imgur.com/pwbKi.png

You should put this screenshot somewhere in Erminigs page in the Maemo garage. It is a bit too difficult to find it in this thread. I keep forgetting what the icons mean so I need a cheat sheet. :-)

pmd 2010-05-17 20:30

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by lorelei (Post 661533)
as promised version 0.2.9 of Erminig has been released and is available in extras-devel.

I installed 0.2.9, removed the old erminig.db and created a new profile syncing my Google calendar with a newly created calendar on the N900 (with the same name as my google mail adress: pmdanielsson@gmail.com).

Erminig accepted the sync command, but nothing was put in my new calendar on the N900. I have only a handful fixed entries in my Google calendar plus about a handful recurring events.

The erminig log says this after a sync attempt:
"RequestError({'status': 400, 'body': 'Invalid UserID 0', 'reason': 'Bad R

Unfortunately the text is wider than the screen, and I can't get the horizontal scrollbar at the bottom of the text box to work. (Some way to save the log to a file would be helpful in this situation, I think).

If the solution to this problem is obvious to you I will not submit this as a bug report in bugzilla, but if this is a mystery let me know and I will make a bugzilla submission.

(I am connected to the net via WiFi with the N900 4-5 meters from the base station so the quality of the network connection should not be a factor.)

lorelei 2010-05-17 21:16

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by pmd (Post 663040)
The erminig log says this after a sync attempt:
"RequestError({'status': 400, 'body': 'Invalid UserID 0', 'reason': 'Bad R
[...]
If the solution to this problem is obvious to you I will not submit this as a bug report in bugzilla, but if this is a mystery let me know and I will make a bugzilla submission.
[...]

Hmmm, I have a feeling about what went wrong, but I can't put my finger on it yet. I will release tomorrow a new version with some more debugging information displayed (or with a bug fix if in the meantime I find what I'm looking for)

thank you for your patience

Edit:

@PMD: could you please send me via private message (I don't know exactly how sensitive this information is) the output of the following commands run from the X-terminal (you have to type only those in bold)?

Code:

$ sqlite3 erminig.db
sqlite> select * from Profiles;
sqlite> .quit

thanks

DaSilva 2010-05-17 22:06

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
What happens if I schedule automatic synchronisation and the phone is offline when it should sync?
Will it sync when the next connection is established or will it forget about it?

jwshale 2010-05-17 22:14

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by lorelei (Post 662440)
Great. My bet is that the problem stems from poor/unreliable internet connection (as you already mentioned in this thread previously)....now in which way it affects Erminig I'm not entirely sure.

From using erminig quite a few times, I certainly get this impression. The 3G internet connection in my house is a little poor and erminig often crashes. However, if I use a wifi connection it is fine every time.

John

pmd 2010-05-17 22:31

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by lorelei (Post 663096)

@PMD: could you please send me via private message (I don't know exactly how sensitive this information is) the output of the following commands run from the X-terminal (you have to type only those in bold)?

Not sensitive at all. :-) See below.

Quote:


Code:

$ sqlite3 erminig.db
sqlite> select * from Profiles;
sqlite> .quit

thanks
The output from sqlite3 is:
Code:

SQL error: no such table: Profiles
So it appears that no profile was registered in erminig.db when I tried to create one?

The strange thing is that in erminig I can see the profile below the title line (or whatever it's called; the one starting with "Device").

However: the field below the title "Google" is empty, but when I edit the profile everything looks right.

lorelei 2010-05-17 22:37

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by DaSilva (Post 663164)
What happens if I schedule automatic synchronisation and the phone is offline when it should sync?
Will it sync when the next connection is established or will it forget about it?

It will forget about it...

wired 2010-05-17 22:42

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Yes! recurring events were exactly what I needed!

Thank you :D

lorelei 2010-05-17 22:44

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by pmd (Post 663193)
Not sensitive at all. :-) See below.

The output from sqlite3 is:
Code:

SQL error: no such table: Profiles
So it appears that no profile was registered in erminig.db when I tried to create one?

The strange thing is that in erminig I can see the profile below the title line (or whatever it's called; the one starting with "Device").

However: the field below the title "Google" is empty, but when I edit the profile everything looks right.

Hmmm, an error slipped in the command I gave you (forgot a dot, and made other assumptions). Can you please try again with the following:

Code:

$ sqlite3 ~/.erminig.db
sqlite> select * from Profiles;
sqlite> .quit

The fact that the entry below the Google header is empty is for sure not normal, and probably a clue toward the root cause of the problem we are trying to debug.

pmd 2010-05-17 23:47

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by lorelei (Post 663208)
Hmmm, an error slipped in the command I gave you (forgot a dot, and made other assumptions)

After I posted my previous message I realized that the inital dot was missing. :-) Here's the output from the correct command:
Code:

SQLite version 3.6.14
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select  * from Profiles;
2|0|0|6|Gcal|1|0||1|0|1274137963|1274137965
sqlite> .quit

I started from scratch, and the synced local calender is named Gcal.

lorelei 2010-05-18 05:07

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
@pmd: thank you for the feedback. It's getting clearer what the problem might be. For comparison, here's the (slightly edited) output from my Profiles table:

Code:

12|0|0|23|Work Clone|5|eim66lus2al3e2mastf9hhtg7a@group.calendar.google.com|Work Clone|1|0|1274049223|1274049225
There are clearly some missing entries, which explain

1) why you got the error messages
2) why no event got synchronized

I will release this evening a debug version with some more informative output: I hope that we will be able to trace why those values are missing.

petibub 2010-05-18 19:14

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Hi Lorelei!

Thanks for the update. Especially thanks for the recurring events!

Now I switched to my "real" google calender and I had no problems - it works like a charm.

Actually I had a crash in the GUI while creating a new profile but I can not tell you what exactly happened. And, it's a minor thing - just restarted Erminig and repeated the steps...

BTW, I was even able to sync from "others" google calendar - I am subscribed to the Austrian holiday calender on Google and I can sync it to N900. Neat!

microe 2010-05-18 21:27

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
2 Attachment(s)
I am having a bit of trouble trying to get erminig-ng to sync to my google calendar on my N900.

1. I am using erminig-ng 0.2.9 from 5/16/2010 in extras-devel.
2. I use google calendar through google apps.
3. I set up a read-only sync mainly because I do not yet want erminig to make any changes to my google calendar.

I select my account in the UI and then hit the update button. It gets about maybe 10% through and then it dumps out to a trace. The trace is attached here.

Since syncing w/ google calendar is the last step I need to do before I am transitioned from my N810 to my N900, I am willing to do any testing.

lorelei 2010-05-18 21:58

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
@microe:

thanks for the report. It is definitely a bug with the recurring events code path. I will analyze the trace in more details in the following days and maybe ask you to run a debug version of Erminig in order to pinpoint the exact problem

@pmd: I've been unable to prepare the debug version for the profile problem you encountered (got stuck with an urgent presentation to prepare). I will create a debug version that combines yours and microe's bug as soon as I get the time.

lorelei 2010-05-19 21:56

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
An updated version (0.2.10) is available in Extras-devel (or will be in a few minutes). There are absolutely no new features, so users with no issues don't need to update.

@microe & @ pmd (& maybe @fw190):

please update to version 0.2.10: this build spits some information on the terminal (and in the log window, but since it's not practical to use, let's forget about it). Here are the instructions:

- open an x-terminal
- type: erminig
- for microe: try to sync your calendars
- for pmd: delete all profiles and recreate them. Don't attempt a sync for the moment
- for both: copy the output that went to the terminal and send it to me via PM or mail (lorelei@garage.maemo.org).

from there I will look at what went wrong and hopefully fix the bugs.

thank you very much!

nikolajhendel 2010-05-20 02:00

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Just updated (but seem to get version 0.2.9?)

Regular reoccurring seems to work (have a weekly that shows up on the N900 calendar).
Another reoccurring is not showing up. This is setup in Google calendar as reoccurring on the 20th of every month.
Just reporting as this could be one of the instances that Erminig does not cover (or the N900 calendar can't handle).

gasper_k 2010-05-20 07:35

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Same here (0.2.10), some recurring events just don't seem to work. I would provide more detail, but can't figure out any. For some, the reason may be that they were started before 1970 (I tend to enter birthdays on the day of birth), but I have another that was started on 2007 and just doesn't seem to work. All of these are simple "repeat yearly" events, nothing more.

I didn't come to some weekly events, which also don't sync, but are already completed. These finished a few weeks ago, so this may be the reason.

If you need any detail with these events, just ask.

Martin Atkins 2010-05-20 12:43

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Many thanks for recurring events! This release has finally made my N900 (almost - see below) usable as a calendar.

However, I've also got some events that just don't sync.

I had two such events (one every Tuesday, the other every Thursday, with no end dates). Setting end dates caused the Thursday event to sync, but not the Tuesday. Very odd!

Can I also suggest that all Erminig users/fans add their comments to the Maemo Bugzilla bug for non-working repeating event exceptions (#5294). Weight of numbers might be the only way to convince Nokia that this is a real issue :mad:

The bug details can be found at:
https://bugs.maemo.org/show_bug.cgi?id=5294

fw190 2010-05-20 16:26

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
For me it works ok:)

cdarek 2010-05-21 11:54

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Great job Lorelei.!!! :):):)
Thank you very much.

I have all my recurring events well synchronized.
It didn't work at first - I had to open and edit them slightly in Gmail just to refresh the creation/update time in Gmail I guess and it works fine.
I had this recurring events for at least one year and were skipped many times at synchronization with previous version.
This could explain that some are and some are not synchronized.
Try to re-edit the slightly and check again.

I sync 4 calendars and ca 10 recurring events.

Good luck.
Darek

lorelei 2010-05-21 12:13

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Thanks Darek for your comment. In fact this reminds me that I forgot to mention something when I released the last version of Erminig: you have to delete and re-create the sync profiles, otherwise previously created events (recurring and not) won't be synced, since as you point out the timestamps of those events will be before the last sync, so they won't be seen by Erminig.

LippiVan 2010-05-21 12:23

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
lorelei, thx so much for this app! works like a charm for me!

is there some kind of donate option?

gasper_k 2010-05-21 15:09

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by lorelei (Post 669177)
Thanks Darek for your comment. In fact this reminds me that I forgot to mention something when I released the last version of Erminig: you have to delete and re-create the sync profiles, otherwise previously created events (recurring and not) won't be synced, since as you point out the timestamps of those events will be before the last sync, so they won't be seen by Erminig.

Recreated the profiles and it seems to work fine. Great work, thanks!

microe 2010-05-21 16:13

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Quote:

Originally Posted by lorelei (Post 669177)
Thanks Darek for your comment. In fact this reminds me that I forgot to mention something when I released the last version of Erminig: you have to delete and re-create the sync profiles, otherwise previously created events (recurring and not) won't be synced, since as you point out the timestamps of those events will be before the last sync, so they won't be seen by Erminig.

Will this have any effect on the crashing problem I am demonstrating? Happy to try a few testing variations if you see the need.

Boru 2010-05-22 11:21

Re: [Announce] Erminig-NG: two-way synchronization Google Calendar <-> Fremantle Calendar
 
Hi. Thanks for this great app. I've been using it without any software errors but when I sync any calendars TO google the existing events get duplicated. I have no recurring events and this never seems to happen when syncing FROM Google. Is there something I need to do or check?


All times are GMT. The time now is 16:36.

vBulletin® Version 3.8.8