Goal:
Examine the DatabaseBuilder to understand its function and use.
Execution:
Download the DatabaseBuilder named "MyPleasure Lesson 1", and store it in your Tutorial JumpStart folder and open it in your Excel application.
In general:
The DatabaseBuilder is an MS Excel sheet that is loaded with functions and code-behind scripts. To prevent these functions and scripts for accidental damage, the sheets are locked with a general password, thus making it inpossible to overwrite cells. This password is " MySheets" and will apply all over the DatabaseBuilder. You can turn it of, at your own risk. (Make backups!)
The Tables and Fields:
The DatabaseBuilder can contain 20 tables at once.
Any table can hold up to 100 tablefields.
Conventions:
For the ApplicationBuilder to be able to build your application, it is necessary that all names in your database follow the convention that JumpStart DNN dictates.
The DatabaseBuilder takes care of these convention by adding certain codes to the names of the tables and the table fieldnames.
For instance the "Primary" and " Secundary" prefixes are needed to distinguish the table- and fieldnames in the SQL database. The guarantee the uniqueness of the names within your database, and over your applications.
The conventions for the extentions on the tablefieldnames take care for the correct building of the code that make up your application.
The DatabaseBuilder Tabs.
There are 14 tabs in your DatabaseBuilder, some are optional, the others are oliged and will build your application in the ApplicationBuilder. Some are not in use.
Calculations |
Optional |
This is a helper tab that enables you to create calculated content. |
In this example we use it as the primary information on the contribution fee. |
Conventions |
Obliged |
This tab contains your application information. |
In the top rows are the application name, the primary and secundary prefix and so on. You have to set them prior to building your application. |
Tables |
Obliged |
This tab contains the names of the tables that make up your application. |
Try to arrange your tablenames in a logical order. The tables will get a number, so it makes sense to get them in a convenient order. Primary tables on top, secondary tables to the bottom. |
YC_TUT_00_Template |
Not in use |
The template tab is only used when you run out of Table tabs. |
Create a new tab at the end of your DatabaseBuilder and copy-paste the template content to the new inserted tab. Then open the script page and also the script page of the new tab. Copy paste the script from the Template to the new tab. |
YC_TUT_01_YCSociety |
Obliged |
The Society table keeps the contribution data. |
This table contains just three records: Adult fee, Child fee and Spouse fee. |
YC_TUT_02_YCActivities |
Obliged |
The Activities table keeps the Activity information. |
This table contains just five records: Parasailing, Hanggliding, Hiking, Rafting and Camping. The information consist of date and cost information along the Activity Officer. |
YC_TUT_03_YCOfficers |
Obliged |
The Officers table keeps the Activity Officers information. |
This table contains just five records with the Activity Officer name in it. It has NO role information in it, because any Officer is a registered user, so most of this data is stored in DNN's system tables. Any number of officers can be added by the administrator. |
YC_TUT_04_YCMembers |
Obliged |
The Memberstable keeps the Member information. |
This table contains a number of member records with the needed data. Because members do not need to be registered on the website, it is the administrator's task to add new un-registered members after they have payed thier contribution fee. |
XYC_TUT_05_ |
Not in use |
Reserve table. |
When you need to expand your application with more tables, you can use this reserve tab. Just fill in a new tablename in the " Tables" tab and this tab will set ready for your new dataset. |
XYC_TUT_06_ |
Not in use |
Reserve table. |
Same as above.... |
XDataYC_TUT_01_YCSociety |
Optional |
This tab contains test data for the Society table. |
The top row of the DataTab holds the fieldnames of the corresponding TableTab. The data in the record in this tab will partially origine in the " Calculation" tab. |
XDataYC_TUT_03_YCOfficers |
Optional |
This tab contains test data for the Officers table. |
These are the Activity Officers names, stored in five records. |
XDataYC_TUT_02_YCActivities |
Optional |
This tab contains test data for the Activitiestable. |
The five activities are stored in this tab, along with their properties, the fieldnames in the top row. Again, these correspond with the fieldnames in the TableTab |
XDataYC_TUT_04_YCMembers |
Optional |
This tab contains test data for the Memberstable. |
The same as above, but for the members. This tab contains a number of test members that can be used to re-fill the table after modifications in your DatabaseBuilder. |
You're done with this lesson
----> To Lesson 3: The content of the DatabaseBuilder