Skip Headers
Oracle® HTML DB User's Guide
Release 1.6

Part Number B14303-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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

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:

Supported export formats include:

To access Data Workshop:

  1. Click the Data Workshop icon on the Workspace home page. (See Figure 4-1.)

  2. 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

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:

  1. Click Data Workshop on the Workspace home page.

  2. Under Data Import, click Import Text Data.

    The Data Import Wizard appears.

  3. Under Import To, select either Existing table or New table.

  4. Under Import from, select either Upload file or Copy and paste.

  5. 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:

  1. Click Data Workshop on the Workspace home page.

  2. Under Data Import, click XML Import.

    The Import XML Wizard appears.

  3. 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:

  1. Click Data Workshop on the Workspace home page.

  2. Under Data Import, click Import Spreadsheet Data.

    The Import Spreadsheet Data Wizard appears.

  3. Under Import to, select either Existing table or New table.

  4. Under Import from, select either Upload file or Copy and paste.

  5. 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

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:

  1. Click Data Workshop on the Workspace home page.

  2. Under Data Export, click Export Text Data.

    The Export Text Data Wizard appears.

  3. 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:

  1. Click Data Workshop on the Workspace home page.

  2. Under Data Import, click XML Export.

    The Export XML Wizard appears.

  3. Follow the on-screen instructions.

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