carlst99 / trialmanager Goto Github PK

Need to investigate circular dependency issues when importing data

• Convert LINZ data to database (see suggested format)
• Add DB as app resource
• Create DB model
• Create AddressLocationService
• Create tests

Suggested format:
Table - pKey, town_city, link(suburb_locality/s), location
Table - pKey, suburb_locality, location

Suggested method:

1. Read in all town_city from DB
2. Iterate through all town_city elements and see if address string contains them
3. If so, create new list with suburb_localities of that town_city. Else read in ALL suburb_localities
4. Compare string to list created in step 3.
5. If suburb_locality found, take that location. If only town_city found, take that location. If nothing found, take trial location.

The initial brief need to be fleshed out

• Discuss Issue
• Complete initial consultation writeup
• Identify social and physical factors
• Propose a solution
• Design specifications

Will need to factor in all specifications:

• Honour competitors preferred day request
• Competitors with travelling companions placed close together in draw, with at least one run between them if possible
• Competitors with further to travel placed in later day of trial
• Competitors with multiple runs on the same day should be well spread out
• Locals should be run on the first day, unless they have three or more dogs

We should have some optional mappings, so that the user is locked in as little as possible. Optionals can include:

• Preferred Day
• Address
• Status
• Dog two upwards

The viewmodel could then predictively decide which modules to use from #43.

This will include video tutorials, and will cover:

• Google Form creation, best practices and downloading
• Event separation, for trials where events are combined into one form
• TrialManager usage

Version 1.0.0(1.0.0)

Stacktrace

TrialManager.Bootstrapper.ConfigureIoC(IStyletIoCBuilder builder) in C:\Users\carls\Source\Repos\TrialManager\TrialManager\Bootstrapper.cs:line 44;TrialManager

Stylet.Bootstrapper`1.ConfigureBootstrapper() in /_/Stylet/Bootstrapper.cs:line 39;Stylet

Stylet.BootstrapperBase.Start(String[] args) in /_/Stylet/BootstrapperBase.cs:line 77;Stylet

Stylet.BootstrapperBase.b__9_0(Object o, StartupEventArgs e) in /_/Stylet/BootstrapperBase.cs:line 48;Stylet

MS.Internal.CulturePreservingExecutionContext.CallbackWrapper(Object obj);MS.Internal

MS.Internal.CulturePreservingExecutionContext.Run(CulturePreservingExecutionContext executionContext, ContextCallback callback, Object state);MS.Internal

MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled);MS.Win32

MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o);MS.Win32

MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam);MS.Win32

MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg);MS.Win32

TrialManager.App.Main();TrialManager

Reason

System.IO.FileNotFoundException

Link to App Center

• https://appcenter.ms/users/carlst99/apps/TrialManager/crashes/errors/266906765u

The Trialist model now needs to include address (string) and travel distance (double), to enable to main database to work with the location services being tracked in #11, #17

Version 1.0.0(1.0.0)

Stacktrace

MaterialDesignThemes.Wpf.DialogHost.Show(Object content, Object dialogIdentifier, DialogOpenedEventHandler openedEventHandler, DialogClosingEventHandler closingEventHandler);MaterialDesignThemes.Wpf

MaterialDesignThemes.Wpf.DialogHost.Show(Object content, Object dialogIdentifier);MaterialDesignThemes.Wpf

TrialManager.ViewModels.ShellViewModel.OnViewLoaded() in C:\Users\carls\Source\Repos\TrialManager\TrialManager\ViewModels\ShellViewModel.cs:line 52;TrialManager.ViewModels

MS.Internal.CulturePreservingExecutionContext.CallbackWrapper(Object obj);MS.Internal

MS.Internal.CulturePreservingExecutionContext.Run(CulturePreservingExecutionContext executionContext, ContextCallback callback, Object state);MS.Internal

MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled);MS.Win32

MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o);MS.Win32

MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam);MS.Win32

MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg);MS.Win32

TrialManager.App.Main();TrialManager

Reason

System.InvalidOperationException

Link to App Center

• https://appcenter.ms/users/carlst99/apps/TrialManager/crashes/errors/3256409548u

• Import from csv
• Option to merge/overwrite
• Prevent editing data while an import is in progress
• Convert address to coordinate point. See #17
• Shift to custom service

This is a long shot, but potentially we could use machine learning on user-modifed previous draws to improve the output, as there are so many variations to consider depending on which club, which trial and who's involved.

There is no need to lock the user in to certain Status values; and removing this need will also decrease the error potential when importing data

The draw setup bar is starting to become cluttered, and with the addition of new features planned such as #43, I propose that all the options be shifted to a dialog. This will also mean that better descriptions can be given for each option

We should be checking for possible duplicates, in the event that someone has submitted the form more than one time

We should be able to make map CSV properties based on a best-guess basis

• Input TextBox below other controls
• Autocomplete using address location service (#17)
• Add location editor to DataImportPage, with resolver

Suggest the use of Squirrel. Could also use Onova

May have to manually download using Octokit.NET as repo is private

• Discuss emailing clients after they have been placed in the draw

The initial conceptual design needs to be completed, and stakeholder feedback obtained.

• Research Branding - develop logo + colour scheme
• Mock initial UI concepts for desktop app
  • Import data page
  • Manage/View data page (merged with Import page)
  • Create draw page
• Get stakeholder feedback on concepts

Need to find out:

• Discuss proposed specifications
• Exactly what data needs to be stored by the system
• How I can access the website
• Ask if and how payments are managed

The user should be able to export the draw to other formats

• PDF
• PNG
• Text?

This would see a customisable number of near-distance trialists be placed in the draw before far-distance trialists.

Sqlite has many missing migration functionalities compared to other database providers. Given that the solution only runs on windows, consider shifting to a SqlServer database provider

There are cases where one trial contains multiple events (e.g. Shorthead, Longhead, Zigzag Hunt and/or Straight Hunt). To simplify form creation, the user should only have to enter it once and select which events they wish each of their dogs compete in. TrialManager should then be able to determine this and create multiple draws.

We are recommending in the documentation that users condense multiple events into one form, however we require them to do the heavy lifting of separating out the data into multiple CSV files.

TrialManager should have the ability to do this for them. I envisage a button placed in the Select Data File section of the DataImportView.

Note that this would supplement #46

It would be prudent to give the user the ability to customise which parts of the draw algorithm are used, such that they could turn off e.g. the location sorting 'module'.
This will increase flexibility and will help solve the seemingly endless number of variations in the way trials are run

Module ideas:

• Location Module
• Reverse Location Module
• Preferred Day Module
• Dog Count Module
• Reverse Dog Count Module

• Get stakeholder feedback on proposed solution and specifications
• Decide on work environment and applications to use
• Write up final brief
• Get stakeholder feedback on final brief

• Ask about privacy policy. Mention how this may lock down future use of user data (without prior consent). Ask if required/wanted

• Add about section to app
• Include license info in distribution

The core project already has the capability to push dialog requests. Now need to implement the response to said requests in platform projects

The draw creation algorithm increments days for each draw entry, but does not reflect it in the final run position. This needs to be changed so that the DrawCreationOptions.MaxDogsPerDay property is properly respected.

Mitigates accidental deletion