I've created a custom class to hold ISO country names and codes and I'm trying to import an xml file with the data. I've tried a lot of different things to debug but I keep getting an error:
An error occurred during "countryimporthandler" import process : invalid "countryname" field for current SQLIContent.
Country name is just a standard ez text line and I've checked and rechecked to ensure that I haven't misspelled any identifier names. I even tried using the article class instead and putting country name in the title but that didn't work either. Also from the print line I can see that the xml is being parsed correctly.
I'd be really grateful for any help debugging. When this input handler is working I think it might be a good example because it imports the ISO country code list which is handy if you don't want to use the country datatype and would rather use objectrelation.
Thanks!
Fraser
The XML File (sample)
<ISO3166List xml:lang="en">
<ISO3166Entry>
<CountryName>AFGHANISTAN</CountryName>
<ISO3166Alpha2Code>AF</ISO3166Alpha2Code>
</ISO3166Entry>
<ISO3166Entry>
<CountryName>ÅLAND ISLANDS</CountryName>
<ISO3166Alpha2Code>AX</ISO3166Alpha2Code>
</ISO3166Entry>
<ISO3166Entry>
<CountryName>ALBANIA</CountryName>
<ISO3166Alpha2Code>AL</ISO3166Alpha2Code>
</ISO3166Entry>
</ISO3166List>
The INI Override
[ImportSettings]
AvailableSourceHandlers[]=countryimporthandler
[countryimporthandler-HandlerSettings]
Enabled=true
Name=Country XML Import Handler
ClassName=SQLICountryImportHandler
Debug=enabled
DefaultParentNodeID=469
StreamTimeout=
xmlFile=C:/<ezRoot>/extension/issat/stubs/iso3166list.xml
The Import Handler
<?php
/**
* File containing demo import handler SQLIRSSImportHandler
* @copyright Copyright (C) 2010 - SQLi Agency. All rights reserved
* @licence http://www.gnu.org/licenses/gpl-2.0.txt GNU GPLv2
* @author Jerome Vieilledent
* @version 1.1.0
* @package sqliimport
* @subpackage sourcehandlers
*/
class SQLICountryImportHandler extends SQLIImportAbstractHandler implements ISQLIImportHandler
{
protected $rowIndex = 0;
protected $rowCount;
protected $currentGUID;
/**
* Constructor
*/
public function __construct( SQLIImportHandlerOptions $options = null )
{
parent::__construct( $options );
$this->remoteIDPrefix = $this->getHandlerIdentifier().'-';
$this->currentRemoteIDPrefix = $this->remoteIDPrefix;
}
/**
* (non-PHPdoc)
* @see extension/sqliimport/classes/sourcehandlers/ISQLIImportHandler::initialize()
*/
public function initialize()
{
$xmlFile = $this->handlerConfArray['xmlFile'];
$xmlOptions = new SQLIXMLOptions( array(
'xml_path' => $xmlFile,
'xml_parser' => 'simplexml'
) );
$xmlParser = new SQLIXMLParser( $xmlOptions );
$this->dataSource = $xmlParser->parse();
}
/**
* (non-PHPdoc)
* @see extension/sqliimport/classes/sourcehandlers/ISQLIImportHandler::getProcessLength()
*/
public function getProcessLength()
{
if( !isset( $this->rowCount ) )
{
$this->rowCount = count( $this->dataSource->ISO3166Entry );
}
return $this->rowCount;
}
/**
* (non-PHPdoc)
* @see extension/sqliimport/classes/sourcehandlers/ISQLIImportHandler::getNextRow()
*/
public function getNextRow()
{
if( $this->rowIndex < $this->rowCount )
{
$row = $this->dataSource->ISO3166Entry[$this->rowIndex];
$this->rowIndex++;
}
else
{
$row = false; // We must return false if we already processed all rows
}
return $row;
}
/**
* (non-PHPdoc)
* @see extension/sqliimport/classes/sourcehandlers/ISQLIImportHandler::process()
*/
public function process( $row )
{
// $row is a SimpleXMLElement object
$this->currentGUID = $row->ISO3166Alpha2Code;
$contentOptions = new SQLIContentOptions( array(
'class_identifier' => 'isocountryentry',
'remote_id' => (string)$row->ISO3166Alpha2Code
) );
print (string)$row->CountryName;
$content = SQLIContent::create( $contentOptions );
$content->fields->countryname = (string)$row->CountryName;
$content->fields->alpha2code = (string)$row->ISO3166Alpha2Code;
// Now publish content
$content->addLocation( SQLILocation::fromNodeID( $this->handlerConfArray['DefaultParentNodeID'] ) );
$publisher = SQLIContentPublisher::getInstance();
$publisher->publish( $content );
// Free some memory. Internal methods eZContentObject::clearCache() and eZContentObject::resetDataMap() will be called
// @see SQLIContent::__destruct()
unset( $content );
}
/**
* (non-PHPdoc)
* @see extension/sqliimport/classes/sourcehandlers/ISQLIImportHandler::cleanup()
*/
public function cleanup()
{
// Nothing to clean up
return;
}
/**
* (non-PHPdoc)
* @see extension/sqliimport/classes/sourcehandlers/ISQLIImportHandler::getHandlerName()
*/
public function getHandlerName()
{
return 'Country Import Handler';
}
/**
* (non-PHPdoc)
* @see extension/sqliimport/classes/sourcehandlers/ISQLIImportHandler::getHandlerIdentifier()
*/
public function getHandlerIdentifier()
{
return 'countryimporthandler';
}
/**
* (non-PHPdoc)
* @see extension/sqliimport/classes/sourcehandlers/ISQLIImportHandler::getProgressionNotes()
*/
public function getProgressionNotes()
{
return 'Currently importing : '.$this->currentGUID;
}
}
