To set up the Courses database to be used on Page 5-2 of the User Guide

• Click on Build, then click the Add to Web Site drop down box and select Form Page
• Add the Form page to your web site and click OK, then click ADD
• For this example, select Text for the Type
• Enter 'Name' for the Description, enter '15' for the Width, '30' for the Max Length, and click OK
• Click Add, then set up City, State and Phone using the same method. (You could also set up validations for the fields, but for this exercise we do not need to)
• After you have completed Name, City, State, and Phone, click Next
• Click on Automatic Save to Database and type 'Courses' for the Database name
• Click Data and select Import Data Into Existing Table, then select MS Access Database
• Select Courses2.mdb (located in C:/Web Business Builder/Samples/Databases directory) and click OK
• Select 'Island Golf Courses' and click Next
• Select 'Courses' from the Table Name (the database you just set up) and click Next
• You should only see 'id', 'datetime', 'name', 'city', 'state' and 'phone'. If you scroll down and see several other entries, click 'Cancel' and try importing the data again.

• Select Name > Name and select Add (If you see many different 'Target Data Fields' then click 'Cancel' and try importing the data again, this time make sure that you select each table yourself before clicking on next).

If you want the database, without the form:

• Click on Build
• Click on the Form Page and select Remove
• Click Yes
• When it asks if you want to keep the files, select Yes
• You now have a database, with imported information

When I try to import data into Web Business Builder from an existing MS Access or MS Excel database, I receive an error message "Syntax error in From clause.":
Due to a driver requirement, you must put a space in the database/spreadsheet name and a space in the Sheet name tabs. Example: Data Base. xls; Change to Sheet 1, Sheet 2, etc. Features

How do I specify Sizes and Colors for Items in my Store?
You can specify sizes, colors, and other options in the Store's Data Definition Wizard. You are placed in this wizard automatically when you add a store to your site. Please visit your "Getting Started" manual, Exercise 3, Adding Product Options. You may also visit this section in our Online Getting Started document.

How do I set up Shipping Charges based on total weight or total price?
To set up Shipping Charges, enter the Online Store Data Definition Wizard (Choose Build, Click on the Online Store page, then click on the Data... button in the left margin). Double-click on a product in your store and set the Shipunits field for that product according to the Shipping Charge scheme you wish. For example, if you would like Shipping Charge based on price, set Shipunits the same as the price of the object. If Shipping Charge is base on weight, set Shipunits to the weight of the product. Be sure to set Shipunits for all of your products.

Now click on the Shipping Rates tab, then Add. Enter Ship by, Shipunits range, and rate for each tier of shipping charges you have.

For example, to set the following Shipping Rates:

Ship by Purchase Price Rate

------- -------------- -----

UPS $0 - $ 99.99 $ 2.50

UPS $100 - $199.99 $ 5.00

UPS $200 or more $10.00

1. Ensure that all products have Shipunits = price

2. Make the following entries in Shipping Rates:

Ship by: UPS Start From: 0 Less Than: 99.99 Rate: 2.5

Ship by: UPS Start From: 0 Less Than:199.99 Rate: 5

Double-click on the "Less Than 99999999.99" entry and enter Rate: 10

How can I remove the price if I don't want it to be displayed on the product detail page?

In the Layout of the Detail page, simply remove the "US$" expression.

Miscellaneous

Can HTML and WebC be mixed in the same document?

Yes. You can have both HTML and WebC in a file with the .html extension. If WebC sees a SERVER tag in the .html file it will execute only the code in that tag. Any HTML outside the SERVER tag will not be printed unless it is properly tagged and you issue a printtag() from within the server tag.

What if I get a Proxy error when I try to Preview my web site?

Your browser is configured to use a Proxy server to access web sites. For local preview to work properly you must disable the Proxy. To do this, go to Start, Control Panel, Internet. Click on the Connection tab and check the disable proxies box.

What can I do if the serial number I was given doesn't work when I try to install the software?

It may just be a mispelling when entering the serial number. The most frequent error cases are : considering a 1 instead of a l, or a 0 instead of a O...

How can I have a single address area on the Order Form?

One method to have just a single Address area on the Order Form is to remove the secondary "Billing Address" information from the ORDER FORM is as follows:

. Press the Preview tab to go to the Preview section.

. Select the "Order Form" page in Layout editor.

. Double click on the Form tag to open the form properties

. Select the "Form Field Options" tab.

. Add a new hidden field of "p_same" with a default value "on".

. Now delete all of the Billing fields from the "Order Form" and "Confirm Order" HTML page.

You can now check that you get the correct results in the Preview window.

How do I set-up my web site to use the Secure Server?

Setting up your web site to use the secure server can be done by following these instructions:

1. In Web Business Builder, select Web Properties under the file menu.

Check which Internet Service Provider you've selected in the FTP tab.

If your ISP isn't in the list, you have probably selected Custom.

2. In the Windows Explorer, go to the Breakthrough\ISP database folder.

Select the .ini file that corresponds to your ISP (for example custom.ini or Sirius.ini).

3. Edit the file using an editor such as notepad

4. Remove the leading semicolon and space before "SECURE_SERVER" to activate this line, or add a line called SECURE_SERVER if none exists.

5. Enter the URL to access the Web Business Builder store pages through the secure server. Normally this is similar to the URL used to reach your Online Store. For example, if you visit your home page and then click the Online Store, you will see a URL such as http://www.yourdomain.com/cgi-bin/webc.cgi/st_main.html

See if you can you access this same page through the secure server using a URL such as https://www.yourdomain.com/cgi-bin/webc.cgi/st_main.html

If you can, then the proper entry for SECURE_SERVER is:

SECURE_SERVER=https://www.yourdomain.com/cgi-bin/webc.cgi/

6. Save the file and exit the editor

7. You are now ready to re-publish your Web Business Builder Store to activate the secure server. Be sure to sure to De-select databases if you do not want to overwrite data collected on your site.

Your online store will now switch to the secure server (SSL) when you enter the page that gathers shipping, billing, and credit card information.

What if I am not receiving email from my online forms?

If you have created a custom Publish configuration for Windows you will need to add a configuration entry to the webc.ini file to specify the mail forwarding server for your web account. To do this:

1. Ask your ISP for the IP address of the mail forwarding server you should use. Our software will use SMTP to talk to this server.

2. Locate the webc.ini file that you have published to your account -- this was placed in the directory specified in the "CGI Directory" field of your publish configuration.

3. Add an entry to this file: MAIL_HOST=100.100.100.100

(where 100.100.100.100 is the IP address of your hosting server)

Publishing to an NT/UNIX WebServer : WebC component installation and publishing configuration?

If your ISP is not one of our Prefered Providers or if you intent to publish to your own Web server, you can view and save a readme text file for NT or a readme text file for UNIX, which contains all the information you need to install the WebC component on the NT webserver and to configure the Web Properties.

Site Administration

How do I access my Site's Administration area?

To access your site's adminstration area, begin by going to the home page of your site. Then select your online store. If you have a secure server, locate "http://" in your browser's URL/Location/Netsite window and change this to "https://". Now locate "st_main.html" in the same line and change this to "admin.html". Once you have accessed your site's Administration area you will want to add a Bookmark to reference it the next time.

How do I change my Site's Administration password?

The admin password can be modified in Web Business Builder :

1. Open your website in Web Business Builder

2. Select "Web Properties" in the "File" menu

3. Click on the "Admin password : Change" button.

4. If needed, publish your website so that the "USERS" database is refreshed

Note :

Another option is to directly modify the value of the password in the "USERS" database, in Web Business Builder :

1. Open your website in Web Business Builder

2. Click on the "Data" button from the toolbar along the top

3. Select "Enter Data Records" and click Ok

4. Select the "USERS" database and click Ok

5. Change the password for admin to whatever you wish - but DO NOT CHANGE the admin userid which HAS to BE admin in the current versions of Web Business Builder

6. Click Update and then Done

7. If needed, publish your website so that the "USERS" database is refreshed

How can I receive a notification email sent to me for each product ordered?

To do this you will need to make an update to one of your configuration files.

1. In the Explorer, go to the Breakthrough directory (where you installed the software), then to your website folder.

2. Edit the config.ini file (using Notepad for example) and add the following lines: EMAIL_ORDER=True and WEBMASTER=webmaster@domain.com (replacing webmaster@domain.com by the appropriate value -- this WEBMASTER address should have been already set in the Web Properties (in the general tab), but it seems we have a bug on this and we're currently working on it).

3. Now re-publish your account and ensure that the config.ini is published.

If you are still having trouble receiving an email confirmation, please refer to the Publish FAQ topic for additional information on configuring the mail server for your installation.

Can I allow other users or group users to access my Site's Administration ?

This feature is not currently offered in our product.

How can a set a group of users who would be given a userid & password to access my website?

If you wish to restrict the access of your website to a group of users, you can add a secure area (in the Build section) to your home page. You'll then be able to set a group of users and give each user a password.

The group can be defined by going to the user administration page (in the Preview window), adding users, creating a group and then validating the users for this particular group that you've created.

After upgrading from Version 1.0x to 1.1, I can no longer access my admin area. What can I do?

Here are the steps to solve the problem :

0. If you have the Breakthrough software open, shut it down.

1. In the Windows Explorer, edit the security.ini file (which is located in the Breakthrough\yourwebsite directory) and set the NCSA_SECURITY_ONLY variable as following : NCSA_SECURITY_ONLY=Off

2. Copy the logon.webc file from the Breakthrough\source\admin directory into your website directory

3. Open the Breakthrough software, for each of the admin pages (in the BUILD section), click on the "Properties" button and in the Security tab, set the User to admin.

4. In the Web Properties (found in the "File" menu), set the value of the password

5. You can now go to the Preview window and you should be able to access your admin area, using admin as the Userid.

Styles

How do I change the text on my Banners after IBB has built my site?

To change the text on your Banners, select Build from the toolbar. Now, select the page you wish to change from the left, then select the Properties button. Click the Banner tab, and enter the text you wish in the field. Now, return to Preview to view your new banner.

How can I create my own Style Sheet?

1. Start your style sheet

- Press Style to enter Style mode

- Select a style that has a layout similar to the style you would like to create.

- Rename the style, by selecting "Edit Style" in the File Menu, typing in your style name and clicking Ok.

- Click the Banners tab to import your own graphic items such as Banner, Menu icon, etc.

- Click the Images tab to import other graphic items such as Ruler, Bullet, and to customize your background.

2. Enhancing your style sheet

- Press Preview to enter Preview mode

- In Preview mode, go to the layout editor.

- In the File Menu, select "Open Page from File" and browse to the html file corresponding to your style (it is located in the \Breakthrough\styles directory). For example, if your style is named "MyStyle", the file will be \Breakthrough\styles\MyStyle.html.

- You may now add other graphics to your style and change the layout as you wish

3. Apply your style sheet

- Press Style to return to Style mode

- Select your new style and click on the Set Default Style button. This will apply the style sheet to your web site.

4. Finalize your style

If you wish to disable text writing over your banner:

- Press Build to enter Build mode

- Double-click on your home page. In the Page Properties, go to the banner tab and uncheck the Generate Banner Text checkbox.

Any more tips to enhance my style sheet?

The trick here is to use a transparent template!

Well, it's a simple way to use our graphic templates and use your imagination to give your style sheet an original look... You can also customize one of the existing templates by utilizing particular elements of this template, such as the transparent menu icons...

You can dowload the transparent template from Transparent Template.

Unzip the file and paste it into the Breakthrough\styles directory.

What is the difference between the custom_banner and the home_banner?

The custom_banner is only applied to the page it is associated with, whereas the home_banner is applied to the whole website.

ISP Configuration Information

If your ISP is not in the list of pre-configured ISPs (found in File/Web Properties menu item under the ISP tab), or if you have not yet chosen one, we recommend that you choose an ISP from the list of IMSI/Breakthrough Software’s Certified Preferred Providers. Our ISP partners in this list have been chosen specifically for their robust, secure Web hosting environments, and all offer a package that is especially suited for Web Business Builder. 

If you have chosen an ISP that is not yet our partner, don’t worry! Web Business Builder has no special requirements beyond basic web hosting packages that most ISPs offer. To get your site up and running on your ISP, we can guide you through the following steps: 

• Determine if your ISP offers a package that will support an Web Business Builder Web site 

• Gather Information from your ISP 

• Build a Custom publish configuration or contact Breakthrough Software to complete your configuration 

• You may wish to inform your ISP that Breakthrough Software has a Preferred Provider program if they wish to partner with us. 

1. Determining If Your ISP Supports an Web Business Builder Web Site 

Please review our System Requirements / Hosting Requirements for this information. 

2. Gathering Information From Your ISP  

Once you've determined that your ISP fulfills the requirements listed above, please gather some information from them by asking the following questions: 

3. Building a Custom Publish Configuration

Once you have gathered the information from above, you can build your custom publish configuration. 

This information is for building a Custom publish configuration if your ISP is not currently supported by Web Business Builder, or if you are publishing to an internal (intranet) server.

The information entered in this dialogue tells Web Business Builder where to Publish your web site. These settings govern the ftp process (transferring files to your web account), and WebC operation (auto-installation and configuration for our server executable). 

• When you are ready to publish your online store, select Publish.
• Click on the "View" button.
• Fill each field with the appropriate information, according to your ISP/Web Host account
• For added flexibility you may use variables which reference other fields.  Examples of this technique will be shown below.

Definitions

• FTP Home Directory - The location (directory or folder) you are in, on the remote server, after  FTP login.
• HTTP Document Root - The default location (directory or folder) where the HTTP/web locates HTML files
• Full Path Name - The full, explicit name of a directory or folder, beginning from the root (Unix) or from the drive letter (Windows).  Examples: /home/users/account, d:\inetpub\wwwroot\account

Ftp settings

Web Business Builder will establish an FTP connection to your web account, and then publish (transfer) your web site according to the following parameters:

Public Directory

This is the standard location for your web pages or HTML files, relative to your FTP home directory.  After FTP login, Web Business Builder will change directory (cd) to the location you specify in this field, and then transfer HTML files, graphics, and supporting files for your web site.  Web Business Builder will create this directory if it does not exist.

Examples:

• If you normally FTP to your account and then immediately transfer files in, leave Public Directory empty.
• If you normally FTP to your account and then change directory to public_html, enter: public_html •Other common values for this field: www, webdocs

Private Directory

This is the location of a directory where you would like your Web Business Builder databases stored.  This field is useful if you can specify a directory that is not in the HTTP Document Root so that database files cannot be accessed directly from a web server.  Web Business Builder will change directory (cd) to the location you specify in this field, and then transfer the database files for your web site. Web Business Builder will create this directory if it does not exist.

Examples:

•If you are unsure we recommend you enter: $ftp_public_dir/$ftp_random_dir •If your account does not offer space outside of the HTTP Document Root, enter: $ftp_public_dir/$ftp_random_dir •If you would like your databases to be placed in a directory called private_dir, enter: $ftp_home_dir/private_dir

Access File

This is the name of an Access Control File that will be used for security purposes.  This field is useful if you are unable to specify a Private Directory that is outside of the HTTP Document Root.  Enter the name of the access control file recognized by your account's web server.

Examples:

•If your web site is running the Windows IIS server, leave this field blank •If your web server is NCSA compliant, enter: .htaccess •Other common values for this field: .bhtaccess

Contents of Access File

The contents of the access control file. Sample .htaccess contents can be found in the configurations files shipped with the product.

Cgi Directory

This is the location for cgi programs you have in your web account.  Your ISP must offer the ability for you to publish your own cgi programs.  (Otherwise, inform your ISP to visit Breakthrough Software's web site to learn about our ISP Partnership program.)  Web Business Builder will change directory (cd) to the location you specify in this field, and then transfer our server executable, webc.  This location can also be your FTP Home directory, or in your public directory.

Examples:

•If you normally FTP to your account and then immediately transfer your cgi programs in, leave this field empty. •If you normally FTP to your account and then change directory to cgi-bin, enter: cgi-bin •If you normally FTP to your account and then change directory to public_html/cgi-bin, enter: public_html/cgi-bin •Other common values for this field: cgi, scripts

WebC Settings

Our server executable, WebC, manages your web site including the Online Store, Discussion Groups, databases, etc.  The parameters in this section tells Web Business Builder where WebC can  be invoked, and where WebC should locate the files for your website.

Access to Public Directory

The Full Path used by WebC to access files in your Public Directory.

When WebC is invoked through HTTP, it will access the file system directly to read files in your public directory.  WebC uses the full path provided in this field to locate the files.  Note: The web server and ftp servers might access files in different ways due to network drives.

Examples:

•If you are unsure, ask your ISP for the full path to your public (HTML) directory.  If they are unable to help you, we recommend you enter: $ftp_public_dir •If the ftp and web servers are located on the same machine and the ftp daemon does not 'chroot' then enter: $ftp_public_dir. •Other common values for this field: /home/user/account/public_html, c:\inetpub\wwwroot\account

Access to Private Directory

The Full Path used by WebC to access your Private Directory.  WebC uses the full path provided in this field to locate the files.  You may need to find out the Document Root for your web account to complete this parameter.

Examples:

•If you entered Private Directory of $ftp_public_dir/$ftp_random_name, enter: $ftp_private_dir •If you are unsure, enter: $ftp_private_dir

HTTP Relative Path

The path component that must be added to your web host URL (http://www.domain.com) in order to locate the HTML pages of your published web site.

Examples:

Note:  $user is a variable that will contain the value you entered in the Userid field of the FTP tab.  $subdir is a variable that will contain the value you entered in the Subdirectory field of the FTP tab.

•If you access a page using http://www.domain.com/home.html, enter: /$subdir •If you access a page using http://www.domain.com/~myaccount/home.html, enter: /~$user/$subdir •If you are unsure, we recommend one of the following:

•If you have a virtual domain account, enter: /$subdir •If you have a Unix ~account, enter: /~$user/$subdir •If you have a Windows non-virtual domain account, enter: /$user/$subdir on Windows.

Script Alias

The component that must be added to your web host URL (http://www.domain.com) in order to run our WebC executable that resides on the web server.  WebC is either PreInstalled on the web server, or it is published as part of your web site into your cgi-bin directory as specified in the Cgi Directory field discussed earlier.

Examples:

•If you access WebC script using http://www.domain.com/cgi-bin/webc.cgi, enter: /cgi-bin/webc.cgi •If you are unsure, we recommend one of the following:

•If you have a Unix account, enter: /cgi-bin/webc.cgi •If you have a Windows account, enter: /cgi-bin/webc.exe

•Note: If your ISP uses a cgi wrapper, please contact them for the proper contents for this field.

Secure Server URL

The full URL to access a page in your web site through a secure server using HTTPS.  This parameter is only useful if your web hosting account includes a secure server.  If this parameter is provide, Web Business Builder will use the secure server when gathering shipping and billing information (including the credit card), and when accessing the Administration area of your web site.

Examples:

•Try this technique for setting the Secure Server URL:

•Once your web site is running, click on the button for your Online Store. •Notice that the URL to get to this page is similar to this:  http://www.domain.com/cgi-bin/webc.cgi/st_main.html •Now, change the URL to get to this page through the secure server.  You might try: https://www.domain.com/cgi-bin/webc.cgi/st_main. •Once you have the secure server URL working, enter this entire URL up to the final slash into the Secure Server URL field: https://www.domain.com/cgi-bin/webc.cgi/

•You may wish to make use of variables such as $user and $subdir if your Secure Server URL contains values that you have entered in those fields.

Home page URL

The full URL to visit the Home Page of your web site.  Once an order is completed in your online store, Web Business Builder will offer a link to return to the Home Page of your web site.  This parameter is used to build that link.

Examples:

•If your home page can be reached at http://www.domain.com, then enter: http://www.domain.com •If you do not have a secure server, leave this field blank

Home page File Name

The name for the home page of your Breakthrough web site.  When publishing, Web Business Builder will use this name for the home page of your site.

Examples:

•If the default file displayed on your web site is index.html, enter: index.html •If you do not want your Breakthrough site to be the default on your web site, enter an alternate name such as: onlinestore.html •Other common values for this field: index.html, index.htm, home.html.

Web Server OS

The Operating system running on the Web Server. Web Business Builder will use this field to select the proper version of WebC to installed on the server.  If WebC has been PreInstalled (or if you wish to supress publishing of webc), set this field to PreInstalled.

Chmod

This chmod argument used to activate the WebC executable on Unix servers.  This parameter is only useful if you have selected a Web Server OS other than PreInstalled or Windows.

Web Business Builder will use telnet access to your account to run the chmod command.  If you do not have telnet access, you will need to make the WebC executable through FTP after you have published, or contact your ISP for assistance.

Examples:

•If you are unsure, we recommend you enter: 4711 •If 4711 does not work, try: 711 •If you must make WebC executable through FTP:

•Publish your web site •Establish an FTP connection using an FTP tool. •Navigate the the webc.cgi file •Set the file to Executable for Owner, Group, and Any.  If you are using command line ftp, use the command: chmod 4711 webc.cgi (If this is not allowed, use: chmod 711)

Payment Processing

Determines if your Online Store will use CyberCash to process orders.  Select this option only after determining that your ISP supports CyberCash for Breakthrough stores.  If you are unsure, please contact your ISP.

Payment Info URL

This field is for ISP use only.  Please contact Breakthrough Software if you are an ISP and you are setting up CyberCash support for Breakthrough stores.

User1

This "User" field may be used if you need to gather additional information and use it for Publishing parameters. The data entered here will be displayed in the Web Properties wizard as a supplemental field.  The information entered by the user in this field can be accessed as $User1Val.

User2

This is another User field that may be used exactly like User1.

User3

This is another User field that may be used exactly like User1.

Variable Names

The following variables can be used in any of the above fields.

 Webmaster email address

                   $email_addr

 Internet Service Provider

                   $isp

 Subdirectory

                   $subdir

 Ftp Server Name

                   $ftp_server

 User Id

                   $user

 Domain Name

                   $domain_name

 User1 Val

                   $user1val

 User2 Val

                   $user2val

 User3 Val

                   $user3val

 Cgi Directory

                   $cgi_dir

 Web Server OS

                   $server_os

 Http Relative Path

                   $http_rel_path

 Webc Ftp Home

                   $webc_ftp_home

 Script Alias

                   $script_alias

 Home Page Url

                   $home_page_url

 Home Page File Name

                   $home_filename

 Public Directory

                   $public_dir

 Secure Server Url

                   $secure_url

 Private Directory

                   $private_dir

 User1

                   $user1

 User2

                   $user2

 User3

                   $user3

 Chmod

                   $chmod

 Access File

                   $accessfile

 Access File Contents

                   $accessfilecont

 Payment

                   $payment

 Company

                   $company

 License Name

                   $license_name

 Serial No

                   $serial_no

 Signature

                   $signature

 Ftp Home Dir

                   $ftp_home_dir

 Ftp Public Dir

                   $ftp_public_dir

 Ftp Private Dir

                   $ftp_private_dir

Translation table from v1.0 to v1.1

These table presents the corespondence between version 1.0 ini variables to version 1.1 variables. This table is usefull mainly

for people who are porting their own publish configurations to version 1.1.

  Remote Web Root

                                          Webc Public Dir

                                          Webc Private Dir

  Remote Server Directory

                                          Public Directory

                                          'Private Directory

  Remote Server Name

                                          Ftp Server Name

  Web Server Cgi Alias

                                          Script Alias

  Web Home File

                                          Home Page File Name

  SECURE_SERVER

                                          Secure Server Url

  Web Server Path

                                          Http Relative Path

  Remote Cgi Directory

                                          Cgi Directory

  OS

                                          OS

  PAYMENT_PROCESSING

                                          Payment