Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Export Driver Prioritization from one environment and import to another environment in SharePoint using PSI

    @mona.jain
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 368
    Comment on it

    Driver Prioritization sets Priority level for business strategy and project impacts.
    Here below is the given code to create Driver Prioritization using PSI.
    First I am exporting Driver Prioritization data from one environment and then importing data into another environment.

     

    Exporting: Use export environment credentials

    1. DriverWebSvc.DriverPrioritizationDataSet driverPrioritizationDataSet = new DriverWebSvc.DriverPrioritizationDataSet();
    2.  
    3. // Reads the list of prioritizations
    4. DriverWebSvc.DriverPrioritizationDataSet prioritizationList = driverWebSvc.ReadPrioritizationList();
    5.  
    6.  
    7. foreach (DriverWebSvc.DriverPrioritizationDataSet.PrioritizationRow prioritizationRow in prioritizationList.Prioritization.Rows)
    8. {
    9.     DriverWebSvc.DriverPrioritizationDataSet driverPrioritizationDataSetTemp = driverWebSvc.ReadPrioritization(prioritizationRow.PRIORITIZATION_UID);
    10.  
    11.     // Merging Prioritization data table
    12.     driverPrioritizationDataSet.Prioritization.Merge(driverPrioritizationDataSetTemp.Prioritization);
    13.  
    14.     // Merging PrioritizationEntries data table
    15.     driverPrioritizationDataSet.PrioritizationEntries.Merge(driverPrioritizationDataSetTemp.PrioritizationEntries);
    16.  
    17.     // Merging DriverRelations data table
    18.     driverPrioritizationDataSet.DriverRelations.Merge(driverPrioritizationDataSetTemp.DriverRelations);
    19. }

     

    Importing: Use import environment credentials

    1. DriverWebSvc.DriverPrioritizationDataSet targetDriverPrioritizationDataSet = driverWebSvc.ReadPrioritizationList();
    2.  
    3. List<Guid> prioritizationUids = new List<Guid>();
    4. foreach (DriverPrioritizationDataSet.PrioritizationRow prioritizationRow in targetDriverPrioritizationDataSet.Prioritization.Rows)
    5. {
    6.     prioritizationUids.Add(prioritizationRow.PRIORITIZATION_UID);
    7. }
    8.  
    9. if (prioritizationUids.Count > 0)
    10.     driverWebSvc.DeletePrioritizations(prioritizationUids.ToArray());
    11.  
    12. foreach (DriverPrioritizationDataSet.PrioritizationRow prioritizationRow in driverPrioritizationDataSet.Prioritization.Rows)
    13. {
    14.     try
    15.     {
    16.         DriverWebSvc.DriverPrioritizationDataSet drvDS = new DriverWebSvc.DriverPrioritizationDataSet();
    17.  
    18.         // Adding Prioritization row
    19.         drvDS.Prioritization.Rows.Add(prioritizationRow.ItemArray);
    20.  
    21.         // Adding Prioritization Entries row
    22.         foreach (DriverPrioritizationDataSet.PrioritizationEntriesRow prioritizationEntriesRow in driverPrioritizationDataSet.PrioritizationEntries.Rows)
    23.         {
    24.             if (prioritizationEntriesRow.PRIORITIZATION_UID == prioritizationRow.PRIORITIZATION_UID)
    25.             {
    26.                 drvDS.PrioritizationEntries.Rows.Add(prioritizationEntriesRow.ItemArray);
    27.             }
    28.         }
    29.  
    30.         // Adding Driver Relations row
    31.         foreach (DriverPrioritizationDataSet.DriverRelationsRow driverRelationsRow in driverPrioritizationDataSet.DriverRelations.Rows)
    32.         {
    33.             if (driverRelationsRow.PRIORITIZATION_UID == prioritizationRow.PRIORITIZATION_UID)
    34.             {
    35.                 drvDS.DriverRelations.Rows.Add(driverRelationsRow.ItemArray);
    36.             }
    37.         }
    38.  
    39.         driverWebSvc.CreatePrioritization((DriverWebSvc.DriverPrioritizationDataSet)drvDS);
    40.     
    41.     }
    42.     catch (SoapException sEx)
    43.     {
    44.         //log exception
    45.     }
    46.     catch (Exception ex)
    47.     {
    48.         //log exception
    49.     }
    50.     
    51. }

    Hope this code will help you.Thanks

    sharepoint PSI Driver Prioritization
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: