PhreeZone 20
Recommended Posts
gemini 0
I would request numbers and dates of manufacture. That way searches could be done both ways. Only cost I see is NT web host (Media3.com is about $284 for one year). Database can be Access with web front end. Should really be simple.
Blue skies,
Jim
Blue skies,
Jim
councilman24 37
It may be simple, but remember PIA is a COMPLETELY volunteer run organization. Unless someone champions an idea AND volunteers to follow through with it, AND finds a replacement when they don't want to do it anymore, it isn't going to happen.
The current PIA volunteers do not have enough time to take on items like this. It does no good to say "Hey, PIA should do this." Maybe we should, but with out ANY full or part time paid staff, the person with the idea needs to run with it. We have a lack of dedicated volunteers participating the way it is. Many of the same people have been running the committees and organization since it's inception. We've gained a large number of new members recently. Especially raw material and component manufacturers and government agencies. But we have very few new committee chairs, officers, or volunteers. At the last elections we had NO contested committee chair positions. Often it's who can we draft and convince to do it.
I was recently speaker coordinator for the symposium and ran the rigger continuing education program. (I'm not done yet!) I'm also rigging committee chair. NOT counting my time, my out of pocket expenses just to work harder are about $2500 a year. This is hotels and travel to the meetings and symposia. This is far more than I make rigging part time in a year.
I do it as a service and because I enjoy the people and the activities.
So, if you want more from PIA, we need your membership but more importantly your HELP.
Let me know when the data base is available and we'll put it on the web site.
The current PIA volunteers do not have enough time to take on items like this. It does no good to say "Hey, PIA should do this." Maybe we should, but with out ANY full or part time paid staff, the person with the idea needs to run with it. We have a lack of dedicated volunteers participating the way it is. Many of the same people have been running the committees and organization since it's inception. We've gained a large number of new members recently. Especially raw material and component manufacturers and government agencies. But we have very few new committee chairs, officers, or volunteers. At the last elections we had NO contested committee chair positions. Often it's who can we draft and convince to do it.
I was recently speaker coordinator for the symposium and ran the rigger continuing education program. (I'm not done yet!) I'm also rigging committee chair. NOT counting my time, my out of pocket expenses just to work harder are about $2500 a year. This is hotels and travel to the meetings and symposia. This is far more than I make rigging part time in a year.
I do it as a service and because I enjoy the people and the activities.
So, if you want more from PIA, we need your membership but more importantly your HELP.
Let me know when the data base is available and we'll put it on the web site.
I'm old for my age.
Terry Urban
D-8631
FAA DPRE
Terry Urban
D-8631
FAA DPRE
Hooknswoop 19
Quotethe person with the idea needs to run with it.
Oops. I'll see what I can do, but no promises.
Derek
LisaM 0
It's coming sooner than you think!
RigTrack is a new upcoming web based application for use by riggers and skydivers alike. Riggers have many options to track their clients. One of its many features does exactly what you've mentioned, Derek. It even goes a step further as to allow a rigger to sign up for email notifications if a SB/AD is issued for a client rig... i.e. the Rigger does not have to go searching for it!
We are very excited about this application and will be asking for beta testers within a month (beta testers of course get the service for free). Stay tuned!
Visit http://www.rigtrack.net and keep an eye on this space!
- Lisa
RigTrack is a new upcoming web based application for use by riggers and skydivers alike. Riggers have many options to track their clients. One of its many features does exactly what you've mentioned, Derek. It even goes a step further as to allow a rigger to sign up for email notifications if a SB/AD is issued for a client rig... i.e. the Rigger does not have to go searching for it!
We are very excited about this application and will be asking for beta testers within a month (beta testers of course get the service for free). Stay tuned!
Visit http://www.rigtrack.net and keep an eye on this space!
- Lisa
QuoteQuotethe person with the idea needs to run with it.
Oops. I'll see what I can do, but no promises.
Derek
I think it would be relatively simple. The hardest part would be designing the tables with the correct fields and that is not really that hard. The interface would be easy.
Why yes, my license number is a palindrome. Thank you for noticing.
IanHarrop 42
QuoteI think it would be relatively simple. The hardest part would be designing the tables with the correct fields and that is not really that hard. The interface would be easy.
I think the hardess part is not setting up the initial database, but rather the effort and time required to get the data into the system, and a QA process to make sure it goes in right. Then there is the the time and effort required for on going data entry and QA.
"Where troubles melt like lemon drops, away above the chimney tops, that's where you'll find me" Dorothy
PhreeZone 20
I'd perfer to go with MySQL. Futureproof it as much as possible and allow for a large potential user base to access it at the same time. That or actual MS-SQL. The Host that PIA already uses allows for use of a 10 meg MySQL DB on the entry level package and larger sizes for larger accounts.
I've got some time on my hands here that I can use to design and assist on something like this if there is really a large demand.
I've got some time on my hands here that I can use to design and assist on something like this if there is really a large demand.
Yesterday is history
And tomorrow is a mystery
Parachutemanuals.com
And tomorrow is a mystery
Parachutemanuals.com
riggerrob 643
QuoteQuoteI think it would be relatively simple. The hardest part would be designing the tables with the correct fields and that is not really that hard. The interface would be easy.
I think the hardest part is not setting up the initial database, but rather the effort and time required to get the data into the system, and a QA process to make sure it goes in right. Then there is the the time and effort required for on going data entry and QA.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
That would require me to have a lap-top in my loft and enter serial numbers early in the inspection process.
Fat chance!
My boss has repeatedly refused offers to install a wireless network for free.
As for him buying me a lap-top?
Hah!
Hah!
I would prefer a lap-top and a paper-less loft, but that is not going to happen this year.
On the plus side ... Perhaps I should not complain too loudly as he just moved my loft into a freshly-painted 30X40 hangar, and bought me a half-dozen sewing machines.
Instead, I rely on the Australian Parachute Federation's list of Service Bulletins, ADs, etc. I visit the APF website once a month, print out ADs that I am likely to encounter, then just have to vaguely remember that there is an SB on Mirage ...
skycat 0
QuoteThat would require me to have a lap-top in my loft and enter serial numbers early in the inspection process.
Fat chance!
My boss has repeatedly refused offers to install a wireless network for free.
As for him buying me a lap-top?
Hah!
Hah!
I would prefer a lap-top and a paper-less loft, but that is not going to happen this year.
Hehe...good thing hooknswoops boss hooked him up with all that stuff.
Plus a database that does everything rig track does except the auto email part, but I'll get around to that eventually. Maybe Saturday if he leaves his laptop at home.Fly it like you stole it!
tdog 0
I write software as part of my job. 
What you want I could knock out on a few rainy days.
If someone was willing to pay some hosting fees for a server - less than a reserve packjob a month (like PIA or USPA or someone) - and you could get all the manufactures to play ball - the system could be up very soon. Heck, if someone scratched my back, I would find a way to host it for free - but I like the idea of it being hosted on an independent trade organization's website.
I think it is a cool idea.
When I took a truck in for repair last month, the GM dealer looked up the VIN and knew every recall (or lack there of) that was required to be done... That is what you are looking for, right?
Hook - get some manufactures to agree to play ball, and I will write the software. Nothing fancy - just clean and reliable.
Initial design info needed, if you are serious:
1) List of manufactures who are gonna play ball. (This might take some sweet talking)
2) Can the system be password free (I think it should – if I am buying something used I should be able to use it, but the manufactures might have a different idea)
3) List of manufacture’s products by name.
4) List of types components you want in the system (Container, Reserve, AAD???, Others?)
5) Sample serial numbers for each manufacture/product to determine data length and data format (special characters, etc)
6) Does a manufacture ever issue the same serial number to a model X reserve and a model Y – or are the serial numbers unique within the manufacture. I.E. Serial number X1234 is only used once, ever, by that manufacture.
7) Could a manufacture who chooses to play ball give us every serial number affected by a issue – or are they going to do DOM because they fear their records are not good enough and they might miss a serial number?
8) Do manufactures tend to do sequential serial numbers – or do they jump around?
9) How important is it to track what has been done to a specific rig? I.E. a rigger logs in and says “I fixed this on this one rig.” – Note for liability reasons, I really don’t like this… Car manufactures do it, but their system is a closed loop to dealers and manufactures. That being said – instead of keeping track of very specific serial numbers – would a more broad search engine be effective where the rigger – not the computer – does the fuzzy logic. I.E. – does the rigger enter “Manufacture X, Model Y” – and the system simply reports “all units before serial number 1234 or DOM 9/05 need to have this done”. Then the rigger, not the computer, figures out if the rig in hand is subject to the mod.
I can come up with more questions - but these should be a good start to see if you are serious or not???
What you want I could knock out on a few rainy days.
If someone was willing to pay some hosting fees for a server - less than a reserve packjob a month (like PIA or USPA or someone) - and you could get all the manufactures to play ball - the system could be up very soon. Heck, if someone scratched my back, I would find a way to host it for free - but I like the idea of it being hosted on an independent trade organization's website.
I think it is a cool idea.
When I took a truck in for repair last month, the GM dealer looked up the VIN and knew every recall (or lack there of) that was required to be done... That is what you are looking for, right?
Hook - get some manufactures to agree to play ball, and I will write the software. Nothing fancy - just clean and reliable.
Initial design info needed, if you are serious:
1) List of manufactures who are gonna play ball. (This might take some sweet talking)
2) Can the system be password free (I think it should – if I am buying something used I should be able to use it, but the manufactures might have a different idea)
3) List of manufacture’s products by name.
4) List of types components you want in the system (Container, Reserve, AAD???, Others?)
5) Sample serial numbers for each manufacture/product to determine data length and data format (special characters, etc)
6) Does a manufacture ever issue the same serial number to a model X reserve and a model Y – or are the serial numbers unique within the manufacture. I.E. Serial number X1234 is only used once, ever, by that manufacture.
7) Could a manufacture who chooses to play ball give us every serial number affected by a issue – or are they going to do DOM because they fear their records are not good enough and they might miss a serial number?
8) Do manufactures tend to do sequential serial numbers – or do they jump around?
9) How important is it to track what has been done to a specific rig? I.E. a rigger logs in and says “I fixed this on this one rig.” – Note for liability reasons, I really don’t like this… Car manufactures do it, but their system is a closed loop to dealers and manufactures. That being said – instead of keeping track of very specific serial numbers – would a more broad search engine be effective where the rigger – not the computer – does the fuzzy logic. I.E. – does the rigger enter “Manufacture X, Model Y” – and the system simply reports “all units before serial number 1234 or DOM 9/05 need to have this done”. Then the rigger, not the computer, figures out if the rig in hand is subject to the mod.
I can come up with more questions - but these should be a good start to see if you are serious or not???
In therory it would'nt be that hard to do. SQL tables for each product. Manufactors supply a COMPLETE list of all affected serial numbers and drop them into the table. Web GUI front end to do an exact match on input vs the table. If the serials match then you can have it display direct links to the SB or AD.
Hard issues I see are when they do recalls or SB by Everything made before X date. Things get really blurry there because even though they say 6/99, they don't provide serials and then the search results get blurry.
If someone like PIA ran the DB then it is even possible in theory to allow the riggers to update the records for Container serial XXXXX-XXXX-XX that SB01000 was applied and they can leave something like a seal/certificate number as further proof. Thats kinda out there though since I can see some riggers just looking to see if the DB was updated and not actually confirming it on the gear.
On a rating of 1-10 I'd rate this as a 5 for most computer geeks (who know anything about Databases). It should be easy to have it contracted out for cheap, few $k MAX for someone like PIA.
And tomorrow is a mystery
Parachutemanuals.com
Share this post
Link to post
Share on other sites