Lookout

cancel
Showing results for 
Search instead for 
Did you mean: 

Logging an ASCII signal to Excel through Lookout

I am trying to use Lookout to log a serial data  communication. I am actually
getting the signal to Lookout, however the ASCII signal is sending each
individual digit separately instead of as a string. Therefore,  when it logs in
excel, it places each digit  of the number in a different cell.  For instance, the number that flashes through my Lookout display will be 30.50 (flashing each digit seperately, one at a time. When the number logs to excel, there will be a "3" in the first box, "0" in the second row, "." in the third, and so on. 

 

 

Is there a way
to get around this?

 

Thanks,

Jared

0 Kudos
Message 1 of 35
(7,197 Views)

Just wanted to add that I am using Lookout 6.7.1, and that the ASCII signal I am trying to log is coming from a closed system that I do not have access to to change the signal type.  Hope this clarifies any questions.


Thanks again for any help.

0 Kudos
Message 2 of 35
(7,196 Views)

Anybody?

0 Kudos
Message 3 of 35
(7,127 Views)

Can you give an example of the data from a serial log file?

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
0 Kudos
Message 4 of 35
(7,122 Views)

 

Attached is a screenshot of how the file is logging.  It is logging a weight and a length.  The weight signal is logging fine, but the length signal logs each digit separately.  I need to get the signal to where the length will all log into one cell paired with it's corresponding weight.  Even in Lookout, I created a display on the screen to show the length, and each digit of the string flashes by - one right after the other. 

 

Thanks for any help,

Jared

0 Kudos
Message 5 of 35
(7,119 Views)

What is your response format?
Please log the serial port data (Options > Serial Ports)

-----------------------------------------------------------------------
Forshock - Consult.Develop.Solve.
0 Kudos
Message 6 of 35
(7,102 Views)
Com3
9600 baud
8 data bits
1 stop bits
None parity

Thank you
0 Kudos
Message 7 of 35
(7,098 Views)

Are these measurements coming from separate instruments or what?

 

I think Mr Forshock is asking how the data sent from the device(s) is structured, not what the com port parameters are.

 

I'd suggest you take a good look at the structure of the data stream using Hyperterminal in Programs| Accessories|Communications|(in XP), log it to a file and use a hex editor to see what's really being sent.

 

 

0 Kudos
Message 8 of 35
(7,084 Views)

The two signals are coming from different instruments.  I will try to use Hyperterminal to log the signal.

0 Kudos
Message 9 of 35
(7,082 Views)

Here is the signal I get in Hyperterminal in the first "column", then converted to Hex right next to it. Is this what you are asking for?

0 Kudos
Message 10 of 35
(7,078 Views)