Topic awaiting preservation: mysql editing (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=12259" title="Pages that link to Topic awaiting preservation: mysql editing (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: mysql editing <span class="small">(Page 1 of 1)</span>\$

Red Ninja Bipolar (III) Inmate From: Detroit, MI US Insane since: Mar 2001	posted 06-11-2002 19:33 Is it possible for a client to update their mysql database using a program like access? What I mean to say is is there a way that they can edit the file locally and then upload it to their server rather than using something on the server itself like PHPmyadmin, mambo or the like? Thanks in advance
WarMage Maniac (V) Mad Scientist From: Rochester, New York, USA Insane since: May 2000	posted 06-11-2002 20:59 You could make a program that would store the information in a CSV file. Simple interface easy to set up. That would then make a flat text file that they could upload to the server and have it parsed by the recieving program and have it placed into the database. I am pretty sure you could do this with a barage of different languages, from PHP to Perl to C to Java, Python, ASP, etc,. I don't think it would take more than a couple of hours to program. Their might be some kind of pre-packaged solution, but I haven't found the need for that kind of tool seeing as phpMyAdmin works just fine for me. The initial program could be done in say Java or C / C++ and then have it automatically connect to the upload page, could do it all in memory if you so choose.
Sash Paranoid (IV) Inmate From: Canada, Toronto Insane since: May 2000	posted 06-11-2002 22:29 MySQL supports ODBC (Open DataBase Connectivity) for access from Windows database software, like Microsoft Access. The server where my site is hosted supports it and there is a little tutorial that you may find interesting. BTW, phpMyAdmin works fine for me too. Sasha »
bitdamaged Maniac (V) Mad Scientist From: 100101010011 <-- right about here Insane since: Mar 2000	posted 06-12-2002 04:23 There's a bunch of MySQL GUIs Though I think PHPMyAdmin is just as good with as Mage said you can have something like Excel dump a CSV file that can be parsed by PHPmyadmin or by a home-rolled parser. I've found this solution works well with something like populating an online store with inventory. .:[ The Tao of Steve ]:. Be Desireless Be Excellent Be Gone ...................................
Red Ninja Bipolar (III) Inmate From: Detroit, MI US Insane since: Mar 2001	posted 06-12-2002 14:40 Thank you for your suggestions. PHP myadmin works fine for me, too. However, I was hoping there was a way for a client to perform this task in a familiar environment rather than having to teach somebody who is reluctant to learn new things. I find that this is usually disastrous later as they never really listen to the important details. This should be a little easier than I originally surmised.

Topic awaiting preservation: mysql editing (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=12259" title="Pages that link to Topic awaiting preservation: mysql editing (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: mysql editing <span class="small">(Page 1 of 1)</span>\$

Red Ninja
Bipolar (III) Inmate

From: Detroit, MI US
Insane since: Mar 2001

posted 06-11-2002 19:33

Is it possible for a client to update their mysql database using a program like access? What I mean to say is is there a way that they can edit the file locally and then upload it to their server rather than using something on the server itself like PHPmyadmin, mambo or the like?

Thanks in advance

WarMage
Maniac (V) Mad Scientist

From: Rochester, New York, USA
Insane since: May 2000

posted 06-11-2002 20:59

You could make a program that would store the information in a CSV file. Simple interface easy to set up. That would then make a flat text file that they could upload to the server and have it parsed by the recieving program and have it placed into the database.

I am pretty sure you could do this with a barage of different languages, from PHP to Perl to C to Java, Python, ASP, etc,.

I don't think it would take more than a couple of hours to program. Their might be some kind of pre-packaged solution, but I haven't found the need for that kind of tool seeing as phpMyAdmin works just fine for me.

The initial program could be done in say Java or C / C++ and then have it automatically connect to the upload page, could do it all in memory if you so choose.

Sash
Paranoid (IV) Inmate

From: Canada, Toronto
Insane since: May 2000

posted 06-11-2002 22:29

MySQL supports ODBC (Open DataBase Connectivity) for access from Windows database software, like Microsoft Access. The server where my site is hosted supports it and there is a little tutorial that you may find interesting.

BTW, phpMyAdmin works fine for me too.

Sasha »

bitdamaged
Maniac (V) Mad Scientist

From: 100101010011 <-- right about here
Insane since: Mar 2000

posted 06-12-2002 04:23

There's a bunch of MySQL GUIs

Though I think PHPMyAdmin is just as good with as Mage said you can have something like Excel dump a CSV file that can be parsed by PHPmyadmin or by a home-rolled parser. I've found this solution works well with something like populating an online store with inventory.

.:[ The Tao of Steve ]:.
Be Desireless
Be Excellent
Be Gone
...................................

Red Ninja
Bipolar (III) Inmate

From: Detroit, MI US
Insane since: Mar 2001

posted 06-12-2002 14:40

Thank you for your suggestions.

PHP myadmin works fine for me, too. However, I was hoping there was a way for a client to perform this task in a familiar environment rather than having to teach somebody who is reluctant to learn new things. I find that this is usually disastrous later as they never really listen to the important details.

This should be a little easier than I originally surmised.