MYSQLDUMP to XML

[JamesFlowers]

Hi , I am currently in the middle of a ERP design , and we are using a MYSQL backend , with PHP.

We have a requirement to provide XML outputs of the screens seen from certain screens so the data can be loaded into Excel and also into a clients system (they have specifed XML output).

So we have investigated and we think MYSQLDUMP is the best way to kill two birds with one stone?

We run the PHP/MYSQL on a hosted website.

Can anyone advise on a different strategy ?

Many thanks.

James Flowers
Crystal Consultant

 

[jpadie]

if the screen is a view of a single table then mysqldump might be a good solution.

otherwise, if the screen is a view across multiple tables and with filters etc, then you may find it best to use php to produce the xml output. All you would need is the schema that the company wishes to use for the xml and the mapping between the columns of your table/view and their schema. then it is straightforward.