BusinessObjects Board

XML Map - Relative path for XML Data URL

I’m looking for the acceptable format for a relative “XML Data URL” path used in the XML Maps data connections properties. I’ve tried many formats but nothing seems to work.
My SWF, XSD Maps, and XML data files will always be named the same and co-located in the same folder. Regardless of complete path, I would like to provide a relative path to the co-location.

This format

 File://C:\XML Data\Dashboards\Test.xml 

works fine, but is an absolute file URL. I am looking for a solution that allows me to move the entire directory to another location and still be functional. URL to provide like using:

./Test.xml   or   file:../Test.xml  or   ./../Test.xml  

I just haven’t been able to be successful. Any ideas?

[Moderator Edit: Added code formatting - Andreas]


datawizard (BOB member since 2015-01-20)

Nope. I never found a way to get a relative path to work. I ended up putting the server name into cell A1 and then concatenating it to everything else with a formula. So when I change servers, I simply type the new server name into A1 and everything else changes - then I recompile the SWF on the live server.

Debbie


Debbie :uk: (BOB member since 2005-03-01)

Thanks Debbie… that should work. I read another where they used a flash variable to specify the path externally on open… then concatenating as you did internally. This allows an external adjustment at the command line vice regenerating the SWF for each location change. Interesting idea… Setup a flash var named “PATH” in the data connections and create the URL with the following link format or just paste into a browser, run, and bookmark.
example format started with SWF and XML on desktop:

file:///C:/Users/User/Desktop/Dashboard.swf?PATH=C:/Users/User/Desktop/

Then moved SWF and XML to D:\XML\DATA\

file:///D:/XML/Data/Dashboard.swf?PATH=D:/XML/Data/

Cell A1 = File://
Cell A2 = (map to Flash variable PATH input)
Cell A3 = Test.xml
Cell A4 = A1 + A2 + A3 (Map to XML Map - XML Data URL setting)

Update: Just ran and tested the above - works great!


datawizard (BOB member since 2015-01-20)

Interesting… unfortunately I doubt I’ll get any future development done in Xcelsius - it’ll be maintenance only now. SharePoint is apparently the future … :roll_eyes:

Debbie


Debbie :uk: (BOB member since 2005-03-01)