A simple module for exporting all the records from a predefined table or custom query to Excel, CSV or XML. The module can also connect to an external database (MS SQL and MySQL).
Input the connection string to connect to an external database. If the external database is MySQL, check the corresponding checkbox first when inputting the connection string. Leave this empty to use the default DNN database.
Select the source table to export the records from. If a connection string is entered, the module will retrieve a list of tables from the external database.
Input your custom query here. This will be used to export the data instead of a predefined source table.
Connecting to an external database could be blocked by your hosting provider. Make sure the server and/or firewall will allow connections to external databases. When using MySQL, make sure the DotNet MySQL Connector is installed on your DNN installation. You can check this by verifying if the file "MySql.Data.dll" is present in the \Bin folder. This file is included in this package.
Which version to install
DataExporter comes in 2 versions. Normal installation and a HostOnly installation because the module does NOT take Portal ID’s into account. This could potentially be a security risk on shared hosting solutions so when the HostOnly version is installed, only Host account users can change the settings of the module.
Go to http://modules.vdwwd.eu for a live demo.