4 Managing Data with Data Workshop

This section describes how to use Data Workshop to import data into and export data from your hosted database.

This section contains the following topics:

About Data Workshop
Importing Data
Exporting Data

See Also:

About Data Workshop

Oracle HTML DB renders information stored in a Oracle database to create a collection of database-driven Web pages called an application. Using Data Workshop you can import data into and export data from the hosted database. Supported import formats include:

Text such as comma or tab delimited data
XML documents
Spreadsheets

Supported export formats include:

Text such as comma or tab delimited data
XML documents

To access Data Workshop:

Click the Data icon. (See Figure 4-1.)

Figure 4-1 Data Icon

Description of the illustration htmldb_datico.gif
Under Data Import and Data Export, click the appropriate link.

Importing Data

You can use Data Workshop to import text files, XML documents, and data stored in a spreadsheet into an Oracle database.

Topics in this section include:

Importing a Text File
Importing an XML Document
Importing Spreadsheet Data

Importing a Text File

For files less than 30KB, you can copy and paste tab delimited data directly into the Import Text Wizard. For files larger than 30KB, you must upload a separate file.

To load a text file:

Click the Data icon.
Under Data Import, click Import Text Data.

The Import Text Data Wizard appears.
Under Import to, select Existing table or New table.
Under Import from, select Upload file or Copy and paste.
Follow the on-screen instructions.

Importing an XML Document

Data Workshop supports the import of XML documents adhering to the Canonical XML specification.

To import an XML document:

Click the Data icon.
Under Data Import, click XML Data.

The XML Import Wizard appears.
Follow the on-screen instructions.

Importing Spreadsheet Data

You can load spreadsheet data by either copying and pasting text, or by importing a file. To copy and paste text, the spreadsheet file must be less than 30KB. For files larger than 30KB, you can import the file in a delimited format (such as comma delimited (.csv) or tab delimited), upload the file, and then load the data into a new or existing table.

To import spreadsheet data:

Click the Data icon.
Under Data Import, click Import Spreadsheet Data.

The Spreadsheet Data Import Wizard appears.
Under Import to, select Existing table or New table.
Under Import from, select Copy and paste or Upload file.
Follow the on-screen instructions.

Exporting Data

You can also use Data Workshop to export the contents of a table to a text file or XML document.

Topics in this section include:

Exporting to a Text File
Exporting to an XML Document

Exporting to a Text File

Use the Text Export Wizard to export the contents of a table to a text file. For example, you could export an entire table to a comma delimited file (.csv).

To export a table to a text file:

Click the Data icon.
Under Data Export, click Export Text Data.

The Text Data Export Wizard appears.
Follow the on-screen instructions.

You select the schema and choose the table and columns to be exported. You can also specify the type of separator to be used to separate column values as well as whether column text strings are identified using single or double quotation marks.

Exporting to an XML Document

Use the XML Export Wizard to export the contents of a table to an XML document adhering to the Canonical XML specification.

To export a table to an XML document:

Click the Data icon.
Under Data Import, click XML Export.

The XML Export Wizard appears.
Follow the on-screen instructions.

You select the schema and choose the table and columns to be exported.