Free web service converting ICS files to CSV

Merlin on Mac can import all day events of ics (calendar) files as exceptions in the ‘working time’ inspector of your Merlin project or resources.

It can also export project scheduling (or resources’ assignments) as ics files so you can use them in your calendar applications.

Some Merlin users may however want to import events or todos of ics (calendar) files as activities in their Merlin projects. This is also possible if one first converts the ics files to csv and drags the csv file in a second step to Merlin.

To help our Merlin users with the conversion task, we’ve provided a free web service:

ics to csv converter

Click here to convert an ics file to a tab delimited csv file…

Please use and share it with others if find appropriate 🙂

 

MERLIN – DO A BIT OF MAGIC IN REPORTS – PART XVIII

Those of you who have checked our new post series about “Merlin report templates” know by now…

Now let’s do some magic with the reports.


Calendar View

If you like to report  working days of your project’s scheduling and/or assigned resources, this is a custom report template to use.

You may check contained ‘CalendarView.py’, “CalendarView.wbl” to see how we iterate in project’s duration, convert dates to the desired formats and color the table on working days.

Feel free to modify this custom report further as you require for your needs.

Some output samples:

Showing project scheduling grouped by month.

Or resource’s working days grouped by week… Continue reading

Merlin – change the preselected project calendar

Merlin provides a user friendly interface to modifying the project calendar.

Project calendar can be accessed in a tab of the inspector when the top most row (row “#0”) in the activities view is selected.

In the “Regular” tab you may modify the work intervals of the working week days if required.

You may also choose to change the preselected project calendar all together and switch from “Standard” to “Night Shift” for example.

Just select the desired project calendar from the appropriate pop up on the top right area of the inspector and make it your main project calendar afterward.

Please find hereafter a screencast of those actions Continue reading

Merlin – Exceptional working days

If you want to enter some exceptional working days in a Merlin project, for example when needing to plan and schedule work during the weekend, you do this in the ‘working time’ inspector.
If you need this information for the whole project, you click the top most entry in the activities views. You switch to the ‘working time’ inspector and add an exception for the specific date in the ‘exceptions’ tab. Continue reading

Merlin: 24h calendar

Sometimes you plan activities in projects, which can be done by equipment. Machines or computer which may run unattended, do not need regular working hours and can work 24h a day, 7days a week.  Surely you have assigned real person as resources for activities in the past and you know how to do this in Merlin, but how to proceed when having equipment resources?

The good news? This is as easy as setting up person resources.

Continue reading