Mapping JCalPro Events and Categories in to JEvents using Microsoft Access: Install JEvents, so that you have both the JCalPro and JEvents tables in the same database... JEvents puts categories into the Jos_categories table, with section (field) = com_events, so do this: INSERT INTO jos_categories ( name, title, description, [section], image_position, published ) SELECT jos_jcalpro_categories.cat_name, jos_jcalpro_categories.cat_name, jos_jcalpro_categories.description, "com_events" AS Expr1, "left" AS Expr2, "1" AS Expr3 FROM jos_jcalpro_categories; You can then assign colors manually, or figure out the SQL to insert them. main table is jos_events - Insert the JCal Events there, using the new CategoryIDs you created: INSERT INTO jos_events ( title, content, contact_info, extra_info, catid, publish_up, publish_down, approved, state ) SELECT jos_jcalpro_events.title, jos_jcalpro_events.description, jos_jcalpro_events.contact, [url] & "<br>" & AS Expr1, jos_categories.id, jos_jcalpro_events.start_date, jos_jcalpro_events.end_date, jos_jcalpro_events.approved, jos_jcalpro_events.published FROM (jos_jcalpro_events INNER JOIN jos_jcalpro_categories ON jos_jcalpro_events.cat = jos_jcalpro_categories.cat_id) INNER JOIN jos_categories ON jos_jcalpro_categories.cat_name = jos_categories.name WHERE (((jos_categories.section)="com_events")); Have fun with this. YMMV, worked for me. Enhancements are welcome. For example, make the queries generic SQL instead of Access SQL. Best, Ken[email] AS Expr1, jos_categories.id, jos_jcalpro_events.start_date, jos_jcalpro_events.end_date, jos_jcalpro_events.approved, jos_jcalpro_events.published FROM (jos_jcalpro_events INNER JOIN jos_jcalpro_categories ON jos_jcalpro_events.cat = jos_jcalpro_categories.cat_id) INNER JOIN jos_categories ON jos_jcalpro_categories.cat_name = jos_categories.name WHERE (((jos_categories.section)="com_events")); Have fun with this. YMMV, worked for me. Enhancements are welcome. For example, make the queries generic SQL instead of Access SQL. Best, Ken
