If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
FAI/IGC/CAI File Name Decoding - Automated!!
See my other posting "IGC File Name Decoding Made Easy" on this topic.
Several people asked me to automate the "onerous" task of translating FAI/IGC/CAI flight recorder file names. I created an Excel spreadsheet which does the trick. See http://www.skysoaring.com/FAI_Flight...e_Decoder_V1.x. There is some error checking in this version and I am adding more. Enter (copy/paste) the filename into the yellow box. The results of the decoding immediately appear below in the green box. Let me know if you find this useful. If so, and I find the time, I will try to create a standalone visual basic tool. Enjoy, John johnatderosaweb.com |
#2
|
|||
|
|||
Looks like the system didn't want to allow my URL which should have
ended in a .xls. Similar to it eating email ids. This may be a security feature. Let's try this again. The correct URL is; http://www.skysoaring.com/FAI_Flight...Decoder_V1.xls That is... http://www.skysoaring.com/ with the filename FAI_Flight_Recorder_Filename_Decoder_V1.xls If you cannot download it, just send me an email and I will forward the latest version to you. Enjoy, John johnatderosaweb.com |
#3
|
|||
|
|||
Hi John,
Cool. Good idea. That link works well for me. I'll add a link to it from my Soaring Links pages. You may want to note that the last digit is the flight number for the day. Good Soaring, Paul Remde "ContestID67" wrote in message ups.com... Looks like the system didn't want to allow my URL which should have ended in a .xls. Similar to it eating email ids. This may be a security feature. Let's try this again. The correct URL is; http://www.skysoaring.com/FAI_Flight...Decoder_V1.xls That is... http://www.skysoaring.com/ with the filename FAI_Flight_Recorder_Filename_Decoder_V1.xls If you cannot download it, just send me an email and I will forward the latest version to you. Enjoy, John johnatderosaweb.com |
#4
|
|||
|
|||
Hi John,
thank you for the decode spread sheet. In case you are looking for improvements, I do have a suggestion. You could re-implement the code as a Windows system patch that would display the information while the mouse cursor hoovers over the an IGC filename in file lister programs such as Windows Explorer. Bela |
#5
|
|||
|
|||
For those without Excel installed, there is an Excel "viewer" available
at http://www.microsoft.com/office/000/viewers.asp. This allows you to view and use an Excel spreadsheet without owning the full version. |
#6
|
|||
|
|||
Please see some background information about this thread in the topic
"IGC File Name Decoding Made Easy". Enjoy, John johnatderosaweb.com |
#7
|
|||
|
|||
In the "IGC File Name Decoding Made Easy" it was mentioned about the EW
Avionics recorders (and other recorders) which take a long base10 serial number and convert it to base36 (0-9, a-z) to fit in the file name format. "Cambridge, Garrecht (Volkslogger), Zander all use the external serial. Filser,LX,Colibri,PrintTechnik convert external serial directly to base36" - Peter Wyld Peter also comments that depending on the Model of EW recorder, they take the serial number on the case and add 2000 (B models) or 9000(D models). A models stay the same. Whew. From a post by Martin Gregorie I see the following example for an EW model D The A line from a trace: AEWAD0430 99429850 The serial number on the case: D0430 The serial number in a filename: 79Y Taking D0430 and adding 9000 per Peter Wyld's post, I get a base10 serial number of 9430. Taking 79Y and converting it to Base10. 79Y = 7x36x36 + 9x36 + 34 = 9430. Hey, it works. All I need now is to get Excel to do the math in reverse and deal with the add 2000 or 9000 to the SN. I'll report back. Enjoy, John johnatderosaweb.com |
#8
|
|||
|
|||
I noticed in Peter Wyld's comments: "Cambridge, Garrecht (Volkslogger),
Zander all use the external serial. Filser, LX, Colibri, PrintTechnik convert external serial directly to base36" Two models are not mentioned in the CAI document dealing with manufacturer file name encoding. Zander PrintTechnik Does anyone have one of these recorders and could share with me an example filename so I can figure out what the missing information is? Thanks, John |
#9
|
|||
|
|||
X-no-archive: yes
In article .com, ContestID67 writes In the "IGC File Name Decoding Made Easy" it was mentioned about the EW Avionics recorders (and other recorders) which take a long base10 serial number and convert it to base36 (0-9, a-z) to fit in the file name format. "Cambridge, Garrecht (Volkslogger), Zander all use the external serial. Filser,LX,Colibri,PrintTechnik convert external serial directly to base36" - Peter Wyld Peter also comments that depending on the Model of EW recorder, they take the serial number on the case and add 2000 (B models) or 9000(D models). A models stay the same. Whew. What about the Model C? I don't think there were many of these, but I believe there were some. From a post by Martin Gregorie I see the following example for an EW model D The A line from a trace: AEWAD0430 99429850 The serial number on the case: D0430 The serial number in a filename: 79Y Taking D0430 and adding 9000 per Peter Wyld's post, I get a base10 serial number of 9430. Taking 79Y and converting it to Base10. 79Y = 7x36x36 + 9x36 + 34 = 9430. Hey, it works. All I need now is to get Excel to do the math in reverse and deal with the add 2000 or 9000 to the SN. I'll report back. Enjoy, John johnatderosaweb.com The problem with deciding to decode Base-36 or Base-10 according to the manufacturer code is that while a specific manufacturer may use Base-10 now, any future recorder models will not get approval for Base 10 serial numbers, they will need to use Base-36. For instance, Legacy Cambridge models use base-10, but 302 uses base-36. I would therefore urge you to display both the Base-36 and the Base-10 serial numbers as it is not possible to determine the model from the filename (if you ignore EW). Tim Newport-Peace "Indecision is the Key to Flexibility." |
#10
|
|||
|
|||
At 21:36 23 September 2005, Tim Newport-Peace wrote:
X-no-archive: yes In article , ContestID67 writes In the 'IGC File Name Decoding Made Easy' it was mentioned about the EW Avionics recorders (and other recorders) which take a long base10 serial number and convert it to base36 (0-9, a-z) to fit in the file name format. 'Cambridge, Garrecht (Volkslogger), Zander all use the external serial. Filser,LX,Colibri,PrintTechnik convert external serial directly to base36' - Peter Wyld Peter also comments that depending on the Model of EW recorder, they take the serial number on the case and add 2000 (B models) or 9000(D models). A models stay the same. Whew. What about the Model C? I don't think there were many of these, but I believe there were some. Model EWC - add 6000 (range 6001-8999, 4MP-5EF) Model EWF - add 5000 (range 5001-5999, 3UX-4MN) I have an Excel spreadsheet which converts logger serial numbers to the b36 part of a filename. It's pretty ugly, but you're welcome to it if you want it. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
IGC File Name Decoding Made Easy | ContestID67 | Soaring | 14 | September 23rd 05 08:25 PM |
Washington DC airspace closing for good? | tony roberts | Piloting | 153 | August 11th 05 12:56 AM |
New File Library Email Service | Tom Allensworth | Simulators | 2 | July 19th 04 10:33 PM |
And they say the automated Weather Station problems "ASOS" are insignificant because only light aircraft need Weather Observations and forecasts... | Roy | Piloting | 4 | July 12th 03 04:03 PM |