Hi,
I added this module to my Drupal 7 site.
I'm trying to import a list of member with the user importer.
When i uploaded my file and Clicked import, Progress bas was displayed and then return in the main page with No imported items.
Here is my error log for all items in my file :
User name missing or email not valid.
Original item

array (
  0 => 'krimos',
  1 => 'xxx@gmail.com',
  2 => 'Med',
  3 => 'Krimi',
  4 => 'xxxxxxxxxx',
  5 => 'xxxxxxxxxx',
  6 => 'passwd',
  7 => 'username',
)
Entity

stdClass::__set_state(array(
   'uid' => 0,
   'roles' => 
  array (
    8 => '8',
  ),
   'status' => '0',
   'feeds_item' => 
  stdClass::__set_state(array(
     'entity_id' => 0,
     'entity_type' => 'user',
     'id' => 'adgc_user_importer',
     'feed_nid' => 0,
     'imported' => 1314930234,
     'hash' => 'f40c5e1793171ea6a6731cc486aacc1b',
     'url' => '',
     'guid' => '',
  )),
   'name' => '',
   'mail' => '',
   'field_nom' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_prenom' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_telephone' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_telecopieur' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'field_titre' => 
  array (
    'und' => 
    array (
      0 => 
      array (
        'value' => '',
        'format' => 'plain_text',
      ),
    ),
  ),
   'pass' => '',
))

Is someone have same issue ?

Comments

stuwat’s picture

stuwat commented

I have the same problem. Did you ever manage to solve it?

stuwat’s picture

stuwat commented

Upon closer scrutiny, I noticed that the source for mapping emails was labelled "email", but my CSV file column header was labelled "mail". Changing the latter to "email" solved the problem.

Looking at your logs, I suspect you have selected the "no headers" option in the mapping configuration. There is a note next to that check box that tells you "mapping sources must be named '0', '1', '2' etc." if you choose that option. Changing your source names should solve the problem for you.

xanxano’s picture

xanxano commented
Assigned: krimos » Unassigned

i'd tried mapping in differents ways, with and without headings... but don't works for me neither.

2012-02-08 14:10:24	 User name missing or email not valid.
Original item
array (
  0 => 'name;mail
xanxano;xxxxx@xxxx.com',
)
Entity
stdClass::__set_state(array(
   'uid' => 0,
   'roles' => 
  array (
  ),
   'status' => 1,
   'feeds_item' => 
  stdClass::__set_state(array(
     'entity_id' => 0,
     'entity_type' => 'user',
     'id' => 'user',
     'feed_nid' => 0,
     'imported' => 1328706624,
     'hash' => 'ff43ddfbe861726418bc7916c3f755fb',
     'url' => '',
     'guid' => '',
  )),
   'name' => '',
   'mail' => '',
))

thanks for help

xanxano’s picture

xanxano commented

ok guys!... my problem was the csv format, not the module. Something stupid that has made me lose my time. Thanks!

fightingsaint’s picture

fightingsaint commented

What is the correct csv format? I'm having the same issue.

Road Kill’s picture

Road Kill commented

I have been pondering the same question. The tutorial shows how to use the module but is not clear on what options or settings should be used when exporting the user CSV.

wusel’s picture

wusel commented

Like I wrote at http://drupal.org/node/622710 - "CSV":

The line-ending-char(s) of a Feeds-imported CSV-file depend on the type of the operating system of the www-server:
If you are using a Linux-Server, please use only "LF" at the line-end of the CSV-file.
If you are using a Windows-Server, please use "CR+LF" at the line-end of the CSV-file.
If you are using a Mac-Server, please use only "CR" at the line-end of the CSV-file.
The changing of the line-end of the CSV-file is important, if the source of the CSV-file (e.g. your computer or the database of the CSV-file) has a different operating system!

You can also use "Migrate". look at http://drupal.org/node/1285276 (Import new users and their "Profile2"-fields from one CSV-file).

Good luck.

emackn’s picture

emackn commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

2¢’s picture

2¢ commented

I just encountered this error and the solution that worked for me was to 'quote all text fields' in my CSV file when using Open Office (this might apply to other cases as well).

On save dialog:
• select "CSV (comma delimited)" file type.
• Ensure "Edit Filter Settings" is checked.
- This will prompt an additional dialog box.
• Ensure "Quote all Text Cells" is checked.

Wala, everything works as expected.

Captjmiller’s picture

Captjmiller commented
Component: Feeds Import » Code

Same problem here.......knuckle-head......there was a blank space preceding the email cell. fixed

gaurishankar’s picture

gaurishankar
he/him
Primary language English
Location Delhi
commented

#2 "Upon closer scrutiny, I noticed that the source for mapping emails was labelled "email", but my CSV file column header was labelled "mail". Changing the latter to "email" solved the problem."
Working for me.

Thanks

knalstaaf’s picture

knalstaaf commented

#10 worked for me.

shobhit_juyal’s picture

shobhit_juyal commented

#10 worked for me too !!

however, I would like to mention a point here for those who still could not get the fix i.e.
You have to change the "Text delimiter" to single Quote[ ' ]...

Actually it worked for me only in this condition.

Thanks