Forum Discussion
Uploading/Data Mapping Recurring Task Information for MS Project
I would like to upload a number of recurring tasks into MS Project. How/where do I find the field names associated with recurring tasks? For example: recurring pattern, number of occurrences, etc. ...
Jeff_Herbert,
First of all, what version of Project are you using?
The only way I know to upload that kind of information is with VBA. What application has the recurring task information that you want to upload?
John
First of all, what version of Project are you using?
The only way I know to upload that kind of information is with VBA. What application has the recurring task information that you want to upload?
John
Hello John, I'm using MS Project Professional Online Desktop. I have an MS Access Database of Equipment and associated tasks (recurring preventative maintenance requirements). From Access I can generate a list of tasks with the necessary fields as a table to export that I could then upload to Project. I have Task Name, Duration, Resource information, etc., and I have how often the task needs to recure (daily, weekly, monthly, etc.). I want to use project to estimate resource loading for maintenance over a multi year timeframe. I assume there must be defined field names in project that would accept the data needed to generate the recurring tasks. Does this make sense?
- Jeff_Herbert,
Yes, it does make sense.
I haven't worked with an import from Access for several years, it was done using SQL. However, unless there is some avenue through the Project database tables, Project can only import basic fields such as Task Name, Duration, and Resource information. There is no way to directly import recurrence information but it could be done with VBA.
John- When I go through the Upload Wizard in Project there is an opportunity to map the fields in the upload file (excel spreadsheet) to the fields in project. The Project Field list is available in the pull down (it is the same list as the list in the Add New Column" in the Gantt Chart View and the "Recurring" field is available (I can set this to yes for recurring, what I don't see are the fields that would be associated with the Frequency. They must exist in the project file as they can be set in the recurring task window, but apparently they are not exposed for mapping. If anyone knows how this can be done using VBA that would be interesting.
- Jeff_Herbert,
As a follow-up to Dal's input, if your import is a one time action to produce a maintenance plan in Project then the best approach is to manually create the recurring tasks. If the import is something that will be done on a regular basis (e.g. monthly) then the VBA approach is better.
And as I thought about it more, there is noting magic about a recurring task. It's nothing more than a summary line with subtasks "packaged" in a format process for creating the subtasks. Creating a summary line with multiple periodic subtasks is very doable with VBA.
John