replacement for xadmin?

[benjamintr]

I'm upgrading an older Miva 4 store. Orders are exported from the standard order batch file into a custom batch/xls file that is then sent by email to the client for import into their own database for order processing. This is all done with xadmin.

I need to do the same thing with Miva 5.5. Essentially, pick and choose the database fields that I need to export for each order batch, customize the field headers, and then email or download the file to the clients computer via a browser.

My understanding is that xadmin isn't supported in 5.5. How can I do this?

thanks!

-B

[d_host]

Re: replacement for xadmin?

You could probably get an export script written in PHP that pulls the data out of mySQL - bypassing MM admin entirely. There are plenty of developers on this forum, or any PHP programmer with a touch of mySQL knowledge would be able to write something like this for you pretty quickly.

[Nerd Boy Inc]

Re: replacement for xadmin?

Dear Benjamin,

We have written several XML / EDI Modules that create files on the fly. I am sure we could do the same for you.

[benjamintr]

Re: replacement for xadmin?

You could probably get an export script written in PHP that pulls the data out of mySQL - bypassing MM admin entirely. There are plenty of developers on this forum, or any PHP programmer with a touch of mySQL knowledge would be able to write something like this for you pretty quickly.

I could do it myself if I could get open access to the mysql DB. My web host won't give me open access for security reasons.

-B

[d_host]

Re: replacement for xadmin?

I could do it myself if I could get open access to the mysql DB. My web host won't give me open access for security reasons.

That sounds extremely unorthodox and very unusual... Perhaps what they meant was that they wouldn't give you access to mySQL from a remote location? You should be able to keep the script on the web server you already have, and have the script access mySQL - just like Miva Merchant accesses mySQL locally - and output the results to a file you can download. For that you do not need remote mySQL access at all - you just need to host the PHP script on the web server that has "local" access to mySQL.

[benjamintr]

Re: replacement for xadmin?

That sounds extremely unorthodox and very unusual... Perhaps what they meant was that they wouldn't give you access to mySQL from a remote location? You should be able to keep the script on the web server you already have, and have the script access mySQL - just like Miva Merchant accesses mySQL locally - and output the results to a file you can download. For that you do not need remote mySQL access at all - you just need to host the PHP script on the web server that has "local" access to mySQL.

Yes, you're right, I can do it the way you describe. I just can't access the DB from outside the firewall through a report generation tool on the client's desktop.

-B

[d_host]

Re: replacement for xadmin?

If running this report generation tool on your client's desktop is something that would make it more convenient for you - perhaps moving the site would be a viable option? We can give you and your client remote mySQL access if you were hosting it with us... and we can do the entire site transfer for you, at no cost, if you are interested. If you are - give us a call (see number below) or visit our web site to sign up.

Thank you,