The CSV Export tool is platform independent and can be operated with the current Internet browsers. We recommend the latest version of Firefox. The CSV export tool can be installed directly in the web space of the online shop or CMS. If the database is configured for external access, the installation is possible at any place with external access to the database.
System Requirements
To use the CSV export tools following requirements must be met:
- Web server with PHP5
- Target system with mySQL database
- Current Internet browser with Javascript (recommendation: Firefox!)
Installation of the CSV export tool
The CSV export tool can be installed directly in the web space of the online shop or CMS.
- Copy directory „csv-export-tool“ to any location in the web space and access with a browser on the directory
For example: www.ihrDomainName.com/csv-export-tool/ - Safety Recommendation 1: Rename the directory!
- Safety Recommendation 2: Set up a directory protection for the directory!
- Encoding the files: UTF-8 without BOM
Connecting to the database
In the file ‚connect/connection.php‘ the connection is established to the database:
$system_desc = "Optional system description";
$db = "Database Name";
$host = "Database Host";
$dbuser = "database user";
$pw = "database password";
The system description is optional and can be used for multiple connections.
Database name, database host, database user, and database password were assigned when you create the database.
The database user should only have read access. It is recommended that, if necessary, create a new user.
It can also be remote databases are read. For this, the database must be unlocked for external access.
Saving Queries
The directory „/data“ and the files included must be writable!
-
Writeable dir attribute to save queries.