AGG Software Forums
November 25, 2024, 09:42:15 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: Advanced Data Logger to Excel  (Read 19885 times)
Delrin5
Newbie
*

Karma: +0/-0
Posts: 2


View Profile
« on: April 27, 2009, 06:13:24 PM »

I am trying to get data from a gram scale into an excel spreadsheet, but I am running into problems.

When I launch the data logger it open Excel like I would expect but when the scale sends data over to it I only get the date into A1 them moving to A2 and so on.

What I need to get is the actual weight with a Date/Time stamp in another column say B1 and the weight in A1.

I think this may have something to do with my parsing, but I only think this from reading other posts. Please correct me if I am wrong on this assumption, considering I am a total newbie to the Advanced Data Serial Logger tool as I am using the trial version to test if the product will work on the production floor.

Here is a snippet of the output from the data logging screen:
<20090427094451.645>
ST,+00061.55  g#0D#0A
<20090427103755.957>
ST,+00061.57  g#0D#0A
<20090427103758.347>
ST,+00061.57  g#0D#0A
<20090427103802.238>
ST,+00061.57  g#0D#0A

Can someone help me out or point me in the right direction on some documentation on how to use the parsing tool?
Logged
Delrin5
Newbie
*

Karma: +0/-0
Posts: 2


View Profile
« Reply #1 on: April 27, 2009, 11:23:16 PM »

To answer my own question.. Thanks for the Demos and Tutorials BTW
Packet beginning = #53#54
Packet Ending = #67

Filter = ASCII 44|',' Remove Character

Excel Bind:
 ASCII Data Packet (w/o framing characters) = A1
 Date Date Time Stamp B1

The only problem left is why when the Excel spreadsheet is accidentally closed it does not prompt the user to save or anything, it just closes and when you open it back up the spreadsheet is blank.

Anyone have a solution to this issue or is it something more to do with the Excel Version (2000)?
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #2 on: April 30, 2009, 08:58:23 AM »

The data export plug-im has corresponding options. Please, look at the attached image.


* s2.JPG (37.82 KB, 448x432 - viewed 25 times.)
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines