public function createRecordFromCMDL($cmdl, $properties = [], $viewName = "default", $workspace = "default", $language = "default")
{
$contentTypeDefinition = Parser::parseCMDLString($cmdl);
/** @var Record $record */
$record = new Record($contentTypeDefinition, '', $viewName, $workspace, $language);
$revision = isset($jsonRecord['revision']) ? $jsonRecord['revision'] : 0;
$record->setRevision($revision);
if ($this->getOption('validateProperties') == true) {
foreach ($properties as $property => $value) {
$record->setProperty($property, $value);
}
} else {
$record->setProperties($properties);
}
return $record;
}
/**
* remove protected properties and execute @name annotation
*
* @param Record $record
*/
protected function finalizeRecord(Record $record, DataDimensions $dataDimensions)
{
// Apply @name annotation
if ($record->getDataTypeDefinition()->hasNamingPattern()) {
$record->setName(Util::applyNamingPattern($record->getProperties(), $record->getDataTypeDefinition()->getNamingPattern()));
}
// remove protected properties
$properties = $record->getProperties();
foreach ($record->getDataTypeDefinition()->getProtectedProperties($dataDimensions->getViewName()) as $property) {
unset($properties[$property]);
}
$record->setProperties($properties);
return $record;
}
public function importXLSX(Repository $repository, $contentTypeName, $filename, $workspace = 'default', $language = 'default', $viewName = 'exchange')
{
$this->count = 0;
$this->records = null;
$this->stash = array();
$this->error = false;
$repository->selectContentType($contentTypeName);
// Select view and fallback if necessary
$contentTypeDefinition = $repository->getContentTypeDefinition();
$viewDefinition = $contentTypeDefinition->getExchangeViewDefinition($viewName);
$viewName = $viewDefinition->getName();
$repository->selectWorkspace($workspace);
$repository->selectLanguage($language);
$repository->selectView($viewName);
$objPHPExcel = \PHPExcel_IOFactory::load($filename);
if ($objPHPExcel) {
if ($this->isTruncateRecords()) {
$this->deleteEffectiveRecords($repository, $workspace, $viewName, $language);
}
$objWorksheet = $objPHPExcel->getActiveSheet();
$highestRow = $objWorksheet->getHighestRow();
// e.g. 10
$highestColumn = $objWorksheet->getHighestColumn();
// e.g 'F'
$highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);
// e.g. 5
$idColumnIndex = null;
$propertiesColumnIndices = array();
for ($i = 0; $i <= $highestColumnIndex; $i++) {
$value = trim($objWorksheet->getCellByColumnAndRow($i, 1)->getValue());
if ($value != '') {
if (substr($value, 0, 1) == '.') {
if ($value == '.id') {
$idColumnIndex = $i;
}
} else {
$value = Util::generateValidIdentifier($value);
if ($contentTypeDefinition->hasProperty($value, $viewName)) {
$this->writeln('Detected valid property ' . $value);
$propertiesColumnIndices[$value] = $i;
}
}
}
}
$this->writeln('');
if (count($propertiesColumnIndices) != 0) {
for ($row = 2; $row <= $highestRow; ++$row) {
$id = null;
if ($idColumnIndex !== null) {
if (!$this->isGenerateNewIDs()) {
$id = $objWorksheet->getCellByColumnAndRow($idColumnIndex, $row)->getValue();
}
}
$properties = array();
foreach ($propertiesColumnIndices as $property => $col) {
$value = $objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
$properties[$property] = $value;
}
$record = new Record($contentTypeDefinition, 'Imported Record', $viewName, $workspace, $language);
$record->setProperties($properties);
$record->setID($id);
$msg = $this->stashRecord($repository, $record, $workspace, $viewName, $language);
$this->writeln($msg);
}
$this->writeln('');
$this->writeln('Found ' . $this->count . ' records to import');
$this->writeln('');
if ($this->count != 0) {
$this->writeln('Starting bulk import');
$this->writeln('');
$this->saveRecords($repository);
$this->writeln('');
$this->writeln('');
}
} else {
$this->writeln('Excel does not contain matching property columns.');
}
} else {
$this->writeln('Error parsing Excel file.');
$this->error = true;
}
return !$this->error;
}
