Galf Regional Updates. Proposal # 2

Reports for the web site.

There 3 reports I come up with so far for a single company.

Report 1 will generate a random numbers and print them in Report/PDF Format by choice of the Company representatives.



Similar to this.

2. Report will summarize the results of drug testing in this way:



3. Standard All Names and Testing Results, like that, but with Title and accreditation of Gulf Regional.

Gulf Regional Update Proposal # 1

Introduction Of Supervisor Capabilities and logins.



Currently authorization works like this. One company may have more then one contact person.



Request is to design a different structure - one contact (Supervisor) would be able to oversees more then one company.

This leads us to modification of the web site authorization algorithm as follows:


This also leads us to developing additional 2 tables - Supervisors and List of companies the would be able to have access to.


Administrative application also will have to be updated with new buttons and forms to support this authorization.



The proposal #2 regarding on-line reports will follow.

Sending mail instructions and help

During first few day of working with send mail button I have found a few issues which were preventing from properly function of this feature.

1. Too many emails.

Currently there 350 email accounts listed in a data base. If you will try to send them at once you will receive error in a line 22. Which means you have too many emails to be in your "bcc:" text box of your e-mail program. Currently most of mailing programs permit limited amount of addresses to be send at once. Most of them limit this to about 100 emails at the same time.

There 3 ways you can make it work:

a) Manually select under a 100 emails at once to send e-mails
b) Create lists with less amount of e-mails in it.
c) Use text box on a bottom of the page to copy and paste email account in smaller portions. And send more then one email.



2. Multiple emails

If company has more then one e-mail, by clicking on a company check box you will send e-mails to all people in a company. Be aware, that if you put 2 or more times the same email address for each contact, the same address will be hit more then one time with the e-mail.

So, the good practice is to put only one the same e-mail for one company. Otherwise your clients may became very annoying with repeating e-mails.

3. No emails.

If you have no email address for the person - do not put anything in a box. Because when you will try to send e-mail to the address "no address" it will make an error.


4. Erroneous emails.

There are some emails I can see have mistakes in it.

For example such e-mail do not exists. Symbol "&" will generate an error in your mail program.

Be mindful of this. You may cost troubles to anyone who will use this list.

Gulf regional Contacts Version 1.09

Order On Company List has been fixed.

Gulf regional Tests Version 1.04

Improvements in Reporting System:

1,2 - Grouping report made more clear.
3 - Total Summary Report, grouped by Company, Reason and result.
4. (New!) Export Company Report to File
5. Summary Report For Company
6. (New!) Export Summary Company Report To File

If you click on button to Export to File Report you should get a choice, which format you want to select for export. This can be handy for emailing those report to the clients.

Gulf regional Contacts Version 1.07

1. Created Refresh Button & Tab. From now and on if you need to refresh any controller you need to click on this button. It was done, so re-query will not happened every time you click on any tab as before. Intention is to speed up the application.


2. Help will show the blog page. It was done to keep connection with the client and be able to communicate any question.


3. A separate Refresh button was installed for refreshing a list of mailing lists. This may not use very often, but sometimes it helps.

Gulf Regional Contacts and Help Info

Help and info for clients of Gulf Regional.
This post is dedicated for users of 2 applications, developed for company "Gulf Regional Occupational Medical Center"


If you are client of this program and you have any concerns or questions, please post them as comments below.

Updates.
Contacts

1.07
1.08
1.09

Tests
1.04



Help on sending emails

Update Proposal # 1
Update Proposal # 2