Use Existing MySQL table

Hello,

I'm afraid not. JEvents needs it's own database and tables for it to function.

You can import events into JEvents though. Please see:
https://www.jevents.net/frequently-asked-questions/importing-events-in-csv-format

Many thanks
Tony

Tony

Many thanks for your reply.

I have now discovered that JEvents has the ability to use a live Google Calendar and can refresh the data using a cron job.

I have set up a JEvents calendar to use our Google Calendar and the refresh button works well. However, I am unable to use the recommended code:
/usr/bin/curl -s "http://www.mydomain.com/index.php?option=com_jevents&icsid=3&task=icals.reload" > /dev/null 2>&1
as my web site host's cron job keeps rejecting the code. Obviously, this makes sense as no one wants the code refreshing by any "Tom, Dick and Harry". I've also added the code to a CRON job and, naturally, get a 303 error.

Having read your forum, I have also tried another solution by adding a PHP file that sends the URL to our web site. However this returns the error that only the Super User has access to the component, which is correct. Can you help, please?

My other problem is getting the Calendar to display "full size" without using the "Switch View" module. How can I accomplish this, as I seem to have tried every option available.

I am very impressed with your component but feel that I need to test the possibilities further before buying a Gold or Silver membership.

With thanks.

Stephen

Did you enable anonymous refreshing of the calendar when you edited it in JEvents - you need this setting for the cron job to work.

You shouldn't worry too mush about 3rd parties updating your calendar since the data source is google and they can't put any events into your google calendar

geraint

Thank you for your reply.

In my list of calendars, there are two. The first is the DEFAULT calendar and the second is the one accessing our Google calendar. This is the calendar where anonymous refreshing has been enabled. This option does not seem possible on the other calendar and I assume that that is quite correct.

I have also listed the super users in the list of authorised used of JEvents. However, the Cron job refuses to work. Our web host is STRATO and their cron job refuses to accept the recommended statement:
/usr/bin/curl -s "http://www.xxx.xxx/index.php?option=com_jevents&icsid=3&task=icals.reload" > /dev/null 2>&1
it simply leaves "/usr/bin/curl " in place and the rest of the field blank as well as suggesting that " > /dev/null 2>&1" is not acceptable. I have tried using it in several ways without success.

I have also tried a free account at EasyCron where the URL alone is requested and that does not work either.

Kind regards.

Can you give me the domain on the private site details tab below and I'll take a look

Geraint

Many thanks for your help.

Access details have been sent, as requested.

Stephen

sorry for the delay in responding - I've been at the JandBeyond Joomla conference (http://www.jandbeyond.org).

When I access your update URL http://www.mXXXb.co.uk/index.php?option=com_jevents&icsid=3&task=icals.reload I get a "Not Authorised - must be super admin" message

I therefore tried to log in the backend but it says the password is not correct - can you check the credentials please?

geraint

Apologies, your account was not registered as a Super User account.

Please try again and thank you in anticipation.


Stephen

I can now login to the frontend but I can't access the backend

geraint

I've now disabled Two Factor verification on the account and changed the password (Private Site Details completed).

Sorry to be such a nuisance.

Stephen

Havng logged in I see that the autoreload URL is actually http://www.mXXXb.co.uk/index.php?option=com_jevents&icsid=5&task=icals.reload - notice the 5 and not 3 a you had earlier

When I load this in a webbrowser it refreshes the calendar correctly. This URL should work at an online service like EasyCron or via your webhost.

If you can't get it to work with your webhost then I suggest you ask them for advice for that the correct format should be for their set up

geraint

I am very grateful for your time and help.

Stephen

Does this mean you got it to work in your cron job?

It sounds like it maybe your host is limiting remote access run times. Opposed to local crons :-)

Glad you have it all working and hope to see you in the Gold forums soon!

Many thanks
Tony