Project Import from MS Project - ERROR - wbs_exception

aserra
Tera Contributor

‎05-24-2024 06:20 AM

Hello everyone, we are having a problem when importing projects from MS Project.
When the import process is carried out, the WBS field and the WBS Order remain empty and when the tasks are reordered, the wbs_exception error is generated.

 

Summary: When we import projects from MS Project, we cannot perform a reordering of Tasks (Move Up - Move Down)

 

aserra_0-1716556722620.png

 

aserra_1-1716556777908.png

 

0 Helpfuls
  • 580 Views
1 REPLY 1

SasankaV
Mega Guru

‎06-16-2024 11:58 PM

Hey @aserra  , I encountered a similar use case in my experience at Work4flow. Give the below steps a try:

- Importing projects from MS Project leaves WBS and WBS Order fields empty. Reordering tasks generates a wbs_exception error.
- Ensure successful import of projects with correctly populated WBS and WBS Order fields. Enable reordering of tasks without errors.
- Verify MS Project File. Check the MS Project file for correct task structure and WBS information.
- Review Import Configuration. Ensure the import template and field mappings in ServiceNow are correctly configured for WBS and WBS Order fields.
- Import a simple project from MS Project to see if the issue persists. This helps isolate if the problem is with complex projects or all projects.
- Modify Import Script. Access the script that handles MS Project imports. Add logic to correctly populate WBS and WBS Order fields during import.
- Sample Script Adjustment.

 

// Assuming taskList contains imported tasks
for (var i = 0; i < taskList.length; i++) {
var task = taskList[i];
task.wbs = calculateWBS(task); // Custom function to calculate WBS
task.wbs_order = i + 1; // Assigning sequential order
task.update();
}

 

- Test Modified Import. Import projects again after modifying the script. Verify if WBS and WBS Order fields are populated correctly.
- Address Reordering Issue. After successful import, test reordering of tasks. Ensure no wbs_exception error occurs. Adjust the script further if needed.
- Validate Changes. Import various projects with different complexities to ensure the solution works universally. Check for any edge cases that might still cause issues.
- Document Process. Update documentation to reflect changes in the import process. Include steps for troubleshooting common issues related to WBS and task reordering.
- Train Users. Inform users about the changes and provide guidance on how to ensure their MS Project files are correctly set up for import. Offer training sessions if needed.
- Monitor and Adjust. Continuously monitor the import process and gather user feedback. Make necessary adjustments to the script or process to improve reliability and performance.

Let me know if it doesn't work. I'd be happy to assist.

0 Helpfuls