|
Metho Beginner
Joined: 10 Jul 2005 Posts: 28
|
Posted: Fri Jul 29, 2005 5:41 am
Exporting/Parsing Database data |
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 |
|
|
|
Dharkael Enchanter
Joined: 05 Mar 2003 Posts: 593 Location: Canada
|
Posted: Fri Jul 29, 2005 4:46 pm |
I'm curious why the php script? Why not parse the data and enter it into the mysql database directly from zmud?
|
|
_________________ -Dharkael-
"No matter how subtle the wizard, a knife between the shoulder blades will seriously cramp his style." |
|
|
|
Ikyu Beginner
Joined: 27 Feb 2005 Posts: 24
|
Posted: Fri Jul 29, 2005 4:50 pm |
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. |
|
|
|
Metho Beginner
Joined: 10 Jul 2005 Posts: 28
|
Posted: Fri Jul 29, 2005 11:02 pm |
Dharkael wrote: |
I'm curious why the php script? Why not parse the data and enter it into the mysql database directly from zmud? |
Well, that would be the most ideal way to do it, I'm however unfamiliar with how zmud goes about that. Could you point me to some documentation with the concepts of this so I can look it over?
Ikyu wrote: |
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. |
Thanks much. Didn't see it before. |
|
|
|
Dharkael Enchanter
Joined: 05 Mar 2003 Posts: 593 Location: Canada
|
Posted: Sat Jul 30, 2005 3:00 pm |
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. |
|
_________________ -Dharkael-
"No matter how subtle the wizard, a knife between the shoulder blades will seriously cramp his style." |
|
|
|
Metho Beginner
Joined: 10 Jul 2005 Posts: 28
|
Posted: Sun Jul 31, 2005 7:48 pm |
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.
|
|
|
|
|
|