dolibarr 20.0.0
|
Class to import CSV files. More...
Public Member Functions | |
__construct ($db, $datatoimport) | |
Constructor. | |
write_header_example ($outputlangs) | |
Output header of an example file for this format. | |
write_title_example ($outputlangs, $headerlinefields) | |
Output title line of an example file for this format. | |
write_record_example ($outputlangs, $contentlinevalues) | |
Output record of an example file for this format. | |
write_footer_example ($outputlangs) | |
Output footer of an example file for this format. | |
import_open_file ($file) | |
Open input file. | |
import_get_nb_of_lines ($file) | |
Return nb of records. | |
import_read_header () | |
Input header line from file. | |
import_read_record () | |
Return array of next record in input file. | |
import_close_file () | |
Close file handle. | |
import_insert ($arrayrecord, $array_match_file_to_database, $objimport, $maxfields, $importid, $updatekeys) | |
Insert a record into database. | |
Public Member Functions inherited from ModeleImports | |
__construct () | |
Constructor. | |
getDriverId () | |
getDriverId | |
getDriverLabel () | |
getDriverLabel | |
getDriverDesc () | |
getDriverDesc | |
getDriverExtension () | |
getDriverExtension | |
getDriverVersion () | |
getDriverVersion | |
getLibLabel () | |
getDriverLabel | |
getLibVersion () | |
getLibVersion | |
listOfAvailableImportFormat ($db, $maxfilenamelength=0) | |
Load into memory list of available import format. | |
getPictoForKey ($key) | |
Return picto of import driver. | |
getDriverLabelForKey ($key) | |
Return label of driver import. | |
getDriverDescForKey ($key) | |
Return description of import drivervoi la description d'un driver import. | |
getDriverVersionForKey ($key) | |
Renvoi version d'un driver import. | |
getLibLabelForKey ($key) | |
Renvoi libelle de librairie externe du driver. | |
getLibVersionForKey ($key) | |
Renvoi version de librairie externe du driver. | |
getElementFromTableWithPrefix ($tableNameWithPrefix) | |
Get element from table name with prefix. | |
Class to import CSV files.
Definition at line 35 of file import_csv.modules.php.
ImportCsv::__construct | ( | $db, | |
$datatoimport ) |
Constructor.
DoliDB | $db | Database handler |
string | $datatoimport | String code describing import set (ex: 'societe_1') |
Definition at line 82 of file import_csv.modules.php.
References dol_syslog(), getDolGlobalString(), GETPOST(), versioncompare(), and versionphparray().
ImportCsv::import_close_file | ( | ) |
ImportCsv::import_get_nb_of_lines | ( | $file | ) |
Return nb of records.
File must be closed.
string | $file | Path of filename |
Definition at line 213 of file import_csv.modules.php.
References dol_count_nb_of_line().
ImportCsv::import_insert | ( | $arrayrecord, | |
$array_match_file_to_database, | |||
$objimport, | |||
$maxfields, | |||
$importid, | |||
$updatekeys ) |
Insert a record into database.
array | $arrayrecord | Array of read values: [fieldpos] => (['val']=>val, ['type']=>-1=null,0=blank,1=string), [fieldpos+1]... |
array | $array_match_file_to_database | Array of target fields where to insert data: [fieldpos] => 's.fieldname', [fieldpos+1]... |
Object | $objimport | Object import (contains objimport->array_import_tables, objimport->array_import_fields, objimport->array_import_convertvalue, ...) |
int | $maxfields | Max number of fields to use |
string | $importid | Import key |
array | $updatekeys | Array of keys to use to try to do an update first before insert. This field are defined into the module descriptor. |
Definition at line 307 of file import_csv.modules.php.
References dol_include_once(), dol_print_error(), dol_stringtotime(), dol_syslog(), dol_trunc(), getDolGlobalString(), ModeleImports\getElementFromTableWithPrefix(), num2Alpha(), price2num(), and testSqlAndScriptInject().
ImportCsv::import_open_file | ( | $file | ) |
Open input file.
string | $file | Path of filename |
Definition at line 183 of file import_csv.modules.php.
References dol_osencode(), and dol_syslog().
ImportCsv::import_read_header | ( | ) |
Input header line from file.
Definition at line 226 of file import_csv.modules.php.
ImportCsv::import_read_record | ( | ) |
Return array of next record in input file.
Definition at line 239 of file import_csv.modules.php.
References dol_strlen(), getDolGlobalString(), and utf8_check().
ImportCsv::write_footer_example | ( | $outputlangs | ) |
Output footer of an example file for this format.
Translate | $outputlangs | Output language |
Definition at line 169 of file import_csv.modules.php.
ImportCsv::write_header_example | ( | $outputlangs | ) |
Output header of an example file for this format.
Translate | $outputlangs | Output language |
Definition at line 126 of file import_csv.modules.php.
ImportCsv::write_record_example | ( | $outputlangs, | |
$contentlinevalues ) |
Output record of an example file for this format.
Translate | $outputlangs | Output language |
array | $contentlinevalues | Array of lines |
Definition at line 155 of file import_csv.modules.php.
ImportCsv::write_title_example | ( | $outputlangs, | |
$headerlinefields ) |
Output title line of an example file for this format.
Translate | $outputlangs | Output language |
array | $headerlinefields | Array of fields name |
Definition at line 140 of file import_csv.modules.php.