Work with Extended Attributes of a Project

Microsoft Project has an extensive XML data interchange schema that makes exchanging information between applications and programming with project files easier. The schema allows you to add extended attributes to tasks, resources and assignments. This article demonstrates how to work with Extended Attributes using Aspose.Tasks.

Working with Custom Fields using Microsoft Project

In this example, we will demonstrate how to work with Text1 extended attribute of a project for associating the information with a Task.

1. In MSP, go to Project->Custom Fields.
2. From here, select Task.
3. Select Text as Custom Field Type from the Type combo box.
4. Select Text1 as a custom field that you want to work with
5. Use the “Rename” button to rename the alias of the field if it is desired and press OK button
6. Add a new task and insert a new column to the task row with the custom field that you used in the above step

Working with Custom Fields/Extended Attributes using Aspose.Tasks for C++ API

Aspose.Tasks for C++ API provides the capability of creating new extended attributes as well as working with Extended attributes already present in a document. Custom fields or Extended Attributes are represented by ExtendedAttributes collection of a project in Aspose.Tasks. It contains all the extended attributes definition of a project document. Some of the mappings of MSP Custom Field definition are as shown in the image below.

Creating a New Extended Attribute and Adding it to Task

To add a new extended attribute for task or resource, we first need to define and add the extended attribute definition to the ExtendedAttributes collection. ExtendedAttributeDefinition class is used to define a new ExtendedAttribute in a project. The FieldId must be set for proper defining an Extended attribute which is linked to ExtendedAttributeTask (in case of Task) or ExtendedAttributeResource (in case of Resource). The following sample code shows how to define a new Extended Attribute for Text1 field of project. Once the Extended Attribute definition is complete, you can now create a new Extended Attribute from it and assign it to a task.

System::SharedPtr<Project> project1 = System::MakeObject<Project>(dataDir + u"Blank2010.mpp");
        
System::SharedPtr<ExtendedAttributeDefinition> myTextAttributeDefinition = project1->get_ExtendedAttributes()->GetById((int32_t)Aspose::Tasks::ExtendedAttributeTask::Text1);
        
// If the Custom field doesn't exist in Project, create it
if (myTextAttributeDefinition == nullptr)
{
    myTextAttributeDefinition = ExtendedAttributeDefinition::CreateTaskDefinition(Aspose::Tasks::ExtendedAttributeTask::Text1, u"My text field");
    project1->get_ExtendedAttributes()->Add(myTextAttributeDefinition);
}
        
// Generate Extended Attribute from definition
System::SharedPtr<ExtendedAttribute> text1TaskAttribute = myTextAttributeDefinition->CreateExtendedAttribute();
        
text1TaskAttribute->set_TextValue(u"Text attribute value");
        
// Add extended attribute to task
System::SharedPtr<Task> tsk = project1->get_RootTask()->get_Children()->Add(u"Task 1");
tsk->get_ExtendedAttributes()->Add(text1TaskAttribute);
        
project1->Save(dataDir + u"CreateExtendedAttributes_out.mpp", Aspose::Tasks::Saving::SaveFileFormat::MPP);

Writing Updated Extended Attribute Definitions and Values to MPP

Aspose.Tasks for C++ API supports updating extended attribute data in a Microsoft Project MPP file and save it back.

The code example given below demonstrates how to add new extended attributes of the Resource and Task types to the source MPP file. The steps involved in this activity are:

1. Create an instance of Project Reader.
2. Read the source MPP file.
3. Define a new extended attribute and update its values.
4. Save the project using the Project Writer.

The following example shows setting the extended attributes of a resource.

System::SharedPtr<Project> project = System::MakeObject<Project>(dataDir + u"WriteUpdatedExtendedAttributeDefinitions.mpp");
        
        
// C# preprocessor directive: #region task attributes
        
        
// Add new text3 extended attribute with lookup and one lookup value
System::SharedPtr<ExtendedAttributeDefinition> taskTextAttributeDefinition = ExtendedAttributeDefinition::CreateLookupTaskDefinition(Aspose::Tasks::ExtendedAttributeTask::Text3, u"New text3 attribute");
taskTextAttributeDefinition->set_ElementType(Aspose::Tasks::ElementType::Task);
project->get_ExtendedAttributes()->Add(taskTextAttributeDefinition);
        
System::SharedPtr<Value> textVal = System::MakeObject<Value>();
textVal->set_Id(1);
textVal->set_Description(u"Text value descr");
textVal->set_Val(u"Text value1");
        
taskTextAttributeDefinition->AddLookupValue(textVal);
        
// Add new cost1 extended attribute with lookup and two cost values
System::SharedPtr<ExtendedAttributeDefinition> taskCostAttributeDefinition = ExtendedAttributeDefinition::CreateLookupTaskDefinition(Aspose::Tasks::ExtendedAttributeTask::Cost1, u"New cost1 attribute");
project->get_ExtendedAttributes()->Add(taskCostAttributeDefinition);
        
System::SharedPtr<Value> costVal1 = System::MakeObject<Value>();
costVal1->set_Id(2);
costVal1->set_Description(u"Cost value 1 descr");
costVal1->set_Val(u"99900");
        
System::SharedPtr<Value> costVal2 = System::MakeObject<Value>();
costVal2->set_Id(3);
costVal2->set_Description(u"Cost value 2 descr");
costVal2->set_Val(u"11100");
        
taskCostAttributeDefinition->AddLookupValue(costVal1);
taskCostAttributeDefinition->AddLookupValue(costVal2);
        
// Add new task and assign attribute lookup value.
System::SharedPtr<Task> task = project->get_RootTask()->get_Children()->Add(u"New task");
        
System::SharedPtr<ExtendedAttribute> taskAttr = taskCostAttributeDefinition->CreateExtendedAttribute(costVal1);
task->get_ExtendedAttributes()->Add(taskAttr);
        
System::SharedPtr<ExtendedAttributeDefinition> taskStartAttributeDefinition = ExtendedAttributeDefinition::CreateLookupTaskDefinition(Aspose::Tasks::ExtendedAttributeTask::Start7, u"New start 7 attribute");
        
System::SharedPtr<Value> startVal = System::MakeObject<Value>();
startVal->set_Id(4);
startVal->set_DateTimeValue(System::DateTime::get_Now());
startVal->set_Description(u"Start 7 value description");
        
taskStartAttributeDefinition->AddLookupValue(startVal);
        
project->get_ExtendedAttributes()->Add(taskStartAttributeDefinition);
        
System::SharedPtr<ExtendedAttributeDefinition> taskFinishAttributeDefinition = ExtendedAttributeDefinition::CreateLookupTaskDefinition(Aspose::Tasks::ExtendedAttributeTask::Finish4, u"New finish 4 attribute");
        
System::SharedPtr<Value> finishVal = System::MakeObject<Value>();
finishVal->set_Id(5);
finishVal->set_DateTimeValue(System::DateTime::get_Now());
finishVal->set_Description(u"Finish 4 value description");
        
taskFinishAttributeDefinition->get_ValueList()->Add(finishVal);
        
project->get_ExtendedAttributes()->Add(taskFinishAttributeDefinition);
        
System::SharedPtr<ExtendedAttributeDefinition> numberAttributeDefinition = ExtendedAttributeDefinition::CreateLookupTaskDefinition(Aspose::Tasks::ExtendedAttributeTask::Number20, u"New number attribute");
        
System::SharedPtr<Value> val1 = System::MakeObject<Value>();
val1->set_Id(6);
val1->set_Val(u"1");
val1->set_Description(u"Number 1 value");
System::SharedPtr<Value> val2 = System::MakeObject<Value>();
val2->set_Id(7);
val2->set_Val(u"2");
val2->set_Description(u"Number 2 value");
System::SharedPtr<Value> val3 = System::MakeObject<Value>();
val2->set_Id(8);
val3->set_Val(u"3");
val3->set_Description(u"Number 3 value");
        
numberAttributeDefinition->AddLookupValue(val1);
numberAttributeDefinition->AddLookupValue(val2);
numberAttributeDefinition->AddLookupValue(val3);
        
project->get_ExtendedAttributes()->Add(numberAttributeDefinition);
        
        
// C# preprocessor directive: #endregion
        
        
System::SharedPtr<ExtendedAttributeDefinition> rscStartAttributeDefinition = ExtendedAttributeDefinition::CreateLookupResourceDefinition(Aspose::Tasks::ExtendedAttributeResource::Start5, u"New start5 attribute");
        
System::SharedPtr<Value> startVal2 = System::MakeObject<Value>();
startVal2->set_Id(9);
startVal2->set_DateTimeValue(System::DateTime::get_Now());
startVal2->set_Description(u"this is start5 value descr");
        
rscStartAttributeDefinition->AddLookupValue(startVal2);
        
project->get_ExtendedAttributes()->Add(rscStartAttributeDefinition);
        
// Define a duration attribute without lookup.
System::SharedPtr<ExtendedAttributeDefinition> taskDurationAttributeDefinition = ExtendedAttributeDefinition::CreateTaskDefinition(Aspose::Tasks::ExtendedAttributeTask::Duration1, u"New Duration");
project->get_ExtendedAttributes()->Add(taskDurationAttributeDefinition);
        
// Add new task and assign duration value to the previously defined duration attribute.
System::SharedPtr<Task> timeTask = project->get_RootTask()->get_Children()->Add(u"New task");
        
System::SharedPtr<ExtendedAttribute> durationExtendedAttribute = taskDurationAttributeDefinition->CreateExtendedAttribute();
        
durationExtendedAttribute->set_DurationValue(project->GetDuration(3.0, Aspose::Tasks::TimeUnitType::Hour));
timeTask->get_ExtendedAttributes()->Add(durationExtendedAttribute);
        
System::SharedPtr<MPPSaveOptions> mppSaveOptions = System::MakeObject<MPPSaveOptions>();
mppSaveOptions->set_WriteViewData(true);
        
// Save the project as MPP project file
project->Save(dataDir + u"WriteUpdatedExtendedAttributeDefinitions_out.mpp", mppSaveOptions);