ZZ-DATABASE List of Potential New Features

TOP TEN
As of 12-12-07:

(H) [D] Fix the load feature so it's permanently trackable, so the history of completed loads shows somewhere.
(H) [E] Add "Clear Filter" functionality to clear JUST the filter settings except state (not clear the whole table setup, like if it was sorted by "item update" descending) (IN TEST MODE)
(H) [M] Project Management Facility type (PARTIALLY IN TEST/DEVELOPMENT)
(H) [M] URLs in Address Bar should not be general, but the exact URLs, or pretty close, like it used to be Fix the URL address so we can copy/paste ANY lists links (not just presets)
(H) [D] Add button to every page to link to Facilities/Org Advanced Search/Filter(we like the filter and use it a lot)
(H) [E] FIX Qty. Editor. Should only make changes that the user makes (it should not update dates for whole list of items)
(M) [E] Change Facility type Name: "Animal Shelter" to "Animal Care Services"
(M) [M] Search, via google (60% improvement over today), revise google settings to point to commandcenter.org AND to https://ccc.haghy.com
(M) [D] "Update item date" button to update dates on the facility's items, one button for each item, and then an "update all" button
(M) [VE] Clean up (erase, get rid of) deleted Facilities/Open businesses and Deleted Items
(M) [VD] Printable Tables, selectable X and Y (IN TEST)
(M) [D] Printable Lists...same lists as shown already in the database. (IN TEST)
(M) [E] Put the NEW FACILITY BUTTON on the right, so it's always in the same place. Bigger? Colored Box around it. It's lost where it is.
(M) [E] Add a "remove items" button, to the left of the Qty/Urgency button. Same link, different button.
(M) [D] Search "all columns" (100% improvement), as an option in the pull down search menu
(M) [VD] Move items automatically from needs to avail (Part of Project Mgmt)
(M) [MD] Create a series of text boxes with corresponding boxes that turn into link buttons "click here"
(L) [E] Take out old references to gulf in function pages, new facility, Qty/Urgency
(L) [VD] State/county preset Pull Down menu only for those that use it, refresh only when they pull down menu
(L) [M] Contact list sorting, sort columns (ascend/descend) in the Contact List
(L) [E] Categories/Items listing 4 columns: needs (items & facilities)+ avails (items & facilities). In the Categories/Items list, take out the two columns, and add back four columns. The first two columns will have merged heading called, "listed needs". Below the merged headings, will be two separate columns, one titled, "items", one titled "facilities." The second two columns will have merged heading called, "listed avails". Below this merged heading, will be two columns, one titled, "items", one titled "facilities".

New Idea
Pull down menu to go to "a" letter in the list, facility name or item name
Make "State" mandatory upon creation, not mandatory during edit
Search by other fields, first "areas served"

KEY:
[Ease of Implementation]: VD=very difficult, D=difficult, M=moderately difficult, E=easy, VE=very easy)
(Priority): High, Medium, Lower

OLD STUFF:

Lists prepared for ???? meeting.
-------------------------
* Features implemented since last meeting (THANK YOU TOM!!!):

* In Dev/Test:

--------------------------
Lists prepared for 4/5 meeting.
--------------------------
* Features implemented since last meeting (THANK YOU TOM!!!):
- show only urgent/very urgent for the Availability/Needs lists (DONE)
- Make "Clinic" a facility type (DONE)
- Take out "Closed" in the default facility listing (DONE)
- Terra can now grant anyone full read/write access (DONE)
- Take out Standby from the default, add to filter as choice

* In Dev/Test:
- new facility list filtering (see www.youdoit.org, choose facilities/org)
- new avail/needs list filtering (see www.youdoit.org) unclogging the list

--------------------------
==========================
UPDATE: 7/22
TOP TEN
==========================

LOW PRIORITY - NOT TOP 10:

- (H) [E] Qty/Urgency Editor - Add button to "Check All" to remove all [DONE]
- (H) [VD]Facilities can be more than one type, primary, secondary, terciary?
- (H) [E] Update All Items Button...to update condition update dates by facility
- (M) [?] Button for sending "verification" email again (DONE?)
- (M) [D] Auto-remove, by settable date
-
- (M) [D] Email on the lists so we can email all that need an item easier
- (M) [VD]"Save my settings" for sorting
- (L) [VE]Verification note needs to be bigger/ so people "SEE" it (DONE?)
- (L) [E] Unsubscribe button
- (L) [D] Group email/survey, w/user preferences
- [E] Add a button to take out "Standby" facilities in the facilities listing\
- [E] timezones in the hours
- [M] take out irrelevant fields for certain shelters. hotline, no need address, forklift, for example.
- (.25) put in a red arrow and a sign that says, "scroll to the right to
find more categories"

* New Feature Requests
[Ease of Implementation]: VD=very difficult, D=difficult, M=moderately difficult, E=easy, VE=very easy)
(Priority): High, Medium, Lower

==========================
TOP TEN (Terra's proposed cut based on notes from last meeting)
==========================

* = DONE!

- * (H) [E] Qty/Urgency Editor - Add button "Check All" to remove all [IN TEST]
- (H) [VD]Facilities can be more than one type, primary, secondary, tertiary?
- * In Test(H) [M] Collapsible items list, with "show all" button
- (H) [E] Update All Items Button...to update condition update dates by facility
- *(H) [VD]Laura's quantity issue
- *(M) [VE]Does your facility have a pallet jack?
- *(M) [M] Button to filter the conditions by avails, needs or both
- *(M) [?] Button for sending "verification" email again
- (M) [D] Auto-remove, by settable date
- (M) [D] "Update item date" button to update dates on the facility's items
- (M) [D] Email on the lists so we can email all that need an item easier
- (M) [VD]"Save my settings" for sorting
- (L) [VE]Verification note needs to be bigger/ so people "SEE" it
- (L) [E] Unsubscribe button
- (L) [D] Group email/survey, w/user preferences
- *(H) [E] Fix Phone Search

OTHER NEW FEATURE REQUESTS (in order of ease of implementation):

- [E] volunteer housing as a separate green button. Leslie T [We'll have to have a category that it pertains to, and that will take some shape shifting of items and whatnot]
- [E] Take out "region" sorting -T. [is it "dangerous" to take this out while we're thinking about figuring out how to make "service area" and "name that disaster" work?]
- [E] Add a button to take out "Standby" facilities in the facilities listing
- [E] timezones in the hours
- [E] a link saying something like "About Volunteering in General" on the Quick Start page and the Volunteering Database page would be good. Link who go to the "How I Can Help" on web site.
- [M] Put year on date sort for facility list
- [M] take out irrelevant fields for certain shelters. hotline, no need address, forklift, for example.
- [M] an arrow in the conditions list so that we can sort by oldest first to newest last or the other way around
- [D] Collapsible items list so that someone, via cookies only has to look at the categories that they care about.
- [D] Put year on date sort for all lists [more difficult cuz they've got to figure out where all the lists are]
- [D] Write access by state. County. Town.
- [D] Put emails on the facilities listing that comes up with an item [VD because the emails only show up for certain people and some kind of slick caching will be required to know who has what access for which facilities. Maybe have this feature ONLY for those with full read access? Does that make it easy?]
- [D] choose which categories to show for the Availability/Needs lists
- [D] something to help identify the oldest/out of date item entries...either avail or needs.
- [VD] something to REMOVE oldest/out of date item entries, avail AND needs
- [VD] Put other phone numbers on the list of facilities for an item [see email notes in the request above this one..."other contacts" are only seen by certain people for certain facilities]
- [?] Write access for all, except item/category name change. two levels of full write access
- [?] Save all my settings, so that I can see the facilities list the same way with the same columns showing with the same columns sorted as the last time I came there. Save 15 minutes/week
- (.25) put in a red arrow and a sign that says, "scroll to the right to
find more categories"
- [?] Fix cache so item list is current all the time.
- [?] CAT assignee for facility type (changeable by us), shown in all lists. This would allow vol. manager to organize/manage vol. easier.(capbham@aol.com)
- [?] web-based permissioning for terra/volunteers "by facility"
- [?] Canada pull down option
- [?] show items that don't match anyone...by urgency
- [?] show a running total of items needed...by state...by urgency
- [?] When you click on "Items" and get a list. I would like to know how many of those hits were urgent and very urgent vs. average. (capbham@aol.com)
[T: is this the same as the one above this one?]
- [?] option to add columns for everything in the facility record. all places with forklifts???
- [?] Fix SORTING display inaccuracies on the lists. Sort facility list by cond update date and the list doesn't show that everything was updated today. It's got old dates on and people that didn't do the update this time. It shows the last update and the last person that did the update. [a caching problem?]
- [?] Need more space in quantity box.

-----------------------------------------------------------------------

* Things which need more definition/explaining by the users:

- Laura's quantity issue (see email at the bottom of this record)
- A choice to categorize the needs/avail lists in the record
- Add "partner ID" field and "partner Org ID" field to allow other orgs to use the database. John Walling.
- Survey button. They may not be writing with feedback, but a good percentage of those that I surveyed responded? so it seems people are willing to answer specific questions. [to actually "do" the survey and keep tabs of results, or just to send an email to the whole group?, or to ask people if they want to be surveyed?]
- add line in record that asks "Does your facility have extra storage space". capbham [is this better done via an item? otherwise, there would have to be a quantity box too, and then why not just use an item?]
- 'facility profile:' on show page
- When someone places the cursor over the space, is it possible to have a text msg come up stating how it works again? - I know, it's very redundant, but unfortunately, end users need that. Leslie Holly
- since so many people are intimidated by the database, is it possible to create a slideshow explaining how to set up a username, enter organizations, enter needs, enter donations, do a search to match needs and donations?
This could be sent to some organizations on a CD to some agencies to see if it's right, and then have it to mail to new organizations. Possibly even have it on the website for folks? Leslie Holly (NOW slideshow on website)

- placing the little * Note msg under the needs/avails tables, might be seen better if it were placed beside the grey bar, in the title bar itself.... (Dayle ~ Under the needs/avails, on a record, is the astrick symbol-- unless people see the small notation or key.... it is easily missed. My suggestion was to move the key just above in the grey bar) Hope this helped!!

- ability to check off urgency/facilities for a particular item
- tabs to enter log in data return also for the search field
- An "alert" sent that says New User, ID, just requested login.. easier follow-up [To whom? who gets the alert? ] THE current acting Op Manager by assignment... ie Terra or Dayle or ???

- = "item", "show", it would be nice to have the updater's initials, so we know how good the info is. (I think it is already available via edit)[but it might be a pain to cycle back and forth]
- List of the top needs for donors to focus on. [What is "top"? How about that running total, by state, urgency?]
- Notify people that their stock is needed elsewhere. [No, because they can match, if they care. This would drive them crazy and they'd take stuff off the avail list. Tom's working on a list of choices for how many emails people want to get from us.]
- Internal management spots that we can change ourselves. Let us add pages. Let the title of the doc be what?s shown on a side bar of pages. Allow us to decide which pages are public.
- What about adding to the "Vehicles" category to make it "Vehicles/Heavy Equipment"? - Or should we place heavy equipment under "Construction"? (LTel) [Is this done?]
- Why do we need "Non-Profit" & "Non-Profit Charity" under Organization? (LTel)
- do we want to list the links? with a back arrow to let people back up along the same route?
- point the "about" and other stuff to www.reliefdatabase.org? If so, we need a contribution page, or else I'll have to screw around with Sari to get him to change the citizenactionteam.org page. Or maybe Tom can do that?
- figure out a way to make the facilities list load faster. maybe just default the list to incl phone numbers and update date? and add columns by choosing?
-People do not understand what you want on facility record where it says Organizations without searching other orgs. I think this might be solved by changing the title to "Organization Type" LKP
- Add Admin Notes section & redefine Notes to Public Notes. DN
- It would be nice to have Condition Update also listed on record info so if we are on an orgs record we can see when the needs and availabilities have been updated. I ask my volunteers to make a note there, but it's easy to forget to do that if there are no changes for the record and you are just working with the needs and available. Laura Parenteau (capbham@aol.com)

* New Stuff:

(none)

----------------------------------

* Longer Term Vision Stuff
- a function to allow for automated emails to go to those that need an item
- a function to allow us to automatically email people on a certain list
- add a new tier or two to accommodate additional user groups. "entity" at the top level. "facility" is an entity. "person" is an entity. other entities: animal, concepts...
- Internal management spots that we can change ourselves. Let us add pages. Let the title of the doc be what?s shown on a side bar of pages. Allow us to decide which pages are public.
- Group email. For whatever facilities are showing. For ONLY certain people.

----------------------------------

* Things for tech strategizing:

- name the disaster (like "name that tune"), Laura [this is tough because new disasters get added all the time. we might be better served by making this an "item" and having a new category for "name the disaster".]
- Service Area indicated by a field. So we can sort by service area. [I see this as difficult because like we couldn't get the region to work because there is no definition of what a region is, we have to leave this as "text", and maybe display it like you do the org type. the issue is that people type in the names differently, misspelling, different nicknames, different boundaries, so if you let them type it in, then you'll never get a good, meaningful sort. John Walling's group is doing some thinking on this. Terra's been giving them feedback on what didn't work when we tried it last, in the hopes that we can find a solution for this.]
- [M] add a field for "disaster restriction" with pull down menu to choose "Katrina" or others [need list from users, or should we do this via categories/items? John Walling] [What would the category be called? Service Areas? Disaster applicability? Need some help with this taxonomy thing that John's doing, cuz it's not obvious to me.]

Laura's quantity issue:
I have enclosed an excel sheet that should illustrate the problem I'm having
and the easy fix. I need a good deal more space in the quantity box.

Notice:
Same med comes in different strength
These are samples so sometimes there are 3 in a bottle, sometimes, 1 on a
tab sheet

I am having a hard time getting clinics to be uniform in how they request.
Some request bottles (assuming it's a bottle quantity that they would buy which
is diff. from sample BTs. some just tell me which meds they want with no
quantity specified. It's taking way too much time to deal with. I even sent
them a form.

Anyway, I'm afraid they don't look at notes attached to item either. So i
will be separating meds in items list by strength as it seems to make a
difference to them. It means more items on the list, but it will be more useful and that's the name of the game right?

I need more space so under availabilities is can put bottles of 3. Actually,
I think it would be better to add a column called "Packaged As"

Example:

Packaged As Quantity

pallets 2
boxes 16
single 4
BT of 3 231
17 g 2


Please put towards top of needs list for Tom and pass it on to him. I did
not copy because I had the word "urgent" . :-) and you told me not to send
urgent messages to IT. [unless it's an actual tech issue that's urgent, like the site is down... terra]
Laura

-------------------------------
NEW FEATURE REQUESTS not yet processed above:

https://ccc.haghy.com/items/list
On this list it shows At # of Shelters
Can this be clarified to say "Needed at # of Shelters"
AND
Can we add a column to show "Available at # of Shelters"????
This will allow a quick glance of how well specific needs/items are being met or UNMET! (Dayle)

I would like to have the advanced search within the WHOLE facility record again!!!
That old Google search worked great even when I checked a phone number, It would list any record that listed the same number. I could find LOTS of info thru that search!! IT WOULD help with issues on duplications as well!! (Dayle)

ABOUT PAGE EDITS:
For Donors
If you would like to be a donor, please click on Conditions
for a quick overview of recently registered needs

THE ABOVE LINK conditions GOES TO: Item: Assistance, Medical Assistance

Ok... its a little thing but do you want to capitalize ALL in:
All donations go strictly to shipping costs