Mass import users into WP
I am working on a complex blog/e-commerce system together with my colleagues at @ntw. I had to import some 10.000 users into WP. The task was easier than expected. The basic idea is leveraging on the wp_insert_user($userdata) function, defined in wp-includes/registration.php. If you look at the source, you’ll see that $userdata is an array containing a number of keys:
* The $userdata array can contain the following fields: * 'ID' - An integer that will be used for updating an existing user. * 'user_pass' - A string that contains the plain text password for the user. * 'user_login' - A string that contains the user's username for logging in. * 'user_nicename' - A string that contains a nicer looking name for the user. * The default is the user's username.
The other keys are user_url,user_email, display_name, nickname, first_name, last_name, description, rich_editing, user_registered, role, jabber, aim, yim; for more detal consult the source itself.
My script goes like this:
<?php include 'wp-blog-header.php'; include 'wp-includes/registration.php'; include 'wp-includes/pluggable.php'; ini_set("memory_limit","1024M"); ini_set("max_execution_time", "240"); global $wpdb; ?> <h1>Importazione utenti EC</h1> <?php $connection = mysql_connect("host", "user", "password") or die("Unable to connect to MySQL"); mysql_select_db("database", $connection) or die("Unable to connect to the database"); $result = mysql_query("SELECT * FROM source_users ;"); while ($row = mysql_fetch_object($result)) { echo "<strong>ID:</strong>".$row->id." <strong>login:</strong>".$row->user_name." <strong>password:</strong> ".$row->password." <strong>e-mail:</strong>".$row->email_address." <strong>name:</strong> ".$row->name." <strong>surname:</strong> ".$row->surname."<br/>"; // Add the ID to trick WP $add_id = "INSERT INTO ".$wpdb->users." (id, user_login) VALUES (".$row->id.",'"."$row->user_name"."' ); "; mysql_query($add_id) or die(mysql_error()); // Add the rest $userdata = array( 'ID' => $row->id, 'user_login' => $row->user_name, 'user_pass' => wp_hash_password($row->password), 'user_nicename' => $row->user_name, 'user_email' => $row->email_address, 'first_name' => $row->name, 'last_name' => $row->surname, 'role' => 'subscriber' ); wp_insert_user($userdata) ; } } mysql_close($connection);
Some highlights:
- Import all the WP files you need
- Change PHP memory and time limits if you have many records
- Explicitly encrypt the password with
wp_hash_password. I have no idea why this is necessary, the WP code should do this by itself; but trust me, it is.
Since we are using the wp_insert_user() function, WP will crate records both in the users and in the usermeta tables.
A last warning. This huge amount of users could conflict with your php settings. To get WP working properly I had to add this line to wp-config.php:
define('WP_MEMORY_LIMIT', '64M');
Without it I could not get the users list in the admin session. I also filed a bug, but this last line should keep you on the safe side.
Enjoy!
2010-03-17 at 3.08 pm
Hi all, just found this here when i did a quick google search. Nice site you got here! Keep it up!
2011-01-20 at 6.17 pm
Wow, thats a very informative blog entry . I like your style of writing. Maybe you should write more articles of these type.
2011-07-31 at 4.55 pm
It’s hard to seek out educated people on this topic, but you sound like you know what you’re speaking about! Thanks
2011-09-28 at 12.16 pm
Beihaosi sponsor the Banff Mountain Movie Festival touring exercise in China Canada coming into China 2010 Banff Mountain Film Festival, screening will be the 2nd time in your own home this year. United kingdom specialist outside movement brand name beihaosi as Banff Film Festival things to do of official supplier provides on the Asgard Challenge beneath Chinese translation askard expedition beneath film, instructed litigation has by beihaosi sponsored of worldwide athletes Liao锟斤拷huoding charge group initial occasions achievements cost-free climbing has Arctic Circle Baffin Island of Asgard was wellbeing feared of North 2000 m vertical cliff of tale, Oscar documentary Director Alastor capture has its the expedition feat of each moments, Show a people today longing for us tour of outside exploration. Movie proven from the group in targets of the friendship and the spirit of by no means giving up won the film critics unanimously praise, lots of out of doors movie festival has acquired several awards in your own home and overseas. Beihaosi gives the askard expedition in 2010 to the Banff Movie Festival very best documentary outside rock climbing courses, because the opening movie Film Festival this yr participated within the four metropolitan areas in China (Beijing, Shanghai, Chengdu, Shenzhen) tour showing activity. Beijing exhibiting activity from September 17-18th in SanLiTun village cinema, popular web page exceptions, almost in excess of extra than 2000 folks took piece on this film festival in Beijing railway station to observe routines. Viewers from the askard expedition movies gave a significant appraisal, and actively participated inside the interactive actions and brand. September 24, Banff Film Festival in Shanghai Xintiandi UME Cineplex showing, by then Shanghai out of doors fans could have the chance to watch for the quite superior praise and repeated winners with the askard expedition. After Shanghai, October 15-Banff Movie Festival will arrive to Chengdu, October 22-will the viewers with Shenzhen. PHENIX was launched in 1952, from the date of birth to tackle each of the conflicts to restrict outside actions and hoped that their merchandise can provide outdoor sports enthusiasts together with the most intimate assistance. For quite a few many years to restrict out of doors sport globe champion sports activities equipments turn into the initial selection of, and was desired in Europe, the Asian members of the Royal friends and family, as its out of doors divertissement specified gear. 锟斤拷锟斤拷As an business pioneer, PHENIX was launched 25 ages ago, the initial abroad analysis and Progress Middle, our know-how is dedicated to specialized advancement and investigation of passe-temps clothes. Immediately after numerous several years of painstaking homework, the cycle of technologies accumulation as well as world’s foremost extensive utilization of useful products, PHENIX has based on the forefront in the in-depth review over the improvement of mechanics and physiology of human entire body movement techniques. 锟斤拷锟斤拷PHENIX, with its professional, not just enjoys a higher popularity inside the industry, also contains a series of cooperation jobs with other establishments of scientific homework and apps, as well as a lot of unique distinctive patents and trademarks, PHENIX is becoming in Europe and The us, as well as Japan and South Korea major model of high-end ski marketplace, but in addition lays the PHENIX exceptional leadership in expert and technical homework and progress. 锟斤拷锟斤拷Among them, by PHENIX impartial analysis and improvement, contains a expert superior operation waterproof and moisture permeability materials LEVEC is properly really worth mentioning. LEVEC large h2o stress resistance and moisture permeability fabrics, laminating method even though keeping the higher amount of water resistance features, continued to guard the shape not intrusion by the rain damp while in the rain and snow, correctly stop rain and snow rainwater though also reaching drinking water vapor permeability, don’t just to soak up water vapour and moisture, and height to avoid condensation and damp air from the outfits, bolster hold outfits dry and relaxed within and exterior. 锟斤拷锟斤拷In addition, LEVEC is divided into 3 unique amounts, concerning resistance to water pressure and drinking water vapor permeability range for various strength of outdoor sports. 1, Advanced Significant Effectiveness superior h2o strain resistance and moisture permeability materials may be used to get a big selection of out of doors activities, water-resistant and moisture permeable processing prevents rain and snow invasion, lowering garments damp. (Drinking water pressure resistance: 10,000mm water vapor permeability: eight,000-10,000g/square meters/24hrs) 2锟斤拷Ultimate Performance 锟斤拷锟斤拷Use water-absorbing non-porous films of plastic fabric, superior stress and moisture permeability fabrics, adapted to the harsh environments of all kinds of out of doors sports activities. Movies with absorbing properties of steam and h2o, height preventing dew and damp air while in the suit. (Water pressure resistance: twenty,000mm h2o vapor permeability: 20,000g/square meters/24hrs) 锟斤拷锟斤拷3锟斤拷High Operation 锟斤拷锟斤拷Oriented waterproof pressure resistance, substantial moisture permeable material, laminated drinking water resistant functionality of processing when retaining high amounts and realizing water vapor permeability it. (H2o strain resistance: twenty,000mm more drinking water vapor permeability: 10,000g/square meters/24hrs)
spyder jackets outlet spyder mens jacket
2011-10-21 at 11.13 am
fafhew fejwaogf
2011-10-21 at 11.13 am
sfka
2011-11-07 at 3.31 am
Europe Goose had done over 50 leather-based coat. They are made from leather hat, is obviously windproof along with water resistant quality products, even got a chance to Antarctica, I believe although absolutely trustworthy thermal merchandise. Needless to say, at the same time, adhere to the design style of Nova scotia Goose, is also the application within the pavement of recent You are able to style floral. They even moved the actual Shiny Damon your Artist celebrity. If you are an individual, you can combination lengthy sleeve T-shirt donning, or, or perhaps in bad weather any time dressed up in the fit outside the house. Possess abundant pouches from the coat coats, not just hot the hands, but additionally to go out of your current mobile phone and also Personal digital assistant ample spots. Simultaneously, Hat clothing layout, therefore the whole garments seem much less rigorous, you can ready to accept put on, or perhaps you may take on zip. Combine african american along with khaki, is the every day perform associated with cold-the finest products.
Suggested center language: “New York Block wind windy, My spouse and i tend to be may be simply no options wearing Shang beautiful involving top, but since We take part in Lanvin Paris Demonstrate industry, We about into it regarding costume very captivated, doesn’t regulations involving neck-line much more pertaining to My partner and i, because My partner and i of provide because often workout, will certainly a few tiny involving muscle tissue, and this part colour doesn’t way too vibrant, simply because My partner and i is really a prepared steady involving female, therefore i does not hope in 2011 springtime summer season too overstated, just have go with a new dual New sandals upon could access numerous events.
This really is actually, produced through mixing a pair of types of design. A has been well accepted simply by major people in politics and cool patterns of children like to connect; and another is as simple as yacht owners, Ivy League people just like tie with student. This specific design and style is to say thanks to anyone who has the actual creative imagination involving developers, for instance Psychological Bunnie as well as Bill Sherman. Naturally, these kinds of scarves, will bring you a bit of American-style, at the same time, don’t cause you to look quite stubborn. Dark bamboo jacket and you are helping. Ultimately, this is 2009, a single powering obama, that is put together race wouldn’t normally like?
The japanese largest store Usa ARROWS recently unveiled the excitement involving outdoor brand through Greater Nova scotia Goose Combined. Only using the present Hudson Vest according to good quality items to the North america Goose Alberta Vest, and by the UNITED ARROWS to be able to wealth of fine detail, while maintaining the first large perform simultaneously, fully incorporated into the popularity in the Japanese-style components. Content selection, left behind the original nylon Ripstop along with contains a lot more Arctic Technical technological innovation of top quality cloth, achieving much more wind-warm power. Things is going to be introduced Four diverse color schemes, are typically in the the fall and winter don, and should be for sale noisy . Oct.
In 2010, unlike past years coating associated with heavy and comfortable diverse fashion pattern ventured into knitting, cutting superb cosy pelt about the fur or even diamond jewelry. This is a traditional mix of discretion and also to fulfill the occasion night and day, function and leisure wants. Obviously, economic components having an influence on the style remains to be, right now it is the enhancer of fur goods. Use pelt you aren’t only individual option, where ever you’re keen on furs, correct or false came out as it hot to suit your needs style. Europe Goose model Boss Dani Reiss believe coat has its functional part, including cozy. Arctic exploration police officer and Ie frequently dressed in Bad guy throughout Europe Goose buckskin hat versus cold. Of course, Nova scotia Goose inside the top selling manner city.
Canada Goo se Mantra Canada Goose Jackor Canada Goose Online Store Womens Canada Goose Chilliwack Bomber Green Tea High-end features fabric suppliers entered a time period of enlargement of manufacturing capacity
2012-03-06 at 2.51 pm
I wanted to compose you that tiny remark so as to give many thanks yet again for those gorgeous secrets you have shared at this time. It was so strangely generous with you to offer extensively what many people could have made available as an e-book to generate some cash on their own, precisely since you could possibly have tried it in case you wanted. These tips additionally worked to become a great way to fully grasp most people have the same interest really like my very own to figure out significantly more on the topic of this matter. I believe there are lots of more pleasurable moments ahead for individuals that looked over your site.
2012-03-21 at 4.18 am
Hello there, simply was aware of your blog thru Google, and located that it is really informative. I am gonna be careful for brussels. I’ll appreciate if you continue this in future. A lot of other folks shall be benefited from your writing. Cheers! London Escorts Agency, 020 3011 7825
2012-03-24 at 8.10 am
Thanks for sharing Life Changing Self Hypnosis MP3s By Email. » Marianna’s Tips with us keep update bro love your article about Life Changing Self Hypnosis MP3s By Email. » Marianna’s Tips .
2012-03-24 at 8.53 am
Avoided Delta to save $1.00, and this is where it got them.
2012-04-06 at 7.00 am
Thanks so much for giving everyone an exceptionally nice chance to read articles and blog posts from this web site. It is always so terrific and jam-packed with a good time for me personally and my office mates to visit your website a minimum of three times every week to learn the fresh guidance you have. And of course, I’m certainly amazed with all the attractive principles served by you. Certain 2 points on this page are really the simplest we have all ever had.