Importing users from CSV

I've downloaded D7 and installed it for the first time. Was surprised to see no apparent built in capability for importing users from CSV or other data.

Is there a marketplace module, extension or other utility that will do this? Or a SQL template that sets out the syntax? How do I map in custom data to custom profile fields? I have found the profile fields builder and have been able to add desired profile fields.

Thanks.

CSV=Comma Separated Values file.

Or could provide the data in Excel. I can massage the source data into whatever format it might be needed, but if there's no established mechanism for bringing it in and mapping it to custom profile fields and it's considered billable agent work, then that's doable but disappointing.

Your first issue of many to come...

You can basically just dump the required data in to the Profiles table.

Okay. I'm creating new user records and importing information effectively through SQL INSERTs, it looks like, but the World Map module isn't recognizing the new users I'm inserting. Only seems to show users that have been added through the Boonex join page.

Yet when I view inserted user profiles, the country flags and country names appear as they should in the profile's General Info box. And I can search the user directory with the people search function and find these inserted users by searching their country.

Advice, anyone, to get the World Map module to see these inserted users? I've cleared the caches, and no dice.

Go to admin->Modules->World map.

Try clicking update profiles, then after that is done, update cities.

Unfortunately, updating the profiles and cities didn't do the trick.

Anyone interested in looking at this is welcome to peek at my fresh D7 install.

List of 4 test users: http://greentechworld.com/browse.php ... look at in extended view... you'll see the country flags as they should be.

Then look at the map: http://greentechworld.com/m/map_profiles/

While two Canadian users show in the extended list user view, only one Canadian shows on the map. The one that doesn't show, ManuelTwo, was imported via phpMyAdmin using an INSERT into the profiles table. I'm reluctant to import thousands of users until I understand what's going on here. And unless I can import thousands of users, I can't go forward with Dolphin.

A SQL dump of ManuelTwo's profile data:

INSERT INTO `Profiles` (`ID`, `NickName`, `Email`, `Password`, `Salt`, `Status`, `Role`, `Couple`, `Sex`, `LookingFor`, `Headline`, `DescriptionMe`, `Country`, `City`, `DateOfBirth`, `Featured`, `DateReg`, `DateLastEdit`, `DateLastLogin`, `DateLastNav`, `aff_num`, `Tags`, `zip`, `EmailNotify`, `LangID`, `UpdateMatch`, `Views`, `Rate`, `RateCount`, `CommentsCount`, `PrivacyDefaultGroup`, `allow_view_to`, `UserStatus`, `UserStatusMessage`, `UserStatusMessageWhen`, `Avatar`, `Height`, `Weight`, `Income`, `Occupation`, `Religion`, `Education`, `RelationshipStatus`, `Hobbies`, `Interests`, `Ethnicity`, `FavoriteSites`, `FavoriteMusic`, `FavoriteFilms`, `FavoriteBooks`, `FirstName`, `LastName`, `OrgDescription`, `Type`) VALUES
(6, 'ManuelTwo', 'test@testy.com', 'random', '', 'Active', 1, 0, 'male', '', 'This is my headline I shall not want', '<p>Description text in HTML format, with p tags at front and back</p>', 'CA', 'Toronto', '1987-03-09', 0, '2010-03-09 09:00:00', '0000-00-00 00:00:00', '2010-03-09 09:00:00', '2010-03-09 09:00:00', 0, '', 'M1L 4V5', 1, 0, 1, 2, 5, 1, 0, 3, 3, 'online', '', 0, 0, '', '', '', '', '', '', NULL, '', '', '', '', '', '', '', '', '', 'And this is Dallas'' custom field. To not really be necessary, me thinks, given that there''s already a description field.', 'Service provider');

Looks ok, except for the password and salt fields.

Take a look a the table bx_map_profiles and see if those member id's are in there and the last field to see if the mapping failed.

The problem was in the bx_map_profiles table. For some reason, was missing a "3" in the allow_view_location_to column, like all the other user records.

I added it, and now it shows fine. Will bear in mind as I try some large scale test imports. Thanks for your help.

Hello Ctcadmin,

I'm having the same problem as you are.

I looked at the 2 links you posted. the 2 users who are in Canada are on the wrong place on the map.

the flag on you map is exactly in the same location as mine is.

are you still working on this issue?