I N D E X    

Import in datafile csv format

import_script.php allows imports into the database file
csv
downloaded
Example: / rec / utilisateur.txt

The description of the transfer is in the file extension in import_nomobjet.inc / rec:

example: import_script.php? obj = user

in import_utilisateur.inc , it is defined:

- $ Import = "Insert User": Message
- $ Table = "user": Import table
- $ Id = "userid" field AutoDial / otherwise empty
- $ Lock = 1 update to the base = 0 no update => test phase
- $ 1 = DEBUG records to display the screen 0 = no display
- $ Fic_erreur = 1, / / 0 = no error file d / = 1 file error
- $ Fic_rejet = 1, / / 0 = not file for re / = 1 file relance treatment
This file contains records in error and can revive the
treatment after correction (manual)

Line1 = $ 1 => the first line contains the field names / 0 otherwise

Required

$ mandatory [ 'name'] = 1; / / mandatory
= 1 $ mandatory [ 'login'] = 1; / / 1 = mandatory

test of existence

$ exist [ 'profile'] = 1 => 0 = no / 1 = yes
$ sql_exist [ 'profile'] = "select profile from profile where profile ="

list of areas to insert
to review areas not covered
$ zone [ 'name'] ='0 '=> the 1st area contains the name
$ zone [ 'login'] = 1 => 2nd zone contains login
$ zone [ 'pwd'] ='2 '=> 3eme the area contains the password (encrypted)
$ zone [ 'profile'] ='3 '=> the 4 th zone contains profile

Default If $ zone [ 'profile']="" we can define a default profile
$ default [ 'profile'] ='5 '=> profile default = 5