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?
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. 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.
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.
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?
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
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.
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
is working on a reply...