to confirm, I will be directly importing the CSV into the database and not using the .iCal.

Hello Hughc91,

It is possible but quite complex getting all our table maps etc in place.

Could you not use our importer? or setup an import to google then import automatically to JEvents?

You can try it out with out as JEvents core is free so the event system is all there.

Thanks
Tony

Perhaps it might be possible.

What I'm trying to do is integrate with other software currently used. I am already importing directly into the database for other areas of the site, such as the users.

What is more. There are about three/four different categories which I would like to appear in different colors. The main problem is giving users access to their, and only their calendars.

The calendar could change hourly and I have to take into account rescheduling. So that once an event is created, an hour later it could have then been deleted or altered in some way.

The one positive I have is that all of the events are held in one table on the MSSQL side, so there are no repetitions.

Again I am very appreciative of your help.

Thanks
Hugh

If you can generate a CSV file in the right format and can place the file on the server so that an auto-updating script can read the new version the import should be fine. See http://www.jevents.net/jevents-15-topme ... csv-format

You could create a separate import for each calendar (which is owned by a different user) then a couple of the silver member addons (user specific events, calendar specific menus/modules) could be used to create private personal calendars based on the imported data.

Geraint

Thank you for your reply.

To be honest that sounds a bit beyond my capabilities.

I have made things easier for my myself by naming the username of the Joomla user the same as their employee id. Would it not therefore be possible to add another column into the vevents table for the employee ID and then add "WHERE employeeid = $username" to the SQL statement?

I have had a look at doing this, but I couldn't find the file to write this. If this doesn't work I think I will look at another solution.

If you feel this is too much advice for an nonpaying user that is completely fair enough.

Thanks
Hugh

Are you able to create separate CSV files for each user? If you can do that then the rest of the process is easy