Set up datasource from Text files

PREREQUISITE

  1. First create a datasource to import data to.
  2. Copy source text files to a folder.

FROM DB2DIR

  1. Run db2dir.
  2. Select the ODBCl datasource File, the Open source ( prerequisite 1 ).
  3. In the File menu , select Configure and Import a Texts source. Select the working folder that holds the text files to import ( prerequisite 2 ).
  4. 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).*
  5. A l’issu 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