Arrow 
larger font smaller font default font Fixed screen resolution Auto adjust screen size

Joomlapolis Forums  


<< Start < Prev 1 2 3 Next > End >>
cbjuice error
Date: 2008/02/19 14:07 By: fredrikohgren Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 1
graphgraph
Hi I'm rather new to this but would like to use cbjuice to import a list of users. It installs without error bu gives me this when I'm trying to import from file:

function defined
Notice: Undefined index: ConfirmationEmail in .../administrator/components/com_cbjuice/admin.cbjuice.php on line 172 Header Variables are
Array ( [0] => username [1] => firstname [2] => lastname [3] => email )
username is required
username must be supplied

As seen above username is included.
the file is as follows:

username,firstname,lastname,email
user@mail.foo,user@mail.foo,user@mail.foo,user@mail.foo


Could someone give me some help?

/Fredrik
Click here to see the profile of this user The topic has been locked.

Re:cbjuice error
Date: 2008/03/05 19:43 By: outline4 Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 6
graphgraph
I have the same problem!
did you get any help already?

When I try to reimport the csv file through "Edit Mode (no Adds)." the following error occours:

"Header Variables are
Array ( [0] => username;name;firstname;lastname;email;cb_firma;cb_strasse;cb_plz;cb_ort )
username is required
username must be supplied"

I have Joomla 1.0.13 installed on localhost.
the newest cb version. 1.1

I am desperalely trying to reimport the edited data...
if I reimport only 1 user it failes too..

what could I be dooing wrong?
usernames are present and they match?!
Click here to see the profile of this user The topic has been locked.

Re:cbjuice error
Date: 2008/03/06 05:44 By: oleolsen Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 5
graphgraph
It´s written clearly that you MUST provide a password.

Headding of Juice:

Make sure you submit a properly formatted CSV file of users to import- headings must be included
CSV Format: username,firstname,lastname,password,email, any additional CB profile variables added to the site
In EDIT mode (add mode unchecked), only the username and at least one additional CB profile variable is required otherwise all 5 of the variables noted above are required In EDIT mode, the password is only usefully edited if it is stored externally and supplied as part of the update
Click here to see the profile of this user The topic has been locked.

Re:cbjuice error
Date: 2008/03/07 15:04 By: outline4 Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 6
graphgraph
thanks for helping out.

in fact I had several problems to overcome!

* first problem was the encoding:
the file is encoded in ISO-8859-1 (ISOLatin 1) and it has UNIX LineFeed endings.
(didn't find that info anywhere)

* then I had some fields with "wysiwyg editor" type and some of the texts had "(quotes)". so this made the csv unusable cause it's the same quotes for the text delimiter! does anybody know how to avoid the "" bug? is it a bug? can I exclude some fields from the export?? can I choose a different text delimiter?

once I had the right encoding and the quotes eliminated it worked really fine!
thanks a lot for this!
Click here to see the profile of this user The topic has been locked.

Re:cbjuice error
Date: 2008/03/14 10:35 By: pvh Status: CB Doc subscriber  
Karma: 0  
Senior Joomlapolitan

Posts: 54
graphgraph
I can confirm this. Whatever separator I use, it puts the complete line of separated items in the name.
Could it be that in Joomla 1.5 the format has changed and therefore the headings of the columns do not match anymore?
Click here to see the profile of this user The topic has been locked.

Re:cbjuice error -Sample file
Date: 2008/03/17 16:01 By: jciconsult Status: CB Doc subscriber  
Karma: 6  
Senior Joomlapolitan

Posts: 85
graphgraph
Other users are not having problems. I have attached a sample CSV file in zip format (note, you must use an unzipped csv file). Please do not email me individually to debug your csv files. The csv files are processed using fgetcsv which is a standard routine.
fgetcsv($filehandle,4096,$delimiter,'"')
By definition in php5, the default escape character is , I am forcing strings to be delimited with ".
File Attachment:
File name: users_test4a.zip
File size:484 bytes
Click here to see the profile of this user The topic has been locked.

<< Start < Prev 1 2 3 Next > End >>

CBSubs 1.0

CBSubs 1.0.3 released!

Find out more about the revolutionary new Joomla subscription system:

Info on CBSubs

CB 1.2.3 Documentation

Thank you bonus:

ProfileBook (+Blog) 1.2RC
ProfileGallery 1.2RC2
CB Privacy 1.0RC

What? Why? Where?

Click here for a yearly subscription: subscribe now

CB 1.2.3 Download

Community Builder 1.2.3
Stable and native for:
Joomla 1.5 & 1.0 & Mambo
(incl. CB 1.2.3 Installation pdf)
You need to be a registered member to download.

Full 180 pages updated
CB 1.2.3 documentation:
You need to be a CB doc subscriber to download.

CB Login