For most people CSV/iCal import provides enough capability/flexibility but I guess if you're importing from an existing database/another calendar it may not be the best way to go. If your existing source has an iCal export facility then you can maintain a dynamic import by creating a synchronised iCal import into JEvents from an external URL and keep it updated using an cronjob.

You need to consider the jevents_exceptions table too and also the linkage to the main Joomla categories table and possibly the jevents_catmap table if your events are mulit-category.

As a result you'll see there is a lot to consider in terms of direct database injection.

Another way to go is to interact with the JEvents code you can get ideas on how to do this in the iCalImport.php and saveIcalEvent.php files.

I can provide some more technical advice to silver+ members in the club member forum.

Hey nobicyle,

I have the same problem and stumbled over your post. Have you figured out yet how to do the direct import via SQL?

If you could provide any help, that would great. I started reverse reverse engineering, but it's quite a pain.

I already accomplished to insert the data in the tables
#__jevents_vevent
#__jevents_repetition
#__jevents_rrule
#__jevents_vevdetail

but that is not sufficient.

Thank you