The system will warn the user if it finds that appointments have not been setup for an application type.
For type: Automatic, it assumes that it is the original 0 and 20000 records configures when the site is setup at the beginning of the season.
   To get rid of the warnings, add a 3rd appointment record for that application type.
   At the beginning of the season, there will be:
   1 record of type '0' that is the starting place for counting how many applications have appointments assigned.
   1 record with a number of 20000 that is used as a high number so that when the system searches for where to assign each new applicaiton, it will not 'fall off the end' of the available slots.

   So. . . if it sees only two records, it is going to display that warning.
   If you only have say 100 expected applicatons for a particular application type, and you want them to all show up at 9 AM on a particular distribution day
   Then you shoud add one more record for that app type and date. Add a single new appointment for 9:30 and number 101. Now that there are 3 records (0, 101, 20000) the warning will not happen.

For type: Select Time, checks to see if any have been configured, so to get rid of the warning, Click on the 'Setup (this type) and either Generate or add a record.

Also, remember that the appointments are assigned by a COUNT of the existing apps of this type, not the number assigned.
So for example, if the you have configured Angel type applications to start with number 1001 and expect 200 families.
and you want to have application appointments assigned in blocks of 20 starting at 9 AM:
Your expectation is that the first 20 applications (having assigned numbers 1001 thru 1020 will be assigned to 9 AM
The next 20 (1021 thru 1040) will be assigned to 9:30
and so forth.
Remember that they still are counted 1 thru 20 and fall on the zero record - 9 AM time slot and so forth.
When the 21st application is added, it falls at the 9:30 time slot, regardless of the number assigned.

Follow these configuration steps For type: Automatic:
1. Edit the '0' record to have the correct date and time (if needed)
2. Delete the 20000 record so that the system does not complain about assigning a new number below the highest number.
3. Add a range with a starting number of 21 and a per-block of 20 for the date. Start with 9:30 in this example.
4. Continue doing blocks of numbers, taking the highest number and adding the block number to it for the next starting number.
You would do this for taking a break at lunch (stopping at 11:30 so that you have 12:00 and 12:30 unavailable.
Then next block might start at 1:00 and go to 4:30. Seeing that the last assigned number is 101,
you would enter the starting number of 121 with blocks of 20.

You would then see something like this:
[28293] DEMO Corps, Angel, 12/17/2018, 09:00 AM, - - 0
[28295] DEMO Corps, Angel, 12/17/2018, 09:30 AM, - - 21
[28296] DEMO Corps, Angel, 12/17/2018, 10:00 AM, - - 41
[28297] DEMO Corps, Angel, 12/17/2018, 10:30 AM, - - 61
[28298] DEMO Corps, Angel, 12/17/2018, 11:00 AM, - - 81
[28299] DEMO Corps, Angel, 12/17/2018, 11:30 AM, - - 101
[28302] DEMO Corps, Angel, 12/17/2018, 01:00 PM, - - 121
[28303] DEMO Corps, Angel, 12/17/2018, 01:30 PM, - - 141
[28304] DEMO Corps, Angel, 12/17/2018, 02:00 PM, - - 161
[28305] DEMO Corps, Angel, 12/17/2018, 02:30 PM, - - 181
[28305] DEMO Corps, Angel, 12/17/2018, 03:00 PM, - - 201
[28305] DEMO Corps, Angel, 12/17/2018, 03:30 PM, - - 221
[28305] DEMO Corps, Angel, 12/17/2018, 04:00 PM, - - 241
[28305] DEMO Corps, Angel, 12/17/2018, 04:30 PM, - - 261
Then add one more single record of 20000 for 5:00 PM to act as a final number.

Back

Each Corps has a Corps Manager login, that is the administrator for that Corps.
When your site is setup, this login and password will be emailed to you.
Each Corps Officer can create and manage the logins for their Corps so they can add or make inactive logins to give or remove access to the AngelWeb system.
When logged in as this Manager, you can also configure your AngelWeb Corps to include several options.
Back

Zip codes from your service area will be loaded using the spreadsheet that you provided. You can add or remove additional zip codes using the link on the main menu.
Default messages for Printed Applicaitons and Angel tags, along with options for Assigning Applicaiton IDs and Appointment times, and other options will be set for you.
Please review all of the options by clicking on the link: Manage Corp/Unit Setup and verify all selections.
Back

From the main menu, click on the link for: 'Manage Corps/Unit Setup' and then select your Corps name.
Select to make active or inactive options such as:
* Zip Code in Drop-Down list (used on the Application screen to fill in City, County, State.
* Automatically Assign Appointments.
* Assign Client ID
* Child Angels DOB: (Children born AFTER this date qualify.)
* Elder Angels DOB: (Elders born BEFORE this date qualify.) See details on workin with Elder Angels
* Hide Food Only Apps Question (show or hide the option to create Food Only applications.
* Family based optional questions (7 available) with DDLB (drop-down ListBox) answer choices.
* Angel_Clothing_Questions allows up to 5 clothing type questions (Pants / Shirt / Shoes).
* Corps Application Types :: Configure allows up to 3 'fill in the blank' type questions for Gift Request and Child Need.
* angel_msg1 holds the text that will be printed on the Application.
* angel_msg2 holds the text that will be printed on the Angel tags.
* Income / Expense holds up to 10 categories for recording the family Income or Expenses if used to qualify for Angel Assistance.

* Note: The age of the Angel is calculated based on the date the applicaiton was entered.
since it will continue to use the date the applicaiton was entered into the system for all of the angels.
When printing Angel tags, there is an option to print the Angel age as of either Christmas day or the application date.
Back

Verify that the Zip Codes for your Corps service area are correct. Use the link on the main menu: Zip Codes for service area.
Configure the dates and times for families to return to pickup their Angel bags (toys and clothes).
Follow the link: How to configure Client Appointments.
Back

There are three available options for income validation.
1. Income and Expenses (entered as monthly amounts).
To qualify, Income has to be less than expenses.
It includes the three financial Allowance that can be used to offset Income.
* Financial Allowance per Family
* Financial Allowance per Child
* Financial Allowance per Adult
2. Income vs. Federal Poverty Guidelines that you configure on the Income setup screen.
This takes the number of people in the household, as entered on the family screen, and multiplies this by a per person amount + a base amount to determine eligibility.
3. External qualification (setting it to No means everyone who applies has already been qualified thru some other means.
Back

Preregistration must be activated by adding a code on Corps Unit Setup info 3
03 Appointment must be active
Appointment Site code must be entered and be unique across all sites on AngelWeb

The public facing URL is: http://www.pwhdev.net/AngelWebSQL/loginangel.html

For more information, follow the link: How to actvate and use Preregistration.
Back

To enable clothing and gift requests for Seniors on the HOH screen:
(So that the HOH will be downloaded to the Angel Printing program)

• Go into Corps Unit Setup and turn on the options for clothing and gift requests for HOH
  Enable Clothing input for the HOH screen
  


• Enable Gift request input for the HOH Screen
  


• Also verify on the first page the DOB for elders is correct
  


• When your configuration changes are complete, logoff and back in.


• Now, when a senior is the HOH, you can toggle on the gift requests for that record.
  (This will eliminate the need for entering the senior a second time as angel.)
  
  Reveals the gift request fields for HOH
  


• After downloading, use the separate reports for printing Angels and printing Seniors
  

Back

How to setup a separate application type for Corps families or do Training
If you want to separate your Corps applications from others, you could add a new application type called Corps and give it a starting number like 2001.
(As long as your expectation is that you won’t have more than 2000 Angel type applications)
This will make it easy to tell the difference between them when sorting Angel Tags and Bags

• Set the Status / Appointment indicator to Manual if you will just type in an toyshop pickup date and time.
• Otherwise, set it to automatic and then build the automatic appointments like is done for Angel.
• NOTE: the appointment calculator does not take into account other application types
  So, if you are using Automatic assign and had configured 10 for 9 AM for Angels and 10 for 9 AM for Corpson the same date,
  you could potentally have 20 show up if both had applications.
• In the same way, you could create an application type of Training and build appointments
• Make it some other date than real appointments just for clarity.
• Give these a starting number of 9001 to make it real obvious that these are training.
• When you are done with each block of training, go in and delete them one at a time from search HOH to ensure that they don’t get downloaded later.
• If you used your regular Angel application type for training, when done and ready to take live applications:
  1. Open each existing application from the Search by HOH last name screen and delete each one till they are all removed.
  2. Go to the Manage Corp/Unit Setup screen and then the Corps Application Types page
  3. Reset the starting number to 1 so that it starts numbering from there for your live applications.
  

Back

All of these reports are based on Microsoft's Excel 2003, which is a type.XLS document. Microsoft underwent a big rewrite of their office suite starting with Office 2007 and continuing in Office 2010 and higher. The new format (An XLSX document) is a more complicated file type than an .xls. and is actually type of zip file with multiple parts for the document. So, Excel displays that warning message about a different format and you have to confirm that this is OK. There is a way to turn off this message, but it would be for all documents and not just these reports. Please search the Web if you wish to review these instructions. Back

When you launch an Excel report in the Browser, then Microsoft Edge or Internet Explorer (or any browser) has to read the contents of the document into memory and save it into a temporary location on your hard drive.
Then it passes this location to Excel which has to read the contents again.
There is additional security in your Browser to prevent viruses from spreading, and there may also be a firewall or virus protection program that will also read the contents of the document looking for areas of concern.
When you save the file to your computer as one step and then open the file with excel as a second step, then you bypass these additional steps, so it is often 2-3 times faster to do it this way.
Back

After the family data is entered into the AngelWeb site, the printing process for Angel tags involves downloading a spreadsheet (.XML) file to your desktop that contains the angel data, and using a local copy of the Angel Printing program (MS Access) to print the angel tags.
On the main menu of the AngelWeb site, there is a link on the lower right-hand side called: Download Angel reporting software
Follow this link and then SAVE the Reports program to your PC.

• How to download and run the AngelWeb Reports program.
• Right-Click on the link above (AngelWebRpt2016.ACCDB) and select Save Target As
• Pick a folder on your PC and let the file download.
  NOTE: I recommend C:\Angel
• Return to the menu and now (left click) on Download Angel Data to XML
• This will spin for a few seconds and then take you to a new page that has the generated XML file.
  Note the instructions:
  Right click on this link and select Save Target As (or Save Link As) to download the file to your PC.
  DO NOT single click on the link below as this will just open the XML file in your browser.
  The file to save will look like this: EXP_angeldata_LargeCorps-1132016.xml
• Save the EXP file to the same location as you saved the reporting program -- C:\Angel
• Use Windows Explorer on your PC and navigate to the folder where you downloaded and run the Access program
• Click on Setup and confirm the Automated or Manual ID.
• Click on Import Angel and import the downloaded EXP angel data file.
• Click on Reports and run the reports as needed. For example #86 is the formatted report for two Gift/Need requests.

• How to print Angels:
• Instructions for Printing Angels (opens in a new window)

Back

This has been tested on MS Access 2003, 2007 and 2010.
Microsoft now supports two versions of the Office suite -- 32-bit and 64-bit.
The only place where 64-bit vs. 32-bit has been a problem in the Reporting program has been in the area of using the button to 'Find' the name of the .XML file
for Angels and HOH data. The current version has had limited testing in both 32-bit and 64-bit Office and seems to work well with both.
The work around for the 64-bit version is to copy and paste the full name and path of the XML file into the Import screen instead of using the button to 'Find' the file name.
Back

You will want to order the pre-printed Angel forms to make the angel tag printing process much easier. You can order the tags from Trade or from Liberty Press:

• Where can I order the Angel Tags?
• You can order the tags from Trade or from Liberty Press (opens in a new window)
• --- click on Salvation Army
• --- --- click on laser tags and labels.
• Scroll down to the bottom and you will see 5 angels listed. Since the reporting program prints by number range,
  most folks pick LP-71L LP-72L or LP-73L (and not the little boy or girl).

These forms are 3 angels to a page - legal sized paper.
The reporting program knows the alignment of these forms, so all you need to do is split the three angels once the printing is completed. Back

There are several reports that are designed for Avery labels.
Back

There are several reports that may be useful in organizing for your warehouse.
Floor Sheets can be printed to mark a spot for the Family's bag of toys and clothing.
Bag reports can be taped to the outside of the bag to help identify the contents.
Back

Some Corps have asked for customizations on various reports.
When you open the Report Selector screen of the reporting program, you will see a selection box on the right that says:
Show BASE Reports + this Corps Reports.
If your Corps is not listed, then there may be no customized reports for your location.
Change the Selection to: _Base Reports
Back

There are options available in the printing program:
From the main menu, select: Printing Options Setup (Check this before Printing)


If you wish to print Forgotten Angels, then this percentage will be used to calculate how many of each age and gender based on your current number of Angels.
Only select Manually Assigned ID if your site pre assigned IDs to clients - such as in the case of taking paper applicaitons and then later entering them into the AngelWeb site.
Back

There are a couple of options for printing Sponsor informaiton on each Angel Tag.
In the Printing Options, you can enter the name of up to three sponsors and this will automatically print on the Angel tags. There is no additional cost for this option.
If you wish to include the LOGO of your sponsors, then I can do this for you at the cost of 1-2 hours of billable time. Currently this is $45 / hour. If you have someone on staff that works with MS Access, then you can do this yourself.
Please note, that the sponsors will need to supply the logo file and it MUST BE SIZED in the below ranges:
(Unfortunately, I’m not a graphics artist and don’t have the software or the skills to do this.)

A horizontal logo should be on the order of 144 pixels wide, 72 pixels high
A square logo should be on the order of 150 pixels by 150 pixels.
The sponsor should supply the file in the above size to ensure that they approve the colors and resolution of the printed logo
The file should be a .PNG file (which supports transparent background) or a .JPG file
Generally speaking -- 75 pixels is about 1 inch

If you will be printing more than one logo, then, you can decide how much space you want to give to each.

You only have an area about 2.5 inches wide and 1.5 inches tall on the angel tags to print the logos.
Back