AGG Software Forums
September 20, 2024, 07:34:47 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
   Home   Help Search Login Register  

Pages: [1]
  Print  
Author Topic: Logging data from scale and parsing  (Read 18091 times)
adic95
Newbie
*

Karma: +0/-0
Posts: 4


View Profile
« on: July 15, 2014, 09:54:22 AM »

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!
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #1 on: July 15, 2014, 10:24:40 AM »

Could you specify the vendor and model name of your scales? It is possible we have a parser for this scale already.
Logged
adic95
Newbie
*

Karma: +0/-0
Posts: 4


View Profile
« Reply #2 on: July 15, 2014, 12:39:01 PM »

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.
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #3 on: July 15, 2014, 12:54:27 PM »

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

Your data at fixed positions. Please, use the corresponding parser method.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines