JEvents 1.5 (No longer actively supported)

SOLVED - Exporting data using SQL queries

JEvents 2.0 was launched over 2 years ago and the latest stable version is version 2.2 which will run on Joomla 1.5 and Joomla 2.5. JEvents 1.5 is therefore no longer actively supported - you should upgrade to JEvents 2.2+ as soon as possible.
Forum rules
Please include as much detail in any test or bug reports for JEvents 1.5 as possible.

First of all, check if you are running the latest available version of Joomla! and JEvents. Posts for issues, where both systems are not updated, will be ignored.

We need the following at least:

* PHP version (e.g. 5.2.5). Note: Support for PHP4 is discontinued.
* Joomla! version
* JEvents version
* Web Server software (Apache or IIS with version number if possible)
* Server Operating system (e.g. Linux, Windows, Solaris, Darwin ...)
* Database version
* memory_limit from your phpinfo
* Web browser and version

Please enable error reporting and include any error messages in your posting. You do this via the Joomla Configuration - set "error reporting" to "maximum" on the Server tab.

Finally, please describe the steps required to recreate the problem and also please enable error reporting and give us any error messages generated.

Postby hooha » Wed Apr 18, 2012 11:23 am

Hello,

a client of mine has a site running Joomla and event management with JEvents.

What I need is to export data from the database in specific format and some of the fields are defined using customFields feature which saves all the information in 'rawdata' field with what it looks like something similar to JSON although it's not valid JSON.

What I want to know is how do I parse this string the easiest, perhaps you have some tools/plugins I could use to parse 'rawdata', or are there any easier ways to get this information out?

thanks
hooha
 
Posts: 3
Joined: Wed Apr 18, 2012 11:17 am

Postby Tonyp » Wed Apr 18, 2012 11:51 am

Hello Hooha,

You might want to look into the Export function which is already provided with JEvents. Make sure it is the latest release of JEvents as this includes custom fields exporting.

To export quickly, go to Menu Items, create item and select JEvents Export.

Regards
Tony
---------------------------------------
Feel free to PM me if you would like Custom Installs or Joomla! related work for a competitive quote.

User avatar
Tonyp
Team Staff
 
Posts: 23828
Joined: Tue Oct 12, 2010 9:12 pm
Location: Isle of Man

Postby Geraint » Wed Apr 18, 2012 3:14 pm

rawdata can be ignored - it was implemented early on in the development of JEvents 1.5 as a fall back to allow us to recreate events if we discovered an error in the repeating events algorithm.

You could also look at this article - some people have used this approach to create an inDesign extract combining the xml output with XSS. See http://www.jevents.net/en/jevents-15-to ... -of-events
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!
User avatar
Geraint
 
Posts: 42850
Joined: Fri Feb 15, 2008 6:14 pm

Postby hooha » Thu Apr 19, 2012 8:44 am

OK thanks guys, I'll look into it.

This link by Geraint gives me 'Club Members Only' notification though.

Although I don't need XML, basically I need JSON, so i wrote a simple script that connects to joomla's db, runs a SELECT query and returns the JSON string. We need data to display on mobile app i'm developing.

infact, i just found this: table "prefix_jev_customfields" has some information that looks like something I need. it has columns 'evdet_id', 'name' and 'value'. can i just "JOIN" with "prefix_jevents_vevdetail" and read from there?
hooha
 
Posts: 3
Joined: Wed Apr 18, 2012 11:17 am

Postby hooha » Thu Apr 19, 2012 10:31 am

Yea that works, now the only thing I haven't found yet is where it stores the is_published information?

edit: found it: "WHERE event.state = 1"

thanks

regards
hooha
 
Posts: 3
Joined: Wed Apr 18, 2012 11:17 am


Return to JEvents 1.5 (No longer actively supported)

  • Who is online
  • View new posts
  • View unanswered posts
  • In total there are 0 users online :: 0 registered and 0 hidden (based on users active over the past 5 minutes)
  • Most users ever online was 94 on Tue Sep 01, 2009 12:33 am
  • Users browsing this forum: No registered users