Page 1 of 1

Database Web App

Posted: Fri Jun 14, 2013 4:28 pm
by makingtrails
Hi,

I have a product database (over 100,000 lines) which is currently in Excel(csv) format. I am looking to covert this to an web database so I can manage the data more effectively and have the ability to import/export csv files. Also having a web form to manually enter products would be great. However I know little of PHP/MySql so can't write this myself so I have been looking at off the shelf database web apps.

I started looking at Zoho Creator which is ideal for what I want to use but due to the size of my database this becomes an expensive option. So I am looking for a self hosted alternative to Zoho. Any idea's?

Thanks

J

Re: Database Web App

Posted: Fri Jun 14, 2013 4:41 pm
by daik01
If the only thing is that you want to load it in a database, then Mysql will suit. Yu can just simple import csv or xml.

If you want to import these products in Opencart, you have to have your columns exactly as the product table has. As flat as this, you can't use options. There is a free extension in the extension store where you can import/export inclusive options. But therefore you need more structure in your csv.

Re: Database Web App

Posted: Fri Jun 14, 2013 5:44 pm
by ogun
This is probably a whole new can of worms to suggest opening, but you might want to look at some desktop options first to help you organise your data. Libre Office and Open Office both have database applications if you don't already have Microsoft Access.

If you can separate your data out into meaningful tables, you'll have a better understanding of exactly what you need and a much easier time transferring it to a web-based system/shopping cart.

Re: Database Web App

Posted: Mon Jun 17, 2013 10:59 pm
by makingtrails
Thanks for the replies guys,

I'm going to try and use Access 2013 and get the data all up to date and then look at creating VB macro which exports the data to CSV. Not particular a fan of M$ Access but probably the easiest place to start

Re: Database Web App

Posted: Sun Jun 23, 2013 3:55 am
by butte
Oracle's Workbench (and similar others) will already be and already use mysql, will be quite similar to phpMyAdmin in cPanel, Plesk, or others but with a wealth of further features, has a tolerable learning curve (whether you want to do barbecue cookoffs or rocket science, go for it), is the real deal for working with the real deal on your own machine in your own lap, before or after transfers to and from a public server, and can do connections to local or remote databases as well as do transfers. It happens to be available as freeware. Knock your socks off.

Re: Database Web App

Posted: Wed Sep 25, 2013 9:22 pm
by Fernando Foght
Is true, Access 2013 is the easiest place to start and working very well, you donĀ“t have to fear :)

Re: Database Web App

Posted: Thu Sep 26, 2013 1:11 am
by butte
For that matter, you can actually install phpMyAdmin and mysql (live) on your own machine. That will be about as similar as you can get to phpMyAdmin on the host -- your copy's view of Export and Import will not be helpful, because it will be thinking of itself as a host server rather than a local server while you view it locally, so you would use the host's copy instead to Export and Import from and to the host.