lcollong
FabriKant d'applications web
Hi,
I'm using gcal sync to synchronize 3 different Google agenda. Actually the "events table" is a repeat group of a main table/form. The underlying "xxx_repeat_34" table contains most of the info needed to synchronize. One of the columns is to choose the right calendar. Then, I have setup 3 lists based on the same underlying table with a prefilter on the calendar info. Thus each of these list can be synchronized with the right agenda even if all the events are created from the same form.
It's working pretty well however I have some questions :
1/ The description field is a common field. Thus each of the 3 agenda related list is joined back to the main table on "parent_id" in order to display the "description" which is belonging to the main table not to the repeat group. Fabrik shows that very well. However, in the gcalsync cron plugin, I can select and choose the joined column but it is not updated. Looking to the source around lines 100, it seems that we read the main table itself, not the usual fabrik structure including the joined columns. Would it be possible to grab also the joined columns around line 100 ?
2/ Even it you setup the plugin to synchronize "to" Google, ie upload fabrik events to Google only, it creates rows for existing events in Gcal. Looking at the source, it seems that we store a gcalid in our table each time we synchronize an event. Fair to not synchronize again something which is already up to date. But if one creates an event directly in the Google UI, we should not see it in the fabrik table. This should be only done if "both" of "from" is chosen in the params. In the "to" case, the Google Events not existing in the fabrik table should not be synchronized (also I don't understand why it's doing that as the source code shows an "update", not an "insert"...).
3/ If one of my field is a DBjoin one (title), it's using the raw value (key) instead of the label. Thus Google Calendar shows "4" instead of "Title of the event".
4/ Would be nice to be able to synchronize the place of the event also.
5/ Still something wrong with tz as per this thread : http://fabrikar.com/forums/index.php?threads/gcalsync-setoffset-deprecated-in-joomla-3.36030/
I'm using gcal sync to synchronize 3 different Google agenda. Actually the "events table" is a repeat group of a main table/form. The underlying "xxx_repeat_34" table contains most of the info needed to synchronize. One of the columns is to choose the right calendar. Then, I have setup 3 lists based on the same underlying table with a prefilter on the calendar info. Thus each of these list can be synchronized with the right agenda even if all the events are created from the same form.
It's working pretty well however I have some questions :
1/ The description field is a common field. Thus each of the 3 agenda related list is joined back to the main table on "parent_id" in order to display the "description" which is belonging to the main table not to the repeat group. Fabrik shows that very well. However, in the gcalsync cron plugin, I can select and choose the joined column but it is not updated. Looking to the source around lines 100, it seems that we read the main table itself, not the usual fabrik structure including the joined columns. Would it be possible to grab also the joined columns around line 100 ?
2/ Even it you setup the plugin to synchronize "to" Google, ie upload fabrik events to Google only, it creates rows for existing events in Gcal. Looking at the source, it seems that we store a gcalid in our table each time we synchronize an event. Fair to not synchronize again something which is already up to date. But if one creates an event directly in the Google UI, we should not see it in the fabrik table. This should be only done if "both" of "from" is chosen in the params. In the "to" case, the Google Events not existing in the fabrik table should not be synchronized (also I don't understand why it's doing that as the source code shows an "update", not an "insert"...).
3/ If one of my field is a DBjoin one (title), it's using the raw value (key) instead of the label. Thus Google Calendar shows "4" instead of "Title of the event".
4/ Would be nice to be able to synchronize the place of the event also.
5/ Still something wrong with tz as per this thread : http://fabrikar.com/forums/index.php?threads/gcalsync-setoffset-deprecated-in-joomla-3.36030/