Fantastic CSV import extension - Who owns it?

Wednesday 28 September 2005 5:39:03 pm

Hi,
CSV import is essential for most projects.

We have been using the import extention located at:
http://zev.ez.no/svn/extensions/csv/ and it works great through the admin interface. Using it through command line returns an undefined function or object error.

I'd like to know if someone knows who did this extension since it does not appear in the code.

We have added partial support for importing ezenhancedobjectrelation data types and we'd like to share this.

Ive wondered why this extension is not listed in the Contribs area in ez.no.

Regards,
Felipe

Felipe Jaramillo
eZ Certified Extension Developer
http://www.aplyca.com | Bogotá, Colombia

Friday 30 September 2005 8:42:50 am

Thanks for your reply Gabriel.

One question:
Have you managed to get the CLI version to work?

Regarding the ezenhancedobjectrelation, its simply a new case in a long switch, and it doesnt execute unless the datatype is: ezenhancedobjectrelation. Can this cause trouble?

Regards,
Felipe

Felipe Jaramillo
eZ Certified Extension Developer
http://www.aplyca.com | Bogotá, Colombia

Friday 30 September 2005 2:15:58 pm

Thanks Gabriel,

If you could test the CLI on 3.6 it'd be great.

I need to automate the CSV import so CLI is a must and I'm getting a:

Fatal error: Call to a member function on a non-object in server_path/import.php on line 478.

Fatal error: eZ publish did not finish its request
The execution of eZ publish was abruptly ended, the debug output is present below.

This corresponds to line:

$contentObject =& $class->instantiate( $creatorID, $sectionID );

BTW, how can I commit my changes to zev.ez.no?

Maybe someone from the ez crew could clarify who the user "kh" or "wy" is.

Regards,
Felipe

Felipe Jaramillo
eZ Certified Extension Developer
http://www.aplyca.com | Bogotá, Colombia

Friday 02 December 2005 1:46:00 am

Hi!
I'm trying to import two new types of attribute with this extension.
I'm trying to import URL type and Selection Type, but I've no hits yet.

Could anyone help me?? Anyone haked this extension to support this types of attributes??

Thank you!

Tuesday 13 December 2005 6:16:35 am

Doe's this extension works on 3.6?

{set-block scope=root variable=cache_ttl}0{/set-block}

Thursday 02 March 2006 1:31:59 am

I try this extension on ez 3.7.2 and 3.6.4 in sometimes works fine but in some case ez crash and show this message:

Fatal error: eZ publish did not finish its request

The execution of eZ publish was abruptly ended, the debug output is present below.

It's strange because my csv file test is the same.
For example if I import two rows from csv file the extension works fine for the first time but If I try to import the same rows from the same csv file for second time the extension crash ez.

Antica Bottega Digitale srl
http://www.abd.it

Tuesday 16 January 2007 10:49:08 am

Hello Patrick, welcome to the eZ community!

if (!is_object($document))

What was the result of this condition?

In case the simplified parser returns false, then it can be useful to ask it where it failed:

$errors = $parser->getMessages();

$errors is an array now with human-readable error strings

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Friday 09 February 2007 9:09:43 am

It appears the problem was somewhere else. The input file must be encoded in utf8, and it works perfectly.

Ca, c'est fait !

Friday 06 April 2007 12:54:46 am

Hi Philippe,

I use Open Office, which let you namely specify the encoding used when saving a document. Saving my csv file using UTF-8 encoding solved the problem with xml blocks.

Friday 06 April 2007 6:14:11 am

ok it's work fine now.
I have add your modification Patrick, the first near line 733 to replace :

        case 'ezxmltext':
        {
            $inputData = "<section xmlns:image='http://ez.no/namespaces/ezpublish3/image/' xmlns:xhtml='http://ez.no/namespaces/ezpublish3/xhtml/' xmlns:custom='http://ez.no/namespaces/ezpublish3/custom/' >";
            $inputData .= "<paragraph>";
            if ( $convertTag == true )
                $inputData .= convert( $attributeContent, $tagList );
            else
                $inputData .= $attributeContent;
            $inputData .= "</paragraph>";
            $inputData .= "</section>";

            include_once( "kernel/classes/datatypes/ezxmltext/handlers/input/ezsimplifiedxmlinput.php" );
            $dumpdata = "";
            $simplifiedXMLInput = new eZSimplifiedXMLInput( $dumpdata, null, null );
            $inputData = $simplifiedXMLInput->convertInput( $inputData );
            $input = $inputData[0]->toString();

            $contentObjectAttribute->setAttribute( 'data_text', $input );
            $contentObjectAttribute->store();
            break;
        }

by

case 'ezxmltext':
{
   include_once('kernel/classes/datatypes/ezxmltext/handlers/input/ezsimplifiedxmlinputparser.php');
    $contentObjectID = $contentObjectAttribute->attribute('contentobject_id');
    $parser = new eZSimplifiedXMLInputParser( $contentObjectID, false, 0);
    $document = $parser->process($attributeContent);
    if (!is_object($document))
    {
         $this->messages[] = $this->message("Error", "Adding creating EZXMLText");
        return false;
   }
   $domString = eZXMLTextType::domString($document);
         //echo "<hr />\nDomString = ".$domString."\n<hr />\n";
   $contentObjectAttribute->setAttribute('data_text', $domString);
   $contentObjectAttribute->store();
}

and in the second part, near line 579 to replace code :

        foreach ( array_keys ( $contentObjectAttributes ) as $attributeKey )
        {
            $contentObjectAttribute =& $contentObjectAttributes[$attributeKey];
            $contentClassAttributeID =  $contentObjectAttribute->attribute( 'contentclassattribute_id' );
            foreach ( array_keys ( $dataArray ) as $key )
            {
                if ( $key == $contentClassAttributeID )
                {
                    storeAttributeContent( $contentObjectAttribute, $dataArray[$key], $convertTag, $tagList, $objectRelationClassID );
                }
            }
        }
        include_once( 'lib/ezutils/classes/ezoperationhandler.php' );
        $operationResult = eZOperationHandler::execute( 'content', 'publish', array( 'object_id' => $contentObjectID,
                                                                                     'version' => $versionNr ) );
        $mainNode = $contentObject->attribute( 'main_node' );
        $nodeID = $mainNode->attribute( 'node_id' );
        $objectName = $mainNode->attribute( 'name' );

        $publishedContentObject = eZContentObject::fetch( $contentObjectID );
        $publishedContentObject->setAttribute('modified', $pdate );
        $publishedContentObject->setAttribute('published', $pdate );
        $publishedContentObject->store();
        $logMessage = implode( " | ", $logArray );
        $messages[] = message( "Notice", "Updated <a href='$URL/content/view/full/$nodeID'>$objectName</a>", $logMessage );

by

        foreach ( array_keys ( $contentObjectAttributes ) as $attributeKey )
        {
                $contentObjectAttribute =& $contentObjectAttributes[$attributeKey];
                $contentClassAttributeID =  $contentObjectAttribute->attribute( 'contentclassattribute_id' );
                $contentClassAttributeName = $contentObjectAttribute->attribute( 'contentclassattribute_identifier' );
                foreach ( array_keys ( $dataArray ) as $key )
                {
                        if ( $key == $contentClassAttributeID )
                        {
                                $currentObjectRelationClassID = $mapping_relations[$contentClassAttributeID];
                                storeAttributeContent( $contentObjectAttribute, $dataArray[$key], $convertTag, $tagList, $currentObjectRelationClassID );
                        }
                }
        }
        include_once( 'lib/ezutils/classes/ezoperationhandler.php' );
        $operationResult = eZOperationHandler::execute( 'content', 'publish', array( 'object_id' => $contentObjectID,'version' => $versionNr ) );
        $mainNode = $contentObject->attribute( 'main_node' );
        $nodeID = $mainNode->attribute( 'node_id' );
        $objectName = $mainNode->attribute( 'name' );
        $publishedContentObject = eZContentObject::fetch( $contentObjectID );
        $publishedContentObject->setAttribute('modified', $pdate );
        $publishedContentObject->setAttribute('published', $pdate );
        $publishedContentObject->store();
        $logMessage = implode( " | ", $logArray );
        $messages[] = message( "Notice", "Updated <a href='$URL/content/view/full/$nodeID'>$objectName</a>", $logMessage );

i have only change one thing in your code, i replace

'version' => 1

by

'version' => $versionNr

Thanks a lot for your help !