We are running a survey to help us improve the experience for all of our members. If you see the survey appear, please take the time to tell us about your experience if you can.
Hello everybody giving a helping hand,
got me some trouble here. I was making a program that reads out the duty cycle of an ADXL202 sensor. Everything works, except the part were i want to print my data in a file using this :
FILE *stream, *fopen(); if ( (stream = fopen(...)) != NULL) fscanf(stream,''%s'', string);
Ok this is were my problems start. The compiler gives me the error that he doesn't know this type FILE ore the function fopen (). This seems to be logical to me since i looked in my stdio.h header and found nothing really according to that declaration. Is there a posibility that this is stored in another source file or does not exist??? Or .... how do i get my data's in a *.txt file ???
Thanks for the help i'm about to receive :))
P.S: Im using a 80C535 µC, sorry for not mantuening
Writting a serial receiving program in PC enviroment(Visual Studio,Delphi,GCC,etc) will save you out.
Yes real nice "ninja Z", thats the best solution, write myself a serial receiving program. And loose another 2 weeks on that. I'll bet that the www got something for me that does not include selfprograming serial ports and other desolating methods of human knowledge. Thanks again mister Dragon Ball Z
"write myself a serial receiving program. And loose another 2 weeks on that."
Actually, it's not entirely "losing" 2 weeks, is it?
From your original post, it sounds like getting the data onto your PC is an integral part of your project?
Of course, if you can find something ready-made and suitable, there's no point re-inventing the wheel.
Well actualy my project includes reading an ADXL202 acceleration sensor and transcribe the messurments into a table (diagram), and i figured that would do great with excel. But with the normal Hyperterminal i must record the data into an *.txt file. And then transcribe into excel and then to the table etc.... Help....
"with the normal Hyperterminal i must record the data into an *.txt file. And then transcribe into excel and then to the table etc."
Did you actually look at www.windmill.co.uk/rs232.html ?
They have a lot of stuff about getting serial data into Excel...
"with the normal Hyperterminal i must record the data into an *.txt file. And then transcribe into excel and then to the table etc"
If you won't put the effort into creating an automated application, then you're going to have to put effort into doing it manually, aren't you?
Only you can say where the break-even point is...
"Help..."
Well, as you said yourself, "I'll bet that the www got something for me ..."
Yes i tried the free version and it seems its entirely bulls**t. And my pocket is a little bit tight for the new version, u know what i mean?? So i looked everywere but in the and i gotta stick to the old plan and use the hyperterm..... life's cruel, isn't it?? Sadly ironic.. does anybody have maybe an idee how this could work without special payments and extra work time ???
If your 8051 application is able to send data over the serial port, then have it insert a COMMA in between each bit of data and a LINEFEED at the end of each record. If you open such a csv (comma-separated-value) in any recent version of excel, it will know how to handle it.
"have it insert a COMMA in between each bit of data"
That's "bit" as in "item" of data - not as in "binary digit"!
"a LINEFEED at the end of each record."
The line terminator for PC files should be a Carriage Return (CR) followed by a Linefeed (LF). This 2-character sequence is often known as "CRLF"
eg, see: blogs.msdn.com/.../91899.aspx and follow the links...
"If you open such a csv (comma-separated-value) [file] in any recent version of excel, it will know how to handle it."
In fact, Excel's text-import wizard can cope with many formats - inlcuding fixed-width and lots of other delimiters.
It's still a lot of manual messing about though: get Hypoterminal to capture the data, close the file, open the file in Excel, etc, etc, etc,...
You can see how 2 weeks "lost" in writing a custom data receiver would soon be recovered!
Andy,
Thanks for providing the OP with the clarifications. The rigor with which I craft my posts is directly proportional to the amount of caffeine I've managed to ingest so far that day. :)
-Jay D.
Yes thank you but that is what im doin' right now. Its this thing that bothers me. I must record data, insert it in the excel file (with csv) and than do the table ( or diagram, or whatever you wanna call him ). If there is a posibility i would like to jump over these steps and make a direct connection to the serial port and transform the values directly into an diagram. That Windmill thing ain't working because it costs money witch i don't have and the free version is a joke. I heard it could be done with the macros in excel but i have no idea how to do this. If anybody has an idea or an webpage with the macro language or a done program it would be great.... Thanks
Google for:
serial wedge +excel
Have you looked into the user of ODBC with the Microsoft Text Driver (using text or csv files) to get the data into Excel?
I don't think the problem is in getting files into Excel - the problem is in getting serial data directly into Excel without having to mess about with intermediate files & capture utilities?
Exactly, thats well put.... files directly into excel without intermediate files and capture utilities etc...
Any helpfull sugestion is more than welcome.... but without reward :)) sorry
I think you missed my point. I wasn't talking about getting files into Excel.
To be more explicit:
Have he checked if the M$ ODBC text driver can work directly on a text file, while the Hyperterminal is capturing data, i.e. can Excel do on-the-fly graphing while the data is still being being received?
In that case, it wouldn't matter that the data is being stored somewhere - Excel do need the data somewhere to be able to graph it.