4 Managing Data with Data Workshop

This section describes how to use Data Workshop to import data and export data using a Web Browser.

This section contains the following topics:

About Data Workshop
Importing Data
Exporting Data

About Data Workshop

Oracle HTML DB renders information stored in an 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 Workshop icon on the Workspace home page. (See Figure 4-1.)

Figure 4-1 Data Workshop 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 Data Workshop on the Workspace home page.
Under Data Import, click Import Text Data.

The Data Import Wizard appears.
Under Import To, select either Existing table or New table.
Under Import from, select either 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 Data Workshop on the Workspace home page.
Under Data Import, click XML Import.

The Import XML 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 Data Workshop on the Workspace home page.
Under Data Import, click Import Spreadsheet Data.

The Import Spreadsheet Data Wizard appears.
Under Import to, select either Existing table or New table.
Under Import from, select either Upload file or Copy and paste.
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 Export Text Data 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 Data Workshop on the Workspace home page.
Under Data Export, click Export Text Data.

The Export Text Data 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 Export XML 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 Data Workshop on the Workspace home page.
Under Data Import, click XML Export.

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

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