Skip Headers
Oracle® Application Express End User's Guide
Release 4.1

Part Number E26811-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

Importing Data from a File into Your Application

In order to upload data to your application, the application must have been built with Data Upload capability and the file must be formatted properly.

To illustrate how you can use the Data Load wizard to import data from a text file, the following section demonstrates the upload process and includes examples from the sample database application, Product Portal.

To import data from a file into your application:

  1. Log into your application.

  2. Launch the Data Load wizard.

    The first page of the Data Load wizard appears.

  3. For Import From, select Upload file, comma separated (*.csv) or tab delimited.

    The Data Load Source page appears with options for loading from a data file. The following example shows an example Data Load Source page for the Sample Application.

    Description of data_load_source.gif follows
    Description of the illustration data_load_source.gif

  4. For Data Source Load, make the following additional selections and entries:

    1. File Name - Browse to or enter the path and file name containing the data to upload.

      The following example shows an example customer.txt data load file.

      Description of customer.gif follows
      Description of the illustration customer.gif

    2. Separator - Enter the column separator character. Use \t for tab separators.

    3. Optionally Enclosed By - Enter a delimiter character if you want to delineate the start and end boundary of a data value.

    4. First Row has Column Names - Select Yes if your data contains column names in the first row.

  5. For Globalization, make the following entries:

    1. Currency Symbol - If your data contains an international currency symbol, enter it here. For example, if your data has "$1,234.56" or "¥1,234.56", enter $ or ¥. Otherwise the data may not load correctly.

    2. Group Separator - If your data contains a group separator enter it here. A group separator is a character that separates integer groups, for example to show thousands and millions.

      Any character can be the group separator. The character specified must be single-byte, and the group separator must be different from any other decimal character. The character can be a space, but cannot be a numeric character or any of the following: plus (+), hyphen (-), less than sign (<), or greater than sign (>).

    3. Decimal Character - If your data contains a decimal character, enter it here. The decimal character separates the integer and decimal parts of a number. Any character can be the decimal character. The character specified must be single-byte, and the decimal character must be different from any other group separator. The character can be a space, but cannot be a numeric character or any of the following: plus (+), hyphen (-), less than sign (<), or greater than sign (>)

  6. Click Next.

    The Data/Table Mapping page appears.

    The example below is an example Data/Table Mapping page after importing data from the customer.txt file.

    Description of data_table_mapping.gif follows
    Description of the illustration data_table_mapping.gif

  7. For Data/Table Mapping, make the following selections and entries:

    1. Column Names - The destination column name that will be uploaded with the data in this column.

      If the first row does not contain the column names and the First Row has Column Names option was set to Yes, the Column Names fields will be populated with the column names from the first row of the upload data file. You can change these names by selecting the destination column name this data will be uploaded to, or set to do not load if you do not want to upload data in this column.

      If the First Row has Column Names option was not set to Yes, the column sets the default to do not load. In this case you need to select from the drop down list for each column name, the name of the column this data will be uploaded to.

    2. Date/Number Format - Most of the standardized date and number formats are automatically parsed and then passed to the database. If you want to define your own format or the format is not an automatically parsed format, use this field to define your own. See "Automatically Supported Date, Timestamp and Number Formats".

  8. Click Next.

    The Data Validation page appears showing the data that will be inserted or updated after any table lookup and transformation rules have been applied. For more information regarding table look up and transformation rules, see "About Using the Data Loading Wizard".

    The following illustration shows that once the data from the customer.txt file is uploaded, customer information for Edward Logan will be updated and three new customers will be added.

    Description of validation.gif follows
    Description of the illustration validation.gif

  9. For Data Validation, review the data to be uploaded and click Load Data.

    The Data Load Results page appears.

    This illustration shows the Data Load Results page after the Sample Application has imported the data contained in the customer.txt file.

    Description of data_load_results.gif follows
    Description of the illustration data_load_results.gif

  10. The Data Load Results page shows the following:

    • Inserted Row(s) - This is the number of new rows uploaded to the table.

    • Updated Row(s) - This is the number of rows in the table updated with new information.

    • Failed Row(s) - This is the number of rows from the upload file that were not added or updated.

  11. Click Finish to exit the wizard.