Default import script - Importing data from a csv file

Next topic

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 10:29:32
Script start
Timing:	Jan 18 2025 10:29:32
Module start 'layout'
Timing:	Jan 18 2025 10:29:32
Module start 'content'
Timing:	Jan 18 2025 10:29:34
Module end 'content'
Timing:	Jan 18 2025 10:29:34
Script end

Main resources:

Total runtime	1.5199 sec
Peak memory usage	4,096.0000 KB
Database Queries	66

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0059	588.0391	152.6406
Module start 'layout'	0.0059	0.0039	740.6797	39.5000
Module start 'content'	0.0099	1.5087	780.1797	610.5625
Module end 'content'	1.5185	0.0013	1,390.7422	12.1250
Script end	1.5198		1,402.8672

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.1980	16	0.0002
Check MTime	0.0012	0.0799	16	0.0001
Mysql Total
Database connection	0.0007	0.0492	1	0.0007
Mysqli_queries	1.4588	95.9825	66	0.0221
Looping result	0.0007	0.0461	64	0.0000
Template Total	1.4709	96.8	2	0.7354
Template load	0.0021	0.1364	2	0.0010
Template processing	1.4688	96.6388	2	0.7344
Template load and register function	0.0002	0.0102	1	0.0002
states
state_id_array	0.0010	0.0689	1	0.0010
state_identifier_array	0.0016	0.1056	2	0.0008
Override
Cache load	0.0017	0.1130	33	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0528	3	0.0003
Fetch class attribute name	0.0011	0.0726	8	0.0001
XML
Image XML parsing	0.0014	0.0943	3	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0014	10	0.0000
General
dbfile	0.0011	0.0726	29	0.0000
String conversion	0.0000	0.0007	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
5	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
5	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/link.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/link.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 19 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs