Namo Web Editor

Database Wizard – Chart Settings

Database Wizard (Chart Block) – Step 5
Develop > Database > Block Properties – Chart Block Settings tab

In this step of the Database Wizard for chart blocks, you specify the source fields for the chart block’s series, categories, and values.

When you use the Database Wizard to create a chart block, you must tell the wizard where to get the series, categories, and values that will be in the chart. Values always come from the database. Series and categories can either come from the database or be entered manually once you have completed all the steps in the wizard.

Series and Categories

Source

Enter manually – Select this option if you intend to enter the series and category names manually after finishing the Database Wizard. Use this option if your database table contains only values, or if you only wish to use the values in the table without using the other fields. Once you complete the Database Wizard, double-click the chart and enter the series names in the Series tab of the Chart Block Properties dialog box, then enter the category names in the Values tab of the dialog box using the table cells under X-axis.

Retrieve from database – Select this option to use database fields as the source of the series and categories. Under Source fields, select the source fields for the series names and category names.

In order use the database as the source of series and categories, the database table must be structured appropriately. Each record (row) in the table must have a series name, a category name, and a value. Additionally, each record must have a unique identifier in another field (column), since many records can have the same series name and/or category name. In the example table below, series names will be obtained from the Product field, category names from the Country field, and values from the Units_Sold field.

Number of categories

If you selected Enter manually under Source, enter the number of categories that the chart will have. After finishing the Database Wizard, you must enter this many category names in the Values tab of the Chart Block Properties dialog box using the table cells under X-axis.

Number of series

If you selected Enter manually under Source, enter the number of series that the chart will have. After finishing the Database Wizard, you must enter this many series names in the Series tab of the Chart Block Properties dialog box.

Source fields

Series names

Select the database field that will serve as the source of series names in the chart. The drop-down menu lists all the fields that you selected in the previous step of the Database Wizard.

Category names

Select the database field that will serve as the source of category names in the chart. The drop-down menu lists all the fields that you selected in the previous step of the Database Wizard.

Values

Select the database field that will serve as the source of the values in the chart. The drop-down menu lists all the fields that you selected in the previous step of the Database Wizard.

CGI path

In order for your site visitors to be able to view your database-driven chart, a CGI program on the Web server must generate the chart and pass it to the Web server software. By default, Namo WebEditor saves the CGI program in the same folder as the document containing the chart form. When you upload the document to your Web site, you must also upload the CGI program to the same folder on the Web server.

However, you may wish to move the CGI program to a different folder, such as ‘cgi-bin’. If you do this, you must also specify the path to the CGI program in CGI path. For example, if you decide to store the CGI program in a ‘cgi-bin’ folder at the top level of your Web site, you should enter ‘cgi-bin/CGI program name’ in the CGI path text box. The filename of the CGI program that generates the chart depends on which Web server operating system you selected in the first step of the Database Wizard. Refer to the table below to determine the CGI program filename for your selected operating system.

Web server OS	CGI program filename
Windows	wed_chart_windows.cgi
Linux	wed_chart_linux.cgi
Solaris	wed_chart_solaris.cgi
Solaris x86	wed_chart_solaris_x86.cgi
FreeBSD	wed_chart_freebsd.cgi

Whichever folder on your Web site you put the CGI program in, the folder must have read and execute permissions enabled in order for the CGI program to run. If you’re not sure how to set folder permissions, refer
to your Web server software documentation or ask your network administrator.

Related topics

Chart Wizard – Chart Type tab

Chart Wizard – Title tab

Chart Properties dialog box – Series tab

Chart Properties dialog box – Values tab

Chart Properties dialog box – Trendlines tab

Chart Properties dialog box – Axis tab

Chart Wizard – Chart Formatting tab

Database Wizard – Chart Settings