Q1: I got: “Fatal error: Maximum execution time of 30 seconds exceeded in [..]“, why?
Q2: I got: “Connection Interrupted The connection to the server was reset while the page was loading [..]“, why?
A: edit your php.ini search and modify these entries:
max_execution_time = 0
max_input_time = 360 ; If the CSV file is very big might be needed to be bigger
file_uploads = On
upload_max_filesize = 20M ; Or whatever is the size of your CSV file to import
post_max_size = 20M ; Or whatever is the size of your CSV file to import
After importing users you can put back original values!
Q: My CSV file doesn’t import correctly, outputs bunch of unrelated errors, why?
A: Check if your CSV file has a text delimiter and/or field delimiter and tell the plug-in to use the same, or to not use anything if not present.
Field delimiter is the character(s) that delimits every cell’s data:
for example if you have the following row in your CSV file:
"marco","cimmino.marco@gmail.com","Marco Cimmino"
then you must use double quote as text delimiter and comma as fields delimiter, failing to do so will fail the import of such row(s)!
Q: I have more than 1000 users and this plug-in does not export all of them, why?
A: edit your php.ini search and modify this entry:
max_execution_time = 0
After exporting users you can put back the original value!
Q1: I got “Fatal error: Allowed memory size of 8388608 bytes exhausted [..]“, why?
Q2: I got blank pages after activating this plug-in, why?
A1: Because your memory limit is too low, to fix it edit your php.ini and search memory_limit key and put at least to 12M
A2: If you do not have access to your php.ini you can try this workaround (might not work)
http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP
Q: I am using WordPress MS and import feature is not available for anyone else that is not a Super Admin, why?
A: This is a feature of WordPress MS and a possible workaround can be found here:
http://thereforei.am/2011/03/15/how-to-allow-administrators-to-edit-users-in-a-wordpress-network/
Q: When feature XYZ will be added?
A: I don’t know, remember that this is a 100% free project so answer is “When I have time and/or when someone help me with a donation”.
Q: Can I help with a donation?
A: Sure, visit the donation page or contact me via e-mail.
Q: Can I hack this plug-in and hope to see my code in the next release?
A: For sure, this is just happened and can happen again if you write useful new features and good code. Try to see how I maintain the code and try to do the same (or even better of course), I have rules on how I write it, don’t want “spaghetti code”, I’m Italian and I want spaghetti only on my plate.
There is no guarantee that your patch will hit an official upcoming release of the plug-in, but feel free to do a fork of this project and distribute it, this is GPL!
Q1: I have found a bug what can I do?
Q2: Something does not work as expected, why?
A: The first thing is to download the latest version of the plug-in and see if you still have the same issue.
If yes please write me an email or write a comment but give as more details as you can, like:
- Plug-in version
- WordPress version
- MYSQL version
- PHP version
- exact error that is returned (if any)
after describe what you did, what you expected and what instead the plug-in did 
Then the MOST important thing is: DO NOT DISAPPEAR!
A lot of times I cannot reproduce the problem and I need more details, so if you don’t check my answer then 80% of the times bug (if any) will NOT BE FIXED!
160 Responses
« Previous 1 2 3 Next »
Hello. Great plugin. Unlike a user earlier, I would like it to email users when importing. Do you know of anyway to make this happen?
Dan:
this has been added in v1.0.0 more than 2 months ago.
Hey thanks marco, sorry was stuck in wordpress 2.9 so didn’t notice the update sine i hadn’t moved to 3.0 yet. Thank you!
Hi Marco – your plugin ROCKS … so far so good in that i did a test on WordPress MultiSite 3.04 and was able to run the plugin from site #2 (sub site on the network and not primary site) and your plugin uploaded my csv file and created the new users while preserving their “silo’d” status to that 2nd blog site … other plugins i’ve tried failed to honor this and have assigned new users to the primary blog regardless of what sub site i (or admin user) i was logged in as … and then there was another plugin that did honor silo’d user imports but had no feature to check if users were already in the system … your plugin does both (import silo’d users and double checks if already in database) very elegantly :>)
the only issue for me is understanding why “% USER_NICENAME %” was rejected on import ..??..
in looking at your code, it appears that all i would need to do is define user_nicename at top and then modify the function cimy_um_import_data() ..
thus add something like this at top -> $nicename = “% USER_NICENAME %”;
and then append/modify the function cimy_um_import_data()
..??.. i’m not using your Cimy User Extra Fields plugin yet thus don’t want to break anything hence touching base …
Kudos on brilliant work and thank you for your contributions to the WordPress community :>) cordially, chuck scott
chuck scott:
coding takes time, make a donation and I can plan this feature request.
Excel (2010) doesn’t export CSVs with a text delimiter. When importing excel CSV’s, remove the ” delimiter and it works without the _ character workaround…or modify the import function to not require the delimiter.
When I click on “Export” users I get the confirmation that the csv file has been generated. After downloading the export file, I open it with MS Excel 2010, and it gives me a blank file. The same happens when opening it with notepad, etc.
Any idea why the download file isn’t populated?
Scott:
Using version 1.0.0 of the plugin? Is your target directory writable?
Yes, I’m using v1.0.0, and the target directory is writable. The issue isn’t that the file isn’t being created though. It’s when I click to download the export file, it doesn’t have anything in it.
Hi Marco. I would like to publish a list of users on my blog using the Cymi user manager data. Is there a shortcode for doing this?
Rob Klaassen:
No. This plug-in import/export only.
OK. Would you consider developing this for a donation? I can see a lot of people around the web searching for the list-functionality combined with the possibility of adding extra fields.
I developed this internally, but is not public
shame!
Nice plugin, very usefull.
Have a error “username missing cannot add an user without it (line 2)”
but every field looks rigrth
“user_login”,”user_name”,”user_email”,”user_pass”,”user_nicename”,”display_name”
“log1″,”log1″,”federico@szo.com”, “cat”,”log1″,”log1″
CAN YOU HELP ME?
Fede:
Nothing actually look right if you would have read the documentation, your line should look like:
“% USERNAME %”,”% EMAIL %”,”% PASSWORD %”
“log1″,”federico@szo.com”,”cat”
Display name and nice name are not yet supported as you can see from other comments.
I encourage you to read documentation before commenting.
Thank you very much,
Really sorry not having seen it , I promisse I read every thing I found
Is all the documentation at this page and at wordpress?
Thanks
Excellent plugin, and made the 3.0.4 to 3.1 upgrade seamlessly (almost)…
Before when my Users went to their profile (/profile.php), the Additional Fields were displayed before the default WP fields and my Users LOVED this…
When I upgraded to 3.1, the fields still show up but now below the password & password check. Everything is still there, but I was curious if there was a way to move the extra fields back above the WP fields???
I looked in the /wp-admin/user-edit.php file, but didn’t see anything really jumping out at me.
I apologize if this was in the documentation, but I could not come across it anywhere.
Slydawgg:
Actually I have NO idea how they were _before_ WP fields, maybe you were using some hacks or some other plugins not developed by me.
Thanks for your reply.
Maybe I should ask this – how does your CIMY plugin get appended to the user profile file? What’s the file or function that I should look for.
Hi Marco,
Fantastic plugin! The download link for User Manager is broken on your website, but I still figured out how to download it. Also, it does not export registration date. Is registration date a field that must be filled out by user?
Cheers!
Michael Penner:
Yes all download links are broken, not sure why yet, I’ll try to fix them.
I can add registration date too to the export list indeed.
Marco,
I installed your Cimy User Manager plugin on my old blog and my new blog, exported the csv from the old one, and attempted to reimport the csv into my new blog. It gives the same error for every line: “username missing cannot add an user without it”. I followed the directions to the letter. Not sure what I’m missing.
MYSQL Version : 5.1.50-community
PHP Version : 5.3.5
WP Version: 3.1.1
Cimy User Manager Version: 1.0
Same problem here!
Bruno Cezar Ferreira:
The problem of the the user Warren was that Excel modified the file and removed the text delimiter without telling this to the plug-in.
Your case I don’t know, if you do not read the FAQ and not provide at least an example of your csv file and settings I cannot guess.
I am not using excel. I am using CSVed.
Take a look.
ERROR
http://www.brunocezarferreira.com.br/downloads/erro.jpg
CSV FILE
http://www.brunocezarferreira.com.br/downloads/users.rar
Thanks
Bruno Cezar Ferreira:
Again same problem you are not respecting field delimiter, you cannot have some fields between “” and some not, you need to be consistent!
Hi,
i found a (small) Bug:
=> Fresh WP Multisite (3.1.3), with an existing Userbase (from an old great Blog).
=> if you import Users from an other (old and small) Blog they overwrite the existing Users with the new Data (User E-Mail and Role changed).
As exampel – if you have existing Users with the ID 1 .. 500 and then import Userdata from an other Blog (17 Users) the ‘old’ and already existing Users with the ID 1.. 17 are overwritten – old Username but new E-mail Adress and Role.
Ah.. i have tested a little bit more..
So if you have an existing WP Multisite with Users (example1.blog.tld) , and you create/add an other Blog at the Install (example2.blog.tld) and then import on the ‘new’ Blog with our Plugin, it take the Userdata (Loginname and Nicename) from the Userdata of the Main / first Bloginstall who have the same UserID from the Import.
=> Loginname taken from the first Blog and then only added the E-Mail and Profil Data from the import.
If an User are already registred at the first Blog with the same E-mail in the import data > the User becomes an Account without E-Mail Adress.
I hope you can fix the Bug
Befagor:
The plug-in is meant to update existing user so I do not see big issues here, registering to one blog or to another is the SAME, since all users in WordPress MS end up in the same table.
So how should behave in your opinion? If you use the same username this to me sounds normal that recognizes it as the same user.
Uhm.. see it so:
You have an WordPress MS Installation and would merge some Blogs with different Users (the Userid begin in every old Blog from 1) to your WordPress MS installation – the Subblogs should be an own ‘Community’.
But you can’t Import Users to the Subblogs without that they become (at Moment) the loginname from the Default Blog, if the have the same Userid.
You understand my Problem?
I think at Moment your Plugin look first: Is the e-mail adress used -> yes -> next user or (thats ok) and second if the have the same Userid => take the Loginname and update the Rest with the Importdata (thats not ok for me.
I think it schould be so (only loginname and e-mail adress are unique, userid is an variable:
Step 1: look if e-mail adress syntax is correct and then if e-mail adress is in the Database – if yes then let the User untouched and go to the next user in the Importlist, if not go to step 2.
Step 2: Look if the loginname is in the Database – if yes update this with the e-mail etc. (send if checked an e-mail to this e-mail for notify that is changed) if not -> step 3
Step 3: If the e-mail address and loginname not in the Database -> create an new User with the data from the Importlist (with all other Tests you do here).
This is an little other Way who you use at Moment, but i think this would an Solution for my Problem and also for others who would merge more then one Blog with different Users.
An other Solution is, that before the Import start, the Importer must look manuell at the highest Userid that used at Moment in the Blog and then edit the importlist with hightest userid +1 .. to the End of the Importlist and start then the Import. For an small Userlist thats should be ok.. but for Lists with 100+ Users…
Greetings,
Daniel.
Befagor:
I agree with some of your statements, I can fix this, but not in the immediate future, since I have a lot of request on Cimy User Extra Fields plugin.
Feel free to donate and speed up the process or wait for a fix.
Hi – I’ve used the extra fields plugin to creat some additional fields in order to import users from an old Drupal site. I can import the users using the user manager plug-in, but the extra fields are not importing. I’m working on a Fresh install of WordPress 3.1.3, single site, with MySQL version 5.1.52 and PHP Version: 5.2.17.
Here’s a sample record set I’ve been testing:
“% USERNAME %”,”% EMAIL %”,”% ROLE %”,”% FIRSTNAME %”,”% LASTNAME %”,”% PHONE %”,”% STREET1 %”,”% ALT_NAME %”,”% LIST_EMAIL %”,”% LIST_PHONE %”,”% DONT_LIST %”,”% NEIGHBORHOODWATCH %”,”% SAVE %”,”% PASSWORD %”
“bob”,”bob@email.net”,”subscriber”,”bob”,”smith”,”123-1709″,”4175 Black Canyon”,”",”0″,”0″,”0″,”0″,”1″,”pass”
“jim”,”jim@email.net”,”subscriber”,”jim”,”smith”,”124-1709″,”4118 Tallgrass”,”Jim and Jane smith”,”0″,”0″,”0″,”0″,”1″,”pass”
And here is the error:
‘% PHONE %’ field doesn’t exist (line 2)
‘% STREET1 %’ field doesn’t exist (line 2)
‘% ALT_NAME %’ field doesn’t exist (line 2)
‘% LIST_EMAIL %’ field doesn’t exist (line 2)
‘% LIST_PHONE %’ field doesn’t exist (line 2)
‘% DONT_LIST %’ field doesn’t exist (line 2)
‘% NEIGHBORHOODWATCH %’ field doesn’t exist (line 2)
‘% SAVE %’ field doesn’t exist (line 2)
I’ve checked my extra field setup, and these fields do exist with these names. The order of my extra fields doesn’t match the order in the CSV file, but I seem to remember reading that this doesn’t matter.
nick:
For extra fields you do not need to add ‘% %’ just the field name straight.
That was it. I must have looked at the instructions 100 times, but only after you pointed out that the extra fields did not need the ‘% %’ did I actually see that…
thanks!
“% ROLE % – change the role, choose between: [subscriber|contributor|author|editor|administrator”
this is not working for me, it says it has updated but it hasn’t
Paul Roberts:
Doesn’t work for me doesn’t help me at all.
Read the FAQ above your head, answer questions and provide an example where I can see how you try to set it.
I want to change the role from subscriber, i’m uploading
“% USERNAME %”;”% ROLE %”
“user1″;”lapsed”
“user2″;”lapsed”
USERS SUCCESSFULLY MODIFIED (2)
‘user1′ (line 2)
‘user2′ (line 3)
but the user role is not updated, i’m using multisite.
“lapsed” is not a role, sorry. If it’s in your own language then this is wrong, you need to use English.
Hi Marco,
Firstly thanks for this handy plugin – odd that wordpress itself doesn’t offer the ability to add extra fields!
I have a small problem exporting my users, I have set the PHP timeouts to give plenty of time but unfortunately my host has some programming that kills any processes running longer than 60 seconds. Is there some way I could export my users 1000 at a time? Or export all added from a certain date?
I’m ok with PHP (but quite new to wordpress) and happy to try tweaking the code a bit if you could point me in the right direction.
/programming/program running/
trapper:
Indeed is a bit of a problem, probably I should add a feature to let divide the export in chunks… I don’t have better ideas so far.
Marco I have been thinking further about the timeout issue…
It really shouldn’t be an issue to begin with as it is not actually *that* much data being dumped, ie phpmyadmin can dump my entire database in under 30 seconds.
The slowness arises from the thousands of SQL calls which are being issued via the get_cimyFieldValue function – once for each extra field of each user, and every time with a JOIN in it.
I’ve run a few tests on my server and it is taking around 0.03 seconds per user to execute the 20 or so SQL calls required for my extra fields. This quickly adds up with a several thousand users; 0.03 * 1000 alone is already 30 seconds.
Thoughts?
Surely I can do better there, let me see if I find some time for it.
v1.1.0 should be much faster and uses less memory!
Or just check for a recent partial export file and then resume where it left off?
You could even set the process to stop and refresh itself after X seconds. Could then display a nice progress meter then too… ’500/1000 users exported…’ etc
Since v1.1.x it retrieves 250 users at a time and iterate till they are finished using way less memory.
Another optimization then retrieves all extra fields values at once per every user (instead one value at a time) and this will increase exporting speed.
Try it!
Hi Marco:
I’m sorry for the question; I’m just not skilled enough in CSV editing, I guess. I’ve tried importing a user file with a bunch of fields but I keep getting the “username missing cannot add an user without it (line 2 — and so on through Line 338).”
I have put “% %” on either side of the fields I want to import. The others I didn’t put anything around because I figured the user manager wouldn’t bother with those.
“USERID”,”"% TYPE %”",”"% COPIES %”",”TOPLINE”,”"% USERNAME %”",”"% ADDRESS1 %”",”"% ADDRESS2 %”",”"% ADDRESS3 %”",”"% ADDRESS4 %”",”"% EMAIL %”",”Bill”,”"% FIRSTNAME %”",”"% LASTNAME %”",”SUFFIX”,”NAME”,”TITLE”,”DEPT”,”"% COMPANY %”",”STREET1″,”STREET2″,”"% CITY %”",”"% STATE %”",”"% ZIP %”",”ZIP2″,”CARRT”,”CNTRYCODE”,”COUNTRY”,”"% PHONE %”",”"% FAX %”",”EMAIL”,”USERID”,”"% PASSWORD %”",”SALUTATION”,”SEX”,”DEMCODEA”,”DEMCODEB”,”DEMCODEC”,”DEMCODED”,”DEMDATA1″,”DEMDATA2″,”CASSDATE”,”CUSTNUM”,”ORDERNUM”,”ACSKEY”,”"% EXPDATE %”",”TRACK”,”SOURCE”,”"% ROLE %”"
I’m using CSVed as a CSV editor
Do I need to put the “% %” around every field, even if I don’t want to import that?
Thanks
Rules as per documentation:
1. WordPress fields they should be like “% fieldname %”
2. Extra fields they should be “fieldname” so without % %
3. if you do not want to update a field just do not include the entire column at all
So edit your file accordingly.
Thank you — grazie!
Hey, any suggestions on how to handle (i.e., import) custom contact methods. as in:
function add_custom_contactmethod($contactmethods) {
$contactmethods['fax'] = __(‘Fax’);
return $contactmethods;
}
add_filter(‘user_contactmethods’,'add_custom_contactmethod’,10,1);
obviously, the Fax could go in as a cimy-user-extra-fields field.
but, we depend on another plugin that sets and requires a PHONE field for users.
Not supported at the moment sorry.
I’m getting this:
Invalid address: Enter your admin email hereYou must provide at least one recipient email address.
Every time I try to add users. The user is added to the user list correctly though, and includes their email so I’m a bit confused?
The user does not receive an email however.
This comes from the mailer, when enabled the option to email new users.
Can you double check that under: Settings -> General -> E-mail address there is actually a valid e-mail address?
Thanks Marco, that’s what I thought.. But yes, there is my normal email address in there (no spaces etc.)
Oooh my apologies Marco.
It’s because I had a plugin called New User Email Setup installed and active.
That was hijacking wp_new_user_notification
Disabled and working!
Thanks again, very handy app.
I installed the plug-in and we do also use the Cimy Extra Fields Plug-In, and I go through the export, it says the CSV file was created, but when I hit download it does not download, and when I go in via FTP and to the folder that is specified the CSV file is not there, even though it says it was successfully created. Any thoughts?
Is the directory /wp-content/cimy-user-manager created and writable by the web server?
Yes, on the export screen, it says just that under the directory.
Can you please read the FAQ and provide more info?
I read the FAQ before I resorted to commenting. when I go into User Manager and go down to Export, next to Upload path, it has the path you referred to of /wp-content/cimy-user-manager/ listed and under it, it says that path is “created and writable.” After I click on export, I get the box that says the file was generated, with the path name again, including the csv file name, and when I click on “Download Export File” I do not get a download. And when I go into the FTP files directly, and navigate to that directory/folder, there is no CSV file there.
Yes and last item of the FAQ is asking you more information.
Marco,
I resolved the issue finally. Even though on the export screen, it was saying the path is “created and writable” it was not. The server our client is on was restricting the writing ability to that folder since it was automatically generated, but I was not getting any error message saying it was not able to write the file. So, I went into the control panel and created the folder where the .csv file was to go with full permissions and it’s working great now. Thanks.
I use this function to determine if I can write or not in that dir:
http://php.net/manual/en/function.is-writable.php
And I could read:
“Safe mode limitations are not taken into account.”
maybe your case.
Marco,
I have tired to import about 100 times and been reviewing your website for 2 weeks and am having no luck. Everything is importing except for the existing passwords of users. I am importing from another system and I want the users passwords to stay the same. After I import it tells me that the users have been modified. They I try to login using the username and password from the CSV file and it won’t accept. If you have any ideas or suggestions as to why this won’t work for me I would greatly appreciate it. Thank you for this great plugin.
% USERNAME %,% ROLE %,% FIRSTNAME %,% LASTNAME %,% NICKNAME %,% DISPLAYNAME %,% EMAIL %,% PASSWORD %
AAgustoni,subscriber,Ann Agustoni,Anne Agustoni, Ann Agustoni, AAgustoni@xxxxxxxx.com,oTH963852741
Seems you have 8 columns in the header and 7 in the data.
Sorry, I was only able to copy and paste and had to add the comma’s in the post to show you an example. The CSV file I am using does have 8 columns and 8 elements of data.
AAgustoni,subscriber,Ann Agustoni,Anne Agustoni, Ann, Agustoni, AAgustoni@xxxxxxxx.com,oTH963852741
Please read the FAQ provide proper information and provide a full CSV with a full header and one full row that fails, not a “summary” of it.
You can send via email if you think your privacy would be in danger.
I have been testing your plugin with our setup and have a couple questions.
I’m using WP 3.2.1 and your plugin 1.2.0.
When I do an import test, it is not sending an email to existing users that their password as been updated. Is there something I’m missing with that? I check the box next to “Send an email to the existing users with the new password.” but it doesn’t work.
Any new users I add via the CSV import does get an email with their password though.
Also, is it supposed to be setting the password to be the same as their username? Is there a way for it to generate a generic unique password for all users upon the import?
What I’m trying to achieve is a way to update all of our users about every 8 weeks for our internal website. I guess I’ll be deleting everyone except my admin account, then importing everyone from a CSV file we’ll make from our personel DB.
Thanks in advance.
Yes I can add a better unique password indeed.
About the email: please check your server’s log about that, might be not a plug-in’s issue.
Forgot to mention this – and not sure if it matters. I am running IIS – Windows server.
In installed your Swift SMTP plugin and the test message worked fine.
However, when I try to import and send the passwords to the new and current users, I get an error message.
Fatal error: Uncaught exception ‘Swift_RfcComplianceException’ with message ‘Address in mailbox given [] does not comply with RFC 2822, 3.6.2.’ in E:\inetpub\vhosts\internal.waynecc.edu\httpdocs\safety\wp-content\plugins\cimy-swift-smtp\Swift\lib\classes\Swift\Mime\Headers\MailboxHeader.php:308 Stack trace: #0 E:\inetpub\vhosts\internal.waynecc.edu\httpdocs\safety\wp-content\plugins\cimy-swift-smtp\Swift\lib\classes\Swift\Mime\Headers\MailboxHeader.php(238): Swift_Mime_Headers_MailboxHeader->_assertValidAddress(”) #1 E:\inetpub\vhosts\internal.waynecc.edu\httpdocs\safety\wp-content\plugins\cimy-swift-smtp\Swift\lib\classes\Swift\Mime\Headers\MailboxHeader.php(96): Swift_Mime_Headers_MailboxHeader->normalizeMailboxes(Array) #2 E:\inetpub\vhosts\internal.waynecc.edu\httpdocs\safety\wp-content\plugins\cimy-swift-smtp\Swift\lib\classes\Swift\Mime\Headers\MailboxHeader.php(60): Swift_Mime_Headers_MailboxHeader->setNameAddresses(Array) #3 E:\inetpub\vhosts\internal.waynecc.edu\httpdocs\safety\wp-content\plugins\cimy-swift-smtp in E:\inetpub\vhosts\internal.waynecc.edu\httpdocs\safety\wp-content\plugins\cimy-swift-smtp\Swift\lib\classes\Swift\Mime\Headers\MailboxHeader.php on line 308
If I turn off Swift SMTP, this error goes away. But I still have the problem of the Cimy User Manager sending emails to new users but not current users.
Any thoughts?
Yes seems there is a bug in Cimy User Manager, can you try the development version? I think I fixed it.
http://downloads.wordpress.org/plugin/cimy-user-manager.zip
EDIT2:
Please download from link above and be sure is v1.2.0.2 should be all good. Let me know.
I removed the old files, uploaded the new files.
In the test of this, my new users get a new and unique password, which is perfect!
However, my current users got an email but their new password was not provided. The email content looks like this.
[Safety] Your new password
Brent
« Previous 1 2 3 Next »