Wednesday, March 20, 2013

Advanced Mysql Exporter/Importer

PHP Scripts - Advanced Mysql Exporter/Importer - CodeCanyon

Advanced Mysql Exporter/Importer his title this type of PHPScripts/DatabaseAbstractions This time I will review,made by sadoknet, PHPScripts/DatabaseAbstractions is sold at a price of $10 in CodeCanyon. Advanced Mysql Exporter/Importer - CodeCanyon Item for Sale Export Mysql // command php // console // csv // database abstractions // export CSV // export PDF // export excel // huge database // import excel // import mysql //
Created 7 December 12
Last Update 15 March 13
Software Version PHP 5.x, PHP 5.0 - 5.2, PHP 5.3, MySQL 4.x, MySQL 5.x
Files Included JavaScript JS, HTML, CSS, PHP

Advanced Mysql Exporter/Importer

Advanced Mysql Exporter/Importer is a simple web application allow users to export or import any tables from or to CSV, Excel, PDF files. No special installation needed, the admin Login/Password is stored in configuration file and protected with .htaccess file Advanced Mysql Exporter/Importer able to :
  • Export Import CSV
  • Export Import Excel (xlsx, xls), Export PDF
  • Export to CSV, Excel and PDF with custom queries
  • Enable update queries
  • Console command line to export/import huge databases
Advanced Mysql Exporter/Importer using :
  • Bootstrap style + reponsive version
  • Simple MCV Application
  • Easy Installation

You can customise the import or export function to be applied for each recored, you don’t want to use it put them to `none`. By default they are in config/parameters.ini : export_encode_function=”utf8_encode” import_encode_function=”utf8_decode”

For some databases, you need to setup the option database_default_charset in config/parameters.yml, example : `database_default_charset: “utf8”`

Installation

This is the 2.0 version.
  • Put the whole application where you want
  • Change the admin login/password in config/parameters.yml
  • Change the url in config/parameters.yml
  • Enjoy !

Console Commande

  • To import huge databases open file config/console.yml, in import settings section configure table name and import options, next just run : `php bin/console import`
  • To export huge databases open file config/console.yml, in export settings section configure table name and export options, next just run : `php bin/console export`
  • Enjoy !

Update : Version 2.0 :

  • Command line to export/import huge databases
  • Enable update queries
  • Using yml files for application configuration instead of ini
  • Add database_default_charset option in parameters.yml
  • Improve performances
  • Fix minor bugs

Update : Version 1.1 :

  • Fix minor bugs
  • Allowing execution with previous version of PHP 5 (like PHP 5.2)

Advanced Mysql Exporter/Importer need PHP5 to work. Live Demo If you like this script please take a minute and rate it :)

Related produck This user:sadoknet

VirtueMart Extention - CSV Exporter - CodeCanyon Item for Sale JContact Form Module - CodeCanyon Item for Sale JFacebook Connect - CodeCanyon Item for Sale SPlaceholder Plugin - CodeCanyon Item for Sale SquareMe Plugin - CodeCanyon Item for Sale

More items by sadoknet

No comments:

Post a Comment