Zugg Software :: View topic

Beginner Joined: 10 Jul 2005 Posts: 28

I tried searching, but I couldn't really find anything. I want to export or ideally, transmit directly from zmud, my database to a php script that'll parse the data and enter it into a mysql database. The php/mysql is easy, I know how to do that. I'm curious though if anyone has done things like this before. Ideally I'd like to be able to transmit it directly from zmud and assign a function to a button sorta. I know there's the ftp command, which may be an option, but I was wondering if there were any other routes/options. And how to actually extract the data into some format I could parse ie comma delimited or something. I'm not looking for someone to write this, just to suggest possible routes, as I'm not aware of everything that zmud is capable of in this regard.

Any and all responses appreciated, thank you

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

I'm curious why the php script? Why not parse the data and enter it into the mysql database directly from zmud?

Beginner Joined: 27 Feb 2005 Posts: 24

In the DB page, goto the "view" menu, and select "export"
You can select tab or comma delimited there.

If you also want to run the script on your comp, you can use the #launch command.

Beginner Joined: 10 Jul 2005 Posts: 28

Enchanter Joined: 05 Mar 2003 Posts: 593 Location: Canada

http://forums.zuggsoft.com/phpbb/viewtopic.php?t=20089
In this thread we use ADO to access MySQL from zMud have a look.

Also if your just more comfortable working in PHP you could use the PHP ActiveScript interface(PHPScript) to do it from within zMud.

Beginner Joined: 10 Jul 2005 Posts: 28

Well, I see how it works now basically, but then I'm seeing how I probably couldn't just connect to an online mysql database and play with it. I should've thought of that before since connecting to one would require ssl and all that fun stuff. So maybe I should go about this another way. My other cool idea was to have zmud open an Internet explorer/Firefox/whatever browser window and go to the php script which would be a form, then echo each line into the form, and submit it at the end. I know how to open the window to an address, and I know the other stuff can be done with COM, but I don't know the object titles and such to manipulate the forms and can't find them. So I guess I'm stuffed on that too. Bah.