Forums / Extensions / Sqliimport and multilocation

Sqliimport and multilocation

Author Message

SEBBANE Alexandre

Monday 02 May 2011 1:21:25 am

Hello,

i use to work with sqliimport but i try to do multilocation and it does not succeed :

here is a part of my code which work :

$contentOptions = new SQLIContentOptions( array(
'class_identifier' => 'agence',
'remote_id' => (string)md5($row->etab."-".$row->guichet),
'creator_id' => 14
) );
$content = SQLIContent::create( $contentOptions );
$content->fields->nom_du_guichet = (string) $row->nomguichet;
$content->fields->entite = (string) $row->etab;
$content->addLocation( SQLILocation::fromNodeID( $parentnodeid ) );

$publisher = SQLIContentPublisher::getInstance();
$publisher->publish( $content );

the same with multilocation to contentroot et mediaroot doesn't work :

 

$contentOptions = new SQLIContentOptions( array(
'class_identifier' => 'agence',
'remote_id' => (string)md5($row->etab."-".$row->guichet),
'creator_id' => 14
) );
$content = SQLIContent::create( $contentOptions );
$content->fields->nom_du_guichet = (string) $row->nomguichet;
$content->fields->entite = (string) $row->etab;
$content->addLocation( SQLILocation::fromNodeID( $parentnodeid ) );
$content->addLocation( SQLILocation::fromNodeID( 2 ) );
$content->addLocation( SQLILocation::fromNodeID( 43 ) );

$publisher = SQLIContentPublisher::getInstance();
$publisher->publish( $content );

thanks a lot for your help.

Alexandre

Paris, France

Jérôme Vieilledent

Monday 02 May 2011 2:20:41 am

Hi Alex

It seems to be a simple right access issue. Does your import user has the right to create/edit content in the media section ?

SEBBANE Alexandre

Monday 02 May 2011 2:33:24 am

hello,

14 is the admin ....

Alexandre

Paris, France

Jérôme Vieilledent

Monday 02 May 2011 2:41:20 am

Yes, but there is no login action here...

Try this in your sqliimport.ini :

[ImportSettings]
RobotUserID=14

With that setting, the admin will be logged in. Without it, Anonymous User is used. The creator_id option is different. It's for forcing a user as content owner.

SEBBANE Alexandre

Monday 02 May 2011 2:48:25 am

I try to do this but nothing change ...

How the first code work with anonymous ? anonimous don't have any rights to write .... so i do'nt understand.

Alexandre

Paris, France

Jérôme Vieilledent

Monday 02 May 2011 3:02:38 am

"

I try to do this but nothing change ...

How the first code work with anonymous ? anonimous don't have any rights to write .... so i do'nt understand.

Alexandre

"

When creating/editing content via script, security policies are not always checked.

Do you have anything in your logs (error.log / sqliimport logs) ?

SEBBANE Alexandre

Monday 02 May 2011 3:17:52 am

Cool it's works.... You rock.

i 'am using : sqliimport 1.2.1 et ezpublish 4.5 community

Alexandre

Thanks ...

Paris, France

eZ debug

Timing: Jan 17 2025 23:51:30
Script start
Timing: Jan 17 2025 23:51:30
Module start 'content'
Timing: Jan 17 2025 23:51:32
Module end 'content'
Timing: Jan 17 2025 23:51:32
Script end

Main resources:

Total runtime1.4058 sec
Peak memory usage4,096.0000 KB
Database Queries206

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0053 589.1406180.8438
Module start 'content' 0.00531.1390 769.9844607.6953
Module end 'content' 1.14430.2614 1,377.6797341.0625
Script end 1.4057  1,718.7422 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00370.2599210.0002
Check MTime0.00140.0979210.0001
Mysql Total
Database connection0.00080.057010.0008
Mysqli_queries1.243088.42192060.0060
Looping result0.00290.20922040.0000
Template Total1.367997.320.6839
Template load0.00200.142720.0010
Template processing1.365897.159120.6829
Template load and register function0.00010.007210.0001
states
state_id_array0.00200.145510.0020
state_identifier_array0.00150.108820.0008
Override
Cache load0.00180.1306710.0000
Sytem overhead
Fetch class attribute can translate value0.00170.119230.0006
Fetch class attribute name0.00240.171390.0003
XML
Image XML parsing0.00130.090630.0004
class_abstraction
Instantiating content class attribute0.00000.0024140.0000
General
dbfile0.05603.9834340.0016
String conversion0.00000.000330.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
7content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
7content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
11content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1content/datatype/view/ezxmltags/quote.tpldatatype/ezxmltext/quote.tplextension/ezwebin/design/ezwebin/override/templates/datatype/ezxmltext/quote.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 31
 Number of unique templates used: 8

Time used to render debug report: 0.0002 secs