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

Omkar4 · ‎03-06-2019

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.

Abhishek Pidwa · ‎03-27-2019

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.

View solution in original post

Abhishek Pidwa · ‎03-16-2019

Hi,

Looks like there is a mismatch in the format maybe ?

Can you compare Planned end date field type with the Planned start date ? Also, share the screenshot of your Planned end date.

Try with different date formats maybe ?

Is 2018-09-01 08:00 present in your excel sheet ? If so, is that the value of the first row ? I noticed that your format is YYYY-mm-dd HH:mm:ss. Try changing that to remove ss since your planned end date doesn't have ss in it.

Please mark this answer as correct/helpful if this helps to solve your problem.

Omkar4 · ‎03-18-2019

Hi Abhishek,

Thanks for reverting. Actually, the date/time format is YYYY-mm-dd HH:mm:ss on snow indeed. Hence I'm following the same format on my excel sheet and it's just the planned start date filed that's causing the problem for strange reason.

Here's the screenshot as you requested.

Please let me know if you need additional details. Thanks!

Abhishek Pidwa · ‎03-18-2019

Ahhh

1) can you share a screenshot for your first row in excel sheet with Planned start date and Planned End date?

2) Check for any existing Business rule (insert, update ) or any client script (onLoad or onChange) which changes the value of Planned Start date ?

3) Try this : Make a new table named as u_stage_project_tasks (with two fields : u_planned_start_date and u_planned_end_date) and perform a test load of the data from your excel sheet to the new table. See if you are getting the expected populated table. If YES, then revert to 2 to check anything that changes or defaults the planned start date to a particular value.

Let me know how it goes . Step 3 should be pretty fast and will help you debug faster.

Omkar4 · ‎03-21-2019

Thanks Abhishek for getting back to me. I will definitely follow your guidelines. I've also attached my excel sheet for you to review. Please let me know if you want me to share any other details as well. Thanks again as I'm having a hard time since I'm new to working on the development side of snow.