Fali Message importing ical-link
By fde68 on Wednesday, 29 November 2023
Posted in JEvents (Free Access)
Replies 9
Likes 0
Views 607
Votes 0
Hello Team,
i have an external url, which provides an google compatible ical file.

In jevents (i was silver memebr for years) i added a new calendar and added this url.
By start of import, i get a huge fail message - please let me know, what is reson for this - what is wrong.

320 There were problems saving the event detailProblem saving event Exception: Problem saving event (253402124400) : Out of range value for column 'dtstart' at row 1 in /var/www/salvator-iss/htdocs/sitex-x23/components/com_jevents/libraries/iCalEventDetail.php:301 Stack trace: #0 /var/www/salvator-iss/htdocs/sitex-x23/components/com_jevents/libraries/iCalEvent.php(295): iCalEventDetail->store(false) #1 /var/www/salvator-iss/htdocs/sitex-x23/components/com_jevents/libraries/iCalICSFile.php(441): iCalEvent->store(false, true) #2 /var/www/salvator-iss/htdocs/sitex-x23/administrator/components/com_jevents/controllers/icals.php(450): iCalICSFile->store() #3 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/MVC/Controller/BaseController.php(693): AdminIcalsController->save() #4 /var/www/salvator-iss/htdocs/sitex-x23/administrator/components/com_jevents/jevents.php(274): Joomla\CMS\MVC\Controller\BaseController->execute('reload') #5 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): require_once('/var/www/salvat...') #6 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Dispatcher/LegacyComponentDispatcher.php(73): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}('/var/www/salvat...') #7 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Component/ComponentHelper.php(361): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() #8 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent('com_jevents') #9 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch() #10 /var/www/salvator-iss/htdocs/sitex-x23/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\AdministratorApplication->doExecute() #11 /var/www/salvator-iss/htdocs/sitex-x23/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute() #12 /var/www/salvator-iss/htdocs/sitex-x23/administrator/index.php(32): require_once('/var/www/salvat...') #13 {main}

Joomla is lates version 4.4.1 ... Jevents made update today!
PHP 8.1.26

If i get this running, i start to pay again, as i need to get the modules and cronjob support for this functionality.

As it is urgend, i appreciate for you quick response and suport.

Thank you and with best regards
Frank
Hello, sadly i did not get any response.

All in know by investigation in meantime, is, that the faile basically is compatible with google's .ics standard. But jevents shows this feil message.

The situation is, that the given file could not be changed, as it is part of a system. The plan is, to import this file frequently, to get the latest events in the jevents component in the given website.

Question:
Is there any developer, who can check, what is reason for this fail - and can set up a modified version of .ics import, so that we can use this?

Thank you
fde68
·
12 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Of course, nobody is aktin for free support! This is asking for realizing a job!
Thank you!
fde68
·
12 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hm, any response please possible?

A ADDITIONAL CONTACTED THE TEAM ::: I TRIED - BUT ALSO NO RESPONSE:
Any idea, how to get supprt (also paid)
Thanks
fde68
·
12 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
See your error message

Out of range value for column 'dtstart'


What dates do you have for your events - it looks as though one or more may have an extreme value that can't be stored in the database
geraint
·
11 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello, thank you for your response.
Whyever, the calendar has some facts, start in in 1970, as i can see. I know, it is not very professional ... but it based on another system, a portal for teachers.

Attached i send you the .ics file - zipped.

This needs to download frequently from a fixed url ... so, basically i am not able to change anythang with the file.

So, how is it possible, to modify the import, that it works? What is needed to do?

Thank you very much.
Best regards
Fank
fde68
·
11 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
I just imported this calendar with no problems - though it took a while because it so large

Looking at the file I see where the problem arises e.g. 



BEGIN:VEVENT

DTSTART;TZID=Europe/Berlin:99991230T000000

DTEND;TZID=Europe/Berlin:99991230T000000

X-WWS-ID:2338

UID:2338-1-1676635868-calendar--klassenarbeiten@kss.schulerzbistum.de

CREATED:20230217T121108Z

LAST-MODIFIED:20230217T121108Z

DTSTAMP:20230217T121108Z

X-WWS-C-USER-ID:30064772741

X-WWS-M-USER-ID:30064772741

SUMMARY:9m KA Deutsch

SEQUENCE:2

END:VEVENT
geraint
·
11 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Ok, what exactly is the problem?

i tried to import it manually by file downloaded first - it was the same.

Please, could this solved by changing config from server?
Or what is needed, that the import will work correctly?

Thanks for advise!
Best regards
Frank
fde68
·
11 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Look at the dates for the start and end of the event - they are somewhat extreme!
geraint
·
11 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you for the support ... as the answers are really short and a littly cryptic.
But yes, there where failed dates inside the ics ... these are corrected - and now it possible to import all dates correctly.
Bye
fde68
·
11 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post