11-09-2015 08:50 AM - edited 11-09-2015 09:02 AM
Regarding using ACT’S API to export to .MPP Microsoft Project template….
Using Microsoft.Office.Interop.MSProject
Sub AddCalendar()
Application.BaseCalendarCreate "holiday", "Standard"
Dim cal As Calendar
Set cal = ThisProject.BaseCalendars("holiday")
With cal
.Period(#8/1/2015#, #9/1/2015#).Working = False
End With
End Sub
The added benefits of this functionality would be the ability to monitor and track jobs on-the-go as they materialize following Prince2 methodologies and would help the company integrate it’s requirements more closely, the only question I have is if it’s possible to build a quick extension to convert to .mpp format directly.
Kindest Regards
Lionschasing
11-09-2015 08:58 AM - edited 11-09-2015 09:30 AM
Bump. Just a thought? This requirement is for a Gantt Chart, so my question should really be 'How do you export a Gantt Chart from ACT!' ?
Could we use an Import Map?
When I export data from Microsoft Project into Excel, the data file doesn’t maintain the hierarchy. Creating the hierarchy in Excel usually involves grouping and indenting in Excel or using a custom macro to build the hierarchy. When I import an Excel file into Microsoft Project, it also lacks any of the indenting (Figure 1) and summary tasks that make Microsoft Project a valuable roll-up tool.....
So the problem really is that Excel is missing the following ID's, so I would look for a simple C# or VB Script that could convert from XLS to .MPP so as to avoid the problem of importing 'raw' excel data into MPP as importing normally would not answer the question.
Field Name | Description |
ID | The Task ID for the Microsoft Project task |
Outline Level | Determines the Outline Level in a project’s hierarchy. An Outline Level of 1 is at the highest level in the hierarchy, and an Outline Level of 5 has four summary level tasks above it. |
Name | Task Name |
Start | Forecasted Start date |
Finish | Forecasted Finish date |
% Complete | Task completion percentage |
Baseline Start | Original Baseline Start date |
Baseline Finish | Original Baseline Finish date |
Actual Start | Actual task Start date |
Actual Finish | Actual task Finish date |
Predecessors | Identifies the Task ID of a predecessor task |
Resource Name | Assigned Resource |
11-09-2015 01:28 PM
The short answer to your questions is yes to all of them. My concern is that I don't know how many Act! users are using Microsoft Project. Unfortunately that usually means that the first person ends up footing the bill for the development of the project. I would be happy to discuss it with you further if you like. Should you choose to do it yourself there is an SDK available for Act! that would provide you with the information that you need to get a project like this done. Through the SDK you can get access to pretty much everything that is in the Act! database.
Stan
11-11-2015 07:25 AM
So far the only options that I have found revolve around integrating calendar tasks from outlook using project server 2010.