Colect data from rs232

[ruijc]

Hi Dave,

That's one way to do it...
and easy too
thanks

I've been looking all over the net but coudnt find anything.

I did find an interesting excel sheet with graph already build.
It's called RS232 Scope V1.02 but it doesnt work with windows XP

.

[ruijc]

Hi Dave,

i tested your method and it works

the only problem is that, since it will fill in one row i get limited imported readings.

Excel's rows are limited.

If there was a way to import directly into collumns i could get virtually unlimited reading in.

.

[skimask]

Hi Dave,
i tested your method and it works
the only problem is that, since it will fill in one row i get limited imported readings.
Excel's rows are limited.
If there was a way to import directly into collumns i could get virtually unlimited reading in.
.

Carriage return after every data reading instead of a comma?

[mister_e]

nah it works... depending how you send your data.

look how a excel table is made, Line/Column right?

paste this one in notepad, then import it in excel

COLUMN1	COLUMN2	COLUMN3	COLUMN4
0X00	0X01	0X02	0X03
0X10	0X11	0X12	0X13
0X20	0X21	0X22	0X23
0X30	0X31	0X32	0X33

Here i used space, you can use space, comma, semicolon

Now it should give you some light!

[ruijc]

OK guys,

i know now were i missed.
You have to give me credit...this is not my native language

"Carriage return after every data reading instead of a comma"

So... if have something like :

debug ",",#va ( using comma to separate each value )

i should have:

debug #va, $13 ( being 13 hexa code for carriage ) ?
EDIT: 13 for ascii and 0D for hexa.

But what i get is this :

777777777777
( between each 7 i get a square simbol )

.

[mister_e]

euh.. it's decimal 13 not hexa 13, and it's usual to add a LineFeed , decimal 10.

So try

DEBUG DEC VA,",",13,10

and you should be in business.

Try this using MicroCode Studio Serial Communicator. From there you can also save the Received window as a TXT file.

If you did your own VB code, and place your text in a textbox, you have to enable it's multi-line poprietie... unless it might screw things.

[Ioannis]

As Steve noted, your data should be in ASCII format. So if your variable contains zero, you should send the ASCII zero, that is 48 decimal or 30 hex.

That is what the DEC is doing in the Steve's example.

Hope it is clear now.

And I think the extra comma is not needed before CR.

Ioannis

[mister_e]

euh yeah... mixed few things here. if there, it won't screw things.. it's just not needed