About the Create Application from Spreadsheet Wizard

Previous

Next

---

You can create an application based on spreadsheet data by selecting Create Application from Spreadsheet in the Create Application Wizard.

To create an application from spreadsheet data:

1. On the Database Home Page, click the Application Builder icon.

2. Click the Create button.

3. Select Create Application from Spreadsheet.

4. Specify how spreadsheet data will be uploaded. Select one of the following and click Next:

   1. Upload file (comma-delimited or tab-delimited). Specify the following and click Next:

      • File - Click Browse to locate the file to be uploaded.

      • Separator - Specify the column separator character. Use \t for tab separators.

      • Optionally Enclosed By - Enter a delimiter character. You can use this character to delaminate the starting and ending boundary of a data value. If you specify a delimiter character, the wizard ignores white space occurring before the starting and ending boundary of a data value. You can also use this option to enclose a data value with the specified delimiter character.

      • File Character Set - Choose the character set in which the text file is encoded.

   2. Copy and paste (up to 30KB). Copy and paste the spreadsheet data you wish to import and click Next.

5. Review the preview of how your table will display and click Next. Specify the table name and column names, modify the data types, or specify which columns to include.

6. Review the displayed Singular Name and enter a Plural Name.

   Column User Interface Defaults display default label names.

7. (Optional) Under Column User Interface Defaults, edit the displayed Label names and click Next.

8. For Summary By Column, select the columns for which data will be summarized in reports and charts and click Next.

9. This wizard creates several summary reports. Select columns for which values will be aggregated in summary reports.

   1. Aggregate by Column - Choose one or more columns for which you want data summarized or averaged.

   2. Aggregate Function to Use - Select the aggregate function to use in the report (Sum or Average).

   3. Click Next.

10. Select Application Options:

    1. Application Name - Enter an alphanumeric name for this application.

    2. Specify a Create Mode:

       • Read and Write includes insert and update pages.

       • Read Only does not include insert and update pages.

    3. Select a chart type.

    4. Click Next.

11. Select a theme and click Next.

    Themes are collections of templates that can be used to define the layout and style of an entire application. See "Managing Themes".

12. Confirm your selections. To return to a previous wizard page, click Previous. To accept your selections, click Create.