Forums / Setup & design / Importing users from csv

Importing users from csv

Next topic

Author	Message
Andy Woods	Wednesday 18 May 2011 6:47:00 am Hi, Is it possible to import users from a csv file? I have searched the forum and found a few posts but I haven't found any that describe a simple process to do it. Thanks, Andy
Jérôme Vieilledent	Wednesday 18 May 2011 7:05:05 am Hello You can do so with SQLIImport extension ;)
Andy Woods	Wednesday 18 May 2011 7:58:54 am I've had a quick look at the extension but can't see any information that explains how to import users. Have you used it to import users? Is it a straightforward process? Is this the easiest way to import users? Thanks, Andy
Jérôme Vieilledent	Thursday 19 May 2011 1:05:53 am Hi Andy Users in eZ Publish are actually content objects with an ezuser attribute, so it is straightforward :). I already made an implementation of user import in my JanrainAuth extension (to connect user from social networks like Facebook). Take a look at the JanrainAuth class, in getUser() method. You also might want to read the SQLIImport fromString() Appendix to learn how to deal with ezuser datatype. Take also a look at the documentation because there is a set of classes to handle CSV files ;). Cheers !
Andy Woods	Friday 20 May 2011 2:32:22 am Has anyone uses the user_import extension? http://projects.ez.no/user_import I've installed it but I can't work out how to use it. Andy
scrieler _	Monday 23 May 2011 4:39:28 am Can be that this isn't compatible with your ez version. Try the sqliimport extension first, looks good :)

eZ debug

Timing:

Jan 17 2025 22:40:11

Script start

Timing:

Jan 17 2025 22:40:11

Module start 'content'

Timing:

Jan 17 2025 22:40:12

Module end 'content'

Timing:

Jan 17 2025 22:40:12

Script end

Main resources:

Total runtime

1.4438 sec

Peak memory usage

4,096.0000 KB

Database Queries

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0067	588.8281	180.8438
Module start 'content'	0.0067	1.4345	769.6719	582.3125
Module end 'content'	1.4412	0.0026	1,351.9844	46.1094
Script end	1.4437		1,398.0938

Checkpoint

Start (sec)

Duration (sec)

Memory at start (KB)

Memory used (KB)

Script start

0.0000

0.0067

588.8281

180.8438

Module start 'content'

0.0067

1.4345

769.6719

582.3125

Module end 'content'

1.4412

0.0026

1,351.9844

46.1094

Script end

1.4437

1,398.0938

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.2154	14	0.0002
Check MTime	0.0013	0.0894	14	0.0001
Mysql Total
Database connection	0.0009	0.0640	1	0.0009
Mysqli_queries	1.3937	96.5300	71	0.0196
Looping result	0.0007	0.0462	69	0.0000
Template Total	1.4130	97.9	2	0.7065
Template load	0.0022	0.1501	2	0.0011
Template processing	1.4108	97.7179	2	0.7054
Template load and register function	0.0002	0.0166	1	0.0002
states
state_id_array	0.0026	0.1786	1	0.0026
state_identifier_array	0.0017	0.1148	2	0.0008
Override
Cache load	0.0019	0.1302	39	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0418	3	0.0002
Fetch class attribute name	0.0013	0.0933	7	0.0002
XML
Image XML parsing	0.0008	0.0527	3	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0018	8	0.0000
General
dbfile	0.0009	0.0605	19	0.0000
String conversion	0.0000	0.0004	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Accumulator

Duration (sec)

Duration (%)

Count

Average (sec)

Ini load

Load cache

0.0031

0.2154

0.0002

Check MTime

0.0013

0.0894

0.0001

Mysql Total

Database connection

0.0009

0.0640

0.0009

Mysqli_queries

1.3937

96.5300

0.0196

Looping result

0.0007

0.0462

0.0000

Template Total

1.4130

97.9

0.7065

Template load

0.0022

0.1501

0.0011

Template processing

1.4108

97.7179

0.7054

Template load and register function

0.0002

0.0166

0.0002

states

state_id_array

0.0026

0.1786

0.0026

state_identifier_array

0.0017

0.1148

0.0008

Override

Cache load

0.0019

0.1302

0.0000

Sytem overhead

Fetch class attribute can translate value

0.0006

0.0418

0.0002

Fetch class attribute name

0.0013

0.0933

0.0002

XML

Image XML parsing

0.0008

0.0527

0.0003

class_abstraction

Instantiating content class attribute

0.0000

0.0018

0.0000

General

dbfile

0.0009

0.0605

0.0000

String conversion

0.0000

0.0004

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
6	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
9	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	content/datatype/view/ezxmltags/link.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/link.tpl
1	content/datatype/view/ezxmltags/emphasize.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/emphasize.tpl
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 23 Number of unique templates used: 7

Usage

Requested template

Template

Template loaded

Edit

Override

node/view/full.tpl

full/forum_topic.tpl

extension/sevenx/design/simple/override/templates/full/forum_topic.tpl