The “amr users” plugin allows one to create a wide variety of user lists accessing as little or as much of the user data as you like. One can then export these views for further analysis and manipulation.
There are several ways to export users to csv using amr-users
To those using the user lists plugin and complaining about extra slashes, I apologise for not realising that it is because your host must have magic quotes enabled. Please read the php link. The php manual says: Relying on this feature is highly discouraged.
I have looked into it and it seems that because , with it enabled, php adds the slashes at the very last minute (when you click export cvs), there is no way I can stop it from kicking on.
The only possibility may be to write the csv to a file on the server. I specifically do NOT want to do this for non public lists, because
it is user data and should be kept private, not written to a file on a public server
plugins cannot easily access ‘private’ folders to keep such a file private
So either you could try seeing if there is a way to switch it off at your host, or do a search and replace in the csv file, or make the list public (if this is ok with your users and your privacy agreement with them)
Ask your host to disable magic quotes ….Or try my very good hosts – they are reliable, helpful. We’ve been with them for more than 10 years now with no complaints.
A number of people using the amr-users plugin and who are Excel users, seem to need help when it comes to importing the csv file into excel. Open Office and Google Docs users seem to be fine. [Please note that is also possible to offer an excel file export of your user list.]
As far as I can make out, the problems some people experience with loading csv files into excel seem to be because:
their default excel csv import settings do not match the csv file settings (comma separated, and all fields double quotes delimited – this is a standard csv usage.)
they do not know how to get to the text import wizard (Office 2007 in particular is non obvious) See screenshot below.
In Office 2007, it seems that the trick is to rename the file to a .txt file, instead of a .csv. Excel 2007 should then automatically load the text import wizard. You may find other benefits to, in being able to define how excel should handle the data in each column.
Note: When Excel opens a .csv file, it uses the current default data format settings to interpret how to import each column of data. If you want more flexibility in converting columns to different data formats, you can use the Import Text Wizard. For example, the format of a data column in the .csv file may be MDY, but Excel’s default data format is YMD, or you want to convert a column of numbers that contains leading zeros to text so you can preserve the leading zeros. To run the Import Text Wizard, you can change the file name extension from .csv to .txt before you open it…
Using the Excel Text Import Wizard:
Get the text import wizard up
either opening from the menus (Office 2003 – Click Data → Get External Data) or
by renaming file to a .txt (Offfice 2007) and then double clicking on it