SOLVED - Exporting data using SQL queries

[hooha]

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

[Tonyp]

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

[Geraint]

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

[hooha]

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]

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