Monday, 04 February 2019
  3 Replies
  720 Visits
0
Votes
Undo
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>
6 years ago
·
#208785
0
Votes
Undo
Hello,

Can you check the menu item and see if a date range is set?

Can you check the years set in the JEvents configuration?

Also, you could create a JEvents List of Events menu item, configure the fields you want to export then include the save / print as CSV option on that menu item. Which transforms the menu item into a dedicated export url.

Many thanks
Tony

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

6 years ago
·
#208846
0
Votes
Undo
hello, thank you, right away to the problem, it was the years range in the config.
6 years ago
·
#208850
0
Votes
Undo
You are very welcome! and glad to hear.

You can set these to be relative i.e.:

-1y
+2y

Many thanks
Tony

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

  • Page :
  • 1
There are no replies made for this post yet.

Members Area

Show your support

Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons

Your membership will ensure that JEvents continues to be the best events calendar for Joomla.