Umbraco Export Members to Excel

Introduction

Export Members to Excel is an Add-on for Umbraco which allows you to export members from your Umbraco CMS to an Excel and OpenDocument Spreadsheet using Aspose.Cells. A new node titled Export Members To Excel appears under Members tree in Umbraco backend after installation where you can simply select members to export and output format to get members in selected output document format.

Module Features

This initial version of the Add-on have the following features:

  • Export members to Microsoft Excel Documents (.xls, .xlsx and .xlsb)
  • Export members to Tab delimited text document (.txt)
  • Export members to CSV (Comma delimited) (*.csv)
  • Export members to OpenDocument Spreadsheet (*.ods)
  • Option to select desired output format before exporting
  • Option to export all or selected members to selected output document format.
  • Works with all .NET versions starting from .NET 2.0.
  • Exported document is automatically sent to browser for downloading
  • If selected a copy of the exported document is saved in App_Data/AsposeMemberExport folder on the server for later use.
  • Compatible with a wide range of Umbraco versions 4.5+ including Version 6 and 7.

System Requirements and Supported Platforms

System Requirements

In order to setup this module you need to have the following requirements met:

  • Umbraco 6.0 +

Please feel free to contact us if you wish to install this module on other versions of Umbraco.

Supported Platforms

The module is supported on all versions of

  • Umbraco running on ASP.NET 4.0

Downloading

You can download Export Members to Excel Add-on from one of the following locations

Installing

Once downloaded, please follow these steps to install this package into your Umbraco website:

  1. Log in to the Umbraco Developer section, for example http://www.myblog.com/umbraco/
  2. From the tree, expand the Packages folder.
  3. From here there are two ways to install a package: select Install local package or browse the Umbraco Package Repository.
  4. If you install local package, do not unzip the package but load the zip into Umbraco.
  5. Follow the instructions on screen.

Note: You may get a ‘Maximum request length exceeded’ error when installing. You can easily fix this issue by updating the ‘maxRequestLength’ value in your Umbraco web.config file.

  <httpRuntime requestValidationMode="2.0" enableVersionHeader="false" maxRequestLength="25000" />

Using

After you have installed the macro it is really simple to start using it on your website:

  1. Make sure you are logged in to the Umbraco Developer section, for example http://www.myblog.com/umbraco/
  2. Click Members in the list of sections at the bottom left of the screen.
  3. At the end of the tree, you will see a node titled Export Members To Excel click on it to launch the Export to Excel add-on.
  4. Select your desired output document format and select Members to export. If you wish you Export all members leave member selection or click the check-box in header row.
  5. Click Export button at the bottom and you will be prompted to download the exported file.

Video Demo

Please check the video below to see the module in action.

Support, Extend and Contribute

Support

From the very first days of Aspose, we knew that just giving our customers good products would not be enough. We also needed to deliver good service. We are developers ourselves and understand how frustrating it is when a technical issue or a quirk in the software stops you from doing what you need to do. We’re here to solve problems, not create them.

This is why we offer free support. Anyone who uses our product, whether they have bought them or are using an evaluation, deserves our full attention and respect.

You can log any issues or suggestions related to Aspose.Words .NET for Umbraco Modules using any of the following platforms

Extend and Contribute

Export Members to Excel is an open source Add-on and its source code is available on the major social coding websites listed below. Developers are encouraged to download the source code and extend the functionality as per their own requirements.

Source Code

You can get the latest source code from one of the following locations

How to configure the source code

You need to have the following installed in order to open and extend the source code

  • Visual Studio 2010 or higher

Please follow these simple steps to get started

  1. Download/Clone the source code.
  2. Open Visual Studio 2010 and Choose File > Open Project
  3. Browse to the latest source code that you have downloaded and open e.g Aspose.UmbracoMemberExportToExcel.sln
Umbraco Database Data Exporter to Excel