I tried using my new parrot today. I'm having problems getting the data into excel correctly. When I import the text file it skips a row between data sets. What am I doing wrong?
Thanks, Mark
I haven't run into this myself, but I have heard from other customers that this is a problem with the newest versions of Excel. If you don't have a previous version of Excel available, there are a couple of other work-arounds. Jim Yehle has been working on download and post-processing programs, available here: http://www.xmission.com/~jry/
Another work-around is to use some Excel formulas to look up the data while skipping lines.
Let me know which of the options you'd like more details on. Eventually I'd like to take the work that Jim has done so far and make it easier to install and use, and add in the deployment programming.
I'm using 2000 version of Excel. I might have a 95 version somewhere. I downloaded both programs from Jim's web page I'll play with them & let you know.
Thanks
I have been using excel 2003 without any trouble so I don't recommend going back to Excel 95. I did take another look at the hyperterminal settings under properties/settings/ASCII setup, and there is a selection box for appending line feeds to line ends. Was that checked for you?
No, I recaptured & imported the file again but same result. I'm not having any luck with the programs I downloaded from Jim's website either. I can't get them to connect to the parrot. Were still trying though.
Thanks, Mark
Mark,
Jim's program looks at a batch file that's among the files that are zipped up to see which port to use. You have to modify that to match whatever port number the Parrot gets hooked up to. One of the next steps in making Jim's program workable is to select the port with a GUI. That hasn't happened yet, though.
Just to be clear, did you check that setting in Hyperterminal?
-Adrian
Yes,
What should the emulation be set to? Mine is set to auto detect is that correct?
Actually here's the whole setup as it sits right now.
In the settings tab the following is what's selected
Terminal keys
Ctrl+H
Auto detect
ANSI
500
Input Translation is set to
Shift-JIS
ASCII setup
Nothing is selected for ASCII sending
Line delay & character delay are both 0
Receiving for ASCII only Append line feeds to incoming line ends is selected.
Does that all sound right?
Having "Append line feeds to incoming line ends" selected could be the problem. Try de-selecting that and let me know if that fixes it.
Hi All,
I am wondering if anyone has tried the Parrot in the Giant Leap avionics bay yet ( http://giantleaprocketry.com/hpdefault.asp)? I really like the idea of having all of the "valuables" connected into a single unit and this bay attaches directly to the fore end of my 38mm Dr. Rockets. Size-wise it looks good. It appears that additional holes for wiring may be needed for a 2-stage recovery deployment but that isn't a problem I wouldn't think? Are these wiring holes enough to stabilize the pressure inside the avionics bay for the Parrot?
Appreciate anyone's thoughts and opinions on this.
Thanks,
John
I've tried it both ways. Same result. I also tried cut & paste, and importing. No luck.
Are you going to OF?
If so, if you don't mind, maybe we can sit down & figure it out. It might be something else I'm doing wrong. I can bring my laptop.
I have a rocket itching to set a new B record, maybe even C.
Thanks
Mark
well, I have tried about every combination in the settings menu. If I change the translation to Standard JIS the gap in the datastream disappears in hyperterminal, but still remains once captured into notepad.
I manually removed the line ends in the text file. Then pasted that into the template, and everything works fine, but man is that time consuming.
Problem is I have messed with it so much I think the data is corrupted. I'll have to fly it again.
Is anyone else using the Parrot? If so, any pointers.
Mark
Mark,
Do you have the orignal Excel data file? I could write a macro that remove every other blank line. That might give you the simplified data you need without the corruption.
If so, shoot me an email with the file attached.
Ed
Ed,
I don't think the excel file is corrupted. I think it's my flight data. I have downloaded, deleted, edited, cut, pasted ..... You get the picture. It's just now I'm getting data that doesn't even match what I started with. So I'll Fly it again, and try again.
Adrian says he uses Excel 2003. Maybe I need to get a copy and try that. We'll get it working. I'm sure it has to be a setting somewhere I'm missing.
Thanks for the offer
Mark
I'm planning to be there at Octoberfest. I'll help you set up Jim Yelle's download program. I also have some formulas you can use in Excel to remove the extra lines; I was just hoping to get you a cleaner solution so that you don't have to do the extra work-around steps.
Unless you have erased the flights, you should be able to re-download them without flying. And you can always start recording a new flight test just by holding the altimeter steady vertically and then doing a 6mph upward arm movement. But sometimes it's nice to have an excuse to fly again.
Excuse to fly definitely.
Thanks Adrian.
I think if I could see how it's done correctly that would help a lot.
Besides we can't have you setting all the records without having to keep an eye on the rear view mirror. Whats the fun in that
See you there
Mark