That's right, it's all in the title. OK, client wants a menu in the corporate font, so we need to use flash.
Bit of a mission in the end, so thought I better post about it. My first tempt (posted further down the page) was to generate an xml feed using views. This didn't work as I wasn't able to use custom SQL to populate the view.
What I ended up doing was creating a new content type, XML page, creating the page, then defining custom template that simply contained a SQL query that generated the XML feed. This method doesn't sit that well with me, would have preferred using views, but views doesn't provide access to the menu data.
I've included my first attempt, as I learnt about views datasource module, that could be very handy for other applications.
First (unsuccessful) Attempt:
To get the dynamic data into the flash, we are going to use Drupal views to generate a xml datasource. To do this we need to add the Views Datasource module. Unfortunately the new release of Views breaks this, so we need to download the patched version from here.................
http://drupal.org/node/307223#comment-1040887
Enable the module, create a new view. Now under the Basic Settings -> Style, there will be an option for XML data document. Select this.
Add your fields to get the menu items, create a page view to generate a path.
This is where I got stuck. I couldn't find a way to allow the view module to get access to the menu data.
