Thread Starter
squidz
(@squidz)
Is there any support for this plugin? What happend to the creator of the plugin?
Plugin Author
amitai
(@ty_pwd)
Version 2 is using a different database scheme. When upgrading, the plugin creates new tables and use them instead of the old ones. The old tables are kept (for now).
Please check if the new database tables have been created (wcs2_class, wcs2_classroom, wcs2_instructor, wcs2_schedule).
Thread Starter
squidz
(@squidz)
Hey Ty – you exist!! I appreciate you chiming in.
Yes. I figured out it’s creating new tables…with no easy way to port over existing data.
The problem is that it took hours to input the schedule the first time.
I didn’t see it mentioned anywhere that upgrading would result in having to fully re-input one’s data. That is a pretty major reason not to ever upgrade – if one constantly has a fairly complex schedule in place.
My client is asking whether we should consider going back to a PDF schedule. I haven’t found any class schedule plugin that comes as close to what we need as yours. But starting over is not a reasonable option. My client doesn’t know how to port the information, they don’t want to rebuild it from scratch and would prefer not paying to have me do it for them.
Do you have any suggestions to make upgrading reasonable for those of us that have existing schedules?
Plugin Author
amitai
(@ty_pwd)
The data from the old tables should be imported to the new tables automatically. I actually spent a fair amount of time making sure it is safe to upgrade (see includes/WcsDb.php) and this issue hasn’t been reported so far (many users have upgraded successfully).
Anyway, it’s impossible to know what the problem is without the db error. Please post it.
Thread Starter
squidz
(@squidz)
Well, I attempted to upgrade on a live site, and the result was empty schedule pages. I tried on a local dev version of the site and got the same result.
There was was no db error. The schedules simply do not display. I ran the update. It reported success and that was it.
Now, the shortcodes I have are more complex than just dropping in one big schedule. The most complex one is below. We have multiple classes, classrooms and adding to the complexity is these are offered to different age groups. So I had to get somewhat creative with classrooms and instructors. Your new version includes a setting to allow classroom/time conflicts, which would allow us to simplify this one’s structure.
EXAMPLE SHORTCODE: For children’s class schedule
[wcs classroom=”Age 3″ “Age 3-4” “Age 4” “Age 5-6 – Ballet” “Age 5-6 – Jazz” “Age 5-6 – Tap” “Age 7-9 – Ballet Intro” “Age 7-9 – Ballet 1” “Age 7-9 – Ballet 2” “Age 7-9 – Jazz Intro” “Age 7-9 – Jazz 1” “Age 7-9 – Jazz 2” “Age 7-9 – Tap Intro” “Age 7-9 – Tap 1” “Age 7-9 – Tap 2” “Age 7-9 – Hip Hop” “Age 10-12 – Ballet Intro” “Age 10-12 – Ballet 1” “Age 10-12 – Ballet 2” “Age 10-12 – Ballet 2/3” “Age 10-12 – Ballet 3” “Age 10-12 – Jazz Intro” “Age 10-12 – Jazz 1” “Age 10-12 – Jazz 2” “Age 10-12 – Jazz 2/3” “Age 10-12 – Jazz 3” “Age 10-12 – Tap Intro” “Age 10-12 – Tap 1” “Age 10-12 – Tap 2” “Age 10-12 – Hip Hop”]
You can view the live version of this here: http://www.houstonmetdance.org/childrens-classes
EXAMPLE SHORTCODE: for teen/adult schedule. Even this one does not import the data
[wcs classroom=”Ballet” “Pointe” “Jazz” “Tap” “Hip Hop” “Modern” ]
This one is viewable here: http://www.houstonmetdance.org/teenadult-schedule
I’m willing to run the updated again on my local version to see if any error arises.
Plugin Author
amitai
(@ty_pwd)
Was the information imported successfully to the new database tables?
Plugin Author
amitai
(@ty_pwd)
In the new version, for multiple “classrooms” your shortcode will need to look like this:
[wcs classroom="Ballet"]
[wcs classroom="Pointe"]
[wcs classroom="Jazz"]
[wcs classroom="Tap"]
[wcs classroom="Hip Hop"]
[wcs classroom="Modern"]
Thread Starter
squidz
(@squidz)
I’m not positive about the import since I had not checked the database tables. I had no way of knowing what the behavior should have been.
I will run a local test and see if I can parse out the shortcode correctly and report back.
Thanks Ty.
