ConvoTrack

Thursday, April 03, 2008

BDO tracking software idea


Every airline in the world loses luggage...lots & lots of luggage. Every airline hires a courier company to deliver that luggage to the passengers, once they find it. For each airport they have a different courier company.

Those courier companies hire drivers to do the deliveries. Those drivers must keep track of data from BDO's (Baggage Delivery Order) issued for each delivery.

Most do this on paper, with their manifest sheets, checking off on one side after they turn in a BDO for a completed delivery, and checking the other side once they have been paid for that delivery.

This can be time consuming, tedious work, looking through pages & pages for specific BDO numbers, which are never in any sort of order. Then you have to save the sheets till the next pay period to go back and check off the ones you weren't paid for that show up on the next check.

And if the dispatcher gets a call from an airline complaining about a specific delivery, and that dispatcher starts bugging the driver, that driver has to recall details, digging up old manifests and hunting for that delivery in order to do it.

When I worked at the airport as a dispatcher for one of the courier companies that was hired to handle deliveries for more than 7 different airlines, on pay day my parking lot was full of drivers that spent hours sorting out their manifests and matching BDO numbers for the 2 or more companies they were driving for.

A thought just hit me today: I could make their lives so much easier, especially if they have a laptop in their vehicle.

They could enter the BDO data into software and sort entries by BDO number, date, airline, courier company, etc. A click of a button could change the view to show only unpaid BDO's or ones that weren't turned in for payment yet.

This would be a great way to track all the work they do and cut down on the amount of papers all over their cars & vans.

No more photocopying BDO's at the beginning of every shift. No more misplaced manifests from 3 weeks ago. No more wondering which company you got the BDO from. No more wondering if you got paid for all your deliveries or paid the right amount. No more wondering if you turned them all in for payment.

Now I have done some checking around, and research, and I have not found a single application for the purpose of tracking BDO data. Has nobody ever thought of this before?

Now the data on these BDO's and tracking them is also of use to the courier companies and the airlines. I am pretty sure the airlines have their own software for the purpose, but not all the courier companies do. A great many of the courier companies are living in the dark ages and doing everything with pen & paper still.

I think I would make this software free for the individual drivers to use, but require a commercial license to be purchased by any company that wanted to use it in their offices, for their dispatchers, or other purposes. Knowing that a lot of these companies have some of the tightest budgets, and most are struggling, trying to keep themselves from going bankrupt, I would make it quite affordable for them to purchase a license.

I think it's time for me to call one of my old drivers and see if he can swipe a few blank BDO's from somewhere, for me to work with.

2 comments:

Anonymous said...

I missed you sveral times every day that you were gone.
I'm the kind of person that would have popped the $ in the mail if I ahd it.

Your New Idea:

Use the KISS principal

ASCI Comma delimited transfer protocol so nobody is tied in to hardware or OS requirements (anyone can get a DOS box for next to nothing, a 286 laptop would work)

The very best simple table program I have ever seen is Table Pro from a guy in east europe.

http://zgspro.com

zgspro@zgspro.com

It runs in win 95-98 at least.

It's free for non commercial.

I'll send it if you have trouble with the polish or whatever it is.

yours

douglas

dcsherriff@fastmail.fm

App said...

I believe in simple when it comes to writing applications. (It should be my middle name.)

I can guarantee you this before I even begin, that it will run on at least a 233mhz, 64mb RAM machine running some form of 9x. I still have one around that I use for testing everything I release.

I really try to go for WinAll with the stuff I make. There are plenty of great reliable machines out there that can't run the latest & greatest from Microsoft, and it is a shame to waste them or release stuff that can't be used by the people that need it most.

As far as saving the data, I might go with xml. It would definately allow for others to improve on my ideas and develop something of their own to use with the same saved data, including web applications.

I'll be sure to add an option to export to ASCII comma delimited, for those that might need it for other purposes.

Not sure I will be needing the table program. I am a Delphi coder...we have lots of goodies in our bag of tricks.

This isn't something I will be doing in the immediate or near future. I was just throwing an idea out to see where it goes. I do that sometimes. I have a lot of other projects that need some work and users of existing software and their needs should come first.

But your feedback is quite encouraging. It's nice to know I wasn't alone in my experiences and way of thinking and that if I put in the work on this that someone will appreciate it.

Thanks.

Statistically speaking, most people visiting this site are English speakers from the US, on cable or DSL, viewing the site with a widescreen monitor, in Firefox 3, running on WinXP. Does this describe you?