Unable to process planned start date field for project tasks using data source and transform map

[Omkar4]

I'm trying to import project tasks then subtasks from excel sheet however for some reason planned start date is not updating and the same date is applied to all the tasks despite each having different planned start dates.

[Omkar4]

Hi Abhishek,

Thanks for quick response. Actually I tried disable the business rule option however doing so messes up whole lot of things such as the empty WBS and no relationships with the parent tasks. 

I was wondering if we can use some transform script to temporarily disable the "recalculate" business rule instead of turning off all scripts. 

As I'm new to servicenow scripting I need your guidance for accomplishing this.

Please let me know.

[Abhishek Pidwa · Accepted solution]

Hmmmmm tricky thing to do in Transform Map. There is a setWorkflow(false) method but it disables all the business rules which in your case, you do not want it.

I would go ahead and plan this import during a downtime and would inactivate the desired business rule itself. Import all the data and then re-activate it later.

Hope it makes sense.