DataExporter

posted by VDWWD - 11/7/2014
VDWWD Active Since 11/7/2014
Netherlands

reviews Ask a Question

1 users are watching this product.

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). Module 33856

$0.00

Add To Cart

Description

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).




Module settings

Connection string: 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.

Source table: 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.

Custom query: Input your custom query here. This will be used to export the data instead of a predefined source table.

Note: 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.

Live demo

Go to http://modules.vdwwd.eu for a live demo.