Change Log#

3.10.4#

2024-03-17

Fixed#

  • #232 - Fixed SMR report

Added#

  • Added Troubleshooting tab to search for events/failures by multiple keywords

  • #234 - Changed TSI Failure title

3.10.3#

2024-02-11

Fixed#

  • #229 - Fixed event folder pictures not updating

  • #230 - Availability import failure

Added#

  • #228 - Add event folder path to Open WO email

  • #223 - Add KA Failure Code to FC Summary

3.10.2#

2023-11-13

FIxed#

  • #220 - Fixed can’t email availability table

  • #225 - Fixed terminal display

Added#

  • #226 - Added Rows > Clear Cell Value - can use eg to set date fields to None

  • #221 - Added Notes to Component CO and Prev CO Date to TSI tabs

  • #198 - Added Refresh All Open button to refresh each table’s default set of rows

  • #224 - Added Unit and Serial fields to Unit Info refresh menu

3.10.1#

2023-08-09

Fixed#

  • #205 - Can’t send WO emails

3.10.0#

2023-08-09

Fixed#

  • #197 - Can’t update event folder date

Added#

  • Add customer field to Event Log and Work Orders tabs

3.9.4#

2023-06-13

Fixed#

  • #195 - Can’t email passover or tables

3.9.3#

2023-06-12

Added#

  • #170 - Add minesite dropdown to create plm dialog

  • #174 - Add dialog prompt to check parts before closing work order

  • #175 - Changed Date Added to Date Failure

  • #176 - Add Serial column to FC Details tab

  • #179 - Add event pictures subfolders 4 Corners and SMR, Failure, Repairs

  • #183 - Add list of units in Email New FC email table

  • #185 - Filter on multiple columns simultaneously

  • #193 - Added terminal output to give users more info on operations happening in background

Fixed#

  • #182 - Fixed FC email hours precision to 1 decimal place

  • #186 - PLM report function fails to find correct event folder from Event Log tab

3.9.2#

2023-03-20

Fixed#

  • #165 - Can’t create Failure Report with PLM

3.9.1#

2023-03-19

Fixed#

  • #102 - Fixed screen size restore, screen should now remember previous position

  • #163 - Bulk import operations blocked

  • #164 - Users with old SQL Server driver can’t update values in certain columns

3.9.0#

2023-03-17

Fixed#

  • #154 - Made Work Order field strip leading/trailing whitespace on input

  • #148 - Fixed availability assignments with engine column

  • #155 - Refresh table Model and ModelBase filters shown as M

  • #162 - Can’t create PLM report in certain cases

Added#

  • #151 - Add TSI Notes to TSI table

  • #150 - Add Work Order to FC Details table

  • #152 - Add ability to copy/paste filepaths in file picker dialog

  • #156 - Track user that closes event. User who closes event in Event Log tab (Not Work Orders) will be saved to ClosedBy field

  • #157 - Add To Be Scheduled status to Event Log table

3.8.6#

2023-02-02

Fixed#

  • #146 - Availability shift date start time changed to 5:30

Added#

  • #132 - Add sum SMR hours to SMR Report email

  • #133 - Availability changes for cummins

3.8.5#

2023-01-04

Fixed#

  • #143 - Avail report fails to run

3.8.4#

2023-01-03

Fixed#

  • #140 - Make dialogs scrollable

Added#

  • #133 - Availability Report Improvements

3.8.3#

2022-11-28

Fixed#

  • #139 - Create WO email fails

3.8.2#

2022-11-23

Added#

  • #134

    • Reminder dialog to prompt adding parts to Order Parts column for WO Request emails

    • Added (PARTS) in email subject if parts reqd

    • Prompt can be disabled in Preferences > Events

Fixed#

  • #135 - Fixed column size/order/state after restart

  • #136 - Manual avail data import fails

  • #137 - FC Import fails

  • #138 - PLM Report fails due to Kaleido error (maybe fixed)

3.8.1#

2022-11-7

Added#

  • Manual avail/smr data import function

3.8.0#

2022-09-26

Fixed#

  • #126 - Oil Samples table headers not showing

  • #127 - Can’t create failure report if Failure Cause is blank

  • #128 - Internet check fails on Cummins VPN

  • #129 - MineSite is not remembered with AddEvent dialog when minesite set to CustomSites

  • #130 - If a row is deleted in EventLog/WorkOrders etc, error will be triggered next time row tries to be added in that table

Added#

  • Bumped underlying Python version from 3.9 to 3.10

3.7.14#

2022-09-07

Fixed#

  • #123 - Can’t add new units, minesite not added correctly

  • Fill TSI Webpage now fills component/phenomenon fields correctly

  • Search dialog doesn’t block row highlighting if you exit by using escape

Added#

  • Added warning if user tries to add unit which already exists

3.7.13#

2022-08-12

Fixed#

  • #121 - Unit Info table won’t refresh

3.7.12#

2022-08-08

Fixed#

  • #114 - Passover status wrong colors (FH-Field)

Added#

  • Rows in the EventLog table can be “deleted”, but will retain a backup in the database for emergency info recovery (ask Jayme to recover “deleted” rows)

3.7.11#

2022-06-15

Fixed#

  • No dropdown menus showing

3.7.10#

2022-05-30

Fixed#

  • #106 - Create availability report fails

  • #107 - AddEvent dialog: reload units list when minesite dropdown changes

Added#

  • Structure to add components as units for Reman depts

3.7.9#

2022-04-27

Fixed#

  • #103 - Email WO Request Fails

  • #104 - TSI login fails

3.7.8#

2022-04-20

Added#

  • #95 - Added CustomMinesites setting to allow users to view records from multiple minesites at once.

    1. Define your custom minesites in Preferences > General > Custom Minesites

    2. Set current minesite to CustomSites in the Change Minesite dialog

    • NOTE: this adds an extra column MineSite to several tables which will cause their column sizes/layouts to reset one time (sorry!).

  • #58 - Allow user to define visible tabs

Fixed#

  • #102 - File Menus didn’t render in correct location

  • #98 - Email List refresh dialog fails

  • #94 - Oil Samples Table doesn’t refresh

  • #93 - Some FCs didn’t import

  • #92 - Users table doesn’t refresh

  • #91 - FC Summary doesn’t refresh with single FC

3.7.7#

2022-03-26

Note#

Added#

  • Support for ODBC Driver 18

  • #85 - Notes column addded to Unit Info table

  • Added Title (FC Number + FC Subject) to Factory Campaign table refresh menus

  • #80 - PLM section in Failure Report dialog now has date selector

  • #79 - Added Part Name, Part Number, Failure Cause fields to refresh menus in several tables

Fixed#

  • #84 - Chrome SAP login for new 770 (previously 760)

  • #81 - FC Summary table shows 1 decimal place for labour hours

  • #89 - TSI homepage changed

  • #90 - Autofill TSI - Attachments not working

3.7.6#

2022-01-27

NOTE#

Added#

  • New EquipClass types (skid_steer, packer, crusher)

  • Email Table Selection - Create email with selected table cells, including color formatting

  • #76 - PLM report table showing >120% overloads

  • PLM Payload targets can be set per unit/model/minesite (PLM Target added to Unit Info table)

  • #78 - Add Time Called to Add New Event dialog

Fixed#

  • #73 - Open TSI fails from WO tab

  • #75 - PLM reports showing incorrect overloads

  • Oil samples query speed improved ~4x

  • Import FCs failed due to extra blank header row in KA FC export data

3.7.5#

2021-12-09

Added#

  • Date Submitted field to TSI tab

    • Date automatically set when TSI status changed to Closed

  • #54 Add TSIs submitted to Fleet Monthly Report

  • #66 Get WO number from Outlook

    • Added to event right-click menu in Work Orders tab.

  • #69 Component benchmarks

    • Bench SMR can now be set at the EquipClass (Truck_Electric), ModelBase (980E), or Model (980E-4AT) levels

    • NOTE - the Component SMR table will not work until this update is installed

3.7.4#

2021-12-03

NOTE#

  • Cummins Only

    • This update resolves an issue with updating/restarting.

    • For this update only, you will need to delete your app folder and redownload manually

Added#

  • Move column left/right

    • Allows user to order columns as desired

  • #61 TSI Status field to Event Log tab

  • #53 Work Orders tab now returns all rows which are NOT “Closed” for Refresh All Open (Previously only showed “Open”)

  • Added Pre-Open status to Work Orders tab

  • Menu Item Help > Show Changelog to view all recent updates

  • Improved error dialog, with link to submit issue on github

Fixed#

  • #50 Work Orders tab now shows correct warranty type list for Cummins users

  • Reduced package file size from ~160mb > ~100mb

    • Shouldn’t matter for patch updates, but makes fresh install/unzip much faster

  • #59 Auto updates on Cummins computers

3.7.3#

2021-10-30

Fixed#

  • #46 - Open SAP fails

  • #47 - Add New Event Fails

3.7.2#

2021-10-30

Fixed#

  • #45 - Import Downloads function not working

  • #24 - Event Log screen doesn’t show on startup

    • Caused by bug with restoring window to screen that doesn’t exist anymore (eg a second display)

  • #44 - MineSites list in Add New Event dialog now loads dynamically from all unique Minesites in Unit Info table

  • #42 - Add New Event in TSI tab now checks create_tsi by default

  • #38 - AC Inspections table showed black cells in scheduled column

Added#

  • #40 - Global font size can now be set in Preferences > Appearance > Font Size

    • Useful if app font size is too large on smaller laptop screens

  • #36 - Column widths

    • Column widths and column visibility (hidden/not hidden) adjusted by user will now be saved

    • Column state saved when table refreshed, current tab changed, app closed

    • Column state can be reset to defaults with Table > Reset Column Widths

  • Highlight alternating Model column in Unit Info table

  • #41 - Component changeout records can now specify value in Component CO.Install SMR colum

    • Use this to indicate that the new component installed at a CO had existing hours

    • Eg “new” engine installed with 10,000 hrs on it already

    • Allows for correct component smr displayed in Component SMR tab

  • Show ToolTips on table header hover

    • Some table columns’ exact meaning may be unclear, try hovering to see a helpful message

    • Only added for Component CO and Component SMR so far

3.7.1#

2021-10-06

Added#

  • Update prompt now shows detailed changelog

    • Patch updates (eg x.x.1) can now be dismissed if updates are minor and don’t affect user

  • Insert Current Date Ctrl+Shift+I now adds date + ” - “

  • SMR Report added to File > Reports

  • Fleet Report and SMR Report columns to Email Lists table

Fixed#

  • #37 Can’t delete event rows

  • #39 FC import fails

3.7.0#

2021-09-29

Added#

  • Links to Open Documentation and Submit Issue in the Help menu

  • Global Preferences menu

    • Setting: #10 read_only (to prevent any updates from Event Log to the database)

    • Setting: #18 to close WO and Event at same time

  • New shortcut Insert Current Date Ctrl+Shift+I to insert current date in current table cell

  • #33 Dates highlighted red in long text fields (EventLog.Description, WorkOrders.Comments, etc)

  • Parts Tab

    • Search parts by part name, model

    • Add new parts to database

  • TSIs

    • Ability to submit multiple TSI reports in KA TSI portal at once

    • Email multiple TSI failure reports at once (will auto email all selected rows)

    • Komatsu component group/cause fields

    • #30 Create Failure Report now auto selects all images which are numbers eg 2.jpg, 13.jpg

    • Setting: Open DLS folder at same time as event folder

    • Setting: Auto save TSI pdf to event folder after Fill TSI Webpage

  • #31 Enforced no spaces allowed on Part Number fields

Fixed#

  • Removed PLM import warning if no rows to import

  • Numeric picture sort order in Word Failure Report

  • #23 FRDLS handles DATA1 folder import

  • #19 Component SMR Model filter freezing query

3.6.1#

2021-06-04

Fixed#

  • #9 PLM import function taking too long to find haulcycle files

  • #8 Downloads import recognize AHS Flight Recorder (FR) files

  • #13 Word FailureReport now updates PLM records before creating

  • #19 ComponentSMR model base query works

  • Made PLM import faster

Added#

  • #12 “Order Parts” field to WorkOrders

  • #15 Bench SMR and Life Achieved to ComponentCO

3.6.0#

Added#

  • PLM summary in word failure report

  • Auto import download folders to P-drive

    • Zip GE downloads first for faster uploading

    • Upload PLM files to database

    • Upload fault files to database

    • Check for unit/date in folder name, if not provided, try to get from dls files

  • Oil Samples table

    • View oil samples for any unit/component/minesite

    • Oil samples auto imported daily

  • Alpha release channel

    • Activate with help > Enable/Disable Dev Channel

    • Get alpha updates for testing quick fixes

3.5.0#

Added#

  • Unit SMR full history dialog (FH and OSB units only)

    • Useful to check SMR on specific dates

  • Word (docx) failure reports with oil sample history

  • Enforcement of component CO reason in AddNewEvent dialog

  • “Scheduled” status to FCSummary/FCDetails

  • AC Motor inspection schedule table (FH only, but could be set up for OSB)

    • View current status of 3k hr inspections

3.4.0#

Added#

  • Component CO reason to AddEvent dialog

  • FC “Scheduled” status

  • “View FC in Details View” (jump to FC in FC details from FC Summary)

  • PLM import for BaseMine units (import ALL not yet complete)

Fixed#

  • TSI login for new KA system

  • Chrome automation hide console window