×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: V2.0 Database - Seminar to Matukio

V2.0 Database - Seminar to Matukio 11 years 8 months ago #16916

  • Rob Boerlage
  • Rob Boerlage's Avatar Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 85
  • Thank you received: 0
Hi Yves,

I know it is possible to get all Seminar data into Matukio by renaming tablenames.

Could you please explain step by step how to do that?

Regs,

Rob

Re: V2.0 Database - Seminar to Matukio 11 years 8 months ago #16917

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
Hi Rob,

there are several ways to do this, with version > 2.0 it's a bit more complicated, because we changed the table structure a bit.

First way (mostly Joomla):

Install Matukio 1.0, drop the new created tables (for example with phpmyadmin), except #__matukio_settings and rename the old seminar tables to the new database scheme. After this update to the current Matukio version. Check if the MySQL tables are equal to the one's you find in sql/install.mysql.sql file.

Second Way (mostly MySQL):

Export the Seminar table data using phpmyadmin for example, install Matukio and reimport (change the sql insert statements to the new table scheme) the exported data.

Third Way (mostly MySQL, bit more complicated):

Rename the old Seminar tables to the new matukio scheme. Take a look at the sql/install.mysql.sql from Matukio how they have to look like. Alter the renamed tables (see script.php for the Alter Statements), create Matukio coupons, fields and settings table and insert the default data (also from script.php) into it.


Best regards,

Yves
The following user(s) said Thank You: Rob Boerlage

V2.0 Database - Seminar to Matukio 11 years 7 months ago #17157

  • Rob Boerlage
  • Rob Boerlage's Avatar Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 85
  • Thank you received: 0
Hello Yves,

I can't get the the old Seminar data to migrate to Matukio.

Is there a possibility that you make an Component (or Module) for me (all of us) that automatically migrates the old Seminar data to Matukio?

I would be very happy with that, otherwise I have to re-enter all events by hand...

Kind regards,

Rob

V2.0 Database - Seminar to Matukio 11 years 7 months ago #17163

  • Yves Hoppe
  • Yves Hoppe's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 3519
  • Karma: 71
  • Thank you received: 556
Hi Rob,

we thought about a migrator with version one, but we discarded that then, because you just have to rename the tables.

If you need help with it, you can add me on Skype and i help you through it.

Best regards,

Yves

V2.0 Database - Seminar to Matukio 11 years 7 months ago #17169

  • Rob Boerlage
  • Rob Boerlage's Avatar Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 85
  • Thank you received: 0
Hello Yves,

Yes please, that would be wonderfully.

I will try and contact you by Skype and maybe we could start a teamviewer session?

Manny thanks,

Rob

V2.0 Database - Seminar to Matukio 11 years 7 months ago #17268

  • Rob Boerlage
  • Rob Boerlage's Avatar Topic Author
  • Offline
  • Expert Boarder
  • Expert Boarder
  • Posts: 85
  • Thank you received: 0
Hi Yves,

As I am running out of time, I already entered the upcomming events manually.

The only problem now is that I am not able to enter the registrees. I have opened a new bug report for this.

Thanks!

Rob

V2.0 Database - Seminar to Matukio 11 years 6 months ago #17738

  • Bernhard Knötig
  • Bernhard Knötig's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Karma: 1
  • Thank you received: 0
I was successful in migrating from Seminar to Matukio.
Followed simply the steps of First Way.

Saved the tables
jos_sembookings
jos_seminar
jos_semnumber

with phpMyAdmin (Settings >Export>Custom> selcet the tables > mark "Add DROP TABLE... statement"
klick "ok"

jos_ was my database prefix
j25_ is my new prefix

Installed Matukio Version 1 BETA (! important!)

Edited the downloaded SQL file with a texteditor
and repaced every "jos_seminar" with "j25_matukio"
jos_sembookings > j25_matukio_bookings
jos_semnumber > j25_matukio_number

Then updated to v 2.1 did new settings and everything ist fine now
Took me about 20 Minutes ;-)

V2.0 Database - Seminar to Matukio 11 years 6 months ago #17739

  • Christian
  • Christian's Avatar
  • Offline
  • Senior Boarder
  • Senior Boarder
  • Posts: 53
  • Thank you received: 0
Hello,

Is somebody actually using the matukio extention?

I always used seminar (old booking form for registered users, and this is not working with with matukio 2.1.0

... My site is completely updated to 2.5 (jce, rsformpro, docman, gcalendar, phocagallery)
All I am waiting for is .... :(

gtz
Christian

V2.0 Database - Seminar to Matukio 11 years 6 months ago #17740

  • Bernhard Knötig
  • Bernhard Knötig's Avatar
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 2
  • Karma: 1
  • Thank you received: 0
As you can see I'm using it and I think it works fine.
Even some core-hacks I had in Seminar I could redo in Matukio very easy.

The only thing you have to do is to pay and download ;-)

Yes I know, nobody wants to pay for something he cannot test, but I took the risk rather than waisting time with searching around for free solutions.

Function and look&feel is almost like seminar.

If you want to migrate:

Don't forget to install first V 1.0 Beta
, import (as I described step by step) and then upgrade to v 2.1

One quick remark: there is a lil bug in German Language file:
COM_MATUKIO_AT="um" NOT "am" ;-)
  • Page:
  • 1
Time to create page: 0.143 seconds