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