Fantastic CSV import extension - Who owns it?

Monday 10 September 2007 4:16:47 am

As english is the default import language, I added at the end of script the SQL queries that update language contents (here french):

$sql = "UPDATE ezcontentobject SET initial_language_id=2, language_mask=2 WHERE id=".$contentObjectID;
$db->query( $sql );

$sql = "UPDATE ezcontentobject_attribute SET language_code='fre-FR', language_id=2 WHERE contentobject_id=".$contentObjectID;
$db->query( $sql );

$sql = "UPDATE ezcontentobject_name SET content_translation='fre-FR', language_id=2, real_translation='fre-FR' WHERE contentobject_id=".$contentObjectID;
$db->query( $sql );

$sql = "UPDATE ezcontentobject_version SET initial_language_id=2, language_mask=3 WHERE contentobject_id=".$contentObjectID;
$db->query( $sql );

http://www.acidre.com

Monday 18 February 2008 11:05:17 am

Hi,

I'm trying to install the contrib under eZ 3.10.
It's not working. And as soon as I use the eZ 3.9, it's allright, it's working fine.

Is anybody has a fix to pass through this issue. Or is anybody has already met this problem ?

Thanks for your help.

Friday 07 March 2008 1:32:12 am

The CSV import IS HUGE !!
I change a few stuff and now, it's working better than well. So good !

Thanks for your help.
ByE

Monday 04 August 2008 3:52:35 pm

I had the same problem. Remove this from modules/csv/module.php:

    "functions" => array( 'read' ),

Thursday 14 August 2008 7:44:06 am

You should be able to go to yourdomain.com/csv/csvimport

I got it to work with the instructions above for 3.10.

Wednesday 20 August 2008 12:49:45 am

Ok, I have added the topmenu.

However, it seems I can't get the navigationpart right, even though I set up the menu.ini file:

[NavigationPart]
Part[ezimportnavigationpart]=Import

[TopAdminMenu]
Tabs[]=import

[Topmenu_import]
NavigationPartIdentifier=ezimportnavigationpart
Name=Import
Tooltip=Import CSV
URL[]
URL[default]=csv/csvimport
Enabled[]
Enabled[default]=true
Enabled[browse]=true
Enabled[edit]=false
Shown[]
Shown[default]=true
Shown[edit]=false
Shown[navigation]=true
Shown[browse]=true

The admin interface always switch to the content structure part (highlited) with the dynamic content menu on the left. The center of the screen is the csvimport thought.

Certified eZ Publish 4 developer looking for develop information & collaboration.

Wednesday 20 August 2008 2:33:39 am

Hi Jean-Luc Nguyen,

I am also use French and English for my site. Could you tell me where did you add the SQL queries that update language contents? just at the very end of the csvimport.php and import.php files?

Thanks.

Certified eZ Publish 4 developer looking for develop information & collaboration.

Friday 12 September 2008 7:44:09 am

You want to choose the language instead of using the default? Try using this:

In csvimport.php, around line 460 change:

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

To:

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

Around 550:

$version =& $contentObject->createNewVersion(false,true);

$version =& $contentObject->createNewVersion(false,true,$language);

Around 400:

function addContentObject( $rootNodeID, $parentNodeName, $parentNodeRemoteID, $creatorID, $classID, $sectionID, &$dataArray, &$logArray, $importKey,  $folderClassID, $convertTag = false, $tagList = null , $objectRelationClassID = 0, $pdate)

function addContentObject( $rootNodeID, $parentNodeName, $parentNodeRemoteID, $creatorID, $classID, $sectionID, &$dataArray, &$logArray, $importKey,  $folderClassID, $convertTag = false, $tagList = null , $objectRelationClassID = 0, $pdate , $language = false)

Around: 370:

                    if ( $convertTag )
                        addContentObject( $rootNodeID, $parentNodeName, $parentNodeRemoteID, $creatorID, $classID, $sectionID, $dataArray, $logArray, $importKey, $folderClassID, $convertTag, $tagList, $objectRelationClassID, $pdate);
                    else
                    {
                        addContentObject( $rootNodeID, $parentNodeName, $parentNodeRemoteID, $creatorID, $classID, $sectionID, $dataArray, $logArray, $importKey, $folderClassID, false, null, $objectRelationClassID, $pdate);
                    }

                    if ( $convertTag )
                        addContentObject( $rootNodeID, $parentNodeName, $parentNodeRemoteID, $creatorID, $classID, $sectionID, $dataArray, $logArray, $importKey, $folderClassID, $convertTag, $tagList, $objectRelationClassID, $pdate, $language );
                    else
                    {
                        addContentObject( $rootNodeID, $parentNodeName, $parentNodeRemoteID, $creatorID, $classID, $sectionID, $dataArray, $logArray, $importKey, $folderClassID, false, null, $objectRelationClassID, $pdate, $language );
                    }

And then set the $language variable, around 200:

    else
    {
        $logFieldList = null;
    }

Add below:

    if ( $http->hasVariable( 'language' ) ){
        $language = $http->variable( 'language' );
    } else {
        $language = false;
    }

(If you use the command line version, you'll have to do something similar in import.php)

And then in csvimport.tpl, add somewhere:

<h2>Choose language</h2>

<div class="block">
<select name="language">
{foreach ezini('RegionalSettings', 'SiteLanguageList') as $lang}
<option value="{$lang}"{if $post.language|eq($lang)} selected="selected"{/if}>{$lang}</option>
{/section}
</select>
</div>

Wednesday 24 September 2008 4:39:17 am

Can anyone tell me if s/he had successful experience to import data with objectrelation attribute? What I said above was correct or not? Thanks, need this information for an urgent project. :)

Certified eZ Publish 4 developer looking for develop information & collaboration.

Wednesday 24 September 2008 7:14:14 pm

Thank you very much for your replying!

Certified eZ Publish 4 developer looking for develop information & collaboration.