Close the import wizard for the descriptor resources.
Now choose Data -> Import ->
Wizard ->
Import resources ->
State 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. Deselect the step
Descriptor, it
is not needed since the categorical states have been assigned unambiguous external
IDs in step 3. Check the steps
Categorical state and
State resource
(see below).
We attach the state resource values to the categorical
states, therefore we will not change anything in the categorical state but will
attach data. In import step
Attachment
at the right side select
Categorial state
id (see below).
Select the import step
Merge from the list. For
Categorical state 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
Categorical state and
State resource
and below them the data groups of the import steps. Deselect every column from import
step
Categorical state except "id". Mark the "id" column
as
Key column for comparison during attachment
and click on
From file to select the column "StateID" as data source.
The "id" column of import step
Categorical state now looks as shown below.
In the import step
State resource click
on
Resource ID and in the center window the assignemt 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 second
data line 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 561 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 categorical state.