Output Change Set Data
Outputting the changes between syncs has been requested by several clients recently. There's not an easy way to do it other than enumerate the change set. We are hoping we can fix this so this is a request for some feedback!
Currently we have added a Method called GetChangeSets() on the compareResult this returns an object with three DataTableStore objects Added,Updated and Deleted.
There is also a Helper Method to combine them into a DataSet with 3 tables, where you can then simply write the DataSet to a File.
i.e.
public< override void AfterCompare(ProjectAutomationCompareResult compareResult)
{
if<(compareResult.HasChanges)
{
compareResult.GetChangeSets().GetAllChangesDataSet().WriteXml(<span class="str">"AllChanges.xml"</span>, XmlWriteMode.WriteSchema);
}
}
One problem with the .NET DataSet object is it likes to munch on system memory so if the change set is large it's going to eat away at a lot of memory.
So I guess we're asking given a change set what do you want to do with it?
3xCSV files? 3xXML Files?
How would you see this working?
Recent Blogs
- Upcoming Changes to Data Sync and Ouvvi
- Making Dynamics 365 Items Inactive rather than Deleting them
- Performance and Optimisation Strategies for Dynamics Synchronisations
- Creating Dynamics 365 Activity Records
- Setting Content Types on SharePoint List Items
- Importing Documents as Attachments in Dynamics 365
- Scheduled Import and Export for Dynamics 365
- Synchronising Data with Dynamics Navision and OData
- Integrating with Salesforce
- Creating Database Scripts from the Schema Map
- Bulk Update Active Directory
- Managing Active Directory User Group Membership
- Creating New Active Directory Users
- Updating the Active Directory Manager Attribute
- Supporting Mongo DB Connections
- Sending a Data Set as an Email and Email Attachment
- Import, Export and Update Active Directory Contacts
- Exporting & Updating Active Directory Computers
- Synchronising SharePoint Documents and Metadata
- SharePoint List and SQL Table 2 Way Synchronisation
- SharePoint List Data Replication with Ouvvi
- Import Email Messages to a SharePoint Document Library
- Bulk Upload Documents into SharePoint from Excel
- Handling SharePoint Lookup Columns
- Import SQL Table to a SharePoint List
- Synchronise Active Directory Users with SharePoint List
- Import Files into SharePoint Document Library
- Synchronise a SharePoint Folder with the File System
- All you need to know about integrating Podio Apps with your Email Provider
- Updated Dynamics 365, SharePoint & Salesforce Connectors
- Dynamics 365 N:N Relationships
- Download Dynamics 365 Audit History
- The New Run Tool Step Types
- Dynamics 365 Campaign Roll-up
- How to integrate with Case Records in Dynamics 365
- The New and Improved Run Tool
- Creating and Importing Data into Custom Entities in Dynamics 365
- New Active Directory Connector
- Using Ouvvi Apps to Feed Data into Power BI
- Copying Address Records from Accounts to Contacts
- Importing Dynamics 365 Connection Records
- Product Updates October 2020