How To: Understanding Kildrummy® DataEXCHANGE Validation
Posted on: November 7th, 2012 by

What is the Kildrummy® DataEXCHANGE ?

Some years ago, Kildrummy® DataEXCHANGE (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® DataEXCHANGE ‘. 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® DataEXCHANGE ?

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.

DataEXCHANGE 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:

Pre-processing

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.

The full list of pre-processing options for the Expenditure document type. Click for a larger view.

Primary Validation

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.

The above Budget Item upload contains several errors that must be resolved before an upload can be completed.

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.

DataEXCHANGE 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® DataEXCHANGE and its functionality, please contact the helpdesk.