TOPIC: Manually generating Event Registration Reports?

Manually generating Event Registration Reports? 13 years 10 months ago #12491

soccerbum
Topic Author
Offline
Expert Boarder
Posts: 112
Thank you received: 0

Heya dthadmin,

I've been taking a break from DTRegister since I'd finally gotten everything to work after so long, but now I find myself drawn back to it because I'd like to do something (on my own manually if need be until DTRegister has something supporting it later) which involves exporting Event registrations.

Basically my situation is two nights a week (twice a night, so 4 times total per week) I print out a copy of the Event Records for each Event right before I leave for the Event (my Event's on a soccer field so printing at the location's not an option). Inevitably I get people who've signed up in the 30 minute gap between when I print it out and when the Event starts. While it's technically possible to log into the backend on my android phone and see the list, the formatting isn't really setup for a mobile device.

I'd like to either create a new table in the MySQL backend which will house the results from a query, which I can then render as a viewable page on my phone or utilize some sort of latent (if existing) ability for DTRegister to automatically export (CSV) an Event's records so that I can create a small/short batch/shell script that'll present the data I need to do a roll call 4 times a week.

I've been browsing the jos_dtregister tables and it appears there's no table within the database that houses everything I need there, so it's looking like a multi-table query? Maybe getting the CSV export automated and working with it is easier? Which would you recommend?

Cheers,

-soccerbum

Please Log in or Create an account to join the conversation.

Manually generating Event Registration Reports? 13 years 9 months ago #12747

ismadman
Offline
Expert Boarder
Posts: 97
Thank you received: 0

Heya partner in crime . I think I have the solution for you if you know a bit of mysql.
Its called SQL 2 Excel Pro
You can grab it HERE
(hope linking is ok)
I use this on another site i have
You can basically load your query ( or multiple ) from any table in your database
Or field column etc
It is fantastic . Then using the Module you can display it on a restricted page on your website . Or you can set permissions for access etc
You can download your tables OR view them on your site in a spreadsheet layout .
At first it was a bit confusing to set up . But they have heaps of examples to get you going .
For eg . This is one of my worsheet queries I use

SELECT DATE_FORMAT(start_date, '%d-%m-%Y')  AS 'Date', jos_users.name AS 'Tech',  jos_events_rec.text as 'Name', jos_events_rec.event_location AS 'Address', jos_events_rec.tech_notes AS 'Work Done', jos_events_rec.amount AS 'Amount', jos_events_rec.paid AS 'Paid', jos_events_rec.accountcomment AS 'Comments', jos_events_rec.payment AS 'Payment'
FROM jos_events_rec
LEFT JOIN jos_users
ON jos_events_rec.user=jos_users.id
WHERE start_date >= '2011/3/1' AND end_date <= '2011-3-31' AND type='type_4'
ORDER BY jos_events_rec.start_date ASC

It is a fantastic piece of work and you can do exactly what you are after with it
In fact you could do anything pertaining to anything in your database which is great .
I use it for my DHTMLX Event Scheduler .
And after its set up its all done and gives you info at any time you need it
Hope it helps you mate .
Any questions feel free to hit me up .
Kev

Please Log in or Create an account to join the conversation.

Manually generating Event Registration Reports? 13 years 9 months ago #12748

ismadman Offline Expert Boarder Posts: 97 Thank you received: 0	Actually ...lol....just had a thought...my clients have been asking for this same thing almost...I might set it up on my dt reg site and post my findings.... fun fun fun hahahahaa Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

Manually generating Event Registration Reports? 13 years 9 months ago #12753

soccerbum Topic Author Offline Expert Boarder Posts: 112 Thank you received: 0	Nice! It's 6:30am here and I'm outta brain juice. I'll hit your posts up when I'm recharged. -soccerbum Check this box to be notified of replies to this topic. Note: BBcode and smileys are still usable.
	Please Log in or Create an account to join the conversation.

DT Register

General Discussion - Joomla 1.5

Manually generating Event Registration Reports?