Timeout property of Database sync.
We should add Timeout property for Database Sync of D365FO. Currently , We can run Database Sync with LCS/Visual Studio and SyncEngine.exe. However all these tools doesn’t provide with the property of Timeout for running DB Sync. Although SyncEngine.exe in Dynamics AX had “-sqltimeout” option to...
Extend execution error details form with line on which DIXF service failed import to staging
For our migration with a new customer we've had to load enriched data from outside the system into dynamics. Since DIXF is the only supported technology of importing data, we copy the data into a data entity package. The import of this package to staging will often fail because of SSIS data viola...
Full sortable Job List in the DataManagementWorkspaceMenuItem
The Data management menu contains a Job List . This List is sortable by most columns except: Status Company Sort the Job list by company: will ease the usage for a multi company usage of D365 Sort the Job list by Status: will help to see all running jobs on top of the list
Automating import of the files in Data Management
Enhancing the ability of the Task recorder to create recordings for file import from local machine. An example of such scenario will be-Having a data project created for customer\vendor\project data and importing a csv file into it, getting it past the staging into AR\AP\PM modules.
Dynamics 365 F&O connector should support “Asynchronous Pattern” mode.
Dynamics 365 F&O connector should support “Asynchronous Pattern” mode. Currently, Dynamics 365 F&O connector doesn’t support “Asynchronous Pattern” and it always works as “Synchronous” mode, although user can set “Asynchronous Pattern” to “ON” on the settings dialog of this connector’s property....
Performance improvements for HCMWorkerEntity
We face a big time performance issue when we do a full sync or run the CDS project with all data for HCMWorker entity (Talent to FinOps), it even takes 16+ hours at times for just 600~ records We have tried following options: 1. Clear staging table before we run the sync 2. Tried using HCM base w...
Data Management - Select/Unselect all filtered records in the staging form
In the staging table form, there is possible to copy the marked positions to the target or to update them with "Bulk Update". Unfortunately, you cannot select all positions according to the filter criteria (only manually). Idea: New "Mark all" resp. "Unmark all" function that marks or unmarks the...
Data Management - Simple Error log called from staging form
Simple list/export of all records with the TransferStatus = Error, Keyfields from index + ErrorText, so that can be possible to send this log as an excel list to the responsible person to correct the data. Example in SQL: /****** Script for generating of error messages with keys ******/ declare ...
Data Management - Refresh mapping of all entities
After each code release, it is necessary to perform the function "Refresh mapping" for each customized entity with new fields. The new feature would make it as job in the background for all existing entities. The existing changes to the mapping (validation deactivated, deleted assignment) should ...
Data Management - Monitoring the import process
By the long import processes it is important to know, how far they are at the moment or if they work at all. I have implemented three new counters (Not started, Completed, Error) in the staging form. With the Refresh button, it si possible to monitor the import job.