Generate Excel for Maintenance report about ets HOT 7 OPEN

Negative TNI is caused by the TTNI being set incorrectly, either through user error / not understanding what that value is for or through the TTNI not being updated after an inspection has been completed.

For the specific aircraft in that report you can see that their TTNI is set to 99, 100, or 50, which could be users thinking that they were supposed to enter the TNI in the TTNI field as 100 & 50 are the inspection intervals for a lot of aircraft.

We could probably help prevent that error from happening in the future by improving the language used on those fields to make it more explicit what they are for and how to use them (although there's still the problem of TTNI not being updated after an inspection all of the time).

from ets.

The report really contains multiple reports. In CSV that could not be what we want.

I'm looking at ways to generate an Excel compatible file from the app and attach it next to the pdf in the email. Otherwise, I'll be looking at generating multiple csv files and attach them to the email.

Also, I'm looking into splitting the generation of the report from the sending of email. My goal would be for the report generator to be able to generate both pdf and csv.

Another option would be to just generate csv/excel. Any needs for the pdf? If not, we could just remove that.

Reports in the PDF:

• Maintenance report

• Columns: Véhicule, Issues, Date, Air Time, Ground Launches, Final TTSN, TNI, TTNI

• CTC National Report Stats

• Columns: ?, Gilders Flights, Gliders Hours, Tow Aircraft Flights, Tow Aircraft Hours

• CTC Squadron Attendante

• Columns: Date, Squadron, Number of cadets attended, Number of Cadet Glider Fans, Number of Glider Flights, Number of Cadet Fam Flights in Tow A/C, Comment

• CTC Personnel Stats

• Columns: ?, Days Worked, PIC Flights, PIC flights/day worked, Dual Flights, Dual Flights/day worked

• CTC Staff Cadet Attendance

• Columns: Name, San, Site, Days Worked

• CTC Staff Upgrades

• Columns: Upgrade, Name, Type of Participant, Site

• Glider Usage

• Columns: Gliders callsign, Glider name, Glider Flights [Transit, Famil, Prof, Student, Upgrade], Glider Hours [Transit, Famil, Prof, Student, Upgrade], Time Flown, Current TTSN

• Towplane Usage

• Columns: Towplane callsign, Towplane name, Scout Hours [Transit, Towing, TPC, Maintenance, Prof, Upgrade, Fam], Scout Flights Fam, Time Flown, Current TTSN

• Winch Usage

• Columns: ?, Currnt TTSN, Hours, Flights

from ets.

About TTNI and TNI having wrong value. Any idea to clarify the expected values? Maybe we should create a new issue for that.

from ets.

Found a package on github to create Excel file on iOS/macOS called ExportExcel.
I updated it to Swift 5. Seems to need to wait for Xcode package manager to see it (or for the original author to merge into the master branch).
With that package, it will be possible to create an Excel spreadsheet with each report into its own worksheet.

from ets.

A bit awkward... I had to star my own report for ExcelExport to show up in Swift Packages.

from ets.

About TTNI and TNI having wrong value. Any idea to clarify the expected values? Maybe we should create a new issue for that.

@huguesf done: #43. I don't have any specific ideas because I don't have the application open in front of me, but I'll see if I can get a hold of the old iPad we used to use for the CFS so I can play around with the app on that and come up with some ideas.

from ets.

@kirvanp, in the DEBERT example report, the section gliding centre NATIONAL REPORT STATS has a total line which does not balance with the numbers shown above the total line:

In the next example - that I made up from automated tests, there are 7 flights, but the total only shows 6. To get there, I created a flight for the 7 towplane sequences. It also shows only 2 "visible" cells under Tow Aircraft Flights, and 6 "visible" cells under "Hours".

I try removing the towplane sequence named "Tow" (not the "tow course" sequence), then another cell that become visible next to TOW, but it shows 0 (zero) - normal since there is no more flight for that sequence. This is the result:

Notice that I corrected the unbalanced html tags, but does not seem to be related to what I describe above.

The maintenance report section when 7 flights (one per possible sequence) is created:

So, I wonder what is "normal" behavior, and what's not? Is that section is even used? People from DEBERT do not seem to find any issue with that. What is you opinion?

from ets.