Forums / General / Default import script - Importing data from a csv file

Default import script - Importing data from a csv file

Author Message

Alejandro Dominguez

Wednesday 12 January 2011 4:32:01 am

Hello folks,

I'm trying to import data from Joomla 1.5 to eZpublish. With the help provides in this topic http://share.ez.no/forums/install-configuration/moving-site-from-joomla-1.5-to-ez-publish-4 Now I have a CSV with the content of my Joomla articles.

Heath tells me that the extension I was using it's similar to the Default import script of eZpublish but I don't know where to find and how to use this import script.

is this import tool in the ez administrator? Can anymone provides me a link with information of how to import data into content articles of ez?

Thanks!!

Cheers

Alejandro

Jérôme Vieilledent

Wednesday 12 January 2011 5:02:05 am

Hi Alejandro

You should give a try to SQLIImport. This is a generic extension allowing you to handle all the imports you want, whatever the data is. Moreover, it has a set of classes for CSV management ;-)

Gaetano Giunta

Wednesday 12 January 2011 5:05:56 am

default import script is in bin/php/ezcsvimport.php

Principal Consultant International Business
Member of the Community Project Board

Alejandro Dominguez

Thursday 13 January 2011 12:27:55 am

Hi Jerome and Gaetano,

Thanks for the info!! I'm goint to check sql import and the script.

I have a question about the use of the script. If I want to use the script I have to use the command line , don't I?

I was trying to execute the bcimportcsv script with this:

extension/bcimportcsv/bin/./bccsvjoomlacontenttablehtmlimport.php 68 extension/bcimportcsv/var/example.csv article . I write this command when I 'm in /var/www/myez$ . is the correct directory to launch the script?

Thanks!!

Cheers

Alejandro

Jérôme Vieilledent

Thursday 13 January 2011 1:15:52 am

Hello

Yes in both cases you will need to run the scripts from the commande line. The only thing to know is that you need to run every CLI script from the root of your eZ Publish instance (like in your example).

eZ debug

Timing: Jan 18 2025 03:03:58
Script start
Timing: Jan 18 2025 03:03:58
Module start 'content'
Timing: Jan 18 2025 03:03:58
Module end 'content'
Timing: Jan 18 2025 03:03:59
Script end

Main resources:

Total runtime0.9454 sec
Peak memory usage4,096.0000 KB
Database Queries203

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0061 589.4844180.8281
Module start 'content' 0.00610.7970 770.3125615.6563
Module end 'content' 0.80310.1422 1,385.9688337.3750
Script end 0.9453  1,723.3438 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00460.4860210.0002
Check MTime0.00150.1612210.0001
Mysql Total
Database connection0.00110.111510.0011
Mysqli_queries0.849089.81082030.0042
Looping result0.00220.23612010.0000
Template Total0.917197.020.4585
Template load0.00240.254320.0012
Template processing0.914696.751420.4573
Template load and register function0.00030.027110.0003
states
state_id_array0.00070.077910.0007
state_identifier_array0.00110.113920.0005
Override
Cache load0.00200.2167330.0001
Sytem overhead
Fetch class attribute can translate value0.00140.150540.0004
Fetch class attribute name0.00220.237180.0003
XML
Image XML parsing0.00981.031540.0024
class_abstraction
Instantiating content class attribute0.00000.0022100.0000
General
dbfile0.01061.1160400.0003
String conversion0.00000.000830.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
5content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
6content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/link.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/link.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 19
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs