View Full Version : Solved Creating a data file from eeprom data
11-04-2011, 11:53 PM
Been a prop user for a few years but never posted, until now. Just a few questions regarding saving data from eeprom to a text file or speadsheet. My project involves reading a maxbotix ultrasonic distance sensor. I have been sucessful at reading the ranging info (via rs232) and saving that data to upper 32k on my usb prop proto board. I can display this data on pst (via basic_i2c_driver and fullduplexserialplus).
My question to all you smart folks out there is "how do I send this data, from eeprom, to a text file (*.txt)(or a spreadsheet) on my pc?" I tried to "cut and paste" from pst, but for some reason it did not work. I am NOT using an XBEE yet. At this point, just reading ranging data and writing to eeprom and displaying that same data on pst (on the same pc). I also plan to add a time stamp (on hourly measurements) as well as temperature. This will be added at a later date.
Now, just need to know how to save the data to a text file (or spreadsheet) on the same pc that the pst is connected to.
This site is great. Been watching in the background since becoming a prop head. Thanks in advance for any and all advice that you might be able to offer.
Phil Pilgrim (PhiPi)
11-04-2011, 11:59 PM
Welcome to the forum, Renee! Maybe this will help:
11-05-2011, 12:07 AM
There is also a program called StampPlot Pro which is available from Parallax's Downloads page under Stamp Software. It was originally written for use with the Basic Stamps, but works fine with the Propeller as well. You send commands from the Stamp or Propeller to the PC using ordinary serial I/O and the StampPlot Pro program on the PC interprets and acts on the commands which include data provided as number strings. You can save information to one or more files, produce plots, and get parameter values from the PC. Look at the documentation files included for examples for the Stamps. The Stamps use their SERIN and SEROUT statements for serial I/O. The Propeller would use FullDuplexSerial or Simple_Serial instead.
11-09-2011, 12:50 AM
Sorry I did not reply sooner. Wanted to thank you for posting your csv program. Had some trouble with vista (with your csv program). Decided to use xp. For some reason, it worked with xp, but not vista. Plus, my job kept me away from this, for a while. Thanks for the csv program. Worked through your demo program. It's great. I can work with this.
Little more background... I work for Hampton Roads Transit "HRT". I am a Supervisor/Technician for "HRT". We recently started a light rail system in Norfolk. So far, so good (depending on whom you ask). Anyway, my project involves measuring the "weight stack" inside a cantenary pole. These weight stacks keep tension on the overhead power wires. We can determine what the tension is on the wires if we can measure the distances of the weight stacks. Looking at measuring the stacks once an hour, saving the data to eeprom (already good on this). We can also determine if the stacks are "stuck" inside the pole. Then, once a week, transmitting this data to a technician, via xbee (saving to excel spreadsheet). Everything is going as planned (it would go faster if I had more time). Anyway, thanks again. Might be ordering more prop proto boards if this works out.
Light rail systems exist throughout the country. Seems something like this does not exist (believe me, I have ask a number of other light rail cities). Might be asking for more assistance in the near future. Got to go. Thanks. Take care.
Phil Pilgrim (PhiPi)
11-09-2011, 01:35 AM
Thanks for the feedback Renee! I'm glad it worked for you -- at least with XP. Can you provide more details regarding the kinds of issues you experienced with Vista, please? It's something I'd like to get to the bottom of, if possible.
11-15-2011, 09:59 AM
Once again I must apologize for replying so late. If I did not have to sleep, I would have time for everything. The problem I was having with vista had to do with the files not being generated. The problem might have been security settings. I gave the computer to a friend the following day, thus I am not able to try and run the program again. Thanks again for posting a great program. My project is coming along nicely. Have to do some more testing this week. BTW, this thread displays "Unsolved". How do I change it to "Solved"? Take care.
Phil Pilgrim (PhiPi)
11-15-2011, 03:05 PM
You're probably right about the security settings.
BTW, this thread displays "Unsolved". How do I change it to "Solved"?
Edit your post, click "Go Advanced", and there will be a drop-down box where you can change the prefix.