search

albar965 / littlenavmap

Little Navmap is a free flight planner, navigation tool, moving map, airport search and airport information system for Flight Simulator X, Microsoft Flight Simulator 2020, Prepar3D and X-Plane.
https://albar965.github.io/littlenavmap.html
GNU General Public License v3.0
1.3k stars 164 forks source link

Improve Logbook #346

Closed albar965 closed 5 years ago

albar965 commented 5 years ago

Move logbook entries to own database, search tab and info display. Merge entries for one flight

Gulliver54 commented 5 years ago

I'am very much in favor for this change. Using logbook adds rapidly large amounts of data clouding other data.

albar965 commented 5 years ago

Agree. This is going on my nerves too. I added this to 2.4.

The 2.4 list of changes needs cleanup. A lot of issues in 2.4 will be moved to later versions. Alex

Gulliver54 commented 5 years ago

Great stuff, can`t wait to see. :)

albar965 commented 5 years ago

Yep. I like it too. ;-) Now I have to finish at least one flight without writing down a bunch of bugs.:( Alex

Gulliver54 commented 5 years ago

Can you make a screenshot showing the available database colums during the checkout flight?

albar965 commented 5 years ago

Give me a few days to fix bugs and find time for a flight. :) Alex

gaabne commented 5 years ago

Hello Alex, Great new ! Would you mind giving the new database format of the logbook. Just to start thinking what can be collected from... Gérard

Edit : Sorry, I am stupid - LNM is opensource so got it... :)

Gérard

albar965 commented 5 years ago

Hi Gérard, shortcut to the self explaining SQL: https://github.com/albar965/atools/blob/master/resources/sql/fs/logbook/create_logbook_schema.sql Will post screenshots later. Alex

albar965 commented 5 years ago

Hi Gérard, shortcut to the self explaining SQL: https://github.com/albar965/atools/blob/master/resources/sql/fs/logbook/create_logbook_schema.sql Will post screenshots later.

CSV Export sample:

aircraft_name,aircraft_type,aircraft_registration,flightplan_number,flightplan_cruise_altitude,flightplan_file,performance_file,block_fuel,trip_fuel,used_fuel,is_jetfuel,grossweight,distance,distance_flown,departure_ident,departure_name,departure_runway,departure_lonx,departure_laty,departure_alt,departure_time,departure_time_sim,destination_ident,destination_name,destination_runway,destination_lonx,destination_laty,destination_alt,destination_time,destination_time_sim,simulator,description
Beech,BE58,N45XS,,3000,/home/alex/Nextcloud/Flight Simulator/Flightplans/IFR Reichelsheim (EDFB) to Aschaffenburg (EDFC).pln,,0,0,40.932739,0,4607.231934,25.785984,31.994833,EDFB,Reichelsheim,,8.878667,50.338665,402,2019-07-11T23:26:53.435,2019-07-11T06:04:16.000Z,EDFC,Aschaffenburg,08,9.062500,49.938835,410,2019-07-11T23:39:26.908,2019-07-11T06:17:01.000Z,X-Plane 11,

Alex

albar965 commented 5 years ago

Logbook entry information in separate tab and logbook search. All separate now and not mixed with the user waypoints. Logbook entry is shown with blueish text background and line.

Track and actual flight plan are not saved yet. I keep this for the next version. Otherwise 2.4 would never be finished.

The screenshot contains some extra information I use for debugging (database ids, Pos, etc.).

grafik

Alex

albar965 commented 5 years ago

Edit dialog has three tabs. The third tab contains only the description.

grafik grafik

Gulliver54 commented 5 years ago

most useful. Thanks for the overview.

albar965 commented 5 years ago

You're welcome. :) Let me know if something is missing. Some parameters like night (difficult) and IFR flying time (no idea how to find out) cannot be added. Alex