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.
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 - 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 - 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...
Batch job alert for the hanging processes
Occasionally, the batch job hangs and remains in the "Executing" state. An alert informing that the job has been in this state longer then usually (could be defined as a variable on the batch job), would help to quickly recognize the problems.