You are here: Home Support Forums JEvents (Free Forums) Pre-Sales List of Events from eventcreator ical export
Recent
Categories
Tags
View Replies (3)

Resolved csv import does not create entries in catmap

0
Votes
Undo
  1. abgoesnuts
    abgoesnuts
  2. Contribute to JEvents
  3. Saturday, 26 May 2012
The multi category feature (component release 2.2.0beta3) uses the new catmap table. However when importing from a csv file the categories entry is put in the categories column of the #__jevents_vevdetail table and no entries are created in the catmap table. Without those entries the events don't show up in the front end. :(

As a workaround I created a trigger on the #__jevents_vevent table to create these entries. This worked and confirmed my analysis. I assume you want to fix this bug? ;)
Community builder & jevents
Get Agenda & Minutes Fields in listeventsbody....
Responses (3)
geraint
geraint
Support Team
Accepted Answer Pending Moderation
0
Votes
Undo
I thought I'd found all the places where all the 'multi' vs 'single' category events would need to change. It looks as though I missed this one :(

Can you give me your code changes and I'll make sure they are incorporated into the next release?

thanks for the detective work!

Geraint
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
  1. more than a month ago
  2. Contribute to JEvents
  3. # 1
abgoesnuts
abgoesnuts
Accepted Answer Pending Moderation
0
Votes
Undo
I hope this is usefull. Like I said, I created a workaround using a database trigger. My core skills are java, jsf, (PL)/SQL. I'm just starting out with Joomla and php.

translated the joomla table prefix to #_



create trigger event_after_insert after

insert

on

    #__jevents_vevent for each row begin

    -- code:

    if not exists

    (

        select

            1

        from

            #__jevents_catmap cm

        where

            cm.evid = new.ev_id

        and cm.catid = new.catid

    )

    then

insert

into

    #__jevents_catmap

    (

        evid,

        catid,

        ordering

    )

    values

    (

        new.ev_id,

        new.catid,

        0

    ) ;



end if;

end;
  1. more than a month ago
  2. Contribute to JEvents
  3. # 2
geraint
geraint
Support Team
Accepted Answer Pending Moderation
0
Votes
Undo
thanks for this - I have now implemented php code that will set the multiple categories (if set) - this will be in the next release of JEvents 2.2.

I'll also clear the map table when deleting the event.

Geraint
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
  1. more than a month ago
  2. Contribute to JEvents
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!

Members Area

Show your support

Unlike many Joomla calendars we do not charge to download JEvents - please show your support for this project by becoming a member of the JEvents Club Club members get access to early releases, exclusive member support forums, and Silver and Gold members can use many exciting JEvents addons

Your membership will ensure that JEvents continues to be the best events calendar for Joomla.

Login Form