Logging an ASCII signal to Excel through Lookout

[Mike@Forshock]

LKS is the source file of the process you are working on, saved in same folder as process.

Right click the ascii object, select Edit Connections.

"ResponseFormat" is what formats the frames coming across the serial line.

[JaredTyler]

Mike,

Here is the LKS file.  I also attached a screenshot of the response format screen - I don't believe there is anything selected for the response format data member. Or am I just missing it?

Thanks,

Jared

[JaredTyler]

Is there a way in Lookout to concatenate a certain number of digits to join what I need together?

Thanks,

Jared

[Mike@Forshock]

That is what I was going for, but the problem is that from what it appears you string may not always be 5 (or x) characters.

Let me play with the source you provided a little bit and give you something to try.

[JaredTyler]

Thanks Mike. Yea I initially tried to use a macro to rearrange the data in excel, but like you said it is not always consistent.

[Mike@Forshock]

Okay, on Ascii1 set ResponseFormat to "M%f"

Drag the ascii1.RSV1 value to the display. (you are currently showing ascii1.response)

Any luck?

EDIT:  Ascii1 may actually need to be Ascii2 for my test.

[JaredTyler]

Ascii2 is the signal that I'm trying to fix, so I should do everything for ascii2? Or are you wanting a test done on the working ascii1 signal?

If I use the ascii2, should the display show the ascii2.RSV2 value? Or will it be ascii2.RSV1?

Thanks again.

[Mike@Forshock]

It looks like "ASCII2" is the weight scale?

If so, set the responseformat on that one.  It should go into the RSV1 datamember.

[JaredTyler]

The ascii2 is the one for length. Ascii1 is for the weight.

[Mike@Forshock]

Okay, whatever one you are trying to get 😉  

It starts with "M", eg "M31.13" from your example spreadsheet.