TOPIC: Recurring Events

Hey I'm just wondering if anyone out there has an answer for recurring events. I have 2 events that happens every Monday night. I know DT Register does not support recurning events... and that's why I'm asking... Does anyone have a script that can put an event in 52 times... Right now I have the event setup as recurring in JEvents... and DT Register is working fine with it... Just don't try to use the Email All Users etc... But the client doesn't like the way it shows up in the schedule... So she want me to put the event into JEvents... 52 times a year.... then set each one up in DT Register for registrations... A tedious task at least... Just wondering if any body... has any idea on this... cron job to add the event to the proper tables etc... I should also mention that I have 6 custom fields. Any idea would be appreciated.

I need this too!
I bought this component thinking that it would be good for recurring events, then after install found it doesn\'t do it. Which, sorry if this offends - But, is pretty stupid to develop a component based on another and leave out its most used function.

That said, despite the recurring event registration being MUCH needed, DT Register is a still a good component despite having to enter several recurring events 52 times plus each. (and I thought computers where made to make life easier!)

I need recurring events support, too. I have a seasonal Farmer\'s Market where I want to schedule people picking up produce.

I think I know what the issue is...that JEvents calculates the future dates on the fly, so there are no *real* database records for DTRegister to link to.

I think I posted something to the forum about generating date information with Excel or something and importing into JEvents to simulate recurring events. I guess I will have to do that for now, too.

I found a good starting point tip at http://lists.evolt.org/archive/Week-of- ... 48308.html

Ken

Enter your Event as a single nen-recurring event. Go into your dB using PHP my Admin or whatever, export the single event as csv, then replicate it in excel by dragging, then import the csv into excel. That will get you all the events as single events into JEvents. Am assuming you can replicate the same for DTReg, just have to have a look and see what the join field is....That\'s my plan anyway!

Hey rdbean, How did that work out? I think that you were angling to generate the events in Excel then use a CSV import, and I have had grief with that.

I have what I think is a pretty hot way of doing this, but it took me hours of having Access give me error messages, and finding out that Excel data connections seem to not be live, i.e. don\'t allow adding data.

Anyway,

Create one occurrence of each event.
Use any tool like PHPMyAdmin, etc. to generate a SQL dump of records you want to replicate.
Open the file in a good editor that has a Column mode. I use UltraEdit.
Null out the ID field of the one original record for the event you are working on, so that you aren\'t creating key errors.
Make a bunch of copies of that line in your file.
Go to Excel, and create a column of the dates you want, using a simple formula like =A1+7, and copy that for as many weeks as you want.
Use Right Click, format cells on the dates to make them into yyyy-mm-dd format.
Copy the dates.
Go to the SQL file in your editor.
Go into column mode, and replace the column of publish up and publish down dates with your copied dates.

Once you know what you are doing, it\'s fairly quick.
Now, just take your SQL back to PHPMyAdmin and run it.

The cool thing is that you don\'t have to mess with the field mapping in PHPMyAdmin or the errors that Access seems to give around null fields. You can also easily use search and replace and do the insert again.

To make this fully functional, you have to have a record in jos_dtregister_group_event for each event. Do the same trick. More precisely, you are omitting the \'slab_id\' primary key from the insert. You have to make the event_ids in the insert match up with the event ids that got created in the prior (events) insert.

Set up Registration under Registration Management for one event.
Export the SQL for that record.
In Ultraedit, use column mode, and you can fill with sequential numbers.
Run the SQL file.

To make it really, really good, you might want to apply the same trick to jos_dtregister_field_event. That insert looks like:
INSERT INTO `jos_dtregister_field_event` (`field_id`, `event_id`, `showed`) VALUES
(1, 81 , 1),

And you just have to make a bunch of rows with the eventids as the middle number for which you want the field to be active.

Post any improvements here, please.

Please also encourage Nathan to step up and create a simple PHP script for us to clone events.

Update: 5/27/08 - I just did this again, and am glad I had this note to refer back to. It really is just a couple of minutes, once you know where all the buttons are.

Thanks,
Ken

I am in a similar boat, I purchased this component, for the recurring events, and it doesn\'t work for it...

can I see your end result site, I am not sure I understand, you just made a copy of the one event, and put it in jevents multiple times, so it would appear on the jevents calendar? If I can see your site, then maybe I would understand better what you did.

My website I am setting up classes that people can register for online. Each class has a start and end date, and runs a specific day of the week, and at a specific time.

thanks so much!

-- Laura