Colect data from rs232

[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

[ruijc]

Thanks alot guys,

i did some experiments yesterday and i used the method:

DEBUG DEC VA,13 with no result... i needed the extra 10 there at the end

Steve, will try the :

DEBUG DEC VA,13,10

that you mentioned and give some feedback later.

PS.: I'm currently using the RS232 Data Logger from Eltima ( which is freeware ) to colect the data and save to a txt file.

.