Hello,
One of my clients asked me to export all of his JEvents events to a CSV file.
I used the ics export feature but it only exports dates and titles, it does not export event description and I need it to be exported as HTML code.
So I extracted the JEvents descriptions database table and combined with an ICS export that I had transformet to csv
I have many years of events in the database: from 2011 to 2018 but on the ics export interface per year only the events from 2011 to 2015 are listed. 2016 to 2018 are missing.
Can you help me find out why?
<code>
PHP Version : 7.0.33
MySQL Version : 5.5.5-10.0.36-MariaDB
Server Information : Linux lighthouse.easygiga.com 3.10.0-862.14.4.el7.x86_64 #1 SMP Wed Sep 26 15:12:11 UTC 2018 x86_64
Fix jQuery? : Yes
Load JEvents Bootstrap CSS? : Yes
Club code set? : Yes
User Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:65.0) Gecko/20100101 Firefox/65.0
Joomla : 3.8.11
component_com_jevents : 3.4.48
component_com_jce : 2.6.35
component_com_acymailing : 5.5.0
module_mod_acymailing : 3.7.0
module_mod_jevents_cal : 3.4.48
module_mod_jevents_custom : 3.4.48
module_mod_jevents_filter : 3.4.48
module_mod_jevents_latest : 3.4.48
module_mod_jevents_legend : 3.4.48
module_mod_jevents_switchview : 3.4.48
layout_JEventsIconicLayout : 3.5.6
layout_iconic : 3.4.6
plugin_acymailing_calltoaction : 1.1.3
plugin_acymailing_contentplugin : 3.7.0 (not enabled)
plugin_acymailing_geolocation : 5.5.0
plugin_acymailing_managetext : 1.0.0
plugin_acymailing_online : 3.7.0
plugin_acymailing_plginboxactions : 5.5.0
plugin_acymailing_share : 1.0.0
plugin_acymailing_stats : 3.7.0
plugin_acymailing_tablecontents : 1.0.0
plugin_acymailing_tagcontent : 3.7.0
plugin_acymailing_tagjevents_jevents : 3.1.1
plugin_acymailing_tagmodule : 5.5.0
plugin_acymailing_tagsubscriber : 5.5.0
plugin_acymailing_tagsubscription : 5.5.0
plugin_acymailing_tagtime : 5.5.0
plugin_acymailing_taguser : 5.5.0
plugin_acymailing_template : 5.5.0
plugin_acymailing_urltracker : 5.5.0
plugin_content_jevents : 3.4.48
plugin_editors_acyeditor : 5.5.0
plugin_finder_jevents : 3.4.48 (not enabled)
plugin_installer_jeventsinstaller : 3.4.48 (not enabled)
plugin_jevents_jevfiles : 3.6.5
plugin_search_eventsearch : 3.4.48
plugin_system_acymailingclassmail : 5.5.0 (not enabled)
plugin_system_acymailingurltracker : 5.5.0
plugin_system_gwejson : 3.4.44
</code>
One of my clients asked me to export all of his JEvents events to a CSV file.
I used the ics export feature but it only exports dates and titles, it does not export event description and I need it to be exported as HTML code.
So I extracted the JEvents descriptions database table and combined with an ICS export that I had transformet to csv
I have many years of events in the database: from 2011 to 2018 but on the ics export interface per year only the events from 2011 to 2015 are listed. 2016 to 2018 are missing.
Can you help me find out why?
<code>
PHP Version : 7.0.33
MySQL Version : 5.5.5-10.0.36-MariaDB
Server Information : Linux lighthouse.easygiga.com 3.10.0-862.14.4.el7.x86_64 #1 SMP Wed Sep 26 15:12:11 UTC 2018 x86_64
Fix jQuery? : Yes
Load JEvents Bootstrap CSS? : Yes
Club code set? : Yes
User Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:65.0) Gecko/20100101 Firefox/65.0
Joomla : 3.8.11
component_com_jevents : 3.4.48
component_com_jce : 2.6.35
component_com_acymailing : 5.5.0
module_mod_acymailing : 3.7.0
module_mod_jevents_cal : 3.4.48
module_mod_jevents_custom : 3.4.48
module_mod_jevents_filter : 3.4.48
module_mod_jevents_latest : 3.4.48
module_mod_jevents_legend : 3.4.48
module_mod_jevents_switchview : 3.4.48
layout_JEventsIconicLayout : 3.5.6
layout_iconic : 3.4.6
plugin_acymailing_calltoaction : 1.1.3
plugin_acymailing_contentplugin : 3.7.0 (not enabled)
plugin_acymailing_geolocation : 5.5.0
plugin_acymailing_managetext : 1.0.0
plugin_acymailing_online : 3.7.0
plugin_acymailing_plginboxactions : 5.5.0
plugin_acymailing_share : 1.0.0
plugin_acymailing_stats : 3.7.0
plugin_acymailing_tablecontents : 1.0.0
plugin_acymailing_tagcontent : 3.7.0
plugin_acymailing_tagjevents_jevents : 3.1.1
plugin_acymailing_tagmodule : 5.5.0
plugin_acymailing_tagsubscriber : 5.5.0
plugin_acymailing_tagsubscription : 5.5.0
plugin_acymailing_tagtime : 5.5.0
plugin_acymailing_taguser : 5.5.0
plugin_acymailing_template : 5.5.0
plugin_acymailing_urltracker : 5.5.0
plugin_content_jevents : 3.4.48
plugin_editors_acyeditor : 5.5.0
plugin_finder_jevents : 3.4.48 (not enabled)
plugin_installer_jeventsinstaller : 3.4.48 (not enabled)
plugin_jevents_jevfiles : 3.6.5
plugin_search_eventsearch : 3.4.48
plugin_system_acymailingclassmail : 5.5.0 (not enabled)
plugin_system_acymailingurltracker : 5.5.0
plugin_system_gwejson : 3.4.44
</code>