Copied to clipboard

Flag this post as spam?

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


  • Barry Fogarty 493 posts 1129 karma points
    Nov 10, 2011 @ 20:00
    Barry Fogarty
    0

    Yes or No for true/false fields

    Hi Richard,

    Just got the pro version today.  I had a client request to output 'Yes' or 'No' in place of the 1 or 0 for bit fields.  Is that possible?  Also, my exported phone numbers are dropping the leading zeroes when opened in Excel - I think this is an excel thing though?

  • Richard Soeteman 4035 posts 12842 karma points MVP
    Nov 11, 2011 @ 08:06
    Richard Soeteman
    1

    Hi Barry,

    Thanks for the purchase. To include the leading zeroes simply set Text Indicator to " then Excel knows it's a text field and includes the leading zero

    The other request is easy to implement, I will do that in a minute and update this thread where you can download an extra dll. I will use it for a blogpost as well to explain how you can use Extensions in MemberExport. What I will do is use the Umbraco translations to determine the text, so f you are logged in as an English member you will get Yes/No, if your are Dutch you will get Ja/Nee .

    I think your suggestion is awesome, but I'm not sure if I will add this to the core functionality because some people use the data to import it in other systems again and 1/0 is easier for these systems to understand than Yes/No or Ja/Nee. Config can solve this but that would require updating an xml file. Think I will add some sort of Gallery with extensions you can download. Just thinking out load here.

    Will update this thread later today with a location where you can download the bits.

    Thanks,

    Richard

  • Barry Fogarty 493 posts 1129 karma points
    Nov 11, 2011 @ 09:23
    Barry Fogarty
    0

    THanks Richard.  Yes even when I use the " text indicator it still happens.  But I can see that the zeros are in the raw export so its an Excel issue.  Will look into stopping this default behavious for CSV.  It would be nice to have a native XLS export too!

    Extensions gallery sounds cool :-)  You could make the serarch filters an extension too or even make it extendable so others can plug in their own.

  • Richard Soeteman 4035 posts 12842 karma points MVP
    Nov 11, 2011 @ 10:56
    Richard Soeteman
    1

    Hi Barry,

    Weird that Excel does that, You are the second person in 1 week that request this. Expect an update soon, will be a great addition to the PRO version. I only need to find a way to support native excel. hope the components I use in CMSImport can also be used to write excel data. I will make this extenable so you can plug-in whatever you want, SQL etc

    The parser is done, you can download it from my site. Only put the dll in your bin folder and it will be picked up automatically. Will blog about this and add the option to the documentation it's only a simple interface you need to implement.

    I will make sure that you can extend filters as well, but that will take a while since it's a big upgrade.

    Thanks,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft