* @author Romain Quetiez * @author Denis Flaven * @license http://www.opensource.org/licenses/gpl-3.0.html LGPL */ // // Known limitations // - output still in html, because the errors are not displayed in xml // - reconciliation is made on the first column // - no option to force 'always create' or 'never create' // - text qualifier hardcoded to " // // Known issues // - ALMOST impossible to troubleshoot when an externl key has a wrong value // - no character escaping in the xml output (yes !?!?!) // - not outputing xml when a wrong input is given (class, attribute names) // - for a bizIncidentTicket you may use the name as the reconciliation key, // but that attribute is in fact recomputed by the application! An error should be raised somewhere // require_once('../application/application.inc.php'); require_once('../application/webpage.class.inc.php'); require_once('../application/csvpage.class.inc.php'); require_once('../application/xmlpage.class.inc.php'); require_once('../application/startup.inc.php'); require_once('../application/loginwebpage.class.inc.php'); class WebServiceException extends Exception { } LoginWebPage::DoLogin(); // Check user rights and prompt if needed $oContext = new UserContext(); $oAppContext = new ApplicationContext(); //$iActiveNodeId = utils::ReadParam('menu', -1); //$currentOrganization = utils::ReadParam('org_id', ''); // Main program //$oP = new XMLPage("iTop - Bulk import"); $oP = new WebPage("iTop - Bulk import"); $oP->add('This is a prototype, I repeat: PRO-TO-TYPE, therefore it suffers bugs and limitations, documented in the code. Next step: specify...'); try { $sClass = utils::ReadParam('class', ''); $sSep = utils::ReadParam('separator', ';'); $sCSVData = utils::ReadPostedParam('csvdata'); $oCSVParser = new CSVParser($sCSVData, $sSep, $sDelimiter = '"'); // Limitation: as the attribute list is in the first line, we can not match external key by a third-party attribute $sRawFieldList = $oCSVParser->ListFields(); $aAttList = array(); $aExtKeys = array(); foreach($sRawFieldList as $iFieldId => $sFieldName) { if (!MetaModel::IsValidAttCode($sClass, $sFieldName)) { throw new WebServiceException("Unknown attribute '$sFieldName' (class: '$sClass')"); } $oAtt = MetaModel::GetAttributeDef($sClass, $sFieldName); if ($oAtt->IsExternalKey()) { $aExtKeys[$sFieldName]['id'] = $iFieldId; $aAttList[$sFieldName] = $iFieldId; } elseif ($oAtt->IsExternalField()) { $sExtKeyAttCode = $oAtt->GetKeyAttCode(); $sRemoteAttCode = $oAtt->GetExtAttCode(); $aExtKeys[$sExtKeyAttCode][$sRemoteAttCode] = $iFieldId; } else { $aAttList[$sFieldName] = $iFieldId; } } // Limitation: the reconciliation key is the first attribute $aReconcilKeys = array($sRawFieldList[0]); $aData = $oCSVParser->ToArray(); $oBulk = new BulkChange( $sClass, $aData, $aAttList, $aExtKeys, $aReconcilKeys ); $oMyChange = MetaModel::NewObject("CMDBChange"); $oMyChange->Set("date", time()); if (UserRights::GetUser() != UserRights::GetRealUser()) { $sUserString = UserRights::GetRealUser()." on behalf of ".UserRights::GetUser(); } else { $sUserString = UserRights::GetUser(); } $oMyChange->Set("userinfo", $sUserString.' (bulk load by web service)'); $iChangeId = $oMyChange->DBInsert(); $aRes = $oBulk->Process($oMyChange); // Setup result presentation // $aDisplayConfig = array(); $aDisplayConfig["__RECONCILIATION__"] = array("label"=>"Reconciliation", "description"=>""); $aDisplayConfig["__STATUS__"] = array("label"=>"Status", "description"=>""); if (isset($iPKeyId)) { $aDisplayConfig["col$iPKeyId"] = array("label"=>"id", "description"=>""); } foreach($aReconcilKeys as $iCol => $sAttCode) { $sLabel = MetaModel::GetAttributeDef($sClass, $sAttCode)->GetLabel(); $aDisplayConfig["col$iCol"] = array("label"=>"$sLabel", "description"=>""); } foreach ($aAttList as $sAttCode => $iCol) { $sLabel = MetaModel::GetAttributeDef($sClass, $sAttCode)->GetLabel(); $aDisplayConfig["col$iCol"] = array("label"=>"$sLabel", "description"=>""); } $aResultDisp = array(); // to be displayed foreach($aRes as $iRow => $aRowData) { $aRowDisp = array(); $aRowDisp["__RECONCILIATION__"] = $aRowData["__RECONCILIATION__"]; $aRowDisp["__STATUS__"] = $aRowData["__STATUS__"]->GetDescription(); foreach($aRowData as $sKey => $value) { if ($sKey == '__RECONCILIATION__') continue; if ($sKey == '__STATUS__') continue; switch (get_class($value)) { case 'CellStatus_Void': $sClass = ''; break; case 'CellStatus_Modify': $sClass = 'csvimport_ok'; break; case 'CellStatus_Issue': $sClass = 'csvimport_error'; break; } if (empty($sClass)) { $aRowDisp[$sKey] = $value->GetDescription(); } else { $aRowDisp[$sKey] = "

".$value->GetDescription()."

"; } } $aResultDisp[$iRow] = $aRowDisp; } $oP->table($aDisplayConfig, $aResultDisp); } catch(Exception $e) { $oP->add(''.((string)$e).''); } $oP->output(); ?>