Exporting Data
      Back to home
      1. Help Center
      2. Programs
      3. Exporting Data

      Exporting Integration Playbook

      Exporting Integration Playbook

      There are several ways that you can edit an Integration Playbook.  You can edit directly within the M&A tool for a few edits or Export to Excel if you have a substantial number of edits to make.  Both methods are described below.


      Edit All


      If you have a few edits to make in your Playbook, use the Edit all button.


      1. From the Menu Bar, select Playbook/Program/Activity Map.
        The Playbook is displayed.

      2. Click on the Edit all button.


      3. Navigate to the area that you want to edit and type or select from the drop-down menu.




      4. When done, press the Save List icon.


      Exporting the Playbook


      If you have many updates to make within your Integration Playbook, use the Export button. 


      1. From the Menu Bar, select Playbook/Program/Activity Map 

      2. The Playbook is displayed.  

      3. Select the Export button. 


        The exporting process begins and will download the Playbook data to an Excel spreadsheet. 
      4. If necessary, select Enable Editing at the top of the spreadsheet.

      5. When editing your spreadsheet, please follow these guidelines:
        • Leave rows 1 - 3 alone.  Editing these rows will disrupt the import process.
        • Do not add or delete the ID's or WBS Numbers as these are system generated once imported.
        • Do not delete rows of data.  Deleting data can only be done with the Devensoft system.
        • Do not edit or remove the column headers.
        • For the Entity Name column use the drop-down menu values vs. manually typing in “Task.”  Manually typing in tasks, etc. WILL NOT import properly.


      6. Insert Rows - Insert the number of rows needed for the data that you will be entering within the spreadsheet. Red filled cells appear indicating that these are required fields that you must complete.   



      7. Delete –If you delete data from your spreadsheet, it WILL NOT be deleted once you import the data back into the Playbook.  A suggested workaround is to highlight the row(s) in yellow that you want to delete.  Once the data is imported into your Playbook, you can reference the Excel file and manually delete the items (that were highlighted in yellow) from the system.

      8. When you are done, Save your spreadsheet.

        Click here for information on Importing an Integration Playbook.