Can I publish my CatBase data on my website?

Q: Can my CatBase data be used to power a website database?

There are two ways to use your data on a website, assuming that the website's back end is running on a database such as MySql or Sql Server:

Using CatBase Data Chameleon Edition: If you are using the Data Chameleon Edition, you can upload data directly to your online database via an ODBC connection.

Create a new Connection by going to Admin->Data Connections->New Connection
Fill in the required connection details and make sure that you select the appropriate connection type (eg MySql, SqlServer, etc.)
Save your new Connection
Create a new Publishing Stylesheet in the data table that you want to publish
Go to the Preferences tab
Choose MySql Database or ODBC Connection from the Default Publishing Destination pop-up menu
Some new options will appear
From the Connection popup, choose the Connection you set up.
CatBase will connect to the remote database and get a list of its tables.
From the Tables popup, choose the table that you want to publish the data to.
CatBase will try to map the fields in the remote database table to the fields in the CatBase table.
You will then see the field mapping on the Field Map tab

Export data to a text file: You can create a delimited text file from a CatBase data table and import it into your online database. Typically you will create a tab-delimited or CSV (Comma-Separated Values) file. To do this:

Create a new Publishing Stylesheet in the table that you want to publish
Go to the Preferences tab
From the Default Publishing Destination popup menu, choose Plain Text
Choose the Text tab in the second row of tabs
The default field delimiter is a Tab - so this would create a tab-delimited text file.
To create a CSV file, choose Comma from the Field Delimiter popup
Change the other settings if necessary
Go back to the Paragraphs tab
Add ONE Paragraph
Add as many Elements as you need to that Paragraph - ie, add one Element for each field you want to export
You do not need to add any punctuation or delimiter Elements to the Paragraph - CatBase will insert the appropriate field and record delimiters as specified on the Text tab.
Publish your data using this Publishing Stylesheet
That will create a text file
Import the text file into the appropriate table in your online database