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 🙂

 

Applescript – MS Excel to Merlin

Can I import a selected range of cell from an MS EXCEL sheet into Merlin as tasks?

Merlin can import various file formats.  For a complete list please check related topic in Merlin online help.

The official way to import MS EXCEL documents is to save them as csv files, and to open the csv file in Merlin in a second step.

  • So you select in MS EXCEL File > Save as… > Comma Separated Values (.csv)
  • You drag the csv text file to Merlin’s project listing and
  • map the fields of the csv files to Merlin columns.
  • Merlin will then import the file into the existing project.

To quicken things however, we have created a small Applescript sample, which handles the current MS EXCEL selection, goes through its rows and enters them as tasks into an existing Merlin project.

If interested, feel free to download, use or modify as you like.  Continue reading

Merlin: CSV duration units

Duration unitsThere is a new feature in Merlin 2.7.6 and its CSV reading & writting possibilities.

You can now define the unit for the durations and choose one of the following: Seconds, Minutes, Hours, Days, Weeks, Calendarweeks, Months and Years.

This is very practical in case you want to import project information in spreadsheets of MS Excel, Numbers, etc and need further calculations referencing duration data.

In this case simply choose the appropriate unit when exporting. Merlin will recalculate project durations if necessary in the output.

Continue reading