New Feature

[Fernando]

it would be nice to generate dinamically XML file for migration toolkit, for example with PHP or ASP, in that way we could use a query with a dinamically WHERE statement and only (in the primary key autoincremented) transfer the data that is > than the max(id) field. This way we could avoid updating data in the ODBC database.

maybe something like:

sja [url=”http://localhost/updatescript.php”]http://localhost/updatescript.php[/url]

[peterlaursen]

@Fernando.

We can't se files on your 'localhost' ! 😀

Paste it in instead, so we can see it.

You can generate the jobfile dynamically from a script and then execute it with SJas the last step. You also need not update the ODBC source. And SJA has nothing to do with PHP or ASP – is a compiled binary that runs alone. But I think you will have to explain better.

[Fernando]

Hi Peter, I know you can´t see localhost, it was just an example, the question is about reading an XML file from any web host via SJA, which is generated dinamically from any Server side script language such as PHP or ASP. so in the query you can include a parameter in the WHERE statment to retrieve data and, (for example again) from the last id that was introduced in Mysql Table.

….

–

select * from data where id > id

data

–

….

the parameter in red comes from same table but in Mysql side obtained by the script.

probably with a command like

sja http://whateverhost.com/somescript.php

who will parse XML data to sja.

I hope this would be clearer.

[peterlaursen]

there are lots of ways to do such thing allready.

An example:

1) Write a jobfile for ODBC/Migration using where: “where id > dummy” //idea is that 'dummy' shall be replaced

2) Run a PHP script, finding what 'dummy' really should be by querying MySQL. Read the 'dummy'-jobfile from script; make a copy of the XML replacing 'dummy' with that (simple string handling). Execute SJA from the script with the 'replaced' jobfile as parameter.

SQLyog and SJA does not at all relate to PHP or any other server side script. There are no plans for the foreseeable future to change that. SQLyog is based on C, not PHP. Also I believe that the needs of different people would differ anyway. The exact solution that you need nobody else will need exactly like that, I believe. But you can easily do it yourself.

BTW: Your link does not show anything relevant here! (pop-up blocked!)

[Ritesh]

I understand what Fernando is talking about:

SJA should have an option to pick-up the xml config file from a script running on the web-server.

The script(PHP, ASP, whatever) should send “Content-Type: text/xml” in the HTTP header and the contents of the XML config file in the HTTP body. Of course, this feature would provide unprecedented flexibiliy on genrating dynamic config files.

Currently, the SQLyog tunneling page uses this method to communicate with the client.

Nice suggestion Fernando – I have already put it in our TODO list.

[Fernando]

Thank you Ritesh, I look forward to see this feature soon. 😀

Fernando Colin

Productos Carey S.A. de C.V.

[Author]

Posts