Merging new data deletes Start, Finish and Duration RRS feed

  • Question

  • Hello, I'm trying to update the information in Project for these fields: Name, Text1, Text2,  and Notes. This is done weekly because our work order program generates an Excel file with new work order numbers or "Tasks" in addition to the already open work orders then they are added to Project for scheduling. But when I import the .xls file it deletes any scheduling I had for the current open tasks.

    Once you create and schedule a Task is it not possible to only Merge new data without deleting the schedule?

    • Edited by J Redgrave Tuesday, June 20, 2017 5:20 PM
    Tuesday, June 20, 2017 4:36 PM

All replies

  • J Redgrave,

    If you are adding new tasks then what you want to do is to Append the Excel data, not Merge it. Merge is used to update existing data and requires a merge key. If the field you select for the merge key results in a conflict of new incoming data versus existing data, the incoming data will prevail.

    Just for reference, what version of Project are you using and is it fully updated?

    Hope this helps.


    Tuesday, June 20, 2017 7:38 PM