HowTo:Import Data from an External System

For:   Designers Level: Beginner Time:  20 minutes See more:     ◾ HowTo Guides

If you have data in an external system, you can generally export it as a plain text file, with one record per line, where values in each line are separated by values. That kind of file is known as comma-separated value (Template:CSV) file. Using such files, you can import data into your application objects.

In this guide, you'll create a few items of data in a spreadsheet, and use that. But the data could come from any system that is capable of exporting CSV data.

Preparation

Using process described in the first step of HowTo:Create_a_Simple_Application, use the Application Builder to create a Movie Reviews application. (Learn more:HowTo:Create_a_Simple_Application#Use the Wizard to Create the Application|Use the Wizard to Create the Application]].)

The application should have the following objects and fields:

• Movies
  • Title (Text Field)
  • Theater Release (Date)
  • DVD Release (Date)

• Reviews
  • Rating (Number)
    (This will be a value in the range 1..5. Edit the field after the application is created to specify the range.)
  • Reason (Text Area)

• Reviewers
  • Name (Text Field)

And it should have the following relationships:

• One Movie can have many Reviews.
• One Reviewer can have many Reviews.

Create a Spreadsheet with Sample Data

1. Create Customer data
2. Create Order data
3. Create Order Item data

Export the Data as CSV Files

1. Export Customer data
2. Export Order data
3. Export Order Item data

Import the Data

The process here is to start at the top of the lookup chain, so that the Lookups in the incoming record all resolve to an actual record. (It isn't strictly necessary to do things in that order, but it's good form.)

Coming soon...