Only 15 Euros, full source code with reusable classes!!
Have you ever wanted to import a CSV file with thousands of records into multiple tables and wondered how you should go about this? Use a utility and write some fancy SQL queries? If you are not quite literate in SQL this might require hiring someone or using up a lot of your time.
Well, we needed this too. So we developed a PHP Application that handles writing the queries and executes them in the right order no matter how your foreign keys are set. Also, you can choose to update the tables/columns based on a primary key in the CSV table (product_sku in VirtueMart for example).
The only thing you have to provide is the foreign keys and the tables in the config file. We can customise this application for your needs, so that you can provide the foreign keys in the user interface for example. This application was written primarily for VirtueMart (the Joomla based e-commerce solution) but can be used in any database.
You can now view a demo of this at http://csv2sql.ihostnz.com (username: user, password: password). You can see the result at http://jecomm.ihostnz.com .
If you have questions regarding these demos, please don't hesitate to ask in either the forum or through one of the contact forms.
NOTE:
You can use this demo only with data for virtuemart. If you want to use this software with a different database schema, the configuration file needs to be changed.
If there is demand for this, we can make the configuration writable but as this brings up a security risk, this is disabled for now.
Only 15 Euros, full source code with reusable classes!!