csv import problem - VERY URGENT

« 
Previous topic
|
Developer
|
Next topic
 »
Author Message

viraj hoober

Sunday 11 July 2010 9:51:12 pm

I have a csv file which contains user details. I need to import the data
such that it fills 3 classes (depending on which profile user is
associated). It also needs to check if user is already present, if not it
will insert the details.
I have used the data_import extension. It just create the necessary
folders but i wasn't able to fill the 3 classes.(3 different profils) Any
idea how this can be achieved?

Jérôme Vieilledent

Monday 12 July 2010 12:25:27 am

Hi Viraj

This is exactly why I don't like data_import and why I'm currently developing another import extension. Did you try ezcsvimport script (in bin/php folder) ?

Nicolas Pastorino

Monday 12 July 2010 12:25:44 am

Hi Viraj,

Could you test the default CSV import handlers shipped with data_import ? Do they work properly ?

Let us know,
Cheers,

--
Nicolas Pastorino
Director Community - eZ
Member of the Community Project Board

eZ Publish Community on twitter: http://twitter.com/ezcommunity

t : http://twitter.com/jeanvoye
G+ : http://plus.tl/jeanvoye

viraj hoober

Monday 12 July 2010 12:39:26 am

yes the default CSV import handlers work properly. Any idea?

Jérôme Vieilledent

Monday 12 July 2010 1:00:33 am

"

Hi Jerome,
Can you please give me more details on the ezcsvimport script please. Sorry am new to ezpublish, can you please guide me on how to use it

"

Built-in ezcsvimport script is quite simple... Just type this command line from your eZ directory :

php bin/php/ezcsvimport.php --help

You'll get all available options. I guess best way to import your users in your case would be to split your CSV into 3 (1 per category) and then use ezcsvimport to process them
Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 11:28:14
Script start
Timing: Jan 18 2025 11:28:14
Module start 'layout'
Timing: Jan 18 2025 11:28:14
Module start 'content'
Timing: Jan 18 2025 11:28:15
Module end 'content'
Timing: Jan 18 2025 11:28:15
Script end

Main resources:

Total runtime0.8010 sec
Peak memory usage4,096.0000 KB
Database Queries66

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0058 587.9141152.6250
Module start 'layout' 0.00580.0030 740.539139.4453
Module start 'content' 0.00880.7906 779.9844610.2188
Module end 'content' 0.79940.0015 1,390.203112.1563
Script end 0.8009  1,402.3594 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00340.4277160.0002
Check MTime0.00150.1926160.0001
Mysql Total
Database connection0.00100.124510.0010
Mysqli_queries0.742292.6636660.0112
Looping result0.00070.0820640.0000
Template Total0.768095.920.3840
Template load0.00230.283120.0011
Template processing0.765795.591220.3828
Template load and register function0.00030.032010.0003
states
state_id_array0.00080.099110.0008
state_identifier_array0.00070.084420.0003
Override
Cache load0.00180.2284320.0001
Sytem overhead
Fetch class attribute can translate value0.00060.080430.0002
Fetch class attribute name0.00150.185670.0002
XML
Image XML parsing0.00130.158330.0004
class_abstraction
Instantiating content class attribute0.00000.002280.0000
General
dbfile0.00110.1434230.0000
String conversion0.00000.001340.0000
Note: percentages do not add up to 100% because some accumulators overlap

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/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
9content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1content/datatype/view/ezxmltags/link.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/link.tplEdit templateOverride template
1content/datatype/view/ezxmltags/quote.tpldatatype/ezxmltext/quote.tplextension/ezwebin/design/ezwebin/override/templates/datatype/ezxmltext/quote.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/strong.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/strong.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 26
 Number of unique templates used: 10

Time used to render debug report: 0.0001 secs