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, one of our clients 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.
So far, we will only distribute this commercially. We like the idea of open source but it just took too much time to write this application, especially the query generation part and getting the right order for the queries.
You can send an offer to us by using the contact form on this site. It was sold previously for NZ$1000 for a VirtueMart website. We can make it cheaper, but for now that is the price and we think it is fair enough considering the development time/cost and the fact that we set it up and make sure it works with your database. If for some reason it does not work for you, we wont charge you at all. No win, no charge.
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.