Hello, I'm stuck in the development of a system that automates Microsoft Project, I hope you can give me a clue where to go from here. In the company where I work we need to automate the creation and modification of tasks in Microsoft Project. We use Project Web App (PWA) in SharePoint. The thing is that due to technical requirements our system is based on Python so it would be great to be able to connect with Python to MS Project.
I did it, I connect to MS Project Professional using PyWin32 and I managed to create projects, upload them to PWA, and create/modify the 100.000 tasks. Where is the problem? It is extremely slow and takes many hours to create/modify all the tasks, which makes it unfeasible and I need a faster solution. I think it is because I have connected using win32com and this slows down the work. I also think that VBA for Microsoft Project is not very fast.
Does anyone know of a faster way to get me to connect to Project? Maybe directly accessing PWA from Python? But I haven't managed to do that. I would have to create my own Python API? Any other alternative you can think of would be appreciated.