FreeRadiantBunny docs

User Documentation

Here is a step-by-step guide of what can be done using FreeRadiantBunny and how to do it. Little by little this will get easier, and so I hope you learn things along the way to make it doubly worthwhile to do all of this.

No doubt there will be pretty diagrams of use cases because the pictorial How-To's are always fun make for swift progress. Nevertheless, there is something precise about writing out all of the steps in text. Here we go:

Assumptions

Assumption 1: a FreeRadiantBunny system. This document assumes that you have installed a FreeRadiantBunny system, such as is described in Install FreeRadiantBunny.

Assumption 2: a database installed your database system. The FreeRadiantBunny system has a database installed. In this example, the database has the name: frb_stable.

Assumption 3: a web-based database administration tool. The webserver system has phpPgAdmin installed on it.

Assumption 4: a "client" (aka "Primary Actor", site owner, stakeholders). There is a permaculture project being assessed and analyzed.

Situation at the Start

When we completed the install we were left with a webpage that showed a working system but there was no data. Note the red field below.

frb screenprint success install

No projects were found because this is a fresh install and the user has not add any projects to the database.

So, it is time to add a project.

Adding a Project

To add a project, the database is going to be manipulated using a program called phpPgAdmin. This is a browser-based app that allows one to mange a database.

On the webserver used for the test, the phpPgAdmin program can be found using the following URL:

http://localhost/phppgadmin/

The phpPgAdmin application will ask you to sign in. Use the username and password associated with the database that you installed.

One logged-in, note the left column menu lists your PostgresSQL databases. Click on the name of the database that appears on that list. In this case, the database name is "frb_stable" and it shows the "public" schema.

phppgadmin first page

Click on "public" and you will be presented with a list of tables in the FreeRadiantBunny database schema.

phppgadmin list of tables

As of version 1.2, there are 105 tables in the database, each with an associated php file of class code. If you haven't already, click on a few of the table names and see how the columns of the table are displayed (along with lots of other information about the table).

Below is what displays for the projects table. This shows the columns of the table.

phppgadmin projects table

The phpPgAdmin program is a quick way to develop the database. Until FreeRadiantBunny gets developed more (with more input and update forms) phpPgAdmin may be used to modify the data. The FreeRadiantBunny will focus on displaying the data.

To add a project, look for the "insert" hyperlink. In the above screenprint, find the "insert" hyperlink in the horizontal menu below the column names.

phppgadmin projects table arrow on insert

Once you click on insert, phpPgAdmin displays a form with fields for each of the table's columns.

phppgadmin projects table insert

In this example, we are going to input a permaculture project for a chickens and a chicken coop. Read the example, but add your project information accordingly. When you have completed the form, click on the "inert" button at the bottom of the form.

phppgadmin projects table insert

Note, the projects table documentation page contains a brief descriptions of the projects table's columns, and these descriptions may be a guide when entering data into the fields of the INSERT form.

Now, use phpPgAdmin to display the data of the projects table. Surf to the projects table and then click on browse so that you can browse the data on the table.

phppgadmin projects table arrow on browse

When you browse the data using phpPgAdmin, here is what the new row of data looks like:

phppgadmin projects table row of data

And now the payoff is viewing the data of the project using FreeRadiantBunny. Go back to the FreeRadiantBunny system and load the projects page.

http://skindrop/phppgadmin/projects

phppgadmin projects table browse

Time to take a break. When you get back, check out How To Add goal_statements.



More User Documentation:

Alternatives to Graphical Interaction

The above is not the only way to use FreeRadiantBunny. There are some things that can be done using a command-line tool such as the typical Linux terminal. The bash shell is the shell used here. To learn about this, please, check out: Using Via Terminal.