Importing all data from MS Project Online to ServiceNow PPM

[LisaKomidar]

I have a use case where the customer wants to a do a bulk one time import of all data from MS Project Online.  I was thinking of trying to somehow utilize the import process provided OOTB but I don't think that would work.   Has anyone done this and maintained the parent child relationships on the tasks and kept the wbs numbering order?  I'm thinking I may need to build a temporary table to help map the relationships.  Was hoping to avoid a lot of looping but I don't know that it would be possible.  

Project ABC

Project task 1

Project task 1.2

Project task 2

Project task 2.1

Project task 2.2

Project task 2.2.1

Project task 2.2.2

Project task 2.2.2.1

Project task 2.2.2.2

Project XYZ

Project task 1

Project task 1.2

Project task 2

Project task 2.1

Project task 2.2

Project task 2.2.1

Project task 2.2.2

Project task 2.2.2.1

Project task 2.2.2.2

The wbs numbers can go out up to 7 levels.  (And there are numerous projects as they want them all in one load)

[Anantha Gowrara]

Hi @LisaKomidar , OOTB Load MSP projects will work and maintain parent-child relationship intact. Please let me know if you encountered any issue when loading using OOTB option

[LisaKomidar]

Yes, I know this.  However, this is doing one at a time.  The need is to do bulk import of the projects.

[Anantha Gowrara]

Hi @LisaKomidar , Yes OOTB MPP doesn't support bulk import but I remember doing this for one of my client using Transform maps, for that you need to manage your projects and project related tasks in separate excel sheets and perform data load option using 2 different transform maps. You should disable BR's and make sure to map all required fields like top project, top task etc.. in project tasks.