Difference between revisions of "FGdb"

From FreekiWiki
Jump to navigation Jump to search
 
(21 intermediate revisions by 8 users not shown)
Line 1: Line 1:
 
==Description==
 
==Description==
−
This is PHP code ( http://www.php.net/ ) that talks to a PostgreSQL database ( http://www.postgresql.org/ ). It is responsible for tracking all our gizmos and their statuses, all our volunteers and the hours they've worked, all our receipts for donations and sales, and more. Everything runs in a web browser.
+
FGdb is where lots of data about Free Geek is kept, including such things as volunteer names and hours, gizmo types and flow, dollar amounts of donations we've received, and much more. It is comprised of a [http://www.postgresql.org/ PostgreSQL] database and a [http://www.ruby-lang.org Ruby] front end.
  
−
==Project Status==
+
You can access it through a web browser, provided you're inside the Free Geek building (not including the wireless network.) Just type the word '''data''' in the address bar (you know, where you'd usually type a big long URL like http://www.example.com.)
−
This code is in a constant state of change. There's always work needed.
 
  
−
==Queue==
+
If you want to find information that isn't available through the web page, and are familiar with (or willing to learn) SQL, check out [[FGdb SQL queries]] for some suggestions.
−
The [[RT]] queue for this project is called FGdb.
 
  
−
==Installation==
+
===Project Status===
−
See [[Installing FGdb on a FreekBox or BaseServer Box]] for more info.
+
The new code is running live in [[Free_Geek|PDX]], [[Free_Geek_Vancouver|Vancouver]], and [[Free_Geek_Columbus|Columbus]].  Look at http://dev.freegeek.org/projects/fgdb.rb/timeline to see what we're working on.
  
−
==Sub-projects==
+
== Documentation ==
−
* Contacts -- Anything relating to tracking volunteers, donors, customers, or other contact information for people '''or organizations''' in the database. -- Martin Chase is working on these related projects.
+
[[FGdb Documentation]]
−
** Volunteer tracking and volunteer hours maintenance
 
−
** Membership program tracking (people making regular cash contributions to Free Geek)
 
−
** Sales receipts (we sell stuff to customers)
 
−
** Donation receipts (donors give us stuff)
 
  
−
* Gizmos -- Anything relating to tracking gizmos in the database.
+
== Bugs ==
−
** new gizmo entry (at receiving)
 
−
** editing existing gizmos
 
−
** cloning of several similar gizmos at the same time
 
  
−
* System checkout -- The process of tying a system's component gizmos to it, assigning an adopter to it, assigning an appropriate value and status to each gizmo, and attributing (in hours) the "value" of the system. This happens when a system is sent to the store, adopted, or granted out.
+
Problem with the database? Create a technocrats ticket in RT. Screenshots are helpful.
  
−
* Reports -- Anything that only requires read access to the database.
+
[[Category: Coders]][[Category: FGdb]]
−
** volunteer reports -- who's in what program, who's waiting to get in, where are they in the process, etc. -- Douglas Howard is working on this.
 
−
** gizmo reports -- how many gizmos of which types were received, recycled, etc.
 
−
 
 
−
* Data Integrity and Cleaning -- Finding old problem in the data itself, removing them, and preventing their reoccurance. This is SQL intensive and less about PHP. -- David Jencks and Richard Seymour are working on this.
 
−
 
 
−
==Unstarted sub-projects==
 
−
* Billing module (for organizations who want to drop off donation but need an invoice to pay instead of payment at time of drop off)
 
−
* Recycling Pickup module (to track quantity and type of materials picked up, and rates we paid or received for that material)
 
−
* Module for tracking borrowed equipment
 
−
* Module for tracking issues with volunteers
 
−
* Gizmo notes -- for tracking history of what happened to a gizmo with text notes, rather than just statuses. This would allow people working on specific types of gizmos to look back and see what happened to a specific motherboard or UPS (for example) and determine what works and/or what to do next.
 
−
* [[Events Database]]
 

Latest revision as of 11:13, 15 April 2011

Description

FGdb is where lots of data about Free Geek is kept, including such things as volunteer names and hours, gizmo types and flow, dollar amounts of donations we've received, and much more. It is comprised of a PostgreSQL database and a Ruby front end.

You can access it through a web browser, provided you're inside the Free Geek building (not including the wireless network.) Just type the word data in the address bar (you know, where you'd usually type a big long URL like http://www.example.com.)

If you want to find information that isn't available through the web page, and are familiar with (or willing to learn) SQL, check out FGdb SQL queries for some suggestions.

Project Status

The new code is running live in PDX, Vancouver, and Columbus. Look at http://dev.freegeek.org/projects/fgdb.rb/timeline to see what we're working on.

Documentation

FGdb Documentation

Bugs

Problem with the database? Create a technocrats ticket in RT. Screenshots are helpful.

Retrieved from "http://wiki.freegeek.org/index.php?title=FGdb&oldid=56037"