Google calendar allows importing tasks from a .csv file, so this can be combined with the TeamPulse feature to export work items (including tasks) into the same format.
Thanks to this straight-forward export/import process, a portion or all of your project related tasks can be synchronized with any device using Google calendar and you can always keep an eye on your assignments.
In order to import your tasks from TeamPulse into Google calendar you need at least:
TeamPulse R2 2013 version
This TeamPulse version supports both export/import of work items to a .csv file and the creation of custom fields for any work item.
Then it is a matter of following 3 easy steps.
In order to create or import a calendar appointment you’d need as a bare minimum the following tasks properties in TeamPulse. These two are also mandatory for Google calendar to allow import:
The following are not obligatory but nice to have:
From the ones above, “Description” already exists, but for the rest you’ll need to create custom fields in TeamPulse as follows:
Start TeamPulse and go to Settings >> Work Items >> Manage Custom Fields >> add “New Field”
Then configure the custom field attributes as per the example below:
This is how the modified tasks would look like in TeamPulse. Note that in the “Start Time” field you should use the AM/PM format, because it is the only one supported by Google Calendar.
The fastest way to do it is to create “New View” in TeamPulse, filter to display type = task and you’ll get a list of all your tasks. Filter any further if you want to narrow the data. Then click on “Export” and choose either of the options.
The minimum amount of header information required to import events into Google Calendar is: Subject, Start Date. Also the Date column should be mm/dd/yyyy, so make sure your .csv file is formatted accordingly.
This is how an imported TeamPulse task looks like in Google Calendar:
Did you know that TeamPulse now offers Git Integration and REST API?
Check out what's new in TeamPulse R3 here.
Subscribe to be the first to get our expert-written articles and tutorials for developers!