contact
support
Download
order
news
AGG Software Forums
November 25, 2024, 11:28:31 AM
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: Welcome on our forum!
Home
Help
Search
Login
Register
AGG Software Forums
>
Online Help Center
>
Data loggers and plug-ins
>
Advanced Data Logger to Excel
Pages: [
1
]
« previous
next »
Print
Author
Topic: Advanced Data Logger to Excel (Read 19886 times)
Delrin5
Newbie
Karma: +0/-0
Posts: 2
Advanced Data Logger to Excel
«
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
Re: Advanced Data Logger to Excel
«
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
Re: Advanced Data Logger to Excel
«
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
« previous
next »
Jump to:
Please select a destination:
-----------------------------
News & Feedbacks
-----------------------------
=> News and Updates
=> Site Comments
-----------------------------
Online Help Center
-----------------------------
=> Advanced Serial Port Monitor
=> Data loggers and plug-ins
=> Data loggers ActiveX
=> Advanced USB Port Monitor
=> Virtual Null Modem
=> Software for DNC and CNC
=> Other questions
-----------------------------
Development
-----------------------------
=> Feature Requests
Loading...