Import Parent and Child Tasks on Import Set

[Andrew Bettcher]

Hi,

I have project data in another system that I need to import into ServiceNow. I can get the Parent project data in but then I need to add child tasks from the same data set. I can't work out a way of associating the imported sub-tasks to the parent because the relationship is defined between the two by the parent field on a sub-task. I obviously can't import a valid parent field entry from my source data because it only exists in ServiceNow.

I import contract/asset relationships onto a separate table (Assets Covered). Any ideas how I can do this for project and project tasks?

Regards, 

[Lavlesh Garg1]

Andrew,

This other source system, is this also ServiceNow?

[Andrew Bettcher]

Unfortunately not. It's Oracle NetSuite.

[Andrew Bettcher]

I've been thinking that the MS Project Import must achieve this somehow but I'm not sure where to go to see how this is done. I know that the field mapping wasn't configurable 2 or 3 years ago (forum post from ServiceNow employee) but even if I could simply view the import process code I might be able to work out how to relate the sub-tasks to an imported parent.

[Lavlesh Garg1]

Andrew,

I'm assuming you're importing it like this:

1) Getting all the projects from source (oracle netsuite) in an excel file and then importing them in ServiceNow.

2) Getting all the project tasks from source in an excel (this shall include a column with parent project mentioned) and then importing them in ServiceNow.

If my above assumptions are correct, then you can create a simple transform map for 2 step (Project task import) and run a on-before script in that transform map. This on-before script will take the parent project number and search for same project number record in project table and map the project task record with the correct parent project record.