Adding Support for ISOMED Spectrwn File formate

[tobiasfalk]

Hi,

I wanted to ask if it would be possible to add support for the File formate one can get out of a Nuvia ISOMED Device, like the ISOMED 2100 Bohlochmessplatz or ISOMED 2163 Inkorporationsmessplatz.

They can export it as a binary .spe file but also as a Text/CSV file, in those file everything from the Name, Note, Time to The Spectrum and Background is in there. I have attached the files of 3 different Cobalt and on Cesium source here:

CO-57_nr1.csv
CO-57_nr2.csv
CO-57_nr3.csv
CS-137_nr1.csv

Spectren.zip

As a side note, I have tried to enter the Calibration values manually, but since in your interface one needs to enter BIN and KeV but I have a Calibration factor (C2) and an Offset (C1) I was not that successful.

If there is a problem that the files are in German, here is a rough translation of the Fields:

• Name -> Name
• Bemerkung -> Note
• Messzeit Spektrum -> Capture Time, Length of the Measurement
• Messzeitpunkt -> Time of Measurment
• Messzeit Nullspektrum -> Capture Time of the Background, Length of the Background Measurement
• Verstärkung -> amplification
• Hochspannung -> Highvoltage
• Kalibrierfaktor: Calibration factor
• Offset -> Offset
• Spektrum -> Spectrum
• Nullspektrum -> Background
• Kanal -> Channel
• Impulse-> Counts (Total)

[NuclearPhoenixx]

Oh god, not yet another entirely differently formatted CSV file. I won't support that, I'm sorry. CSV files are a nightmare to work on since you have to literally reverse-engineer the exact format that is used by the way it looks in order to tell where to get what kind of data. And every manufacturer, of course, uses their own custom formatting.

Is there any other way to export the data? TKA files maybe? Or anything like a cleartext document with a different file extension so that it's more unique?

Have you looked into this spectroscopic file conversion tool? Maybe that's one solution: https://github.com/sandialabs/cambio/

What I can offer you is to write a quick tool to convert this kind of CSV to something like XML or JSON which can be handled much more gracefully and both import into the app.

[NuclearPhoenixx]

Are you able to use Python? Here is a small script that should do the trick:

converter.zip

I have done some quick testing and it works but please don't pin me down to details. The calibration looks a bit funky, but I think that's just down to the linear calibration?

[tobiasfalk]

Cool thanks.
Yes I know Python, Since the control PC for the device is an old XP Machine I will most likely set up a raspberry or something with a web share in a separate VLAN that automatically converts it and saves it on web share where all devices can access it.

[tobiasfalk]

Will have a deeper look in the Calibration thing, could be a Problem on my side.

[NuclearPhoenixx]

I figured you're already using Python for the local server, so might as well make a Python script too.

On another note, would you be interested in a small web tool to simply convert files? Like upload a file, select input and output formats, download, done. No promises, I'm just asking around to see if at least anyone would use it if I'm doing all the work.

[tobiasfalk]

Sounds interesting, and I would use it.

But for the use case that I am currently looking at, this script is already really good.