HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


Google Calendar

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#62951 (In Topic #13660)

Non-joined user

Hi,

How do I import my Google Calendar into the calendar, or at least get it to at least sync with the calendar?? I'm running 4.1.10.

Cheers!
etech97 :)
Back to the top
 
Posted
Rating:
#62954

Non-joined user

I upgraded to version 5, but it does not like the Google ical file :( :'(
Back to the top
 
Posted
Rating:
#62959
Avatar

Hi,

I just tested this myself and ran into a few problems.

  1. When I exported from google, the actual file saved was an HTML error. This is a bug in Google Calendar
  2. I exported a zip containing all my calendars (there's a 'Export calendars' on the 'Settings' screen). This would not extract on Windows due to it using invalid filenames in the zip (probably it's just because my calendars have colons in the name). I was able to get one of the files out though to test importing that…
  3. A stack trace happened on events that were recurring (it seems google doesn't specify a start date for them)
  4. All imported events were unvalidated

Fixes for 3 and 4 are in the attached file.

Attachment
sources/calendar_ical.php
» Download: calendar_ical.php (12 Kb, 199 downloads so far)


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62970

Non-joined user

Do I just replace the file?? Or copy the contents into the current file??? I overwrote the file, and now my 244kb .ics file is taking forever to import :(

Cheers!
etech97
Back to the top
 
Posted
Rating:
#62971

Non-joined user

Chris Graham said

Hi,

I just tested this myself and ran into a few problems.

  1. When I exported from google, the actual file saved was an HTML error. This is a bug in Google Calendar
  2. I exported a zip containing all my calendars (there's a 'Export calendars' on the 'Settings' screen). This would not extract on Windows due to it using invalid filenames in the zip (probably it's just because my calendars have colons in the name). I was able to get one of the files out though to test importing that…
  3. A stack trace happened on events that were recurring (it seems google doesn't specify a start date for them)
  4. All imported events were unvalidated

Fixes for 3 and 4 are in the attached file.

Attachment
sources/calendar_ical.php
» Download: calendar_ical.php (12 Kb, 199 downloads so far)

The bottom of the browser says done and nothing is imported, so I am not doing something correctly :(

Cheers!
Tom
Back to the top
 
Posted
Rating:
#62973

Non-joined user

Okay, I got it uploaded and working(it shows events in the edit events button :) My next question is how do I get it to show up in a calendar format??? I would like to be able to choose between various formats limke, weekly, monthly…etc…

Thanks a lot for all of your help!!!!!!

Cheers!
etech97 :) :lol:
Back to the top
 
Posted
Rating:
#62974

Non-joined user

Guest said

Okay, I got it uploaded and working(it shows events in the edit events button :) My next question is how do I get it to show up in a calendar format??? I would like to be able to choose between various formats limke, weekly, monthly…etc…

Thanks a lot for all of your help!!!!!!

Cheers!
etech97 :) :lol:

I uploaded through Content Management :)

etech97
Back to the top
 
Posted
Rating:
#62975
Avatar

http://yourbaseurl/site/index.php?page=calendar


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62976

Non-joined user

Chris Graham said

http://yourbaseurl/site/index.php?page=calendar

It took me to the website site map :( I imported the file through Content management Interface .

Cheers!
etech97
Back to the top
 
Posted
Rating:
#62977
Avatar

You could look on that sitemap for it, I guess you typed in the URL slightly wrong. Also the menu editor can find a page link for you to put on a menu.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62980

Non-joined user

I entered the url correctly this time and it does not show a calendar :( Also no of the appointments show up in my personal calendar…..just a note.

Cheers!
etech97
Back to the top
 
Posted
Rating:
#62981

Non-joined user

Guest said

I entered the url correctly this time and it does not show a calendar :( Also no of the appointments show up in my personal calendar…..just a note.

Cheers!
etech97


I re-entered the url given to me….copy and pasted correctly this time and it said page not found…something isn't working properly :(

Thank you for your help so far…it is greatly appreciated!!!!

Cheers!
etech97
Back to the top
 
Posted
Rating:
#62983
Avatar

Hmm, does site/pages/modules/calendar.php exist on the filesystem? I am wondering if the module got lost somehow.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62984

Non-joined user

Yes it's not there…..can you please post the file as I do not have it :)

Thank You!

Cheers!
etech97
Back to the top
 
Posted
Rating:
#62986
Avatar

You can find it in the manual installer download. The integrity check (available in /upgrader.php on your site) will tell you any files that are missing.


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#62987

Non-joined user

That did not work :( It did not say that the calendar.php was missing.

Cheers!
etech97
Back to the top
 
Posted
Rating:
#62988

Non-joined user

Guest said

That did not work :( It did not say that the calendar.php was missing.

Cheers!
etech97

Calendar.php is there but nothing is showing up :(

I do not know what else to do…I can edit events but no calendar :(

I'm willing to open up my firewall to an admin to look around…if that is an option.

Cheers!
etech97
Back to the top
 
Posted
Rating:
#62989

Non-joined user

I figured it out……When it imports the calendar the "is public" is not selected. Which is a problem when you have a large database calendar :(

Could you kindly fix this for me….I would be externally grateful ;)

Cheers!
etech97
Back to the top
 
Posted
Rating:
#62992
Avatar

Ah yes, definitely – I didn't realise that was happening. I don't want to make you re-import though so this SQL query will fix it…

UPDATE ocp5_calendar_events SET e_is_public=1;

If you have phpMyAdmin you can run it in there. Otherwise you could type this into OcCLE…

Code

:$GLOBALS['SITE_DB']->query_update('calendar_events',array('e_is_public'=>1));


Become a fan of ocPortal on Facebook or add me as a friend. Add me on on Twitter.
Was I helpful?
  • If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
  • If so, please let others know about ocPortal whenever you see the opportunity.
  • If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying ocPortal on fun personal projects.
  • If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Back to the top
 
Posted
Rating:
#63003

Non-joined user

Chris Graham said

Ah yes, definitely – I didn't realise that was happening. I don't want to make you re-import though so this SQL query will fix it…

UPDATE ocp5_calendar_events SET e_is_public=1;

If you have phpMyAdmin you can run it in there. Otherwise you could type this into OcCLE..

Code

:$GLOBALS['SITE_DB']->query_update('calendar_events',array('e_is_public'=>1));

I do not know how to use ocCLE. Copied and pasted the command into the interface but I do not know how to make it stick :(

Please help me out :)

Cheers!
etech97
Back to the top
 
There are too many online users to list.
Control functions:

Quick reply   Expand