Is there an editor or tool for this?

Forum Moderators: open

Message Too Old, No Replies

Is there an editor or tool for this?

Directly editing fields

Wlauzon

7:18 pm on Feb 1, 2009 (gmt 0)

We are setting up a new ecommerce site. Each product has about 30 fields that need to be set or edited. Not all of those fields are available via csv or other import. The UI for working on each item is a bit slow and clumsy.

So is there a way to, or a program that we can download the mySQL data (basically a backup file), edit the fields as needed, and then upload it back to update?

Or is this a bad way to go?

I know little about SQL databases - is there a better way to do this?

ag_47

12:01 am on Feb 2, 2009 (gmt 0)

hmm, how about phpMyAdmin? It's basically an open source UI for managing mySql, pretty easy to use. Most hosts have it available.

Wlauzon

12:24 am on Feb 2, 2009 (gmt 0)

Not really a user friendly interface for editing about 30 fields out of 350+.

It works, yes, but no better and maybe worse than using the regular program interface.

Marcia

2:15 am on Feb 2, 2009 (gmt 0)

You can set up Apache, MySQL and PHP on a home machine (Linux or Windows).

topr8

10:50 am on Feb 2, 2009 (gmt 0)

phpmyadmin can be used to create 'back up files' in various formats, you could then download the backup to your local machine and edit the file there, then reverse the process.

however it seems you need to design a decent backend for updating the data online, there are tools available that can build half decent backends, check out somewhere like hotscripts: php database tools.

Receptional Andy

11:07 am on Feb 2, 2009 (gmt 0)

There are various standalone software packages for editing SQL databases too - you'll find plenty searching for "MySQL GUI" and similar.