Post by makingtrails » Fri Jun 14, 2013 4:28 pm

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

User avatar
New member

Posts

Joined
Fri Nov 25, 2011 7:11 pm

Post by daik01 » Fri Jun 14, 2013 4:41 pm

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.

TOP 5 Opencart Extensions:
1:Opencart Reservations
2:Stock Report, import/export stock levels with Excel
3:3D Carousel
4:Product Price Changer by Category
5:Set price Inclusive Taxes
DEMO SHOP


Active Member

Posts

Joined
Sun Oct 21, 2012 3:18 am


Post by ogun » Fri Jun 14, 2013 5:44 pm

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.

Active Member

Posts

Joined
Tue Aug 14, 2007 6:04 am

Post by makingtrails » Mon Jun 17, 2013 10:59 pm

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

User avatar
New member

Posts

Joined
Fri Nov 25, 2011 7:11 pm

Post by butte » Sun Jun 23, 2013 3:55 am

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.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by Fernando Foght » Wed Sep 25, 2013 9:22 pm

Is true, Access 2013 is the easiest place to start and working very well, you don´t have to fear :)


Posts

Joined
Wed Sep 25, 2013 8:51 pm


Post by butte » Thu Sep 26, 2013 1:11 am

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.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am
Who is online

Users browsing this forum: No registered users and 9 guests