Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Sam Flanagan 47 posts 147 karma points
    Mar 20, 2014 @ 10:17
    Sam Flanagan
    0

    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

  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Mar 20, 2014 @ 10:41
    Dennis Aaen
    0

    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

  • Sam Flanagan 47 posts 147 karma points
    Mar 20, 2014 @ 10:56
    Sam Flanagan
    0

    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

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Mar 20, 2014 @ 11:19
    Jan Skovgaard
    0

    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

  • Richard Soeteman 4042 posts 12890 karma points MVP 2x
    Mar 21, 2014 @ 08:23
    Richard Soeteman
    100

    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

  • Sam Flanagan 47 posts 147 karma points
    Mar 21, 2014 @ 09:30
    Sam Flanagan
    0

    Thanks Richard

  • Richard Soeteman 4042 posts 12890 karma points MVP 2x
    May 21, 2014 @ 16:58
    Richard Soeteman
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft