Close the import wizard for the state resources. Now choose
Data -> Import ->
Wizard ->
Import resources ->
Description resources ... from the menu, select the session for project
"Deemy". The following window opens that will lead you through the import
of the categorical state resource data. Open file "Deemy_RSC.txt" (see
below).
In the selection list on the left side of the window all
possible import steps for the data are listed according to the type of data you
want to import. Step
Description is already selected. Aditionally check step
Description resource
(see below).
We attach the description resource values to the descriptions,
therefore we will not change anything in the description but will attach data. In
import step
Attachment
at the right side select
Description
id (see below).
Select the import step
Merge from the list. For
Description we select the
Attach option because this tables shall not be changed, for the
other step
Insert should already be selected, because a new entry has to be inserted
(see below).
In the step table at the right side you find the import
steps
Description and
Description resource
and below them the data groups of the import steps. Deselect every column from import
step
Description except "id". Mark the "id" column as
Key column for comparison during attachment
and click on
From file to select the column "ItemID" as data source. The
"id" column of import step
Description now looks as shown below.
In the import step
Description resource
clickon
Resource ID and in the center window the assignment data for the
resource id ("id") are displayed. Click on
to make this the decisive column, further click on
From file to select the column "Resource" as data source.
After that the column should look as shown below.
Click on
Resource name. The center window shows the data column "label".
Click on
From file in the "label" line to select file column "Resource".
After the resource number the value in data column "Caption" shall be
inserted, included in brackets, if it is present. Click on the
button at the end of line "label" and select column "Caption".
Enter ( (blank and opening bracket)
in field Pre.: and )
in field Post.: of the new line. After that the column should look
as shown below.
Finally click on
Sequence number. In the center
window select the data column "display_order", click on
From file and select file column "DisplayOrder" (see below).
To test if all requirements for the import are met use
the
Testing step. The test for the data
line 717 is shown below.
With the last step you can start to import the data into the database. If you want to repeat the import with the same settings and data of the same structure, you can save a schema of the current settings. There are 177 lines that were not imported due to duplicate entries (see below).
The failed lines are caused by duplicate entries, i.e. the resource was already imported for the description.