|
Running 'SM3' created 'SELITE.csv' in 'Works' directory
(see previous page).
It is easy to import that file to IDEA with IDEA's import assistant.
|
|
|
Starting the file import
|
 |
| Picture 1 |
|
 |
| Picture 2 |
|
 |
| Picture 3 |
|
 |
| Picture 4 |
|
 |
| Picture 6 |
|
|
| - |
First select: 'File - Import Assistant - Import to IDEA - ASCII or EBCDIC (Text)').
File explorer starts.
|
| - |
Select a csv file (here: 'SELITE.csv') made by 'SM3' (picture 1).
|
| - |
click 'Open' and then 'Next'.
A dialog window ('Import Assistant - File Type') is opened.
|
|
|
Dialog 'Import Assistant - File Type'
|
| - |
Select field type 'Delimited' in order to have the data appear correctly
('Fixed length' is default) (picture 2).
|
| - |
You will notice that there are extra fields 'A' and 'Z' in the file.
Their function will be descibed later.
|
| - |
If you had chosen 'InField' ('OBJECT') twice
there would be only five fields ('A'; 'RECNO'; 'SELITE'; 'OBJECT'; 'Z') in the file.
|
| - |
Finally, click 'Next'.
|
| |
|
Dialog 'Import Assistant - Specify Field Separatior and Text Encapsulator'
|
| - |
Select 'Semicolon' as field separator. Select 'Nothing' as text encapsulator
(picture 3).
|
| - |
Select 'First visible row is field names' (picture 3).
|
| - | Finally click 'Next'.
|
| - |
As a result your csv file should be devided into columns -
just like 'SELITE.csv' in the picture to the right.
However, if you selected 'IsField' (here: 'Object') also as 'Another field'
the number of columns will be five in stead of six.
|
|
|
Dialog 'Import Assistant - Field Details' |
| - |
You can exclude fields 'A' and 'Z' from the becoming IDEA file.
Those fields exist in the file to get rid of the quotation marks
that IDEA inserts in the beginning and end of a text file.
Select 'A' and 'Z' one by one and select 'Do not import this field'
(picture 4).
|
| - |
Click 'Next', and you will come to a dialog (not shown here)
where you can create virtual or editable fields to imported file.
Insert fields, if you want, and click 'Next'.
|
|
|
Dialog 'Import Assistant - Specify IDEA File Name'
|
| - |
You have a possibility decide whether to generate field statistics, whether to rename file definition
of the file that will be imported to IDEA, whether to rename the file itself (picture 5).
|
| - |
You can e.g. rename the definition of six field csv file 'SM3_6',
and the one of five field csv file as 'SM3_5'.
|
| - |
You can also create a record number field.
|
| - |
Click 'Ready', and the SEM3 cvs file will be imported to IDEA (picture 6).
|
|
 | |
Picture 5 |
|
|
|
'SM3' csv file is imported to IDEA
|
| - |
In the example here we could e.g.
join its 'CODE' and 'OBJECT' with the records of 'InFile' ('G98')
- using RECNO as key for join - with the following results:
|
| - |
|
In the example here we join its 'CODE' and 'OBJECT' with the records of 'InFile',
'RECNO' as key for join. The results are shown in picture 7.
|
 | |
Picture 7 |
|
|
|