Send mail to the author(s) E-mail

View Richard Soeteman's profile on LinkedIn

RSS 2.0 | Atom 1.0 | CDF




The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

Sign In


# Friday, May 28, 2010
Friday, May 28, 2010 3:51:58 PM (GMT Daylight Time, UTC+01:00) ( MemberExport | Package | Umbraco )

This Blog is not active anymore, further posts will be available on my company website. Read new posts here

For those who follow me on twitter probably know that I’m working on a new package for Umbraco that can export Members to a csv file. Below you see the first screenshot of the package. Basically you select the groups and fields you want to export, you specify the export options and when you click the export button a csv file is generated on the fly which you can download.


Two days ago I started tweeting about this because I was very happy that exporting a few hundred members only took 2 seconds. Immediately people warned me about the fact that I used Member.GetAll to get a list of all the members which is very slow when you want to export more than 500 records. Thanks again for this warning guys (also for the brain breaking sql I had to write to improve the performance ;-)).  So I changed the Member.GetAll functionality to a custom SQL query, imported 5000 extra records  and did a performance test to see if  the modification was a success. Guess what, the export of 5000+ records only took 2142 milliseconds. I think that’s a great result to end the week with.

When will this package be available?

Next Monday I will send the package to a few people that  want to beta test MemberExport. When it’s stable enough I’ll release the package. There will be two versions of the package, a free (limited to export 200) records version and a PRO version that can also save the export options for later use. The price for the pro version will be 39 euro (ex 19% Dutch VAT, only for Dutch customers) .

I hope you find the package interesting!

Tuesday, June 1, 2010 2:47:49 PM (GMT Daylight Time, UTC+01:00)
Hi Richard

this looks very slick, can't wait till this gets out, we just estimated something like that to 1 of our customers, a package like this could reduce the cost for them obviously, so we can use those resources on the other topics.

would also be interested in sorting or filtering. the way the site was made, all users subscribing to the newsletter were placed in 1 membergroup but they would like to send out emails based on 1 of the properties, for example a belgian newsletter for all belgians. that would mean they want to export the membergroup 'newsletter' but only people with country property on belgian.

would your package be extendable in any way? either by you creating such a thing or by us modifying it... if not then i think we can also look at filtering post-export. sorting in excel and keeping the lines from the prefered country.

in any case, we're eagerly waiting for a release :)

best regards
Sander Houttekier
Comments are closed.