Is there a way to change Pilot IDs in phpVMS7?

[AdamWilliams]

Changing a Pilot's ID using the new phpVMS 7

Changing pilot's default ID's is something which we need to be able to do, to easily manage our phpVMS system and subsequent flight logging system. When a pilot joins the VA, they are assigned a Callsign (which will be the same as their ID on our phpVMS webpage) and once they were registered on our phpVMS 5 website we could quite easily change their IDs to the one they have been assigned. This helped when it came to identifying pilots and dealing with promotions.

I am wondering whether anyone may be thinking of producing a widget/addon to do this. I have already tried to edit pilot's IDs manually in the phpMyAdmin panel, however this has had knock on effects as users who have had their ID changed manually now cannot access the phpVMS dashboard or for admins, the admin panel.

I understand that this version is still in Beta, however if there is any way to change IDs that anyone knows of, then I'd love to hear it.

Any suggestions would be greatly appreciated,

Thanks, Adam.

Edited October 27, 2018 by AdamWilliams

[ARV187]

Hi Adam, its actually asked: https://github.com/nabeelio/phpvms/issues/265

I tried change it directly in DB but have strange effects.

Edited October 29, 2018 by ARV187

[Nabeel]

It's planned. It won't be tied to their database ID

[AdamWilliams]

Thanks for the reply! We've found a temporary way around it currently, but would be great in the future. 

[Nabeel]

On 11/1/2018 at 5:26 PM, AdamWilliams said:

Thanks for the reply! We've found a temporary way around it currently, but would be great in the future. 

What's your workaround?

[AdamWilliams]

We've basically just added a PiRep field asking for their Pilot ID in regards to our VA. Nothing to do with actually changing the IDs in phpVMS currently, but it works for what we're doing.