none
how to import the Issues list from an Excel File in Project Server 2013 RRS feed

  • Question

  • Hi,

    I'm using Project Server 2013.

    A Project Manager has been playing with the Issues List, deleting some fields, creating new columns and modifying some columns name. The result of this is that I'm getting this error everytime the task Reporting (Project Sync) is executed:

    General
    • Reporting Wss list sync failed:
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='4feafda7-f147-e411-940d-005056957f05' SPListType='a1efd9a9-bd03-4604-91f3-31a2cc5693ff' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='5deafda7-f147-e411-940d-005056957f05' SPListType='a1efd9a9-bd03-4604-91f3-31a2cc5693ff' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='69eafda7-f147-e411-940d-005056957f05' SPListType='a1efd9a9-bd03-4604-91f3-31a2cc5693ff' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='75eafda7-f147-e411-940d-005056957f05' SPListType='a1efd9a9-bd03-4604-91f3-31a2cc5693ff' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='81eafda7-f147-e411-940d-005056957f05' SPListType='a1efd9a9-bd03-4604-91f3-31a2cc5693ff' Error='1100'.
      • ReportingWssSyncListFailed (24018) - 1100. Details: id='24018' name='ReportingWssSyncListFailed' uid='8deafda7-f147-e411-940d-005056957f05' SPListType='a1efd9a9-bd03-4604-91f3-31a2cc5693ff' Error='1100'.
    • Reporting message processor failed:
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='5beafda7-f147-e411-940d-005056957f05' QueueMessageBody='ProjectUID='a1efd9a9-bd03-4604-91f3-31a2cc5693ff'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='67eafda7-f147-e411-940d-005056957f05' QueueMessageBody='ProjectUID='a1efd9a9-bd03-4604-91f3-31a2cc5693ff'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='73eafda7-f147-e411-940d-005056957f05' QueueMessageBody='ProjectUID='a1efd9a9-bd03-4604-91f3-31a2cc5693ff'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='7feafda7-f147-e411-940d-005056957f05' QueueMessageBody='ProjectUID='a1efd9a9-bd03-4604-91f3-31a2cc5693ff'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='8beafda7-f147-e411-940d-005056957f05' QueueMessageBody='ProjectUID='a1efd9a9-bd03-4604-91f3-31a2cc5693ff'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
      • ReportingWSSSyncMessageFailed (24016) - RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.. Details: id='24016' name='ReportingWSSSyncMessageFailed' uid='97eafda7-f147-e411-940d-005056957f05' QueueMessageBody='ProjectUID='a1efd9a9-bd03-4604-91f3-31a2cc5693ff'. ForceFullSync='False'. SynchronizationType='Issues'' Error='RDS failed while trying to sync one or more SP lists. The RDS queue message will be retried.'.
    • Queue:
      • GeneralQueueJobFailed (26000) - ReportingWSSSync.WSSSyncMessageEx. Details: id='26000' name='GeneralQueueJobFailed' uid='98eafda7-f147-e411-940d-005056957f05' JobUID='9e937da7-f147-e411-940e-005056957f0d' ComputerName='b579360a-53ab-4fe0-bf9b-c62f5e8d3529' GroupType='ReportingWSSSync' MessageType='WSSSyncMessageEx' MessageId='1' Stage='' CorrelationUID='0945bd9c-0d6a-a0f1-47b0-68cdfcfbff9a'. For more details, check the ULS logs on machine b579360a-53ab-4fe0-bf9b-c62f5e8d3529 for entries with JobUID 9e937da7-f147-e411-940e-005056957f0d

    What I'm trying to do is to create a new Project from the scratch, update the Issues List, not deleting or modifying columns, just creating new columns in order to match the names he (the Project Manager) put in his Issues List, then Export the list to Excel, and then create a datasheet view matching the Exported list, but here I don't know how to import the list (copy / paste or whatsoever it can be done...)

    Do you know how to do it, or do you know another/any method to solve this problem?

    Thank you in advance,

    José Espases

    Monday, September 29, 2014 4:10 PM

All replies

  • Hi José,

    2 considerations: 

    The first one is that (as you experienced) one should not delete or rename any of the predefined columns in the risk/issue list. What you did is the right way, meaning keeping the native column as is and creating new ones based on the business needs. Finally you just need to create view with the appropriate fields.

    Then for importing risks from an Excel list, I can't test it right now, but you should have a datagrid view (MS Access type) allowing you pasting data from Excel.


    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    Monday, September 29, 2014 4:33 PM
    Moderator
  • Hi Jose,

    To import the excel list into the SharePoint list (issues, risks, etc.) make sure the excel columns match with the datagrid view and at least all mandatory fields are included in the view (otherwise you won't be able to save the new items). Also, the dropdown fields should have the identical options as in the excel file (or the other way around the excel column options should match the list fields options).

    And finally, if you want to remove some of the default risk/issue fields just manage the content type and for the Project Site Risk/Issue you can hide the columns (the calculated column cannot be marked as hidden). Also, the columns/fields should be removed from the existing list views

    Hope this helps

    Paul

    Monday, September 29, 2014 7:14 PM
  • Hi Guillaume / Paul (What a surprise Paul!),

    Thank you for your answer. What you said is what I was trying to do but I don't know how and where to do that as I don't have any option for Copy / Paste, please find below the place where I try to do it, maybe I have to go to another place?

    This is the Excel file containing the information exported previously:

    and this is the updated Issues List as Datasheet view:

    As you can see, there is no option for Paste and Cpy

    Thank you for your help,

    José Espases



    Tuesday, September 30, 2014 11:12 AM
  • Hi Jose,

    You can simply select the cells/rows in the excel file the you want to copy and use CTRL+C and then select the first cell in your datasheet view and use CTRL+V to paste the selection. Make sure the IDs are not included when you copy/paste the cells. Any errors will be highlighted

    Hope this helps

    Paul

    Tuesday, September 30, 2014 11:19 AM
  • It should work with Paul's way (ctrl-c in Excel then ctrl-v in the datasheet selecting the first row). If it doesn't, you can always open the list in MS Access (button in the ribbon) and import from Access the Excel list.

    Hope this helps,


    Guillaume Rouyre, MBA, MCP, MCTS |

    Tuesday, September 30, 2014 12:09 PM
    Moderator