Hop List Position File - format

Started by Pro_Avia, August 04, 2014, 09:43:52 PM

Previous topic - Next topic


Hi Russell

I am trying to reconstruct a position file do to the need to change server providers. I cannot retrieve the original position file from the previous person who was running the server. Several pilots were flying a 50+ leg hop and I'd like to add all of the legs they have previously flown. I did have one pilot fly a hop so I could try to figure out the format. I do understand the first several columns of the position file, but I'm not sure of the data in the last 2 or why the leg number is displayed twice. Any help would be most appreciated.


Pilot_Number/Name Leg_Number Leg_Number 10-Digit_Number 1-Digit_Number

99 Bill                            23                23           1407196094                 0

Russell Gilbert

Hi Gene. Sure, here's the format:


The time values are in Unix time format, or in other words, number of seconds since Jan. 1, 1970.
On Unix/Linux systems, type date +%s to get the current time in Unix time (ex. output: 1407246189).

Or to convert a specific date/time to Unix time, type: date -d '12/31/2013 23:59:59' +%s (outputs: 1388555999)

Or to convert from Unix time back to a local time/date string, type: date -d '@1388555999' (outputs: Tue Dec 31 23:59:59 CST 2013).

Example: Bill is currently on hop 10, which is also the highest hop he's started. He completed hop 9 at 12/31/2013 23:59:59. He has never completed the full hop list.


Example: Bill finished hop 11 at 12/31/2013 23:59:59. He then used a chat command to manually position himself back at hop 10, where he is currently. He has never completed the full hop list.


Example: Bill is currently on hop 10 of a list with 20 hops total. He completed hop 9 at 12/31/2013 23:59:59. He finished the entire hop list once before at 11/30/2013 20:00:00.


Let me know if you need more info.



Hi Russell

Thanks for the quick response and file format data!

I wasn't even thinking about Unix time while looking at the 10 digit number. And I've had to edit Unix time many times in our databases. The converter I use is at:
Just in case anyone else could use it.

Thanks again!

Russell Gilbert

Thanks Gene.  I figured there must be a tool out there somewhere but had never come across one.