Below you will find History of changes made to Data Synchronisation Studio.
FIX: to Encode Column Names when creating SharePoint list form Schema.
FIX: Exchange Contacts Reader, where the same schema column has been added multiple times.
FIX: the Addin installer to correctly write the location of the Addin File to the DataSyncStudio30 path.
Added a SchemaMapping Helper Class Added a new Data Provider to Read/Write .NET XML Data Set Files.
Added a Obfuscator to enable scrambling data. Enabled Name and Version in the output file.
Updated OData provider to support writing.
Updated Obfuscator to include simple mode.
Updated SharePoint List provider to strip Xml Characters from the message that are invalid.
New Build for Live on Web
Addition to Exchange Provider to Expose IsPrivate Flag for Appointments, Tasks and Contacts.
FIX: for DBNull.Value error with Xml DataSet provider FIX: for AD Provider MemberOf to return groups from all OU's
Sets the Working Directory to the Path of the Opened Data Sync Project FIX: to FCompare Disposed Form when running very quick compare FIX: to MapperHelper to only use Included Schema Columns FIX: to Results grid to validate for null collections Change to *.config file to redirect assembly binding.
Change Database Writer Providers to use MappingHelper Change Integer Parsing/Converting to handle negative numbers.
FIX: for SyncAgent with Ouvvi and Custom Log Writer FIX: for New Project introduced in 254 FIX: for Error Messages not displaying introduced in 254
FIX: for SQL Providers to use Schema.GetIncludedColumns() rather than Schema.Map
FIX: .NET Xml DataSet Writer for B-A sync Change SQL Server Discovery to use background thread Change MappingHelper to Return NULL column rather then Exception when Column cannot be mapped to Destination. Change default fonts.
FIX: multiple GetDefaultSchema() calls on load. Improve Update Results Grid Change Fonts
AD Provider MemberOf default to Max Length Multi-Threaded Project Loading in the Background SplashScreen loading on new Thread. Updated Trial Screen Registering License Key no longer closes app. Animated Loading images Recent File List (MRU) Provider settings persistence to pre-populate previous settings.
FIX: Stat's page updating Add extra Boolean conversions to Type Converter.
FIX: for Comparing String Data where one side is NULL and the other is just Whitespace.
Add extra Boolean conversions to Type Converter.
Added ConfigKey to Project Files and Providers to Support Configuration Change Control in Ouvvi.
Updated UI Icons
Now parsing strings from SharePoint to remove "ExternalClass from fields to support SharePoint 2010 syncing to Notes fields of type enhanced editor.
SharePoint List Wizard now uses ColumnDisplayName to correctly create column names. Change Parsing Strings from SharePoint to Null
andAdded warning message to Sync when trying to supply a value of the SharePoint ID column. Added mapping for Float data type in Database Type converter. Change the AD Provider to Call InvokeSet to update property rather than Value.
Added support for Dynamic Columns from User Code Re-wrote the Map code to prevent Map corruption when updating/refreshing Data Sources Auto-Map function now maps columns that only differ with whitespace.
New Graphics Changes to the Dynamic Column base interface.
Added new Actipro Syntax Editor and Intellisense
Added compile error detection and highlighting.
Changed DSID to be a Text Hidden Column in SharePoint as a problem with SharePoint 2010. Added Hidden option when creating a new Column on an existing SharePoint list. (so that DSID can be created as a Hidden Text column for SP 2010). Changed AutoMap to only include Standard columns.
Added a new parameter to the SQL & OLEDB provider to append an ORDER BY option to the query. Changed SharePoint Document Reader/Writer and File System Reader/Writer to better handle missing columns in the Schema such as Length, DateCreated, DateModified.
Changed MySQL Provider to work with My SQL ODBC Driver version 5.1 Changed AD Provider to support in-app editing of AD Properties to return. (no longer uses X.properties.xml file). Changed the Dynamic Columns base class to expose both Reader Objects.
New Run application, GUI with flow control Create Schedule in Run App Sync SQL Database Wizard in Run App FIX: to SQL 2000 when Database is offline.
New Help File Changed Access Provider to use Microsoft.ACE.OLEDB.12.0 under 64 Bit Process.
2-Way Sync Support in Run Tool via SQL CE 4.0 Database.
Updated Help File SharePoint List provider can use custom webservice if it's installed to overcome limitations in the MS Web Service. Run Tool opens data sync project if you double click item. Included the 37Signals add-in FIX:ed FX Rate provider on x64.
New Generic XML File provider Added Import option to Run Tool Added Multiple delete added to Run Tool FIX:ed: Run Tool Close Changed: Default Open action is to open *.dsrun file in Run tool. Updated Help File.
Updated Help File Added Dynamic Column SharePoint Lookup Helper
Added Effiproz Data Provider Updated Help File
Added a new Experimental CRM 4.0 Data Provider
Added a new Experimental CRM 2011 Data Provider Updated Help File.
FIXED: an issue connecting to Exchange 2007 Mailbox via Web Services
FIX: to Dynamic Columns to use Schema Map data type and not property data type. FIX: to Exchange Provider to use ReadOnly Base Class Updated Help File
Changed CRM/Sharepoint/OData providers to cache there Primary Keys as pass them to the Writer rather than use ___crmID
or ___spID
Removed the DestRow object from the Engine as it's no longer required.
Added a WhereFilter option to the SQL providers to allow you to filter the table results whilst keeping write back ability. FIXED: AD Provider to Match DSID if it's a Guid or a String.
FIXED: BtoA Sync Mode in the Run Tool.
FIX: for Updating Lookup Columns in CRM 2011
FIX: for Dynamic Columns incorrectly formatting the Column name to a C# valid Name.
FIX: for CRM 2011 to specify DateTime.Kind default(UTC) when writing back to CRM. FIX: for Schema Map refresh on Side B to prevent Dynamic Column property corruption.
Added a project option to disable SSL Certificate Validation Added a new SharePoint provider to handle document meta data updates. Changed Preview Source to reset Text Length to -1 to prevent length validation errors. Depreciated old SharePoint providers Added Caching to the CRM Organisation and Entity Discovery Service.
Removed the default SSL validator from SharePoint provider, now need to explicitly set the SSL Override FIX: SharePoint DSID updates Improved error reporting from Unique Key validation Changed SharePoint provider in Create SharePoint List Added Create SQL Ce Database Wizard Added Create Xml DataSet Wizard
Ensured that Dynamic Columns C# name doesn't start with a Digit. Added CopyFiles,DeleteFiles,HttpDownload,Cmd Handlers to the Run Tool.
Changed Excel Provider to ensure that it has exclusive access to the Excel File before it opens it. FIX: FIX:ed Changing the View Name on the new SharePoint provider.
Trying to FIX: the Layout on App Startup when Window is Maximized
FIX: CRM 4.0 & 2011 discovery of ID column name rather than assume it's the entity name. Ensure we get a Data Source Property Grid refresh after loading datasource.
FIX: CRM 2011 Change EntityName data type to default to System.String. Change CRM 2011 & 4.0 now return more information when Data Type conversion fails. CRM 2011 & 4.0 now support sending FetchXML Query Expression. Change Dynamic Column default code to be simpler by removing Setup.
FIX: SharePoint Document Library Sync did not handle the path correctly.
FIX: Exchange WebServices didn't load the mailbox correctly. FIX: 2 Way sync with SharePoint columns of type 0020 failed to setup the CE Database Correctly. Change: Ensure the CE Database it opened with the current culture.
FIX: Run Tool with more than 1 2-Way Project used the same Database Table Names.
New Provider for Office 365 SharePoint Online
Clean Up of CRM 4.0 Provider Code via Resharper to isolate occasional "Object Reference" error.
Change SSL Check to True on Startup so all certificates are trusted by default. Change CRM 4.0 Provider to convert Null Strings to "" when the column does not allow null.
Change CRM 4.0 Provider to convert more Null values for types when the column does not allow null.
FIX: Run Tool did not execute updates to SharePoint 365 Online correctly, required a call to ExecuteQuery to populate list meta data.
FIX: File System to File System Sync did not delete files from the Target.
FIX: Dynamic Columns under Ouvvi caused a Key problem when loading assemblies.
FIX: Schema Map did not re-load Columns with Ignore=True
Added a new Option to the Run Tool to Disable Writing Events to the Windows Event Log
Change Excel Provider to support Write Back (INSERT & UPDATE) ability to Change the Table Name to a Range, Browse to Change the Path
FIX: CRM 4.0 FIX:ed returning fields such as NAME, DSC, YOMI, TYPE from Xml Document as there embedded in the Xml Element as attributes.
FIX: Columns injected via Dynamic Column code use the Length of the source and cannot be overridden causing errors when the source incorrectly returns the length.
FIX: CRM 2011 provider did not handle Money Type from CRM correctly.
CHANGE: Changed the behaviour of the "Ignore" Flag in the Schema Map so if it's set and there is a change the value of the column is passed to the update code.
NEW: Added HTTP File Upload to the Run Tool Steps.
Changed Exchange Provider to Return Re-occurring Appointments via Calendar View Changed Single User License to Validate Logged On User to prevent a single copy being used for multiple users on the same machine.
FIX: to Dynamic Columns with Reserved Words. Added All Framework Encodings to CSV Provider
FIX: CRM 2011 Provider FIX: to return name column values. FIX: FIX: for SharePoint Provider to return List Type when running in Ouvvi/RunTool. New Experimental SharePoint 2010 Client API Provider Encrypt Password on AD Provider Extend Data Interface to include index for attachment support Include FX Rate Provider Include Azure Storage Provider Include Custom Web Service Provider
Updated AD Provider to allow for any column to be used as a Key FIX:ed issues where some providers had break; instead of throw; on error.
Added support to be Ouvvi Aware and Save directly back to the Ouvvi Step!
CRM 4.0 Changes to resolve issues saving Status Codes on salesorder entity.
CRM 4.0 Changes to resolve Updating Owner. Encrypted Password for CRM 4.0 Encrypted Password for CRM 2011
New Provider for Adding/Updating Members in a SharePoint Group.
New Connection Dialog that Filters Providers.
Support Proxy server with SharePoint Online, 2010 and CRM4.0 providers. Allow user to enter own credentials for Proxy server.
FIX: DataSyncPassword needed to catch ArthemticException when calling Decrypt.
FIX: Proxy Configuration on SharePoint Online with TMG FIX: Exchange Contacts and Tasks reading multiple Mailboxes.
FIX: Tab order on Connection Dialog AD Provider change to allow user to disable parsing of AD Fields
Added direct lookup Column Support to Data Source A Schema FIX: Dynamic Column Error window highlighting incorrect row Added Column Header Highlight to Compare Results to show columns with changes Added Row Update Count to reflect user settings in Compare Results Ensured that Dynamic Column order matches order of Schema Map. Changed Odbc, OleDb and SQL Server Providers to execute schema column transformations from DataReader rather than in SQL.
My Birthday!!! Added new Form to Help Debug Issues with Dynamic Columns at runtime. Improved performance of UI by Caching Datasource Schema Info SharePoint Online and Client API now write back new values for DSID.
Data Sync 2012 - Too many updates to list. (Major change new storage engine to replace .NET DataTable)
Changes to Exchange Appointment Provider to return full body message FIX: Client API Provider for using Own credentials. FIX: for Error on Start Page when no License Key.
FIX: File Save SharePoint Title Column Length Issue Default Schema to Include Dynamic Columns
FIX: Access Provider did not return DBNUll.Value for NULL Parameters in Writer. FIX: DataTableStore handling of NULL Key values when using a composite Key.
FIX: CRM 4.0 Provider setting custom Status Codes required setting the State Code to the State Code Value.
FIX: CSV Provider with Dynamic Columns.
CHANGE: Added CookieContainer to Exchange WebServices Service
FIX: Excel provider handing of NULL values on writer.
FIX: SqlCe provider writing strings larger than 4000 characters FIX: CSV Reader using DateFormat string when reading dates. ADDED: List of Date Formats to CSV File Reader.
FIX: Lookup Columns which NULL Values in the Lookuo ADDED: Wildcard support to CSV File Provider ADDED: Experimental OAuth providers LinkedIn and Xero.
FIX: SharePoint comparison with '' and NULL values.
ADDED: RSS Read/Write Provider ADDED: Automation C# Hooks (Beta)
FIXED: CRM 2011 Provider, Update StateCode, Owner and Status values.
FIXED: 2-Way Sync when the same item has been updated and deleted on the other side, now verifies that the item still exists for Update and Delete.
CHANGED: Xml Provider now includes XML Schemas BUG: Ignored Columns returned incorrect index causing application exception. BUG: CRM 2011 mapping entities Lookup that has multiple possible target entities.
FIXED: 2-Way Sync didn't observe Failure Mode FIXED: 2-Way Sync with String Key Columns couldn't update CE DB. FEATURE: Automation Control via User Code FEATURE: Custom Assemblies (Can now use any .NET Assembly from Dynamic Columns or Automation Code)
FIXED: Adding new Assembly in UI, updating Code windows referenced assemblies.
Support for Subscription based Licensing
FIXED: CRM Adding new phone call records with Regarding Customer
FIXED: Oracle Provider incorrect parameter. FEATURE: SynchronisationOperation class FEATURE: Obfuscation
FIXED: Schema Info Panel
FIXED: Compare byte[] returned Type name.
FIXED: Startup Crash
FIXED: MySQL Provider FIXED: Subscription License calling Server Multiple Times FIXED: Preview Schema Map with UnMapped Columns.
FEATURE: Data Sync Project Data Provider
FEATURE: Experimental Yammer Data Provider and Yammer Helper Class to send messages to Yammer Feeds.
UPDATED: Yammer Feed updated UPDATED: Subscription Renewal Process Updated. FEATURE: Json Class
BUG: Dynamic Columns failed with Hebrew Text. BUG: Twitter Feed failed when same word used in feed item.
CHANGE: Duplicate Key errors are now allowed however the duplicate rows are excluded and displayed in the preview window. CHANGE: CSV Provider now supports users defining the columns.
FEATURE: String Helper Extension Methods for Dynamic Columns FIX: CRM 4.0 Error with Column names ending in NAME returning Null Values.
FIX: Run Tool Loading Handlers (Obfuscated Name error) CHANGE: Lookups no longer Error with Null Key values. FEATURE: Null Data Provider
FEATURE: New License types Desktop & Server FEATURE: New Auto Mapping Database Support.
FIX: SharePoint Provider failed to stop reading when DateTimeHandling was Local and Items > Query Limit. CHANGE: CSV Provider defaults to Treat Null and '' as Equal. CHANGE: Massive Library update to support OleDB and SqlClient
CHANGE: CRM 2011 Support for Federated Office 365 Authentication FIX: Run Tool Run Condition Status
CHANGE: Removed Default Trial Mode CHANGE: AD Provider can now return byte[]
FIX: CRM NULL DateTime Value on Update FIX: Xero and LinkedIn Authentication
FIX: Null Values with XML DataSet Provider. FEATURE: CRM 2011 N:N Provider FEATURE: Merge/Incremental Capability. UPDATE: ScreenConnect Client
FIX: CRM 2011 N:N Provider FEATURE: AD Provider Creating Users and Contacts in your AD.
FIX: Composite Key Generation wrongly created duplicate because of concatenation. FIX: SharePoint 2010 ClientAPI UserField[] Types FIX: Source Row/Target Row Identifier Callback.
FEATURE: Timeout Setting for MS CRM 2011 Providers FIX: FileStore/DataStoreTable fixes from Unit Test of Out-of-band test case.
FIX: CRM 2011 - Changing Organisation did not work. FIX: CSV Provider now supports Line Breaks in Quoted Strings.
FIX: Server Based Licensing incorrectly validated user count.
FEATURE: New Data Sync Data Type string [] FIX: CRM 2011 Support for PartyList types such as To, cc, bcc etc.
FIX: String to Data Type string [] FIX: Twitter Feed
FEATURE: CRM 2011 listmember specific writer FEATURE: Start of Localization support FIX: SharePoint 2013 support
FIX: CRM Quote Entity Customer Field assigning Contact FIX: CRM Quote Entity Customer Field setting Status.
FIX: Mapping Rules caused error when no Rule was available.
FIX: Excel Locking source file. FIX: Using byte [] as a Key Column FIX: Duplicate Key Log Message incorrectly used wrong table count CHANGE: Support more Number Styles in default Number Type Conversion
FIX: CRM Connections Entity
FIX: SynchronisationOperation Dispose of DataCompare to close Snapshot files.
FIX: SharePoint connection to FBA change HTTP UserAgent Header
FIX: Custom Assembly Loading
FIX: 2 Way Sync for Providers with Extended Identifier Data
FIX: Lookup Columns with Data source columns of 2 names i.e. SharePoint.
FIX: Using HTML Encoding in Dynamic Column Code. FIX: Null Provider writing Status FIX: Installer not putting Run Tool on Start Menu MRU. FEATURE: Run Tool Menu Item
CHANGE: Removed ScreenConnect and replaced with Link to support.simego.com
FIX: for SharePiint CLient API Multi-Value Lookups FIX: For Version Upgrade Check
FIX: ODBC/MySQL DateTime Time Element FIX: ntext to nvarchar(max)
CHANGE: ODATA Provider Clean up and support for Windows Credentials.
FIX: Project Automation always returning Success==True in End Event. FIX: SharePoint 2013 Authentication, passing specific credentials. CHANGE: OData Provider now supports HTTP Timeout parameter.
CHANGE: OData to Decode XML Entity Name. CHANGE: Lookups now default to case-insensitive compare.
FEATURE: Control the UPDATE action via Schema Map settings to enable 2-Way Sync with 2 projects. FIX: SQL Connection Dialog no longer overwrites typed name during discovery. CHANGE: The Startup Assembly Verifier no longer uses encrypted value.
FIX: CRM Provider to check for Duplicate Key in OptionSet Type Schema Discovery.
FEATURE: Podio Data Provider
FIX: CRM 2011 Provider EntityCollection validate "partyid" exists in attribute collection. CHANGE: New Splash Screen for DS 2013.
CHANGE: Extended the Podio Data provider FIX: Exception in Mapping when 2 columns of same name exist (Dynamic column injection) FEATURE: New data type int[]
UPDATED: Podio Data Provider FIX: byte [] Data Type conversion FEATURE: Connection Registry FEATURE: Create Excel Data Source FEATURE: Swap Datasource Sides
UPDATED: Subscription License support FEATURE: ODBC Connections support Connection Registry!
UPDATED: Version Check call to simego.com FIX: Loading Datasource configuration from Run Tool/API Code.
UPDATED: Podio Items provider updated to support Embed Data Type and extra checks on data load. UPDATED: Json provider default max length now unlimited. UPDATED: Dynamic Columns can now override the Data Load completely.
UPDATED: Podio Items provider updated to support extra column names and the Display Name. UPDATED: SharePoint CLient API Provider to support setting Lookup Column NULL
UPDATED: Podio Question Data Type
UPDATED: Enabled Trial Key Self Service
UPDATE: SQL Provider now supports Batch operations to improve write performance. UPDATE: Re-worked core engine to reduce memory requirement on V.Large tables. UPDATE: Podio App Discovery now checks for Duplicates. UPDATE: DataTableStore preserve's int type for Key column value rather than convert to string.
UPDATE: Podio Items provider now Authenticates as the APP.
UPDATE: Podio Items provider can now automatically link Category/Question Text values to ID numbers UPDATE: Podio App ID Authentication FEATURE: Podio Schema Data Provider.
UPDATE: Podio OAuth changed to use a single window.
CODE: Branched to ds3 since ds4 is now in development on Trunk. UPDATE: Podio provider can now switch between App and Client authentication UPDATE: Podio provider sometimes throws a unique key exception in Add items.
FEATURE: Podio Members Provider to Sync Members between spaces. UPDATE: Podio Items provider update to better handle dependencies sync as Date Start and End. UPDATE: CRM 2011 Handle ParentIDTypeCode explicitly.
UPDATE: Podio Error Messages from Response are now added to Log UPDATE: Podio Members added Message option.
General tidy up for Release New Eval License Provider limited to 100 changes Handle Column Type Errors with SharePoint Client API Provider Report Http Response Errors with OData Provider.
FEATURE: PODIO Merge Reader UPDATE: SharePoint Client API Date Handling UTC vs Local UPDATE: SharePoint Online 365 Date Handling UTC vs Local
FIX: CRM 2011 When user creates a Lookup column using the CRM Convention of projectcode if the data typ eid Guid return the Id rather than Logical name.
FIX: Eval Provider failed to update new license.
FIX: CRM 4.0 Provider Customer Data Type to support Account or Contact Entity Type.
FIX: CSV Files with no headers, caused errors when map changed.
UPDATE: CRM 2011 Provider uses cache and connection proxy to speed up connections with CRM.
UPDATE: Registry Files are checked for in Project Directory and Registry Folder UPDATE: CRM 2011 OptionSets return OptionSet ID if no Name exists. UPDATE: Create SQL Table uses varbinary(MAX) on byte [] and sets newid() DEFAULT on Guid PK.
FIX: CRM 2011 Setting Owner to Team FIX: CRM Ignoring NULL Owner UPDATE: CRM 2011 Ignoring overridencreatedon on UPDATE UPDATE: Handle Duplicate Lookup Connection Names.
FEATURE: Calculated Columns FIX: Slow Loading Registry Form
FEATURE: Added lots of Calculated Column Functions.
FEATURE: Added more Calculated Column Functions.
FEATURE: Calculated Columns Intellisense.
UPDATED: Calculated Columns
UPDATED: Calculated Columns with new Functions LOOKUPA, LOOKUPB to enable complex LOOKUPS into Source and TARGET Systems.
FIX: Podio Provider got stuck when filtering results.
FIX: XML DataSet Provider updating records where the Key is a String that contains a Quote. UPDATE: AD Provider formats SID as a String and SidHistory as String [] UPDATE: CRM N:N Provider allows you to select the Relationship Reference Type UPDATE: Calculated Column Functions UPDATE: Calculated Columns returns correct formatted Field Names
UPDATE: Dynamic Column Functions FIX: CRM 2011 Provider closing incident FIX: Podio creating choice item with no value.
FIX: SharePoint Client API Provider using Filtered View did not always return filtered results.
UPDATE: SharePoint Federation Support for 365. FIX: Podio Members Project Loading Issue. UPDATE: Removed Dynamic Columns and Automation Windows by Default.
UPDATE: Xml and Csv providers now accept wildcard file patterns. UPDATE: Map behaviour to better support typical use cases. UPDATE: NULL Provider to expose a Properties Collection. UPDATE: CRM 2011 contains a reference list of default maps to reduce number of columns loaded in map by default.
FIX: Handle Startup Error when the Layout file is corrupt. UPDATE: Pass the SQL CommandTimeout parameter to the SQL Writer Class.
UPDATE: CRM, SharePoitn and AD can now update Username & Password FEATURE: New Checkboxes on Datasource Windows to support simpler Mapping.
UPDATE: Reworked the Connection Registry System.
FEATURE: Support multiple execution Threads for CRM Online/On-Premise per Server Edition License.
FIX: Explicit dispose of Lookup Data Connections FIX: Registry Update Locking and Check during Project Load.
FIX: Performance of LOOKUPA/B Functions FIX: GC Collection of LOOKUPA/B dscache files.
FIX: Loading Datasource When KEY is Int32 and Values are NULL. UPDATE: CRM 2011 Threaded Provider return Response Fault Messages.
FEATURE: Podio Items Provider adds Createdon updated on fields. FEATURE: Subscription Provider Defaults to 4 Max Threads.
FIX: CRM Threaded Provider Settings Status Code FIX: CEM Threaded Provider Reading Picklist from multiple Threads FIX: CSV Loading File with no directory FIX: Multiple Dynamic Columns Windows FIX: Startup Failure with Invalid License Document.
CHANGE: DEFAULT Max Threads to 16 for Server and Subscription License FIX: CSV Provider could hang if invalid format with broken Quotes. FIX: SQL Quickstart to Validate Table names for Valid Filename.
FIX: Multiple Columns in Data Sync now works with 1000 columns FIX: Create SharePoint List failed to connect to List FIX: Access Lookup Column Fields from Dynamic Column.
UPDATED: Trial Dialog FIX: Support for 1000+ Columns in View FIX: Color coding for missing CC Columns UPDATED: Max Threads now 16.
CHANGE: Trial Licensing to have a basic free use mode with no save or open.
FIX: Saving Exchange Projects without Password.
FEATURE: Incremental Sync Mode for SQL, ODBC, OleDB, Podio, SharePoint 2010, SharePoint Online, CRM 2011 FEATURE: Podio Connect to a View FEATURE: Write Datasource Columns to Project File.
CHANGE: Set Max Threads to 128 to support max through-put against CRM Online 2013
FEATURE: SQL Data Provider to Support Blob Interface to Transfer Blob data behind the scenes.
FIX: 2-Way Sync and nvarchar(max) changed to ntext.
FIX: Podio Views with the Same Name.
CHANGE: SQL Provider to use DataSchemaItemInvariant to improve performance on Writer. CHANGE: CSV Provider to use DataSchemaItemInvariant to improve performance on Writer. CHANGE: XML DataSet Provider to Read Multiple Tables and Write Plan XML without Schema FEATURE: CC can now Access Project Properties and Datasource Settings FEATURE: Add Podio item_app_id and item_app_id_formatted FEATURE: XML DaatSet Provider to read multiple XML Documents CHANGE: CRM to Ignore importsequencenumber on UPDATE.
FIX: CSV Writer and Data Type DateTime on Writer FIX: XML Writer.
CHANGE: CSV Provider does not support Line Wrapping when EnableQuotedStrings is False.
FIX: Podio Deleted Fields from App.
FEATURE: Ouvvi Cloud Save Support FIX: Problem with RecentFilesList hanging app start-up.
FEATURE: Cloud Service Licensing FEATURE: Cloud based Metering FIX: SharePoint ClientAPI Lookups with User objects. FIX: SQL Server and NULL valued columns.
FIX: CRM 2011/2013 Null Column from Meta Data FIX: Lookups from Local Registry File FEATURE: Create Simego Online Cloud List FEATURE: Simego Online Web List Provider
FIX: Oracle Byte [] and Guids CHANGE: WebStore EndPoints
UPDATED: WebStore Performance and Filter Capability
UPDATED: Cloud Endpoint
UPDATED: Cloud License catch Exception from Invalid XML Document UPDATED: Email Provider to output EML or MSG formats.
UPDATED: Web Store Provider to Discover Workstreams UPDATED: CSV Provider to Support Basic Auth over Http.
MAJOR: Clean up and general tidy of code-base moving everything over to 2014 release. FEATURE: Run Tool Online Action to Run Project Online
UPDATE: Metering Event in SyncOperation.
UPDATE: CRM 2011 Setting Business Unit on systemuser record.
UPDATE: SharePoint Client Libraries to support reading Managed Meta Data Columns UPDATE: Email Provider to Read Sent Items
UPDATE: CSV Provider to support FTP
UPDATE: Podio Provider to support new API from Podio for faster read operations. UPDATE: Revet SharePoint Client Libraries because they broke more features.... FEATURE: New Server Explorer feature to make connections faster through drag and drop.
FIX: SharePoint, CRM, Podio, SQL Server, WebStore config UI issues with Registry Config View.
FIX: WebStore LOOKUPA/B Functions FEATURE: Intercom Data Provider and Source Code UPDATE: CRM Incremental Mode to configure max size of chunk requested.
FIX: 2Way Sync, Memory Deallocation broke 2-Way Sync.
FEATURE: Create a new Data Provider Template VS Project.
UPDATE: Update of Data Provider Template VS Project.
UPDATE: AD Provider updated to improve performance and ADD/DELETE operations FEATURE: CRM Tools Create Entity FEATURE: CRM Option Set Provider UPDATE: CRM Export SQL Schema to remove NOT NULL.
FEATURE: Preview on Data Libabry Connections FEATURE: Browse Options Sets FEATURE: SQL CE Library and Create SQL CE Database FEATURE: MS ACCESS Library and Create MS Access Database UPDATE: XML Dataset Provider option to save Schema Information UPDATE: WebStore support for SQL View response without WS_ID.
REGRESSION: Create VS Project Menu Item missing.
FEATURE: Ability to modify Schema Map at runtime via Project Automation.
FEATURE: 32/64 Bit Helper Applications for Ouvvi Execution FEATURE: CRM Publish Customizations Request Function
CHANGE: Support setting "Sync" flag of Compare Result from Project Automation.
FIX: LOOKUPA/B Functions with Providers that use DisplayName. FIX: Lookup with Array Types not links ok when the item returns a single key value. FIX: Project Load when there is an error continues to Load and displays error.
UPDATE: SOAP Web Service Provider to support Credentials and better Handing of Server Response UPDATE: ODATA Provider to allow setting the Version Header for CRM 2013 Server UPDATE: PODIO Provider creating HyperLink Field Types UPDATE: SharePoint Navigator catching error during site load.
FEATURE: Compiled to single exe for XCOPY deployment
FIX: PODIO User Agent string change. FIX: PODIO Date only Columns CHANGE: Runtool to run as Console App by default CHANGE: Runtool to not load windows app in execute mode. FIX: CSV throw exception if file not found. CHANGE: Added a AfterCompare Automation Event.
CHANGE: AD Provider to support Account Expires through special case conversion. CHANGE: CRM 2011 Force Load of Proxy.dll for Automation Code. FEATURE: License Type for Simego Online Azure Server Install.
REMOVED: Simego Online License Type CHANGE: Allow the Primary Key column in Dynamic Columns CHANGED: Updated Azure Blob Provider to support referencing self.
CHANGE: Licensing to download a License Policy from Simego.com servers.
CHANGE: Podio Provider stop Conversion of Timezone when Field is DateOnly.
FEATURE: Build button for Calculated Columns FEATURE: Build Exception Source Code form. FEATURE: Filter Expression Input FEATURE: Mapping rules to support, Project Properties, Data Source Collections, Calculated Columns, Filter UPDATE: RSS Provider to support Navori UPDATE: Mapping Rules for Navoiri
UPDATE: CRM 2011/2013 Performance changes to adapt to 2013 changes better.
REGRESSION: Dynamic Columns BeginRow() was not called.
FEATURE: CRM 2011/2013 Fetch Xml Provider FEATURE: FormatXml function on MultiLineEditor FEATURE: Open File function on MultiLineEditor
REGRESSION: Loading of Custom Assemblies failed. REGRESSION: Incremental Load of CRM failed when cancellation delegate was null.
FIX: Schema Map loading after failed connection to preserve mappings. FEATURE: Data Sync can open *.dssub file to install license key. CHANGE: Removal of Datasource Columns List in Project file for local files ... Ouvvi Files still contain Columns Collection for future features. CHANGE: CRM 4.0 Sort order in Connection Dialog. FIX: Refesh Datasource with Dynamic Columns disappearing.
CHANGE: Removed the Merge Provider Option FEATURE: Added Server Initiated Trial License
UPDATED: Added Server Initiated Trial License FIX: Run Tool with & in path.
FIX: Dynamic Code Assembly generation to only include valid types and not previously generated assemblies. FIX: Re-use compiled assembly to prevent Ouvvi memory growing.
BUG: Exchange Reader under Ouvvi failure.
BUG/FEATURE: CRM2011/2013 When a CRM EntityReference Column ends with "name" and the Data Type is Guid return the Id otherwise return the name.
BUG: Fixed small issues reported, Saving empty project, scroll position in treeview, map refresh loosing map, schema window activation. CHANGE: Podio to strip out start and end
tags from string values.BUG: Catch Exception in RegistryProvider when file is corrupt! CHANGE: Remove HTTP Proxy and use config settings.
CHANGE: ReadWrite property of IDataSourceReader is now obsolete use NullDataSourceWriter instead. CHANGE: SQL Server Provider now accepts Stored Procedures with the EXEC syntax (read-only) CHANGE: OData provider accepts custom HTTP Headers. CHANGE: Podio to use Date UTC field values. CHANGE: Podio automatically convert external_id to string in Incremental. CHANGE: Podio test for Column name in Schema and report error if missing.
CHANGE: Improve SP detection to allow for SQL Script. FIX: CRM OptionSets support Global Option Sets.
FEATURE: CRM FulfillSalesOrderRequest support for Sales order (Note: this will always update DateFulfilled to the current time seems to be an issue with CRM.) FEATURE: DataSyncProject provider to support ability to Split a Column into multiple rows of Data. FEATURE: Added an Exception handler to DataSchemaTypeConverter to display type conversion detail in error message for debugging.
BUG: CRM campaignlist_association needs to use AddItemCampaignRequest and RemoveItemCampaignRequest FEATURE: SharePoint Documents - You can now adjust the Name of the document by mapping a value to FileLeafRef FEATURE: SharePoint Documents - You can now adjust the Path and Name of the document by mapping a value to FileRef FEATURE: FileSystem provider and now re-write filenames and paths. FEATURE: Email provider now queries Exchange 1 day at a time to build up the list allowing for an export going back months or years.
BUG: Previewing SharePoint Data from the Connection Library always failed. BUG: SharePoint WebServices converting to String[], int[], byte[]. BUG: WebServices Provider to support Credentials Window Domain and Persist Username. BUG: Added ContentType name back into the SharePoint providers BUG: PreviewA/B on Unmapped Columns caused exception on some providers.
BUG: PreviewA/B on Unmapped Columns removed Dynamic Columns CHANGE: Change for Licensing to store subscription filename in User Profile path to avoid File IO Permission issues.
CHANGE: UI Rework to support High DPI Display ensure Forms display correctly and different DPI Settings.
UPDATE: CRM SDK to Support CRM 2015 (Using the CRM 2013 SDK rather than 2015 since 2015 required .NET 4.5.2) CHANGE: No License Message
BUG: Dynamics CRM campaignlist_association was sensitive to column names and case. BUG: ODBC and OleDB Lookup Functions did not preserve QuoteStart and QuoteEnd Char and failed based on incorrect Quote character.
BUG: Podio setting both StartDate and EndDate NULL at the same time. CHANGE: Added Multi line Editor to Podio Members BUG: SharePoint Client API setting DateTime value to NULL CHANGE: Cut&Paste Grids to Include Header
CHANGE: Cut&Paste Grids to Exclude Header
FEATURE: Dynamics CRM to handle email activities without lead/contact/account record and use addressused i.e. addressused|info@simego.com
FEATURE: Dynamics CRM to expose SetState and SetOwner helper functions that can be called from Project Automation
FEATURE: Compare Mode TargetIsNullOrEmpty added to only update the Target when it's value is empty.
FEATURE: Calculated Column Function ISNOTNULL() added.
FEATURE: List
FEATURE: Native support for SQL LocalDB FEATURE: Automation Item events FEATURE: Support for SQL Server Automation Item Events. FEATURE: Support for NULL Writer Automation Item Events.
FEATURE: Support for Dynamics CRM Items Writer Automation Item Events (Batch==1 only). FEATURE: Dynamics CRM N:N supports batch mode. FEATURE: Dynamics CRM Listmember supports batch mode. FEATURE: Dynamics CRM supports entity image. FEATURE: Dynamics CRM Helper function to Filter based on Modifiedon. CHANGE: Dynamics CRM schema to return statecode as Int. FEATURE: Open XML Data Sync provider for Excel. CHANGE: Data Sync Export Excel and Export results to use Open XML Excel format. CHANGE: Developer Edition can be installed on Windows Server
FEATURE: Podio supports Automation Item Events FEATURE: OleDB supports Automation Item Events FEATURE: Odbc supports Automation Item Events FEATURE: SQL, OleDB, Odbc Helper Function to write back to Database FEATURE: Podio Helper Function to write back to Podio FEATURE: Cause CRM Proxy cache object to expire after 1 hour.
FEATURE: ValuesStoreService to store Point-In-Time values in Project Automation.
BUG: ValuesStoreService Overload not passing default value.
CHANGE: Register License Form to only display Client-ID if License Key endswith -Q FEATURE: Allow for custom Values Store Service via Environment Variable DATASYNCVALUESSTORESERVICE FEATURE: Implement DeleteValue for Values Store Service CHANGE: Removed the QuickStarts
BUG: Calling the Authenticate method on the CRM Proxy now errors so removed it.
BUG: Dynamics CRM N:N returning Guid for owneridtype FEATURE: Dynamic CRM FetchXml provider can use SaveQuery property to load a Saved View from CRM. BUG: Excel OpenXML Provider returns Formula and Data rather than just Data.
BUG: Dynamics CRM Reader Incremental mode not escaping string values in the FetchXml query.
FEATURE: Azure Blob Storage upgraded to Azure SDK v3 FEATURE: Azure Table Storage Provider.
FEATURE: Analysis Provider to Enable Grouping and Summing of Data Set.
UPDATED: Analysis Provider
UPDATED: OpenXML Provider to use Invariant Culture in Excel File. FEATURE: Added a FROMEXCELOPENXML function to support Excel via OpenXML. FEATURE: Included Ouvvi build in output install. FEATURE: DataSchemaTypeConverter now accepts Culture as input.
UPDATED: Drag and Drop CSV file auto detects Separator UPDATED: Export CSV and Excel now uses Schema from Results in output file. UPDATED: Ouvvi updated to include latest changes i.e. Data Sync view.
FEATURE: New Duplicate Removal Provider UPDATED: Ouvvi updated to include latest changes i.e. Data Sync view.
UPDATED: Ouvvi to display and allow configuration of Lookup Connections.
FEATURE: Ability to override Data Sync Password Encryption via Environment Variable DATASYNCENCRYPTX509 with Certificate Details UPDATED: Azure Table Provider to Encrypt the AccessKey, include the Timestamp column, Default value for Partition Key BUG: Stopping data loading not always working. FEATURE: Create Azure Table from Schema Map.
UPDATED: SharePoint and SharePoint Online to use the updated SharePoint SDK version 16.0.0.0 UPDATED: SharePoint Online now uses the Authentication Helper in the Updated SDK. BUG: SharePoint Providers to use Paging when obtaining Lookup Items from related List.
FEATURE: Opening DSCONN file imports the connection file and saves it in the connection library. UPDATE: Opening a CSV File now opens the File for ReadOnly by default. UPDATE: CSV File to suppress Quotes when NULL or Empty FEATURE: Opening an Ouvvi 2.5 project now also links the Connection Library to the Ouvvi Server Connection Library. UPDATE: GroupBy Analysis Provider to allow Grouping of NULL values.
FEATURE: SharePoint Client API and Online include a Method to obtain ListItem Attachment URL's and download attachments. UPDATE: OpenXml Xml Valid Characters RegEx Expression. UPDATE: SharePoint Client API and Online to use Double instead of Decimal DataType UPDATE: SharePoint Client API and Online to Convert Currency to Double. UPDATE: License URL to Lowercase
UPDATED: Ouvvi Data Sync page error.
BUG: Dynamics CRM with Federated Auth and Incremental Load needs to Authenticate under Ouvvi/Run Tool. FEATURE: Ouvvi provides API Endpoint. UPDATE: Simego Web Store updated to Simego Web API
BUG: Podio Members and Contacts writer on ADD included the Identifier Index which causes an exception.
FEATURE: AmazonS3 Provider UPDATE: Removed Simego.DataSync.dll from resources to reduce the total file size. UPDATE: Removed the Add-in installer
FEATURE: AD Provider to support Item Change Events in Project Automation, Allows for setting Account Passwords etc.
BUG: AD Provider under Ouvvi/Run Tool requires explicit load of System.DirectoryServices to support new Automation Events.
FEATURE: Ouvvi includes a Values Service to retrieve values from the User Setting Store. BUG: Ouvvi Setting Connection Library connections on Odd connection did not apply. FEATURE: AmazonS3, FileSystem, SharePoint2010, SharePoint Online, OData, AzureBlobs all support Item Events. BUG: Loading DS Connections from Current Path CHANGE: Prevent Connection Library reload on New Project CHANGE: Reduce Screen Redraw on Startup page FEATURE: Redirect Values Service URL in Project File
BUG: Ouvvi Install didn't update the DB Schema version number on initial DB Create.
BUG: Loading Data Sync Connection files from Ouvvi with a Space in the Name. BUG: Saving Podio connection files can create a File conflict on Save. UPDATE: Ouvvi 2.5.346 UPDATE: Added CC Functions STARTSWITH and ENDSWITH
FEATURE: New AutoMapper feature for automatically creating the Schema Map.
BUG: XML DataSet Writer updating columns with different Schema Naming. BUG: SharePoint URL Field Type would not update with Description value. BUG: Ouvvi adding Assembly to move DB operations outside of Impersonation Section. UPDATE Ouvvi 2.5.348
BUG: CRM FetchXml using Aliased Aggregate Functions in FetchXML.
BUG: Ouvvi showing Project when Connection Library item not found.
BUG: Ouvvi uploading Connection Library File.
BUG: Ouvvi OData Trigger to add trailing / if necessary.
BUG: Ouvvi OData Trigger to be case-insensitive on Column Name.
UPDATE: Ouvvi CRM Trigger updated to call Data Sync to get Entity last change via SDK and support CRM Online.
FEATURE: Ouvvi Copy Trigger function.
FEATURE: Added GetEntityLastChanged helper function to Data Sync for Ouvvi to call.
UPDATE Ouvvi 2.5.350
FEATURE: SQLClient Connector FEATURE: Convert DateTimeOffset to DateTime UPDATE: Add Proxy Timeout to Threaded Connection BUG: Azure File Upload without DS fields crashed.
UPDATE: Podio Provider to support new Email and Phone field types.
UPDATE: Ouvvi Release 2.5.354 UPDATE: Set ActualEnd on FulfilSalesOrderRequest BUG: Checked for Null in SharePoint FieldUrl DataType UPDATE: Podio Support for Location Field Type
UPDATE: Ouvvi Release 2.5.356
BUG: Exchange provider when Appointments has a duplicate key value threw exception. BUG: AsDataTableSchema() did not create Composite Key and failed on Data Load. FEATURE: When Trial Ends Data Sync can still be used in Design Mode and basic providers ie SQL/CSV etc will still work. FEATURE: Data Sync now uses a Claims model in the License to grant access to certain providers. FEATURE: IDataSourceLookupIncremental to support LOOKUP(A/B)INCREMENTAL for SQL and Dynamics CRM.
3.0. 984 - 04/03/2016
UPDATE: Replaced the Linq Chunk method for a custom method based on an Array, improved SQL Insert performance by 2000% insert 1M rows in 8 Min. UPDATE: Changed Incremental load Parallel methods to use no more than 8 threads.
UPDATE: Ouvvi Log to show related logs per project when spanning projects in a single instance. UPDATE: Ouvvi Release 2.5.358 UPDATE: Performance update for SQL Server includes a Transaction option. UPDATE: Providers now clear Sync Flag when row has been committed, allowing for re-start without compare. UPDATE: Dynamics CRM Parallel load now does not re-cycle ThreadPool as unnecessary. UPDATE: SharePoint Federated option, refreshes rtFa Cookie on project open. UPDATE: Improved SQL Insert performance Insert 1M rows over network in 70 seconds ~14000/Sec, local machine 1M rows 21 seconds ~45000/Sec.
BUG: CRM Incremental Lookup with NULL condition was not creating the correct FetchXml.
UPDATE: Ouvvi to extract ColumnDisplayNameA/B from Data Sync Schema Map. UPDATE: Ouvvi Release 2.5.360 BUG: Null provider output ConfigKey in dsprj file during save. FEATURE: Added Open in VS Code context option on Start Page.
;#
needed to be returned otherwise the last item was dropped