After some problems with corrupted configuration files we have decided to update the workbook component, starting with object generation 5.28. We hope that all workbook function work as before. If you find issues please be patient and report to us what you found. We will then try to help you as quick as we can.
Category Archives: Data import
Optoplex NGQ import more flexible
Zeiss Optoplex NGQ files may have a row with explicit wavelength values – or not.
If wavelength information is present there is an empty line before and after the row with wavelength values. We rely on the assumption that the generated wavelength values are equidistant.
In the case of missing wavelength information we count the number of spectral points. It is assumed that the first one belongs to a wavelength of 380 nm, and that the difference between neighbored points is always 5 nm.
Our software can now import NGQ files both with and without wavelength row.
Bugfix for corrupted configuration files
Having investigated a case where CODE stopped working after importing an older method, we found that a data field contained numbers marked as NAN (= not a number). Up to now we don’t know how this situation can arise – probably it was caused by a failing import of measured data.
The following mechanisms have been implemented to make the software survive this situation (active starting with object generation 5.09):
- Directly after loading numbers marked as NAN are replaced by zeroes. This check is done for configurations stored with generations lower than 5.09.
- Starting with object generation 5.09, numbers of data fields are checked for NAN status (and replaced by zeroes if necessary) before they are saved in a configuration file.
- After each import of measured data the relevant data field is checked for NAN status and eventually corrected.
Bugfix batch control using Von Ardenne exsitu files
After using the command ‘Prepare new results page for Von Ardenne exsitu files’ the assignment of spectra and positions on the glass was not correct. This has been fixed.
New ThinProcess (Optoplex) scanner version
The Optoplex scanner has been updated – we have improved several small details like the appearance of the database tables. As a new feature, sheet resistance values can now be imported into BREIN in order to be displayed.
Import of Optoplex NGQ csv files modified (object generation 4.68)
The format of Optoplex NGQ csv files has been changed and we had to modify our import routine to match the new structure of the files – the new procedure is active starting with object generation 4.68. This may eventually cause trouble if you are still working with the older format. Please tell us if that happens …
Batch import using Excel files
If you have used the option to export measured spectra in CODE using Excel format you can now import these spectra in batch mode.
There is a restriction, however: The spectra must be stored in the first worksheet of the Excel document, with the first wavelength in cell A1.
The number of the file format to be used in the batch control sheet is 27.
This feature is available starting with object generation 4.48.
No import routine
There is no import routine for my spectra. How can I get my data into the software?
If there is not import routine for your type of spectra, you should check first if your spectrometer system can export the spectra in a format which is recognized by our software. Most spectrometer packages can generate tables of the measured data in ASCII format which can be imported using the ‘xy-format’.
In desperate cases you can ask us to write an import routine for your type of spectra. We can do this if we get a description of the data format, and if it can be done with a reasonable amount of effort.