Dupliciate Flight ID

[Vegas_09]

Any ideas why I am getting the same flight ID for some flights when I export my flights? (VA Script)

[Drew]

from the look of your flight log, it looks like you have entered a 3 letters of your flight id into fsp company manager. (SAL)

The numeric part of the id is just random, so you will end up getting duplicate id's

you can however name the id you want in the payload screen.

eg,
if you enter 000 for your 1st flight, it will show as SAL000 on the log - 001 for your 2nd etc, then your in control of the id's and it not being
random

hope that makes sense

[Vegas_09]

Ah..I see, I will just stay with the random numbers. I use the flight ID for my pilots to update thier pilot comments. Can't I somehow write
into the VA script to check for duplicates and select a different random flight number?

[2RIP]

how do you even make comments on the flight reports

[Vegas_09]

You have to add this to the script. A little MySQL and php knowledge needed.

[tbnist03]

Is there a simple copy+paste solution that might be shared? It would be greatly appreciated.


Thanks,


Mike

[AltairZQ]

Vegas_09 wrote:
Ah..I see, I will just stay with the random numbers. I use the flight ID for my pilots to update thier pilot comments. Can't I somehow write
into the VA script to check for duplicates and select a different random flight number?

I think it can be done in FsPgetflight, maybe the best option would be to take control of the flight ID and add +1 to the last fligth Id entered...
but we should lock the row to avoid 2 users at the same time. I think it can be done in MySQL but don't remember too well how.

[crowebird]

You could always check the uploads by somthing else, oppsoed to the flight ID > so dont check flight ID, check flight time,
departure/location, pilot, etc... and get rid of flight ID check... Im doing somthing different with mine, invovling the filing of a flight plan
before a flight is allowed to be submitted, but its a little more complicated than that, but this would also solve this issue, as it isnt
dependant of flight ID

[Jetflyer]

With my 606 flights, I've had many of these. I have three "NF100" flights, three "NF116", three "NF122", three "NF522", three "NF618", three "NF754"
and the list goes on....

Not very imaginative, is it?

[AltairZQ]

AltairZQ wrote:

Vegas_09 wrote:
Ah..I see, I will just stay with the random numbers. I use the flight ID for my pilots to update thier pilot comments. Can't I somehow write
into the VA script to check for duplicates and select a different random flight number?

I think it can be done in FsPgetflight, maybe the best option would be to take control of the flight ID and add +1 to the last fligth Id entered...
but we should lock the row to avoid 2 users at the same time. I think it can be done in MySQL but don't remember too well how.

Seems like I was wrong:

"By using incremental updates (UPDATE customer SET value=value+new_value) or the LAST_INSERT_ID() function, you can avoid using LOCK TABLES in many
cases".

[AltairZQ]

I ended up using `id` instead of `FlightID`. Do you foresee any problems doing this?

Check the link under my signature to see how it looks, now we have fligh ID from 1 to 139.

One thing is that it's not too realistic because the flight id is assigned when it's entered to the company and not before the flight itself but...
maybe this is not that important.