Headaches with records?
Thread Starter
Joined: Mar 2003
Posts: 210
Likes: 0
From: Brighton
Headaches with records?
Hello there
Before I thought about this I had a look at some posts from the database so mods please let me know if I'm stepping over the line here...
We have developed a system to manage aircraft records - thats everything from delivery docs from the manufactuer to the maintenance history and tech logs. Our system is pretty nifty and already we have scanned 50 entire aircraft back to birth for customers all over the world.
What we have allows you to type in a component serial number and search for any item containing that number - so in seconds you could get the Form One for example and print it or email it.
I'm wondering how you guys in the tech records areas manage this at the moment? Do you scan already and is it in PDF format or microfilm?
Are you aware of any similar systems that do this at all?
Cheers
Before I thought about this I had a look at some posts from the database so mods please let me know if I'm stepping over the line here...
We have developed a system to manage aircraft records - thats everything from delivery docs from the manufactuer to the maintenance history and tech logs. Our system is pretty nifty and already we have scanned 50 entire aircraft back to birth for customers all over the world.
What we have allows you to type in a component serial number and search for any item containing that number - so in seconds you could get the Form One for example and print it or email it.
I'm wondering how you guys in the tech records areas manage this at the moment? Do you scan already and is it in PDF format or microfilm?
Are you aware of any similar systems that do this at all?
Cheers
Joined: Jan 2006
Posts: 91
Likes: 0
From: Durkadurkastan
The RAF use a network called the Logistic Information Technology System, otherwise known as LITS (or Lost In Time and Space) for ac engineering and asset management. It's not quite up to scanning documents but (aircrew: commence uncontrollable laughter) it is quite good at locating items by component number and calculating rolled-up remaining life on significant components or assemblies, including entire ac. It's based on a Sth African Defence Force system called OSIS and coded by a bunch of geekoids at IBM UK in Stevenage.
Sounds like you might have one over us there. How long did it take to do 50 ac?
Sounds like you might have one over us there. How long did it take to do 50 ac?
Thread Starter
Joined: Mar 2003
Posts: 210
Likes: 0
From: Brighton
Hi Fox
We can scan, index and deliver a searchable DVD just about onsite. A 2 person team can get through between 6000-8000 records per day. Thats about a years worth of typical narrowbody records. Its a bit quicker if its done at our office.
As an example a 5 year old A320/B737 would take us 5 days.
I'll PM you more info...
Cheers
We can scan, index and deliver a searchable DVD just about onsite. A 2 person team can get through between 6000-8000 records per day. Thats about a years worth of typical narrowbody records. Its a bit quicker if its done at our office.
As an example a 5 year old A320/B737 would take us 5 days.
I'll PM you more info...
Cheers
Joined: Feb 2002
Aviation Qualifications: AME
Posts: 4,182
Likes: 1,115
From: UK
Oh please! Talk to BA. Their new system is just fab!
It's called EWS (Engineering Without Spares or Enormous Waste System) It's very cheap, only about £3M spent on it so far in the last 5 years and it still doesn't work!
So if you think you can come on here and tell us all that you have a system that actually works........
Nurse!
I'm going to my happy place now....wibble!
It's called EWS (Engineering Without Spares or Enormous Waste System) It's very cheap, only about £3M spent on it so far in the last 5 years and it still doesn't work!
So if you think you can come on here and tell us all that you have a system that actually works........
Nurse!
I'm going to my happy place now....wibble!
Joined: May 2004
Posts: 934
Likes: 0
From: Balmullo,Scotland
Originally Posted by Irishwingz
Hello there
Before I thought about this I had a look at some posts from the database so mods please let me know if I'm stepping over the line here...
We have developed a system to manage aircraft records - thats everything from delivery docs from the manufactuer to the maintenance history and tech logs. Our system is pretty nifty and already we have scanned 50 entire aircraft back to birth for customers all over the world.
What we have allows you to type in a component serial number and search for any item containing that number - so in seconds you could get the Form One for example and print it or email it.
I'm wondering how you guys in the tech records areas manage this at the moment? Do you scan already and is it in PDF format or microfilm?
Are you aware of any similar systems that do this at all?
Cheers
Before I thought about this I had a look at some posts from the database so mods please let me know if I'm stepping over the line here...
We have developed a system to manage aircraft records - thats everything from delivery docs from the manufactuer to the maintenance history and tech logs. Our system is pretty nifty and already we have scanned 50 entire aircraft back to birth for customers all over the world.
What we have allows you to type in a component serial number and search for any item containing that number - so in seconds you could get the Form One for example and print it or email it.
I'm wondering how you guys in the tech records areas manage this at the moment? Do you scan already and is it in PDF format or microfilm?
Are you aware of any similar systems that do this at all?
Cheers
Joined: Jan 2006
Posts: 91
Likes: 0
From: Durkadurkastan
£300,000,000!
And here's me worried about wasting taxpayers money. I guess £300m on a duff EAM system goes some way to explaining BA's pension deficit or have I opened up a can of worms? Perhaps not the right forum... 
Joined: Jan 2006
Posts: 3
Likes: 0
From: LGW
£300,000,000
£70,000,000 initial budget
had to go back to the board and ask for another £150,000,000 to finish the job
plus about £20,000,000 extra over the last 5 years
and it still take 20 A4 pages of paper 20 minutes hunting for the part on the system to get the parts
"but will save the company millions over the long term
"
had to go back to the board and ask for another £150,000,000 to finish the job
plus about £20,000,000 extra over the last 5 years
and it still take 20 A4 pages of paper 20 minutes hunting for the part on the system to get the parts
"but will save the company millions over the long term
"
Joined: Dec 2005
Posts: 117
Likes: 0
From: OVER THE RAINBOW
Scanning the records is great, but has any body checked that whats within them is correct. We have bought aircraft from reputable companies, did a physical check of rotable components s/n and found something else fitted. Its human nature, we find mistakes we made too, so I am not going to throw stones in the glasshouse. The day you trust everything the computer tells you, is the day you are looking for trouble. Sampling checks are a good way to go.
We use IAS system and works great for us (stores is linked to aircraft status, linked to accounts, linked to defects etc) now if it could only make a decent coffee, I'd be happy.
We use IAS system and works great for us (stores is linked to aircraft status, linked to accounts, linked to defects etc) now if it could only make a decent coffee, I'd be happy.
Joined: Feb 2001
Posts: 25
Likes: 0
From: Left Field
Originally Posted by whiskeyflyer
We use IAS system and works great for us (stores is linked to aircraft status, linked to accounts, linked to defects etc) now if it could only make a decent coffee, I'd be happy.
TT
Joined: Feb 2001
Posts: 25
Likes: 0
From: Left Field
They are far less problematic than IQ, but not as quick. A bit daunting for some users to set up, but worth the asking.
Tip #1 When you work out where all the data is, only bring in the data you want. Don't try to bring everything in at once.
TT
Tip #1 When you work out where all the data is, only bring in the data you want. Don't try to bring everything in at once.
TT
Cunning Artificer
Joined: Jun 2001
Posts: 3,125
Likes: 7
From: The spiritual home of DeHavilland
We've been looking at many of these systems but none of them do precisely what our customers demand.
The root of the problem is getting the original paper into the system. Every system we've looked at uses more labour than an old fashioned 'Cardex' system, which surely defeats a major part of the objective.
The root of the problem is getting the original paper into the system. Every system we've looked at uses more labour than an old fashioned 'Cardex' system, which surely defeats a major part of the objective.
Joined: Dec 2005
Posts: 117
Likes: 0
From: OVER THE RAINBOW
Originally Posted by Blacksheep
We've been looking at many of these systems but none of them do precisely what our customers demand.
The root of the problem is getting the original paper into the system. Every system we've looked at uses more labour than an old fashioned 'Cardex' system, which surely defeats a major part of the objective.
The root of the problem is getting the original paper into the system. Every system we've looked at uses more labour than an old fashioned 'Cardex' system, which surely defeats a major part of the objective.
Everthing was redone including procedures. Procedures where written around the system bought off the shelf and everybody trained in those procedures. You will never get a system that matches your current procedures, which built up over time based on old systems. I would never go back to cardex (we run a fleet with half the staff of old).
Setting up everything takes times (and accurancy, such as do you use dashes in P/Ns, same format for all ADs on system) but once up and running its a joy to use. And once RFT are common on parts, life will even be easier
Thread Starter
Joined: Mar 2003
Posts: 210
Likes: 0
From: Brighton
Getting existing info into the system
We handle this by scanning the feed from the legacy/currrent system and use a zonal OCR programme to 'find' whats required from each page and feed this into an excel file or whatever for easy upload to your new system.
Zonal OCR (Optical Character Recognition) is when you define what field/s on the page you want pulled from the old data and it will 'look' in these fields for the data. works well when you have a structured system but not so well when the data is spread with no particular pattern.
Ultimately, if you dont spend time on migrating the old data to your new system properly then you will have problems. turning junk into junk as they say...
We handle this by scanning the feed from the legacy/currrent system and use a zonal OCR programme to 'find' whats required from each page and feed this into an excel file or whatever for easy upload to your new system.
Zonal OCR (Optical Character Recognition) is when you define what field/s on the page you want pulled from the old data and it will 'look' in these fields for the data. works well when you have a structured system but not so well when the data is spread with no particular pattern.
Ultimately, if you dont spend time on migrating the old data to your new system properly then you will have problems. turning junk into junk as they say...
