News:

Welcome on our forum!

Main Menu

Logging data from scale and parsing

Started by adic95, July 15, 2014, 06:54:22 AM

Previous topic - Next topic

adic95

Hello!

I must log data from several weight scale.

This is what I receive from equipment:

15.07.2014 09:27 087.4 kg 1325 <00>                                           <00><0D>
15.07.2014 09:36 129.9 kg 1326 <00>                                           <00><0D>
15.07.2014 09:40 134.2 kg 1327 <00>                                           <00><0D>
15.07.2014 09:43 136.3 kg 1328 <00>                                           <00><0D>
15.07.2014 09:47 137.3 kg 1329 <00>                                           <00><0D>
15.07.2014 09:51 138.1 kg 1330 <00>                                           <00><0D>


I want to export this string into an excel and/or SQL database.
I've tried to use the tutorial from "Log weight from a scale to a Microsoft Excel spreadsheet (data at enumerated positions)" but without success.
The difference between this tutorial and my data string is that in tutorial the delimiter is "," (comma) and in my data is "space".
I used as Field Delimiter the "space" but data is not splitted.

Any help is much appreciated.

Thank you!

Arthur Grasin

Could you specify the vendor and model name of your scales? It is possible we have a parser for this scale already.
If you like my work, please take a few seconds and add feedback about our site or our software [here]

adic95

The equipment is made by Kurtz  - is a polystyrol production line.
Computer is made by Siemens .
Exact type of scale is PR 1590/24 made by Sartorius Hamburg GmbH.
Data is collected from a resial interface that also send this string to a printer.

Arthur Grasin

Sorry, but we don't have the parser for this scale.

Your data at fixed positions. Please, use the corresponding parser method.
If you like my work, please take a few seconds and add feedback about our site or our software [here]