Set up datasource from Text files
PREREQUISITE
- First create a datasource
to import data to.
-
Copy source text files
to a folder.
FROM DB2DIR
- Run db2dir.
- Select the ODBCl datasource File,
the Open source ( prerequisite 1 ).
- In the File menu , select Configure
and Import a Texts source. Select the working folder that holds the text
files to import ( prerequisite 2 ).
- You will be prompted to analyse
each text file's fields. The intended format can be checked on the sample of
the first row (press Apply format). Step 4 is repeated for
each file in the folder. Discard any file you don't want to import (press
Discard).*
-
A lissu de létape précédente une base de donnée texte est constituée.
Le dossier matérialise une base de donnée source. Chaque fichier texte matérialise une
table de la base.** Reste à sélectionner une source, une destination ( ELEVES ou
PROFS ) et Importer.***
* GEP file format: fixed-size fields (25 for NAME, 25
for FIRSTNAME, 5 for GROUP), with OEM character set.
** Incidentally : a SCHEMA.INI records format information.
*** The retained analysis of the
format can be displayed. If everything's works fine, you can for example see a eleves#txt
root with 3 branches NAME, FIRSTNAME, GROUP
See Procedures