.. ==================================================
.. FOR YOUR INFORMATION
.. --------------------------------------------------
.. -*- coding: utf-8 -*- with BOM.
.. include:: ../../Includes.txt
.. _migration-from-seminars:
Migration from EXT:seminars
---------------------------
We migrated an instance from EXT:seminars v2.1 to EXT:sf_event_mgt v4.3
What's included?
^^^^^^^^^^^^^^^^
* Events
* Registrations
* Categories
* Locations (multiple => single)
* Organizers (multiple => single)
* Speaker
We also migrated event types and target groups. The sql queries are basically the same like the category queries. You will need two more category fields in tx_sfeventmgt_domain_model_event for them.
SQL queries
^^^^^^^^^^^
We are starting with a fresh install of sf_event_mgt so we can use ids mostly 1 to 1.
.. code-block:: mysql
/* Organizers */
INSERT INTO tx_sfeventmgt_domain_model_organisator (uid,pid,name,email,email_signature)
SELECT
uid,
pid,
title,
email,
email_footer,
FROM
tx_seminars_organizers
WHERE
deleted = 0;
/* Locations */
INSERT INTO tx_sfeventmgt_domain_model_location (uid,pid,title,address,city,description)
SELECT
uid,
pid,
title,
address,
city,
directions
FROM
tx_seminars_sites
WHERE
deleted = 0;
/* Speakers */
INSERT INTO tx_sfeventmgt_domain_model_speaker (uid,pid,name,description)
SELECT
uid,
pid,
title,
description
FROM
tx_seminars_speakers
WHERE
deleted = 0;
/* Description of speakers */
UPDATE tx_sfeventmgt_domain_model_speaker
SET
description = (
SELECT
CONCAT(
IF (organization!='', CONCAT(organization, '
'), ''),
IF (homepage!='', CONCAT('', homepage, '
'), ''),
IF (email !='', CONCAT('', email, '
'), ''),
description
)
FROM
tx_seminars_speakers
WHERE
tx_sfeventmgt_domain_model_speaker.uid = tx_seminars_speakers.uid
);
/* Events */
INSERT INTO tx_sfeventmgt_domain_model_event (
uid,
pid,
hidden,
title,
teaser,
description,
startdate,
enddate,
registration_deadline,
cancel_deadline,
enable_cancel,
location,
room,
speaker,
price,
enable_registration,
unique_email_check,
max_participants,
registration,
enable_autoconfirm,
enable_waitlist,
notify_organisator
)
SELECT
uid,
pid,
hidden,
title,
teaser,
CONCAT(
IF (
subtitle!='',
CONCAT(
'