|
Title: Logging data from scale and parsing Post by: adic95 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! Title: Re: Logging data from scale and parsing Post by: Arthur Grasin 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.
Title: Re: Logging data from scale and parsing Post by: adic95 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. Title: Re: Logging data from scale and parsing Post by: Arthur Grasin 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. |