http://wordpress.org/support/ WordPress › Support Tag: users-to-csv en Thu, 26 Nov 2009 01:12:47 +0000 http://wordpress.org/support/topic/315392#post-1226663 Sun, 27 Sep 2009 16:20:03 +0000 Bohlin 1226663@http://wordpress.org/support/ <p>Hello</p> <p>I would like to create a role that is able to export the user list with user-to-csv but not have all admin capabilities. </p> <p>I use capability manager to manage my roles but i have not managed to allow other roles than admin to use users-to-csv.</p> <p>Is htere a way to include usertocsv in the list of capabilities in capability manager? Or is it possible to do something in the user-tocsv code that give other roles the possibility to export users?</p> <p>regards<br /> Lars </p> http://wordpress.org/support/topic/237371#post-1188159 Wed, 26 Aug 2009 01:51:54 +0000 klabunde1998 1188159@http://wordpress.org/support/ <p>BigZack<br /> Thanks for the help, works much better in excel! </p> http://wordpress.org/support/topic/237371#post-1143152 Sat, 18 Jul 2009 22:10:41 +0000 WebTechGlobal 1143152@http://wordpress.org/support/ <p>I created a similiar CSV plugin but it is CSV to POST.</p> <p>I put it together this week and going to make some serious updates to it so that it does anything CSV+WORDPRESS. I've seen CSV to USERS alot, is this in big demand then? Why are people exporting user data as CSV file, is this how they are backing it up I guess?</p> <p>My plugin is here, hopefully by the time someone else finds this my plugin also does user data but right now it does ANY CSV file TO post without editing the CSV file...</p> <p><a href="http://www.webtechglobal.co.uk/wordpress-services/wordpress-csv-2-post-plugin" rel="nofollow">http://www.webtechglobal.co.uk/wordpress-services/wordpress-csv-2-post-plugin</a> </p> http://wordpress.org/support/topic/250037#post-1140345 Thu, 16 Jul 2009 13:32:00 +0000 Lens 1140345@http://wordpress.org/support/ <p>Ok I found a little work around. Its not very clean I suppose, but I am not a coder. This works with the extra fields from <a href="http://www.marcocimmino.net/cimy-wordpress-plugins/cimy-user-extra-fields/">cimy</a>. I suppose it should also be easy to adjust this for Register Plus.</p> <p>Ok here we go for the modifications of the users2csv.php file (Version 1.4.2):</p> <p>Line 149 add to the following array the additional fields you would like to have: </p> <p><code>$fields = array(&#39;URL&#39;,&#39;E-Mail&#39;,&#39;URL&#39;,&#39;Display Name&#39;,&#39;Registration Date&#39;,&#39;First Name&#39;,&#39;Last Name&#39;,&#39;Nickname&#39;);</code></p> <p>example:<br /> <code>$fields = array(&#39;URL&#39;,&#39;E-Mail&#39;,&#39;URL&#39;,&#39;Display Name&#39;,&#39;Registration Date&#39;,&#39;First Name&#39;,&#39;Last Name&#39;,&#39;Language&#39;,&#39;Adress&#39;,&#39;Zip Code&#39;,&#39;City&#39;,&#39;Country&#39;,&#39;Phone&#39;);</code></p> <p>Be sure these extra fields have been created in Cimy or Register Plus</p> <p>Line 169:<br /> Below this Line add a new query to query the table from cimy or Register Plus:<br /> <pre><code>Line 169 $query = &quot;SELECT meta_value FROM &quot;.$wpdb-&gt;prefix.&quot;usermeta WHERE user_id = &quot;.$results[$i][&#39;UID&#39;].&quot; AND meta_key = &quot;; Added query example for cimy: $query2 = &quot;SELECT value FROM &quot;.$wpdb-&gt;prefix.&quot;cimy_uef_data WHERE user_id = &quot;.$results[$i][&#39;UID&#39;].&quot; AND field_id = &quot;;</code></pre> <p>Now add after Line 175/176 `<br /> $nnquery = $query . "'nickname'";<br /> $results[$i]['nickname'] = $wpdb-&gt;get_var($nnquery);`</p> <p>The new queries for your extra fields (example):<br /> <pre><code>$langquery = $query2 . &quot;&#39;1&#39;&quot;; $results[$i][&#39;1&#39;] = $wpdb-&gt;get_var($langquery); $streetquery = $query2 . &quot;&#39;3&#39;&quot;; $results[$i][&#39;3&#39;] = $wpdb-&gt;get_var($streetquery); $codequery = $query2 . &quot;&#39;4&#39;&quot;; $results[$i][&#39;4&#39;] = $wpdb-&gt;get_var($codequery);</code></pre> <p>The numbers are the field_id from cimy. Check them through phpmyadmin.<br /> Hope someone may understand this. At least it works for me :) </p> http://wordpress.org/support/topic/250037#post-1122424 Wed, 01 Jul 2009 11:46:09 +0000 croila 1122424@http://wordpress.org/support/ <p>Me too! I would really like to know how to export the extra data, so ALL the data pertaining to each user is in the one spreadsheet. If anyone can help here, that would be brilliant. </p> http://wordpress.org/support/topic/187189#post-1109317 Fri, 19 Jun 2009 01:21:58 +0000 RonKZ 1109317@http://wordpress.org/support/ <p>I use Thunderbird, and using either comma-delimited or tab delimited, it's impossible to get fields to match up. I've also done ditto matching everything up via a spreadsheet and saving a revised *.csv file, that is no better. I have wasted many hours on this or even a couple of days, to get about 100 users into my tBird address book, but it has never come out right. </p> <p>I'm sure part of the problem is tBird but believe it is also user2csv. Bright ideas are welcome. </p> http://wordpress.org/support/topic/237371#post-1095857 Tue, 09 Jun 2009 03:29:26 +0000 BigZack 1095857@http://wordpress.org/support/ <blockquote><p> edit <strong>wp-content/plugins/users-to-csv/users2csv.php</strong></p> <p>and change line 194 from...</p> <p> $sep = "<strong>;</strong>";</p> <p>to...</p> <p> $sep = "<strong>,</strong>"; </p></blockquote> http://wordpress.org/support/topic/257254#post-1058136 Mon, 27 Apr 2009 19:26:29 +0000 Dekortage 1058136@http://wordpress.org/support/ <p>There are two sets of links, one for commenters and another for posters. So you have to edit four lines of HTML in that area, and you'll fix all the links. </p> http://wordpress.org/support/topic/257254#post-1056887 Sun, 26 Apr 2009 12:39:53 +0000 thecoveted 1056887@http://wordpress.org/support/ <p>this works great with that hack... but i think i exports only every person who has commmented on the blog.</p> <p>also.. i'm wondering if there is a way to get the passwords and extra fields? </p> http://wordpress.org/support/topic/263930#post-1051933 Tue, 21 Apr 2009 12:07:15 +0000 brianlees 1051933@http://wordpress.org/support/ <p>Because the CSV file's first column is called "ID", Excel improperly recognizes the file as a SYLK file and will not open it. If you open the file in a text editor, change "ID" to "UID", it opens fine.</p> <p>Is there any way we can get this changed in the release version of the plugin so the first column is called UID instead? If you are curious about it, click on the following links for more information:</p> <p><a href="http://mail.python.org/pipermail/python-bugs-list/2006-August/034602.html">http://mail.python.org/pipermail/python-bugs-list/2006-August/034602.html</a></p> <p><a href="http://mail.python.org/pipermail/python-bugs-list/2006-August/034602.html">http://www.pcreview.co.uk/forums/thread-1061043.php</a> </p> http://wordpress.org/support/topic/257254#post-1047774 Thu, 16 Apr 2009 19:35:15 +0000 Dekortage 1047774@http://wordpress.org/support/ <p>I had the same problem, but only after I adjusted Wordpress so that it worked from my domain's root directory instead of the /wordpress subdirectory. </p> <p>So here's how I fixed it. Open up users2csv.php and look at lines 227-233. Remove the text "&lt;?php bloginfo('url');?&gt;/wp-admin/" from those lines. It now works for me. </p> http://wordpress.org/support/topic/223364#post-1042312 Fri, 10 Apr 2009 14:10:17 +0000 brianlees 1042312@http://wordpress.org/support/ <p>Any word on this? I use Register Plus as well and I need a dead-simple way for non-computer savvy people to export the user list. Users2CSV seems to be the easiest...but I just need to be able to extend it to include all the fields I added in Register Plus. </p> http://wordpress.org/support/topic/250037#post-1042308 Fri, 10 Apr 2009 14:05:20 +0000 brianlees 1042308@http://wordpress.org/support/ <p>I need the same thing (extra fields in RegisterPlus). Did anyone ever answer your question?</p> <p>As for opening the CSV files in Excel. All you should need to do is associate CSV files with Excel directly by modifing the "Open With" and saying always use this app.</p> <p>Brian </p> http://wordpress.org/support/topic/174768#post-1033498 Wed, 01 Apr 2009 15:09:25 +0000 ehsan4php 1033498@http://wordpress.org/support/ <p>Using version 1.4 and here are the places I had to modify:</p> <p>1. Line 56 (which evilzenscientist referred to line 37), same modification. Although only changing it doesn't fix the ";" problem, so following is the next.</p> <p>2. Line 194 change $sep = ";"; to $sep = ",";</p> <p>3. Then there was a problem with MS Excel that reported something like:</p> <p>"Excel has detected that the 'MyOutput.csv' is a SYLK file, but cannot load it. Either the file has errorsa or it is not a SYLK file. Click OK to try to openn the file in a different format."</p> <p>To fix it I had to replace all the instance of 'ID' to 'USERID', that solved all the issues.</p> <p>So far so good. I will report more changes if there is any. </p> http://wordpress.org/support/topic/257254#post-1029956 Sun, 29 Mar 2009 00:18:42 +0000 samm5195 1029956@http://wordpress.org/support/ <p>I installed plugin and activated it when I try to export my users it goes to 404 page not found<br /> does anyone have any ideas as to whats going on or is there a bug fix for the plugin I'm using current version </p> http://wordpress.org/support/topic/250037#post-1006458 Thu, 05 Mar 2009 16:05:25 +0000 danaparkinson 1006458@http://wordpress.org/support/ <p>Do any of you have an idea how I can export extra fields? Currently the plugin only exports the standard data. I've used Register-Plus to add the extra fields. Any idea how to have it set up nicely in Excel? Currently I can only open the data in Notepad. </p> http://wordpress.org/support/topic/187189#post-991671 Thu, 19 Feb 2009 20:59:08 +0000 wp-boy 991671@http://wordpress.org/support/ <p>hey joost,</p> <p>I like your plugin "user2csv" but is there any way or do you plan on adding a way for the date and time of the "unique" comment to be published next to the name and email?</p> <p>this way I can do a contest on my blog during a time and then a emailing to just those people who posted comment in that time frame.</p> <p>even better...</p> <p>if you could csv commenters by the post they commented on.</p> <p>thanks.</p> <p>-Justin </p> http://wordpress.org/support/topic/237371#post-965924 Sun, 25 Jan 2009 15:21:05 +0000 andypatmore 965924@http://wordpress.org/support/ <p>Firstly, GREAT plugin! I didn't know I needed this until I found it!</p> <p>Anyway, a question. I was under the impression that a CSV file was comma separated and not semi-colon? Does mean that I have to save the file, change the extension to txt and them import it into my spreadsheet program that way.</p> <p>Can I change to comma separated output and if so how?</p> <p>Second, a suggestion. If you are looking to develop this plugin further, may I suggest that you allow the export fields to be defined? I only need first name, last name and email address. It may be useful to allow a user defined field so that I can tag the source of the list (ie. blog 1, blog 2, etc)</p> <p>thanks! </p> http://wordpress.org/support/topic/234988#post-958231 Sat, 17 Jan 2009 00:42:32 +0000 clicknathan 958231@http://wordpress.org/support/ <p>And the users.php file is empty... any ideas? </p> http://wordpress.org/support/topic/230636#post-943616 Sat, 03 Jan 2009 15:10:04 +0000 Producer82 943616@http://wordpress.org/support/ <p>never mind, I just figured out how to do it in phpmyadmin, thanks anyways. </p> http://wordpress.org/support/topic/230636#post-943607 Sat, 03 Jan 2009 14:58:23 +0000 Producer82 943607@http://wordpress.org/support/ <p>I'm using Dadamail for my mailing list but when I import the CSV file that this plugin creates, it doesn't work because of all the extra stuff your plugin puts into the csv file (like the person's name, date they signed up, website etc). I can't manually remove the extra stuff because I have around 9,500 members :/</p> <p>Is there any thing in your plugin code that I can change so it'll export one e-mail address per line and nothing else? </p> http://wordpress.org/support/topic/187189#post-941248 Wed, 31 Dec 2008 18:02:28 +0000 joostdevalk 941248@http://wordpress.org/support/ <p>should be a submenu under users, but it could be that the plugin wasn't working properly for you yet. The shortly to be released version 1.4 should fix that. </p> http://wordpress.org/support/topic/223364#post-941244 Wed, 31 Dec 2008 18:01:23 +0000 joostdevalk 941244@http://wordpress.org/support/ <p>I haven't looked into it as I don't use the plugin, it'd require changing the query for users, depending on how register plus stores the data. </p> http://wordpress.org/support/topic/229596#post-941174 Wed, 31 Dec 2008 16:25:31 +0000 joostdevalk 941174@http://wordpress.org/support/ <p>Thx askibinski! Added this fix in version 1.4! </p> http://wordpress.org/support/topic/229596#post-940273 Tue, 30 Dec 2008 15:09:24 +0000 askibinski 940273@http://wordpress.org/support/ <p>If you use the first export option (all users) and get a bunch of errors saying wp_usermeta tables not found, you need to change this on line 150 of users2csv.php:</p> <p>find:</p> <p><code>wp_usermeta</code></p> <p>and replace it with:</p> <p><code>&quot;.$wpdb-&gt;prefix.&quot;usermeta</code></p> <p>The error is caused by the plugin falsely assuming you are using 'wp' as a prefix for your tables. Which is not necessarily true because you can provide your own prefix during installation of Wordpress. </p> http://wordpress.org/support/topic/223364#post-920693 Thu, 11 Dec 2008 14:49:33 +0000 biv 920693@http://wordpress.org/support/ <p>Anyone? </p> http://wordpress.org/support/topic/223364#post-917781 Mon, 08 Dec 2008 16:55:03 +0000 biv 917781@http://wordpress.org/support/ <p>I'm using the users2csv plugin to see if it fits my needs. This in combination with the Register Plus plugin.</p> <p>But how can I extend the users2csv plugin so it will export the data created by the Register Plus plugin? Tried different things, but couldn't get it to work..</p> <p>Did perhaps someone got already got this done and would share his/her modification? Thanx in advance. </p> http://wordpress.org/support/topic/187189#post-797742 Mon, 07 Jul 2008 03:48:01 +0000 Anonymous 797742@http://wordpress.org/support/ <p>I placed the users2csv.php in the plugins folder and it showed up in my plugin in wordpress then I activated it. Then went to users and nothing shows up in there saying csv, but the plugin is activated so I am not sure whats going on but nothing works. </p> http://wordpress.org/support/topic/174768#post-791370 Fri, 27 Jun 2008 02:15:14 +0000 mosey 791370@http://wordpress.org/support/ <p>Not sure if it's a good idea to use a comma instead of a semi-colon as a separator. It depends on the data though I guess. Most of my data have sentences which *have* commas but not necessarily semi-colons, so the colon seems ideal.</p> <p>If possible could maybe use '|'? </p> http://wordpress.org/support/topic/174768#post-791293 Thu, 26 Jun 2008 22:58:22 +0000 mrnabo 791293@http://wordpress.org/support/ <p>Hi,</p> <p>I edited that line of code, and can open it with a basic text-editor, but not with Excel 2008. Is there a reason for that and is it important?</p> <p>Thanks </p>