This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Collaboration diagram for ilDclContentImporter:

Public Member Functions
	__construct (int $ref_id, ?int $table_id=null)

	import (string $file, bool $simulate=false)

Data Fields
const	EXPORT_EXCEL = 'xlsx'

Protected Member Functions
	checkImportType (ilDclBaseFieldModel $field)

	getImportFieldsFromTitles (ilDclTable $table, array $titles)

Protected Attributes
int	$max_imports = 100

array	$supported_import_datatypes

array	$warnings

int	$ref_id
	Ref-ID of DataCollection. More...

int	$table_id
	Table-Id for export. More...

ilObjDataCollection	$dcl

array	$tables

ilLanguage	$lng

ilObjUser	$user

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning

Definition at line 19 of file class.ilDclContentImporter.php.

Constructor & Destructor Documentation

◆ __construct()

ilDclContentImporter::__construct	(	int	$ref_id,
		?int	$table_id = `null`
	)

Definition at line 55 of file class.ilDclContentImporter.php.

References $DIC, $ref_id, $table_id, ILIAS\Repository\lng(), and ILIAS\Repository\user().

     {
         global $DIC;
 
         $this->ref_id = $ref_id;
         $this->table_id = $table_id;
 
         $this->lng = $DIC->language();
         $this->user = $DIC->user();
 
         $this->dcl = new ilObjDataCollection($ref_id);
         $this->tables = ($table_id) ? [$this->dcl->getTableById($table_id)] : $this->dcl->getTables();
     }

Here is the call graph for this function:

Member Function Documentation

◆ checkImportType()

ilDclContentImporter::checkImportType ( ilDclBaseFieldModel $field )

protected

Definition at line 174 of file class.ilDclContentImporter.php.

References $supported_import_datatypes, ilDclBaseFieldModel\getDatatypeId(), ilDclBaseFieldModel\getTitle(), and ILIAS\Repository\lng().

Referenced by getImportFieldsFromTitles().

                                                                   : bool
     {
         if (in_array($field->getDatatypeId(), $this->supported_import_datatypes)) {
             return true;
         } else {
             $this->warnings[] = $field->getTitle() . ": " . $this->lng->txt("dcl_not_supported_in_import");
 
             return false;
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getImportFieldsFromTitles()

ilDclContentImporter::getImportFieldsFromTitles	(	ilDclTable	$table,
		array	$titles
	)

protected

Parameters

string[] $titles

Returns: ilDclBaseFieldModel[]

Definition at line 189 of file class.ilDclContentImporter.php.

References ILIAS\LTI\ToolProvider\$key, ilDclStandardField\_getImportableStandardFieldTitle(), ilDclStandardField\_getNonImportableStandardFieldTitles(), checkImportType(), ilDataCollectionImporter\getExcelCharForInteger(), ilDclTable\getRecordFields(), and ILIAS\Repository\lng().

Referenced by import().

                                                                                   : array
     {
         $fields = $table->getRecordFields();
         $import_fields = array();
         foreach ($fields as $field) {
             if ($this->checkImportType($field)) {
                 // the fields will add themselves to $import_fields (at the correct position) if their title is in $titles
                 $field->checkTitlesForImport($titles, $import_fields);
             }
         }
 
         foreach ($titles as $key => $value) {
             $not_importable_titles = ilDclStandardField::_getNonImportableStandardFieldTitles();
             $importable_titles = ilDclStandardField::_getImportableStandardFieldTitle();
             foreach ($importable_titles as $identifier => $values) {
                 if (in_array($value, $values)) {
                     $std_field = new ilDclStandardField();
                     $std_field->setId(substr($identifier, 4));
                     $import_fields[$key] = $std_field;
                     continue 2;
                 }
             }
             if (in_array($value, $not_importable_titles)) {
                 $this->warnings[] = "(1, " . ilDataCollectionImporter::getExcelCharForInteger($key) . ") \"" . $value . "\" " . $this->lng->txt("dcl_std_field_not_importable");
             } else {
                 if (!isset($import_fields[$key])) {
                     $this->warnings[] = "(1, " . ilDataCollectionImporter::getExcelCharForInteger($key + 1) . ") \"" . $value . "\" " . $this->lng->txt("dcl_row_not_found");
                 }
             }
         }
 
         return $import_fields;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ import()

ilDclContentImporter::import	(	string	$file,
		bool	$simulate = `false`
	)

Exceptions

ilException

Definition at line 74 of file class.ilDclContentImporter.php.

References Vendor\Package\$e, $i, $warnings, ilDataCollectionImporter\getExcelCharForInteger(), getImportFieldsFromTitles(), IL_CAL_UNIX, ILIAS\Repository\lng(), and ILIAS\Repository\user().

Referenced by ilDclRecordListGUI\importRecords().

                                                                 : array
     {
         $this->warnings = [];
         try {
             $excel = new ilExcel();
             $excel->loadFromFile($file);
         } catch (Exception $e) {
             $this->warnings[] = $this->lng->txt("dcl_file_not_readable");
         }
 
         $sheet_count = $excel->getSheetCount();
         $excel->setActiveSheet(0);
 
         if ($sheet_count != count($this->tables)) {
             $this->warnings[] = $this->lng->txt('dcl_file_not_readable');
         }
 
         if (count($this->warnings)) {
             return ['line' => 0, 'warnings' => $this->warnings];
         }
 
         for ($sheet = 0; $sheet < $sheet_count; $sheet++) {
             $excel->setActiveSheet($sheet);
             $table = $this->tables[$sheet];
 
             // only 31 character-long table-titles are allowed
             $sheet_title = substr($table->getTitle(), 0, 31);
             if ($excel->getSheetTitle() != $sheet_title) {
                 $this->warnings[] = $this->lng->txt('dcl_table_title_not_matching');
                 continue;
             }
 
             $field_names = [];
             $sheet_data = $excel->getSheetAsArray();
 
             foreach ($sheet_data[0] as $column) {
                 $field_names[] = $column;
             }
             $fields = $this->getImportFieldsFromTitles($table, $field_names);
 
             $records_failed = 0;
             for ($i = 2; $i <= count($sheet_data); $i++) {
                 $record = new ilDclBaseRecordModel();
                 $record->setOwner($this->user->getId());
                 $date_obj = new ilDateTime(time(), IL_CAL_UNIX);
                 $record->setCreateDate($date_obj);
                 $record->setLastUpdate($date_obj);
                 $record->setLastEditBy($this->user->getId());
                 $record->setTableId($table->getId());
                 if (!$simulate) {
                     $record->doCreate();
                 }
                 $fields_failed = 0;
                 foreach ($fields as $col => $field) {
                     try {
                         if ($field->isStandardField()) {
                             $record->setStandardFieldValueFromExcel($excel, $i, $col, $field);
                         } else {
                             $value = $record->getRecordFieldValueFromExcel($excel, $i, $col, $field);
 
                             if (is_array($value) && isset($value['warning'])) {
                                 $this->warnings[] = $value['warning'];
                                 $value = '';
                             }
 
                             $field->checkValidity($value, $record->getId());
                             if (!$simulate) {
                                 $record->setRecordFieldValue($field->getId(), $value);
                             }
                         }
                     } catch (ilDclInputException $e) {
                         $fields_failed++;
                         $this->warnings[] = "(" . $i . ", " . ilDataCollectionImporter::getExcelCharForInteger($col + 1) . ") " . $e;
                     }
                 }
 
                 if ($fields_failed < count($fields)) {
                     $record_imported = true;
                 } else {
                     $records_failed++;
                     $record_imported = false;
                 }
 
                 if (!$simulate) {
                     if (!$record_imported) { // if no fields have been filled, delete the record again
                         $record->doDelete(true); // omit notification
                     } else {
                         $record->doUpdate();
                     }
                 }
                 if (($i - 1) - $records_failed > $this->max_imports) {
                     $this->warnings[] = $this->lng->txt("dcl_max_import") . (count($sheet_data) - 1) . " > " . $this->max_imports;
                     break;
                 }
             }
         }
 
         return array('line' => (($i ?? 2) - 2), 'warnings' => $this->warnings);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $dcl

ilObjDataCollection ilDclContentImporter::$dcl

protected

Definition at line 46 of file class.ilDclContentImporter.php.

◆ $lng

ilLanguage ilDclContentImporter::$lng

protected

Definition at line 52 of file class.ilDclContentImporter.php.

◆ $max_imports

int ilDclContentImporter::$max_imports = 100

protected

Definition at line 24 of file class.ilDclContentImporter.php.

◆ $ref_id

int ilDclContentImporter::$ref_id

protected

Ref-ID of DataCollection.

Definition at line 40 of file class.ilDclContentImporter.php.

Referenced by __construct().

◆ $supported_import_datatypes

array ilDclContentImporter::$supported_import_datatypes

protected

Initial value:

= [
            ilDclDatatype::INPUTFORMAT_BOOLEAN,
            ilDclDatatype::INPUTFORMAT_NUMBER,
            ilDclDatatype::INPUTFORMAT_REFERENCE,
            ilDclDatatype::INPUTFORMAT_TEXT,
            ilDclDatatype::INPUTFORMAT_DATETIME,
            ilDclDatatype::INPUTFORMAT_PLUGIN,
            ilDclDatatype::INPUTFORMAT_TEXT_SELECTION,
            ilDclDatatype::INPUTFORMAT_DATE_SELECTION,
        ]

Definition at line 26 of file class.ilDclContentImporter.php.

Referenced by checkImportType().

◆ $table_id

int ilDclContentImporter::$table_id

protected

Table-Id for export.

Definition at line 44 of file class.ilDclContentImporter.php.

Referenced by __construct().

◆ $tables

array ilDclContentImporter::$tables

protected

Definition at line 50 of file class.ilDclContentImporter.php.

◆ $user

ilObjUser ilDclContentImporter::$user

protected

Definition at line 53 of file class.ilDclContentImporter.php.

◆ $warnings

array ilDclContentImporter::$warnings

protected

Definition at line 36 of file class.ilDclContentImporter.php.

Referenced by import().

◆ EXPORT_EXCEL

const ilDclContentImporter::EXPORT_EXCEL = 'xlsx'

Definition at line 23 of file class.ilDclContentImporter.php.

The documentation for this class was generated from the following file:

Modules/DataCollection/classes/Content/class.ilDclContentImporter.php

Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ checkImportType()

◆ getImportFieldsFromTitles()

◆ import()

Field Documentation

◆ $dcl

◆ $lng

◆ $max_imports

◆ $ref_id

◆ $supported_import_datatypes

◆ $table_id

◆ $tables

◆ $user

◆ $warnings

◆ EXPORT_EXCEL