Exercise Two - Import Your Data

Top  Previous  Next

1.

If you haven’t done so already, maximize your dictionary window. It’s not much to look at right now, so let’s import some data definitions. In the GettingStarted folder, we have placed some sample data files. In this exercise, we will import a set of customers, and their orders.

2.

From the DCT Explorer’s toolbar menu, choose the Import Tables option as shown here:

 

 

The Table Import Wizard window appears.

3.

In the Select Server prompt, select TopSpeed Files from the drop list (It’s at the bottom of the drop list). At the time of this release, there are 15 different import formats available for import in the drop list.

4.

Select the Select Dictionary prompt, and press the ellipsis button (you can also press the Next button at the bottom). The Select Database window appears.

 

 

5.

Press the ellipsis button to the right of the Files prompt.

6.

Another Select Files window appears, but this time it is a file dialog where you can select a file name. Navigate to the \Lessons\GettingStarted folder, and holding your CTRL key down, highlight the CUSTOMER.TPS file (The TPS is the TopSpeed default file extension) and the ORDERS.TPS and press the Open button.

7.

We are now back at the original Select Database window. Press the OK button to begin to import the files.

8.

The DCT Explorer displays your imported tables.

 

 

That’s the basics for a file import. Of course, there are many other options and techniques that you can use to import data definitions, but we are only getting started.

To review, the dictionary will be used with the application generator to help match and locate the data that we are planning to process.

 

 

At this time, your dictionary is auto-saved after the import, so let’s proceed to Exercise Three.

 

Exercise Three - Relate Your Tables