HowTo:Import Data from an External System

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, we'll assume that data comes from an Excel spreadsheet. But it could come from any system that is capable of exporting

Preparation

This HowTo Guide builds on HowTo:Create_a_Simple_Application. If you haven't done that one yet, run through it now to create the objects you'll be importing data into.

If you have already worked through that guide, and you've created records to see how things work, let's start by doing a Mass Delete of any data you may have entered, so as to import into a fresh collection objects.

Just as a matter of good form, we're first going to delete the records at the bottom of the "lookup chain". Then we'll work our way up the chain. That way, we're sure that no record is left with a pointer to a target record that doesn't exist.

1. Visit Workspace > OrderItems
2. At the left edge of the table's header row, click All
3. At the top of the window, click [More Actions...]
   A dropdown appears.
4. Select Delete
5. Repeat the process for Orders
6. Repeat the process for Customers

More

Coming soon...