Case Study:
Projility, a leading project and portfolio management solutions provider, collaborated with Advisicon to develop a streamlined application for CEPI, a Michigan-based organization. The solution automates the transfer of tasks from Project Online to Azure DevOps as user stories, supporting both scheduled nightly updates and on-demand transfers from Microsoft Project Desktop, significantly enhancing workflow efficiency and accuracy.
Business Situation:
CEPI’s project managers conducted planning within Microsoft Project Desktop but required a seamless method to push tasks to Azure DevOps for further tracking and execution. Projility sought a solution to automate this process, reducing manual effort and eliminating inconsistencies.
Solution Delivered:
Advisicon developed a custom service hosted in IIS, connecting Project Online to Azure DevOps via the CSOM library and Azure DevOps API. This service logs each task transfer in a SQL Server database, operates on a nightly schedule, and enables on-demand updates through a Project Desktop plug-in and PowerShell commands.
Benefits Realized:
- Saved time by eliminating the need for manual data entry between Project Online and Azure DevOps.
- Reduced errors, ensuring consistency and accuracy across platforms.
- Improved project tracking and transparency, allowing for seamless updates in real-time or on a nightly schedule.
- Enhanced flexibility with on-demand transfer capabilities accessible directly within Project Desktop.
The Company Today:
Projility confirms CEPI has experienced smooth, uninterrupted performance from the integration since implementation. With this reliable solution, CEPI continues to benefit from synchronized project data, while Projility oversees the code base to ensure ongoing functionality.
