We are considering purchasing Jevents to record all of our untimetabled events.

What I need to know is if I can set a cron to delete all of the items in a category and then import them from our CMS. This will reduce the risk of double booked rooms.

Example (every hour)
Delete all items in category "timetabled"
Import a cvs or ical format file from the CMS system.

If this cannot be done within joomla would it be possible using sql to hit the database directly.

I want to know if it is possible, not how to do. I have extensive knowledge of php/sql and joomla but have not used the jevents module before.

Thanks for any answers

Ian
Hereward