When you have setup the package and created a member gruop and a member type.
Then create a member that is assigned to the member group. After that go to the new folder under the member section the folder is called Export Members and comes when you have installed the package. When you have clicked on this folder you should get the opportunity to select which columns that you want in your CSV export.
There you can choose to exclude the password and id columns from your CSV. Chekout this blogpost by Richard Soeteman, there is a screenshot how you can choose your colums in the export.
Thanks Dennis, but what I'm trying to do is exclude Password and Id from the checkbox list on the export UI. My understanding is that you need to modify Umbraco\Plugins\MemberExport\Config\memberexport.config by adding the <exclude alias="password"/> directives in there. Then these properties will not appear in the export UI?
Since ID and Password are some system default fields on the membertype I'm not sure what they're aliases are. Perhaps you can find them by having a look in the database columns of the member tables but I'm not sure.
What you can exclude is aliases you have created on the membertype yourself if your for instance have created a field for Biography, Birthdate etc. - Then you can exclude those form the export options.
If you have bought a license for member-export I think it would be okay to write Richard Soeteman on his e-mail to figure out if he can help.
Thought I send a reply yesterday, maybe it got lost? In the current version it's not possible to exclude those. I will make sure that it's possible for the next release.
Exclude Password and Id from CSV export
Hi
How can I exclude the hashed Password and Id columns from the CVS export?
I've tried <exclude alias="password"/>, but that doesn't seem to work.
I'm using the latest Member Export 2.5 with Umbraco 6.1.6.
Thanks
Sam
Hi Sam,
When you have setup the package and created a member gruop and a member type.
Then create a member that is assigned to the member group. After that go to the new folder under the member section the folder is called Export Members and comes when you have installed the package. When you have clicked on this folder you should get the opportunity to select which columns that you want in your CSV export.
There you can choose to exclude the password and id columns from your CSV. Chekout this blogpost by Richard Soeteman, there is a screenshot how you can choose your colums in the export.
http://www.richardsoeteman.net/2011/12/20/ReleasedMemberExport20.aspx
Hope this helps,
/Dennis
Thanks Dennis, but what I'm trying to do is exclude Password and Id from the checkbox list on the export UI. My understanding is that you need to modify Umbraco\Plugins\MemberExport\Config\memberexport.config by adding the <exclude alias="password"/> directives in there. Then these properties will not appear in the export UI?
Thanks
Sam
Hi Sam
Since ID and Password are some system default fields on the membertype I'm not sure what they're aliases are. Perhaps you can find them by having a look in the database columns of the member tables but I'm not sure.
What you can exclude is aliases you have created on the membertype yourself if your for instance have created a field for Biography, Birthdate etc. - Then you can exclude those form the export options.
If you have bought a license for member-export I think it would be okay to write Richard Soeteman on his e-mail to figure out if he can help.
Just my 2 cents.
/Jan
Hi,
Thought I send a reply yesterday, maybe it got lost? In the current version it's not possible to exclude those. I will make sure that it's possible for the next release.
Best,
Richard
Thanks Richard
Hi Sam,
With the latest v2.6 version it is also possible to exclude the id and password columns. Check the manual how to configure these fixed properties.
Hope this helps,
Richard
is working on a reply...