RadarBox Database - Flight Codes

[CarlosAbreu]

Hi to All

I'm a new RadarBox user and I have a question wish that I would appreciate any help:

How I introduce in Database the following flight from Portuguese Charter Airline White:

WHT891 LPPT-SBRF-SBNT-SBRF-LPPT

There's only one data field for a 1 route stop, the only way is introduce the flight with the same number twice:

WHT891 LPPT-SBNT via SBRF
WHT891 SBNT-LPPT via SBRF

There's other way to do it ?
I will have the same problem with some TAP flights to/from Mozambique.

Other curiosity is the fact of when I'm intoducing a new Airline in RadarBox Database I only can do it in CAPS LOG (?)

Brgds
CA

[AirNav Support]

I wonder why the return flight is called the same as the outbound flight. Thats confusing from a passengers perspective as well as ATC.

That confusion will cause will cause RadarBox 2007 to be confused as well. There isn't another way round it I am afraid.

[CarlosAbreu]

That's what suspected, in fact these flight codes are confused but some portuguese airlines like White and TAP sometimes use them, specially for some Brazil flights, the Mozambique flight is an exception.

I use Airnav Suite 4 since the begining and there I can introduce manually all flight routes without problems, but unfortunetly in RadarBox I can't do it.

And the airline name question ?
Why can't I introduce the name in small letter ?
For example I tried to introduce Clickair as I type it and it was only possible to do it as CLICKAIR (?)...why this happens if all other all airline names are in small letter.

Brgds
CA

[AirNav Development]

Carlos, wait one week to start introducing codes. We are releasing a new version with a definitive (and new) database system and it is much easier to enter data there. The new system is called SQLite and database can be edited with extrenal applications.

[CarlosAbreu]

OOOPPPPSSSS !!!

I have already manually introduced a lot of flights that are usuall at LPPT...!!!

I read about new version here in forum, however, I supposed that the update would keep data, It's clear for me now that I was wrong, all work done will be miss...!!!

No problem, let's consider it a "training procedure", I will do it again to share with all the ANRB users.

Just one more question, the aircraft database is automatically updated ? I suppose I must do it manually as I did with Airnav Suite 4 allover the years.

Brgds
CA

[tarbat]

And you'll be able to use SQL to compare what's in the ARB routes database vs. your own favourite database of routes.  For example, I'll be using routes that I've collected using FD6 over the last few months to fill in the gaps in the ARB routes table, using this SQL:
SELECT DISTINCT
  RoutesFD6.FlightID,
  RoutesFD6.DepICAO,
  RoutesFD6.ArrICAO
FROM
 RoutesFD6
 LEFT OUTER JOIN routes ON (RoutesFD6.FlightID=routes.FN)
WHERE
  (routes.FN IS NULL)
ORDER BY
  RoutesFD6.FlightID

I'll also be using SQL to look for routes that exist in both ARB and FD6 that have different destination or arrival airports, and reviewing these to see which looks more correct, FD6 or ARB:
SELECT DISTINCT
  RoutesFD6.FlightID,
  RoutesFD6.DepICAO,
  RoutesFD6.ArrICAO,
  routes.FN,
  routes.NO,
  routes.ND,
  routes.NV
FROM
 RoutesFD6
 LEFT OUTER JOIN routes ON (RoutesFD6.FlightID=routes.FN)
WHERE
  (RoutesFD6.DepICAO <> routes.NO) OR
  (RoutesFD6.ArrICAO <> routes.ND)
ORDER BY
  RoutesFD6.FlightID

[Roadrunner]

Carlos, wait one week to start introducing codes. We are releasing a new version with a definitive (and new) database system and it is much easier to enter data there. The new system is called SQLite and database can be edited with extrenal applications.

Can I infer from this that V1.4 is only one week away from release ?

[AirNav Support]

Keep your fingers crossed, we are :)