What is the Kildrummy® Data Exchange?
Some years ago, Kildrummy® Data Exchange (KDE) was called the Standard Document Importer. In this version, functionality was limited and it wasn’t possible to upload budget data such as Projects, Budget Items or Structures. Despite these initial limitations, our customers soon told us that it had become a core part of their operation, and allowed them to quickly add data to their system. Since then, the Budget Importer was created and the module was re-branded the ‘Kildrummy® Data Exchange’. With these enhancements, the KDE has become an increasingly valuable asset to our customers.
The KDE has had two key development milestones. Originating as a plug-in system, it was first directly integrated into CostMANAGER (KCM) at version 2.2 for a more rapid development cycle. Following this, the KDE underwent a complete rewrite at KCM 2.5. This rewrite improved performance and introduced a number of new features.
How Do I Use the Kildrummy® Data Exchange?
KDE accepts data from almost any of your existing systems such as SAP, JDE and Primavera. All that’s required is an export into our pre-formatted Excel templates.
Data Exchange Validation Routines
A key part of the KDE is its powerful validation process. Validation allows you to check the data before it enters your database. This ensures that invalid data is not imported. As such, you will have increased confidence in your monthly reports, and reduce the time between receiving data and identifying problems.
Our validation process is broken down into the three following stages:
The pre-processing stage gives you access to many options that allow you to manipulate your data before it’s validated. If you can’t remember what project your budget items belong to: KDE can look these up. If you’re worried about duplicate document codes: they can be automatically concatenated for you using your preferred format.
The screenshot below shows some of the many options available to KDE users.
After pre-processing has completed, your imported data is validated. Validation will check individual rows of data. These routines will check the data for issues such as invalid dates or codes, and compare against existing data that is already in the database to make sure that it’s compatible.
If any errors are found, a message will be displayed against each erroneous line of data. See an example of this below.
Corrections can be made to the erroneous data by manipulating the fields directly within KDE, or by reloading an updated Excel template.
Once all errors are resolved, the data is ready to load into the database.
Data Exchange API
KDE also allows companies to import data directly into the database tables. Many of our existing clients use applications such as Microsoft Dynamics to further integrate Kildrummy® CostMANAGER into their cost management systems.
KDE availability depends on your version of KCM. The Express edition includes a pre-installed KDE license, but for KCM Enterprise databases the KDE is an optional extra.
For further information on the Kildrummy® Data Exchange and its functionality, please contact the helpdesk.