At this time, the nevadaTicketTypes array in data/config-ontario.js only has ticket types found when importing our historical licence data. For the greatest benefit to others, the list should be complete.

The full list is available on the AGCO website.

Submitted by n.n

... can you please look at the add remarks option. I added a new group and it won’t let me add remarks. I can enter the information but when I click on update it won’t accept it. I have to click cancel every time.

What feature are you suggesting?

I was reviewing [a raffle licence] and noticed that the system is looking for 8 reports on this licence. It should only be looking for 1 report. The only time that we have multiple reports for a licence is for Bingos. Bingos will have a report for each event they hold.

Any raffle with multiple draw dates, only has 1 report for the licence. Can you please up the system to reflect this.

Is your feature request related to a problem?

Unreported events remain in an outstanding work list.

Are there any workarounds? Are there any alternative solutions that would work?

Set the report date on the events that don't need to be reported on. By having a report date, the events are removed from the pending list.

Are there any other helpful details?

Adding a checkbox (and potentially a database field) to the event to indicate "Reported on another event" may be a possible solution, but likely won't be any faster than the workaround of setting the report date.

Submitted by n.n

Can we have the option of searching by Licence Number and Group Name.

Submitted by n.n

I was working on the system and noted that when looking at an event to update, which has multiple events, I can’t see which event file I am updating.

Example Nevada licences can have 3 event records. One per year. When going into our current system, I choose the event record I want to updated, then mark it as received, interim, final or incomplete. Then I choose the record and enter the information. This process is the same regardless of what type of event/licence records I am updating.

Not sure where this option is in the new system. If it doesn’t have this option, can you please add it as I need to know which records I am updating.

What feature are you suggesting?

I was wondering if it is at all possible when updating banking information, board, information and group information, have all of the options appear on one screen as opposed to having to click on each individual category to enter the information. Example: Board information: instead of having to click on the board list, projected budget, financial statement, bonafide members, school board budget and team roster separately, could they all appear in once box and then I click on the appropriate response for each category? Banking information: for each month have the bank statement, cheques and receipts/invoices options appear in once box, so I can update everything at once instead of having to click on each category? - n.n

Is your feature request related to a problem?

It can be difficult ensuring that all records have been properly updated.

Are there any workarounds? Are there any alternative solutions that would work?

Remember what you've done.

What feature are you suggesting?

I [...] can’t seem to find where I can add use of proceeds for an organization. On the current system, I have the option to enter in different approved use of proceeds, this way when an organization sends in a lottery application we know if the proposed expenses have already been approved. [...] I know that you can pick past use of proceeds, when issuing a licence, however this would be something I would only be able to add into the system, so anyone entering a licence or receiving a call from an organization can look up use of proceeds to determine if their request could be supported with lottery proceeds, or when issuing a licence and check to see if their request for use of proceeds has already been approved. - n.n

Is your feature request related to a problem?

No,

Are there any workarounds? Are there any alternative solutions that would work?

Use the past use of proceeds values.

Submitted by n.n

The licence details (referred to as “event notes” on current system) don’t’ print on the licence. This is the section where we put notes about the licence.

Example: name of licence (50/50 draw, meat draws, monthly draw), list additional draw dated (if 3 draws this is where we list the dates and time if different for each draw) and/or total number of tickets/draw

Need something basic to show the capabilities of printing a licence if you're not an Ontario municipality.

CodeFactor found multiple issues:

Missing radix parameter

helpers\licencesDB.ts:2581
helpers\licencesDB.ts:2527
helpers\licencesDB.ts:2256
helpers\licencesDB.ts:2242
helpers\licencesDB.ts:2141
helpers\licencesDB.ts:1925
helpers\licencesDB.ts:1876
helpers\licencesDB.ts:1874

To track licence changes since the licence was issued. Things like adding additional Nevada tickets.

Submitted by n.n

When issuing a new licence could this populate the event date?

Example: If there is only 1 event date then the start and end date would be the same and this date could be used to create the event date;

If there was a different start and end date then the end date would be used to create the event date and still have the option to add another event date if required

Recreate the Puppeteer tests in Cypress.

I just issued a raffle licence and the discounted ticket price doesn’t print on the licence. Can you please amend to show the discounted ticket prices on the licence. - n.n

Submitted by n.n
When entering a report when I tab to enter the gross receipts, the cursor leave the “0” there and causes a problem when entering numbers if I don’t delete it. When I tab from here to the Administration figure the cursor doesn’t leave the “0” there. Could you change this?

Originally carried over from the previous lottery system. No longer necessary.

Submitted by n.n

The charitable donations field can be removed, as we never enter this amount on the screen it doesn’t need to be included in the report. We follow the donations through their monthly lottery trust account submissions. The only figures used to calculate the net proceeds are: the administrative expenses and the amount that the group paid for the prize. Charitable donations would not form any part of this calculation.

Is your feature request related to a problem?

No.

What feature are you suggesting?

If possible could all of the organization’s group information be in the same order?
Example: Board, Budget, Financial Statement, Bonafide Members, Team Roster and School Board Budget
This is the order that follows the letter I send them.
- n.n

Are there any workarounds? Are there any alternative solutions that would work?

No.

Are there any other helpful details?

At this time, reminders are sorted to have the most pressing ones first, and dismissed ones last. This may be desirable for someone using the reminders to remind them of the most pressing issues.

This request is in the spirit of the same user's request in issue #84 where historical reminders are not necessary.

Submitted by n.n., reformatted.

I was playing on the lottery system and tried updating an event.

• I don’t see where I can separate reports if there are different events on a licence.
• I tried updating a couple of reports and noted that the system doesn’t calculate the net proceeds.
• When I update a report, bottom of the screen shows “saving” and there is the circle that keeps going around (updating) but never does anything and I have to click the home button to get to a different screen.
• I’m also not sure how to look at reports that I changed.

What seems to be the problem?

When pressing "Dismiss" on a reminder that has no status, the status column displays the word "null".

What did you expect to happen?

Status column should remain the same, a blank status.

Submitted by n.n
I entered in a raffle report for Licence Number ABC1. I updated the information and the system never gave me confirmation that the changes I made were saved. When I went back into the report, the changes were there. I did get a confirmation when I entered a Nevada report for Licence Number ABC2.

Reassigns licence locations already.

What feature are you suggesting?

Maintaining SSL certificates for internal applications can be an afterthought. This would reduce the load on server administrators.

Is your feature request related to a problem?

Modern browsers complain when SSL certificates aren't used or are self signed. The alerts make the use lose confidence in the application.

Are there any workarounds? Are there any alternative solutions that would work?

Maintain an SSL certificate manually.

Submitted by n.n
When searching for a licence could you change the status to always read “All Status”?

Right now, defaulting to Active status.

What feature are you suggesting?

Just following up to see where you are on these changes? I know that you were working on only having one entry/ticket type and it doesn’t show multiple entries on the licensing screen anymore, but it still prints every change/entry on the licence.

Is your feature request related to a problem?

No.

Are there any workarounds? Are there any alternative solutions that would work?

Data is there, just not summarized when multiple entries exist for the same ticket type.

Submitted by n.n
I need to delete a licence for Organization ABC that never took place, draw date was in March ...
However the system will not give me the option to edit the licence so I can delete it.

What feature are you suggesting?

Some representatives have two contact numbers. Need a way to track those.

Is your feature request related to a problem?

Not really.

Are there any workarounds? Are there any alternative solutions that would work?

Create two contacts with the same name having different phone numbers.

CodeFactor found multiple issues:

Missing radix parameter

data\config-ontario-ssm.ts:96
data\config-ontario-ssm.ts:88
data\config-ontario-ssm.ts:80
data\config-ontario-ssm.ts:73

Submitted by n.n
In the Lottery Events-would it be possible to search by the licence number and not the month.

Been thinking about this one for a while. The "Events by Month" view is not very helpful. There is now "Events by Week" that may work better for that. Rework the event search to function more like other search pages.

Is your feature request related to a problem?

No.

What feature are you suggesting?

When I need to update new group information (board, budget, financial statements, school board budget, bona fides members and rosters) how do I get the system to clear out the old reminder information and leave it blank for me to complete? - n.n

User wants a way to easily:

• Increment the "Fiscal Year Start" by one year;
• Increment the "Fiscal Year End" by one year;
• Clear the "Dismissed Dates" and "Reminder Dates" for all reminders.

Are there any workarounds? Are there any alternative solutions that would work?

Yes. All of these items can be done on their own.

Are there any other helpful details?

Reminders were developed to be kept historically. User does not wish to keep historical reminders.

Submitted by n.n
I removed the transaction (licence fee) from Licence Number ABC as I wanted to delete the licence, however when I updated the licence and go to print the amended licence, it still shows the licence fee. Once I remove a licence fee from a licence the amount printed on the licence needs to show $0.00. Then I move on to issue a refund for the credit and cancel/delete the licence from the system.

What seems to be the problem?

A database error occurs generating the amendments by licence report.

How can I recreate this problem?

Click the "Export Amendments" button on a licence with amendments.

What did you expect to happen?

A report.

Do you have pictures of the problem?

No.

What kind of device and web browser are you using?

Firefox on Windows 10.

Is there anything else you can offer that might help?

Nope.

Is your feature request related to a problem?

No.

What feature are you suggesting?

When editing a reminder, and setting a status, like "Received" or "Not Applicable", automatically set the Dismissed Date at the same time if not already set.

Are there any workarounds? Are there any alternative solutions that would work?

Remember to set the dismissed date separately after setting the status.

LotteryEvents.costs_netProceeds is always calculated as follows:

costs_netProceeds = costs_receipts - costs_admin - costs_prizesAwarded

Storing it should be done by a generated column or a trigger.

Submitted by n.n

Can we have the option to view what is missing without having to go into edit.

Example: outstanding banking information, you can’t read the notes without going into edit mode

Is your feature request related to a problem?

Yes.

What feature are you suggesting?

Need the ability to report on events prior to them being complete. If, for example, a location hosting Nevada tickets closes, the reporting may be done prior to the end of the licence.

Are there any workarounds? Are there any alternative solutions that would work?

No workarounds to keep an accurate report date.

Perhaps something happened while updating dependencies.

What seems to be the problem?

I was trying to print out a remark on the new system and it doesn’t show in the report. Can you please advise?
I was looking at the organizationName file and the remark that I entered today, November 8. I want to print it, but can’t find the entire remark on the spreadsheet. I pulled the remarks from the formatted reports and then choose full remarks list option. My full remark does show when you look up the organization and choose remarks, so I’m not really sure why it didn’t carry over to the spreadsheet properly. - n.n

What feature are you suggesting?

When issuing a Nevada licence is it possible to have the system automatically change the end date to one year from the issue date? Just makes it easier to have the system do this than to try and remember to change the end date to one year from date of issuance. - n.n

Is your feature request related to a problem?

No.

Are there any workarounds? Are there any alternative solutions that would work?

Change the end date yourself.

Are there any other helpful details?

This request has been made before, and may be done already.

Probably the biggest barrier to entry on the project.

Submitted by n.n

When adding a new group I need to add their lottery trust account banking information prior to obtaining their banking records, can you please advise if this is available and if not could you add this option, as I wasn’t able to just add the banking information.

What feature are you suggesting?

A way to quickly unlock licences and events that have been locked.

Is your feature request related to a problem?

No.

Are there any workarounds? Are there any alternative solutions that would work?

Append /poke to the end of the URL.

Are there any other helpful details?

Only administrators can unlock locked records. For admin users, possibly add a button like the edit button, floating in the bottom-right corner that redirects to /poke.

What feature are you suggesting?

When I look at the bank spreadsheet for an organization, it is difficult to understand all of the different columns and information presented. Would it be possible to only have the group's name, banking year, bank account number, month, if a bank statement has been received or is outstanding and when it is expected, if cheques have been received or are outstanding and when it is expected and if receipts/invoices have been received or are outstanding and when it is expected? This information would be in the notes in the banking area on the licensing system? - n.n.

Is your feature request related to a problem?

No.

Are there any workarounds? Are there any alternative solutions that would work?

Use the existing reports, and assemble the information in Excel.

Submitted by n.n

I just noticed that I don’t seem to have an event for each bingo event issued. When issuing a bingo licence we have to enter the number of events and thereby the system creates an event record for each event date. When I enter in the number of events for bingos and the day of the week they will conduct the bingos the system generates an event and creates the event dates based on the information entered.

Example: Bingo licences are usually issued for 13 events. The maximum prize board for each event is $3500.00 If my start date is March 26 and bingos are conducted on Thursdays my end date would be June 18. The system would generate 13 event dates Mar 26, April 2,9,16,23,30, May 7,14,21,28 June 4,11 &18/2020. Then when I receive a report for each bingo date I would go to the licence and update the corresponding event date to show what revenue was generated at this particular event.

Raffles would only require one event date/licence issued.

Nevada would have a maximum of 3 event dates/licence. Licences are originally issued for a period of 1 year and then we can extend that licence for another 2 years, maximum of 3 years total. They would need to provide me with 2 interim reports and then a final report. However some organizations apply for 1 licence/year and then supply a report each year and apply for a new licence.

CodeFactor found multiple issues:

An interface declaring no members is equivalent to its supertype.

helpers\llmTypes.ts:319
helpers\llmTypes.ts:315

Submitted by n.n

What feature are you suggesting?

At the beginning of each organization’s fiscal year the following documents need to be submitted to our office:

• Mandate (if changed)
• Board of Director’s List
• Projected Budget
• Financial Statement
• Bona fide Members list (if applicable)
• Team Roster (if applicable)
• School Board Budget (if applicable)

Are there any other helpful details?

Under the current system, I update the information as received, incomplete with date to expect delivery, not applicable. I always have the option to just enter in a date to expect delivery for an item too. This helps us make sure that the group has submitted all required documents. Since each group’s fiscal year varies, we can’t track it annually. The current system lets me update the fiscal year, that is how I know if I haven’t received their information.

Submitted by n.n.
When I enter in the information for an event the total # of tickets printed and the price/ticket are not there, this should be auto-filled from the information entered on the licence. The only section I should be entering is the total # of tickets sold.

• Remove redundant "Tickets Printed" and "Cost per Ticket" fields from the "raffle" lottery licence type events.
• Display licence fields on the event views.

What feature are you suggesting?

The ability to alter ticket type records.

Is your feature request related to a problem?

I issued a Nevada licence and issued it under the wrong distributor. I went in to change it, however I don’t have an amend option. Could you please add this option to the Nevada licences. I don’t like deleting the tickets and then adding them back in with the correct information as it isn’t always that simple.

Are there any workarounds? Are there any alternative solutions that would work?

Delete the incorrect record. Create a correct record.

Is your feature request related to a problem?

No.

What feature are you suggesting?

When printing out a Nevada licence, do not display the times. Possibly remove the section altogether based on a parameter in the config file.

Are there any workarounds? Are there any alternative solutions that would work?

No.

Copy it from cityssm/parking-ticket-system.

The AGCO website offers a list of approved break open ticket manufacturers on their website.

https://www.agco.ca/list-approved-break-open-ticket-manufacturers

The list can be downloaded in a CSV format. It would be nice to be able to import this list.