|
Creating a New Database
|
 |
Your webmaster modules come equipped with powerful tools to manage and display databases which can be imported from external sources, as well as exported from your website to be managed with powerful tools like SQL, and Microsoft Excel. This lesson describes the process of crating a new database on your web server. In addition this step, the display preferences for the database will have to be created, and if you have a current database located off your server you wish to display, it will have to be imported from your local computer
First, Login to your website, as the webmaster.
Next, you will have to create your new database. Click the select bar under database and select new. If you have already created your database, it will be important to be sure that all of the field names on your Excel spreadsheet match the ones in your online database exactly. If they do not match, your fields will not show up in your online database. Now you will have to name your database. Database names will have to be text only, no spaces or special characters.
Once you have named your new database, click the link that says Fields. This is the section you will use to create the fields for your database. Special fields we recommend you use are title, category, description, and buildPageName (used to create a static html page from the database entry and your template, i.e. welcome.html). By using these fields your display options will be enhanced.
For each field you wish to add, click add field.
In the column that Says Field Name, type the name of your field. Click the SAVE FIG button at the bottom. Repeat these two steps for each field you wish to display or store in your database.
There are several types of fields which are available. Text will allow you to edit your info for that field in a text input form element. Area will designate a text area for larger amounts of information. Select, checkbox, and multiple will allow for customized displays of information, which will be discussed in the display preferences help. Photo will allow you to browse from your images folder in the edit form for each item in your database. Hidden will not display the field in the edit form. Each time you make a changes to these fields, you will need to click the SAVE FIG button at the bottom
Once you have created the fields, and assigned them a field type, you will be ready to create your databases, either individually through the web modules, or by importing an existing database.
| 
