I am looking at running an export from my concrete5 database including details about users, orders etc.
I want this data in an xml format, this will them be imported into an external back office system.
Can anyone please give me direction as to the best way to export data from C5 ...?
The second would be to check how concrete5 built-in exports work and you can look that by taking a look at this add-on:
Although that add-on might not give you a ready-to-be-used solution, by looking at it, you can probably get the grasp of how it works.
And also one option: straight SQL queries and export the resultsets into XML files.