TOPIC: Matukio 2.2

Cool!!!
In V2.2 ACL is working the way it should work!

Webmaster vechtstreekmuseum

Hi Yves,

I installed the Developer-Version git_8bca0b0.
I tried to generate an EMail-Template, but I can't save the Templates.

Ever, when I click the save-Button, all the entries disapear and nothing is saved.

Can you imagine, what's the problem?

Regards!
Joachim

Hi Joachim,

can you take a look at the database #__matukio_templates - are there any entries (there should be 7)?

Did you install the dev-version on a Joomla environment which had a previous Matukio Installation?

Best regards,

Yves

Hi Yves,

1. The database is emty.
2. No, I didn't.

Regards!
Joachim

Hmm strange, then something seems to went wrong with the install script. This is the SQL Code you need:

INSERT INTO `#__matukio_templates` (`id`, `tmpl_name`, `category`, `subject`, `value`, `value_text`, `default`, `modified_by`, `published`) VALUES
(1, 'mail_booking', 0, '##COM_MATUKIO_EVENT## MAT_EVENT_SEMNUM: MAT_EVENT_TITLE', '<p>##COM_MATUKIO_THANK_YOU_FOR_YOUR_BOOKING##<br /><br /> ##COM_MATUKIO_BOOKING_DETAILS##:<br />MAT_BOOKING_ALL_DETAILS_HTML<br /><br /> ##COM_MATUKIO_EVENT_DETAILS##:<br />MAT_EVENT_ALL_DETAILS_HTML<br /> <br /> MAT_SIGNATURE</p>', '##COM_MATUKIO_THANK_YOU_FOR_YOUR_BOOKING##\r\n\r\n##COM_MATUKIO_BOOKING_DETAILS##:\r\n\r\nMAT_BOOKING_ALL_DETAILS_TEXT\r\n\r\n##COM_MATUKIO_EVENT_DETAILS##:\r\n\r\nMAT_EVENT_ALL_DETAILS_TEXT\r\n\r\nMAT_SIGNATURE\r\n ', '', 0, 1),
(2, 'mail_booking_canceled_admin', 0, '##COM_MATUKIO_BOOKING_CANCELED## MAT_EVENT_SEMNUM: MAT_EVENT_TITLE (MAT_BOOKING_NUMBER)', '<p>##COM_MATUKIO_THE_ADMIN_CANCELED_THE_BOOKING_OF_FOLLOWING##<br /> <br /> MAT_BOOKING_ALL_DETAILS_HTML <br /> MAT_SIGNATURE</p>', '##COM_MATUKIO_THE_ADMIN_CANCELED_THE_BOOKING_OF_FOLLOWING##\r\n\r\nMAT_BOOKING_ALL_DETAILS_TEXT\r\n\r\nMAT_SIGNATURE', '', 0, 1),
(3, 'mail_booking_canceled', 0, '##COM_MATUKIO_BOOKING_CANCELED## MAT_EVENT_SEMNUM: MAT_EVENT_TITLE (MAT_BOOKING_NUMBER)', '<p>##COM_MATUKIO_YOU_HAVE_CANCELLED## ##COM_MATUKIO_BOOKING_FOR_EVENT_CANCELLED##<br /> <br /> MAT_BOOKING_ALL_DETAILS_HTML <br /><br /> MAT_SIGNATURE</p>', '##COM_MATUKIO_YOU_HAVE_CANCELLED## ##COM_MATUKIO_BOOKING_FOR_EVENT_CANCELLED##\r\n\r\nMAT_BOOKING_ALL_DETAILS_HTML\r\n\r\nMAT_SIGNATURE', '', 0, 1),
(4, 'export_csv', 1, 'ID', '''MAT_BOOKING_NUMBER'';''MAT_EVENT_TITLE'';MAT_CSV_BOOKING_DETAILS', '', '', 0, 1),
(5, 'export_signaturelist', 1, '##COM_MATUKIO_SIGNATURE_LIST##', '<p>MAT_NR MAT_BOOKING_NUMBER MAT_BOOKING_FIRSTNAME MAT_BOOKING_LASTNAME MAT_SIGN</p>', '<table class="mat_table" style="width: 100%;" border="0">\r\n<tbody>\r\n<tr>\r\n<td class="key" width="150px"><strong>##COM_MATUKIO_NR##:</strong></td>\r\n<td>MAT_EVENT_NUMBER</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_FIELDS_TITLE##:</strong></td>\r\n<td>MAT_EVENT_TITLE</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_BEGIN##:</strong></td>\r\n<td>MAT_EVENT_BEGIN</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_END##:</strong></td>\r\n<td>MAT_EVENT_END</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_FEES##:</strong></td>\r\n<td>MAT_EVENT_FEES</td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 0, 1),
(6, 'export_participantslist', 1, '##COM_MATUKIO_PARTICIPANTS_LIST##', '<table class="mat_table" style="width: 100%;" border="0">\r\n<tbody>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_NAME##:</strong></td>\r\n<td>MAT_BOOKING_NAME</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_EMAIL##:</strong></td>\r\n<td>MAT_BOOKING_EMAIL </td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_BOOKING_NUMBER##:</strong></td>\r\n<td>MAT_BOOKING_NUMBER </td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_STATUS##:</strong></td>\r\n<td>MAT_BOOKING_STATUS </td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_BOOKEDNR##:</strong></td>\r\n<td>MAT_BOOKING_BOOKEDNR</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_PAYMENT_FEES##:</strong></td>\r\n<td>MAT_BOOKING_FEES_STATUS</td>\r\n</tr>\r\n<tr>\r\n<td style="text-align: center;" colspan="2">MAT_BOOKING_QRCODE_ID<em><br /></em></td>\r\n</tr>\r\n</tbody>\r\n</table>', '<table class="mat_table" style="width: 100%;" border="0">\r\n<tbody>\r\n<tr>\r\n<td class="key" width="150px"><strong>##COM_MATUKIO_NR##:</strong></td>\r\n<td>MAT_EVENT_NUMBER</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_FIELDS_TITLE##:</strong></td>\r\n<td>MAT_EVENT_TITLE</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_BEGIN##:</strong></td>\r\n<td>MAT_EVENT_BEGIN</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_END##:</strong></td>\r\n<td>MAT_EVENT_END</td>\r\n</tr>\r\n<tr>\r\n<td width="150px"><strong>##COM_MATUKIO_FEES##:</strong></td>\r\n<td>MAT_EVENT_FEES</td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 0, 1),
(7, 'export_certificate', 2, 'E', '<div style="position: absolute; top: 0; left: 0; z-index: 0;"><img src="MAT_IMAGEDIRcertificate.png" border="0" /></div>\r\n<div style="position: absolute; top: 0; left: 0; z-index: 1;">\r\n<table style="width: 734pt;" border="0" cellspacing="0" cellpadding="0">\r\n<tbody>\r\n<tr>\r\n<td rowspan="8" width="180pt" height="1080pt"> </td>\r\n<th width="554pt" height="150pt"><span style="color: #330099; font-size: 48pt; font-family: Verdana;">##COM_MATUKIO_CERTIFICATE##</span></th></tr>\r\n<tr><th width="554pt" height="150pt"><span style="color: #000000; font-size: 28pt; font-family: Verdana;">MAT_BOOKING_NAME</span></th></tr>\r\n<tr>\r\n<td width="554pt" height="100pt"><span style="color: #000000; font-size: 24pt; font-family: Verdana;">##COM_MATUKIO_CERTIFICATE_ATTENDED##</span></td>\r\n</tr>\r\n<tr><th width="554pt" height="250pt"><span style="color: #000000; font-size: 28pt; font-family: Verdana;">MAT_EVENT_TITLE</span></th></tr>\r\n<tr>\r\n<td width="554pt" height="230pt"><span style="color: #000000; font-size: 18pt; font-family: Verdana;">##COM_MATUKIO_BEGIN##: MAT_EVENT_BEGIN</span>\r\n<p style="margin-top: 20pt; margin-bottom: 8pt;"><span style="color: #000000; font-size: 18pt; font-family: Verdana;"><span>##COM_MATUKIO_END##</span>: MAT_EVENT_END</span></p>\r\n<p style="margin-top: 20pt; margin-bottom: 8pt;"><span style="color: #000000; font-size: 18pt; font-family: Verdana;"><span>##COM_MATUKIO_CITY##</span>: MAT_EVENT_LOCATION</span></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width="554pt" height="100pt"><span style="color: #000000; font-size: 18pt; font-family: Verdana;">##COM_MATUKIO_TUTOR##: MAT_EVENT_TEACHER</span></td>\r\n</tr>\r\n<tr>\r\n<td width="554pt" height="100pt"><span style="color: #000000; font-size: 18pt; font-family: Verdana;">##COM_MATUKIO_DATE##: MAT_DATE</span></td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>', '', '', 0, 1);

Replace #__ with you Joomla prefix.

Yves

Hi Yves,

now it seems, that it works.

Thanks.

Regards!
Joachim

Führmann Markus wrote: Hi Yves,

when I use the booking form, then the customer can make in the 2nd step a comment that is not submitted at the moment

Hi Yves,

have you located this problem?

Thank you

Hi Markus,

the comment field is a normal field like every other too - so nothing special about it - should normally be submitted.

Best regards,

Yves

Same here. Fields are not being saved.
I'll have a look in the dbase tomorrow.

Aye there is a bug in the installation script - will be fixed with the next dev release.

Yves

Do you already have a completion date?

Hi there!

I´ve got 2 questions concerning new features of Matukio.

1) Is it possible to add a feature, which sends certain contacts or the complete membership an Email, that a new event is available?

2) Is it possible to let the custom booking fields show up in the booking overview (when i click on the number of rrecieved bookings)?

Thank you in advance

edit:

What else came to my mind is, if you could integrate a feature that sends users an email, when the event details have changed?

Hi Stefan,

1) you could do that manually by contacting all participants as organizer - more is planned in a later version

2) This is also planned for a later version.

Best regards,

Yves

Hi there,

could you give us a fixed release date please? just to be able to plan an upgrade.
Best, Babette

Hi Babette,

yesterday we published the release candidate for 2.2 - if no serious problems are reported we are going to release it at the end of the week.

Best regards,

Yves

I just downloaded and installed latest release candidate. Here are some bugs I found.



* When I want to download CSV (from a Matukio 2.1.10 event), I get "string(158) "

* Can't print participant or signature list - nothing shows
* Cannot set Image for event overview
* When I create a new event with my own custom fields, I get error:

"
Unknown column 'hot_event' in 'field list' SQL=UPDATE `lrn23_matukio` SET `sid`='9',`semnum`='2/13',`catid`='30',`title`='Addis Ababa - Ethiopia | INRM + IPv6',`target`='Network Engineers',`shortdesc`='In four (4) days, learn how to plan and implement IPv6 networks as well as manage Internet resources.',`description`='',`place`='Addis Ababa - Ethiopia',`teacher`='Mukom Akong , Nishal Goburdhan',`fees`='0',`maxpupil`='45',`bookedpupil`='0',`stopbooking`='1',`cancelled`='0',`begin`='2012-09-11 04:30:00',`end`='2012-09-14 13:30:00',`booked`='2012-08-30 08:00:00',`showbegin`='1',`showend`='1',`showbooked`='1',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='8',`published`='1',`updated`='2013-04-17 14:48:43',`publishdate`='2012-07-02 08:11:41',`publisher`='43',`access`='1',`hits`='0',`grade`='0',`certificated`='0',`paid`='0',`gmaploc`='Addis Ababa - Ethiopia',`nrbooked`='1',`pattern`='',`zusatz1`='Phone |1|',`zusatz2`='Gender|1| |radio| Male | Female',`zusatz3`='Job Role|1||select|Network Engineer | Systems Administrator | IT Manager | IT Project Manager | Non-IT Manager | Other',`zusatz4`='Organisation|1|',`zusatz5`='Organisation Address|1|',`zusatz6`='City|1|',`zusatz7`='Country|1||select|Algeria|Angola|Benin|Botswana|Burkina Faso|Burundi|Cameroon|Canary Islands|Cape Verde|Central African Republic|Ceuta|Chad|Comoros|Côte d\'Ivoire|Democratic Republic of Congo|Djibouti|Egypt|Equatorial Guinea|Eritrea|Ethiopia|Gabon|Gambia|Ghana|Guinea|Guinea-Bissau|Kenya|Lesotho|Liberia|Libya|Madagascar|Malawi|Mali|Mauritania|Mauritius|Melilla|Morocco|Mozambique|Namibia|Niger|Nigeria|Republic of the Congo|Rwanda|São Tomé and Príncipe|Senegal|Seychelles|Sierra Leone|Somalia|South Africa|South Sudan |Sudan|Swaziland|Tanzania|Togo|Tunisia|Uganda|Western Sahara|Zambia|Zimbabwe',`zusatz8`='Core job responsibilities|1| |textarea|60|8 ',`zusatz9`='Three best achievements of last 12 months |1| |textarea|60|5 ',`zusatz10`='Projects planned in the next 12 months |1| |textarea|60|5 ',`zusatz11`='Current IPv6 experience|1| |select|Never heard of it | Basic reading online | Can do basic IPv6 configuration | I run an IPv6 network',`zusatz12`='',`zusatz13`='',`zusatz14`='',`zusatz15`='',`zusatz16`='',`zusatz17`='',`zusatz18`='',`zusatz19`='',`zusatz20`='',`zusatz1hint`='Phone number | Type in your phone number, including country and area codes',`zusatz2hint`='',`zusatz3hint`='Job Role | Which of these best describes what you do day-to-day? ',`zusatz4hint`='Organisation | Enter the full official name of your organisation e.g \"African Network Information Center Ltd\"',`zusatz5hint`='Organisation Address |Enter the street address of the headquarters of your organisation',`zusatz6hint`='City| What city is your organisation based in?',`zusatz7hint`='Country| Select the country where you live in from the list ',`zusatz8hint`='Core job responsibilities | One per line, write a a list of your core job responsibilities',`zusatz9hint`='Achievements | One per line, list you 3 best achievements in the last 12 months ',`zusatz10hint`='Planned projects | One per line, list 3 key projects you will be working on in the next 12 months',`zusatz11hint`='',`zusatz12hint`='',`zusatz13hint`='',`zusatz14hint`='',`zusatz15hint`='',`zusatz16hint`='',`zusatz17hint`='',`zusatz18hint`='',`zusatz19hint`='',`zusatz20hint`='',`zusatz1show`='1',`zusatz2show`='1',`zusatz3show`='1',`zusatz4show`='1',`zusatz5show`='1',`zusatz6show`='1',`zusatz7show`='1',`zusatz8show`='0',`zusatz9show`='0',`zusatz10show`='0',`zusatz11show`='0',`zusatz12show`='0',`zusatz13show`='0',`zusatz14show`='0',`zusatz15show`='0',`zusatz16show`='0',`zusatz17show`='0',`zusatz18show`='0',`zusatz19show`='0',`zusatz20show`='0',`image`='',`file1`='',`file2`='',`file3`='',`file4`='',`file5`='',`file1desc`='',`file2desc`='',`file3desc`='',`file4desc`='',`file5desc`='',`file1down`='0',`file2down`='0',`file3down`='0',`file4down`='0',`file5down`='0',`file1code`='',`file2code`='',`file3code`='',`file4code`='',`file5code`='',`created_by`='0',`created_by_alias`='',`created`='0000-00-00 00:00:00',`modified`='0000-00-00 00:00:00',`modified_by`='0',`group_id`='0',`webinar`='0',`hot_event`='0',`top_event`='0' WHERE `id`='14'
"

Hi Mukom,

you can't install developer releases on a Joomla installation which had a previous matukio installation (the database is not updated automatically) - this is causing your sql error.

Same goes for the other problems, the database is not up to date (missing #__matukio_templates for example)

Yves

I uninstalled previous version before installing this release. So how do I get rid of the database? manually?

Aye, manually - we don't delete the tables to prevent data loss

I did a clean install and here are still some bugs I found

1. You have the option "Display Login-form" twice -- this is a minor bug
2. In Event-list view, description doesn't wrap around event image on webkit-based browsers. This is MAJOR

Bug #2 is a deal-breaker for me. Will this be fixed in the 2.2? And when is 2.2 coming out finally?