Logging an ASCII signal to Excel through Lookout

[JaredTyler]

I also tried another program 232 Analyzer which was showing the data in Decimal, and then after a few runs I changed it to show in Ascii. 

[JaredTyler]

Here is the diagnostic file from Lookout in Hex. I think this is what your asking for.

Thanks

[bill_gilbert]

You have data streams coming in to one port from two different instruments? If so, that's a problem right there. How do you expect  that to work?

[JaredTyler]

No. The data for each instrument is coming in a separate port. In the very first file I posted it shows the two columns of data that are logged from two different ports. It is only the second column I am having a problem with (com3). The other port is logging fine.
Thanks

[bill_gilbert]

I was just trying to suggest ways for you to analyze the problem. If I was in your shoes, I would use Hyperterminal to capture samples of both data streams, compare them, and figure out how to parse them in Lookout first, then worry about how to get them into Excel after that. This is assuming you are doing the Lookout programming, or have some say in it.

Good luck,

BG

[JaredTyler]

Thanks BG. I am doing the lookout programming, but I am not familiar with how to parse them as you say to get what I need. I'm pretty new to lookout. Are there some tricks to manipulate it? I feel like I'm so close- I see the data I need flashing across the lookout screen. I just need to capture it all in one piece.

[Mike@Forshock]

Your messages are being broken up, either by serial settings (receive gap, timeout) or formatting (control characters)

One possible solution may be to put the data into a expression to build a string.  Use a trigger when the ASCII character for the end of the frame.

[JaredTyler]

Thanks for the help Mike. Please bear with me as I am a newb to Lookout. I know how to create a new expression, but how exactly do I create the string and call out the "end of frame" trigger to let it know to save the data all as one piece? I have, on the other signal I am logging, truncated the end characters to get what I need, but this one just keeps flashing by. I haven't been able to use the same tools to salvage the signal all as one piece. It seems that no matter what I do, the digits just flash by and I can't keep them long enough to manipulate the data.

Thanks again.

[Mike@Forshock]

Can you post the LKS?

What do you have for the ResponseFormat datamember?

[JaredTyler]

Mike,

Now you are talking above my level! Where do I find the "LKS". I will find it and post it. As far as the reponse format data member- are you asking about the response I have selected as the data to log? If so, it is the Ascii2 response signal.

Thanks again, sorry I don't know the lingo.