Saturday, September 13, 2014

Finding duplicate Product Codes in large EULUMDAT sets

A new version of EulumdatTools 0.11.2.v20140911 was published on September 11 at

The EULUMDAT validator was improved by:

  • allowing easier deployment of sandbox (experimental) checkers and features.

Yesterday I described the feature of finding hidden symmetry in EULUMDAT files, today we talk about duplicate Product Codes.

Detecting duplicate Product Codes

Many files for products are created by copying an existing file and editing some of the data. Sometimes the Product Code is not edited correctly, so there are multiple files all describing the same Product Code. When using the files to enter them into a database for online or mobile lighting calculations, such as for lightingCalc confusing data may be the result. Detecting duplicate product codes is easy from now on, set as global Preference or per project Property.

Enable the Sandbox checker in the Preferences for global reach...

Set as preferences

or select a project and set it in the Properties.

Set as project properties

Errors in the Problems View will show what and where duplicates are located.

Duplicate product code error

More wishes?

Contact me or comment on this blog


Registered users should install this feature following the steps below, new users should install EulumdatTools first. New users can download an apply for 30 day free evaluation license at the installation site

Installation of EulumdatTools

For use in Eclipse you can use the standard Eclipse update site For stand alone RCP versions of EulumdatTools choose your platform and perform update after installation.:

Installation of Sandbox Feature

Select menu Help / Install New Software... and choose the Eulumdat Tools Sandbox / Sandbox Feature, press Next

Install sandbox feature

Press Next

Install sandbox feature 2

Accept the license

Accept license

Accept and Trust my certificates to install this feature

Accept certificate

No comments:

Post a Comment