| 
Welcome, Guest

cbjuice error
(1 viewing) (1) Guest

TOPIC: cbjuice error

cbjuice error 3 years, 11 months ago #57048

  • Posts:
  • Karma:
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
This e-mail address is being protected from spambots. You need JavaScript enabled to view it , This e-mail address is being protected from spambots. You need JavaScript enabled to view it , This e-mail address is being protected from spambots. You need JavaScript enabled to view it , This e-mail address is being protected from spambots. You need JavaScript enabled to view it


Could someone give me some help?

/Fredrik
The topic has been locked.

Re:cbjuice error 3 years, 11 months ago #58278

  • Posts:
  • Karma:
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?!
The topic has been locked.

Re:cbjuice error 3 years, 11 months ago #58306

  • Posts:
  • Karma:
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
The topic has been locked.

Re:cbjuice error 3 years, 11 months ago #58409

  • Posts:
  • Karma:
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!
The topic has been locked.

Re:cbjuice error 3 years, 11 months ago #58925

  • Posts:
  • Karma:
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?
The topic has been locked.

Re:cbjuice error -Sample file 3 years, 11 months ago #59120

  • Posts:
  • Karma:
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 ".

Attachment users_test4a.zip not found

Attachments:
The topic has been locked.
Time to create page: 0.76 seconds