help to better help you:
Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!
Can I Upgrade From Event List to JEM
Re: Can I Upgrade From Event List to JEM
12 years 5 days ago - 11 years 11 months ago
@Bluefox
Thank you for the fix, but the description field in some of my (3002!) events contained HTML and CSS, for some reason, so that broke my CSV export.
I had to do it the hard way, which turned out not to be too hard after all, so I made a quick tutorial to aid others in my position.
You'll need:
Access to your phpMyAdmin
Your source code editor of choice (I use Notepad++).
Half an hour of time.
Log in to phpMyAdmin, navigate to your sites database.
Export
*prefix*_eventlist_categories
*prefix*_eventlist_events
*prefix*_eventlist_venues
through Export Method Custom to SQL.
Open the file in your source code editor, set the database name to match up with your site containing JEM.
Copy and store the whole events section of the file.
Find and replace (CTRL+H) *prefix*_eventlist_ with *newprefix*_jem_ corresponding with your JEM powered Joomla sites prefix.
Paste your previously copied event section to the end of the file.
Find and replace *prefix*_eventlist_events with *newprefix*_jem_cats_event_relations , again corresponding with your sites prefix.
Save the file.
In phpMyAdmin you can now navigate to your JEM powered sites database, and delete:
*prefix*_eventlist_categories
*prefix*_eventlist_events
*prefix*_eventlist_venues
*prefix*_eventlist_cats_event_relations
Import the file you just saved.
Navigate to *prefix*_jem_categories , look at the structure tab, there should be 14 rows representing the categories' table columns.
Add one column after image with the following values:
Name:color; Type:varchar; Length:20; Collation:utf_general_ci; Null:☐
Navigate to *prefix*_jem_cats_event_relations structure tab.
Delete all columns except id and catsid. Rename id - itemid and catsid – catid. Add the column ordering at the end of the table (Type:tinyint(11); Null:No; Default:None).
Navigate to *prefix*_jem_events structure tab.
Delete column three (catsid). Add the columns from the picture attached to this post, in the right place, with the right values. To save some time, here is the SQL query to columns 34-44.
Navigate to *prefix*_jem_venues structure tab.
Rename column six (plz) to postalCode. Add columns from the attached picture, right place, right values.
Log in to Joomla, look at the magnificence and pat yourself on the shoulder.
Thank you for the fix, but the description field in some of my (3002!) events contained HTML and CSS, for some reason, so that broke my CSV export.
I had to do it the hard way, which turned out not to be too hard after all, so I made a quick tutorial to aid others in my position.
You'll need:
Access to your phpMyAdmin
Your source code editor of choice (I use Notepad++).
Half an hour of time.
Log in to phpMyAdmin, navigate to your sites database.
Export
*prefix*_eventlist_categories
*prefix*_eventlist_events
*prefix*_eventlist_venues
through Export Method Custom to SQL.
Open the file in your source code editor, set the database name to match up with your site containing JEM.
Copy and store the whole events section of the file.
Find and replace (CTRL+H) *prefix*_eventlist_ with *newprefix*_jem_ corresponding with your JEM powered Joomla sites prefix.
Paste your previously copied event section to the end of the file.
Find and replace *prefix*_eventlist_events with *newprefix*_jem_cats_event_relations , again corresponding with your sites prefix.
Save the file.
In phpMyAdmin you can now navigate to your JEM powered sites database, and delete:
*prefix*_eventlist_categories
*prefix*_eventlist_events
*prefix*_eventlist_venues
*prefix*_eventlist_cats_event_relations
Import the file you just saved.
Navigate to *prefix*_jem_categories , look at the structure tab, there should be 14 rows representing the categories' table columns.
Add one column after image with the following values:
Name:color; Type:varchar; Length:20; Collation:utf_general_ci; Null:☐
Navigate to *prefix*_jem_cats_event_relations structure tab.
Delete all columns except id and catsid. Rename id - itemid and catsid – catid. Add the column ordering at the end of the table (Type:tinyint(11); Null:No; Default:None).
Navigate to *prefix*_jem_events structure tab.
Delete column three (catsid). Add the columns from the picture attached to this post, in the right place, with the right values. To save some time, here is the SQL query to columns 34-44.
Code:
ALTER TABLE `*prefix*_jem_events` ADD `contactid` TINYINT(4) NOT NULL DEFAULT '0' AFTER `published`, ADD `custom1` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `contactid`, ADD `custom2` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `custom1`, ADD `custom3` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `custom2`, ADD `custom4` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `custom3`, ADD `custom5` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `custom4`, ADD `custom6` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `custom5`, ADD `custom7` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `custom6`, ADD `custom8` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `custom7`, ADD `custom9` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `custom8`, ADD `custom10` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `custom9`;
Navigate to *prefix*_jem_venues structure tab.
Rename column six (plz) to postalCode. Add columns from the attached picture, right place, right values.
Log in to Joomla, look at the magnificence and pat yourself on the shoulder.
Eventlist 1.0.1 | Joomla! 3.1.5 | PHP 5.4.16 | JEM 1.9.3
Last edit: 11 years 11 months ago by kaape.
Please Log in or Create an account to join the conversation.
Re: Can I Upgrade From Event List to JEM
11 years 11 months ago
Dear all,
I have managed to convert my Joomla 1.0.2 which I'm running to v1.9.2.47 which is so exiting.
I followed kaape's instructions and it seems to be working
after some initial testing.
To help with altering the tables I've noted my SQL statements which I have used as I went while following the instructions...
I've notices in kaape's description a discrepancy with regards to field names: he was writing recurrence_by_day but the code uses recurrence_byday. This adjustment is included in the code below.
This is the stuff for the events table
On the Events table I had to drop one field, this was not in the original JEM Events table.
And this for the venues table
Guys keep on the hard and great work! I'm really waiting for the final stuff!!!!
All the best
chrisd
I have managed to convert my Joomla 1.0.2 which I'm running to v1.9.2.47 which is so exiting.
I followed kaape's instructions and it seems to be working
after some initial testing.To help with altering the tables I've noted my SQL statements which I have used as I went while following the instructions...
I've notices in kaape's description a discrepancy with regards to field names: he was writing recurrence_by_day but the code uses recurrence_byday. This adjustment is included in the code below.
This is the stuff for the events table
Code:
ALTER TABLE `*prefix*_jem_events` ADD `version` INT( 11 ) NOT NULL DEFAULT '0' AFTER `modified_by` ;
ALTER TABLE `*prefix*_jem_events` ADD `recurrence_first_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `meta_description` ;
ALTER TABLE `*prefix*_jem_events` ADD `recurrence_limit` INT( 11 ) NOT NULL DEFAULT '0' AFTER `recurrence_counter` ,
ADD `recurrence_limit_date` DATE NULL AFTER `recurrence_limit` ;
ALTER TABLE `*prefix*_jem_events` ADD `recurrence_byday` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `recurrence_limit_date` ;
ALTER TABLE `*prefix*_jem_events` ADD `maxplaces` INT( 11 ) NOT NULL DEFAULT '0' AFTER `unregistra` ,
ADD `waitinglist` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `maxplaces` ,
ADD `hits` INT( 11 ) NOT NULL DEFAULT '0' AFTER `waitinglist` ;
On the Events table I had to drop one field, this was not in the original JEM Events table.
Code:
ALTER TABLE `*prefix*_jem_events` DROP `catsid`;
And this for the venues table
Code:
ALTER TABLE `*prefix*_jem_venues` ADD `latitude` FLOAT( 10, 6 ) NULL AFTER `country` , ADD `longitude` FLOAT( 10, 6 ) NULL AFTER `latitude` ;
ALTER TABLE `*prefix*_jem_venues` ADD `version` INT( 11 ) NOT NULL AFTER `modified` ;
ALTER TABLE `*prefix*_jem_venues` ADD `publish_up` DATETIME NOT NULL AFTER `ordering` , ADD `publish_down` DATETIME NOT NULL AFTER `publish_up` ;
Guys keep on the hard and great work! I'm really waiting for the final stuff!!!!
All the best
chrisd
Please Log in or Create an account to join the conversation.
Re: Can I Upgrade From Event List to JEM
11 years 11 months ago
Nice to read you found a way to use your existing data. However, it's more like a tedious workaround. 
I am working on an import script that does this with one click and it seems to work on my test installation. I will upload it this weekend if I find no new bugs.
Then I will release a new 1.9.4 version. It would be nice if you could test it and check if the import went ok.
I am working on an import script that does this with one click and it seems to work on my test installation. I will upload it this weekend if I find no new bugs.
Then I will release a new 1.9.4 version. It would be nice if you could test it and check if the import went ok.
Please Log in or Create an account to join the conversation.