Skip to Content
author's profile photo Former Member
Former Member

XML MAPPING - swf not updating

When I make a change to the xml file it is not picking up the change in my published swf file. When I open the project in CX and refresh the mapping updates.

So it is connected but when I click on "refresh" on the sxf it is not updating.

I have xml maps, added in the data connection manager, with a refresh button tied to the xml connection. I also have the refresh on load checked in the connection manager.

Need help.

Thanks

Mark

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on Nov 19, 2008 at 02:54 AM

    Hi Mark,

    Now Xcelsius 2008 SP1 has one release note for this issue. That is, when components are bound to a cell range that is larger than the XML Data range, to accommodate additional data, they do not update when XML data is added by new rows and/or columns. We have work around for this issue, you can add more ranges than you want used in xml maps when design xml maps. By doing this, you can get the new added data.

    Please have a try, youu2019ve any problem, please let me know.

    Best wishes,

    Sammi Sun

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Sammi,

      Can you expand on what you are saying about the workaround? I'm having a problem not being able to pull in new rows via excel xml. Changes to existing data refreshes just fine. I just can't get new data introduced to save my soul...

  • author's profile photo Former Member
    Former Member
    Posted on Nov 13, 2008 at 02:15 PM

    If you use windows platform you can see cache file in windows temp directory...

    I don't know yet how to resolve this problem...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2008 at 01:29 AM

    With help from the forum and other I have solved this issue. First issue was that the timestamp in my date displayed in my query results were not matching the date format issued by the calendar selector. I had to work around with formatting in excel to make the dates match each other.

    Second issue were global security settings in flash player.

    Third issue was also understanding the fact that the swf or html file is opened on a client machine and actually downloaded into the cache of the client so the file path for excel mapping has to be set at design time to match the way the client machines accesses the file for direct access. (ie internal network, mapping drives to access the file in a shared folder). At design time this path is not the path that the server machine would necessarily need to have the model work on the serve.

    Finally a full understanding of this process! Moving ON!

    Thanks All.

    Mark

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 01:38 AM

    Hi..Mark.

    I am facing exactly the same problem as how you faced (based on the description you gave in your thread below)

    "When I make a change to the xml file it is not picking up the change in my published swf file. When I open the project in CX and refresh the mapping updates.

    So it is connected but when I click on "refresh" on the sxf it is not updating.

    I have xml maps, added in the data connection manager, with a refresh button tied to the xml connection. I also have the refresh on load checked in the connection manager."

    Can you please kindly assist me on how to resolve this issue?I have spent quite some time to find a solution, but none gives me a positive output.

    Regards,

    Shamim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 01:35 AM

    Shamim my scenario was that I wanted the SWF on a network so that a call center employee could access the file from a mapped drive, open the file direct on her/his client machine. My problem was that I developed the file on the server machine and mapped the data connection path to the XML initially from the server, not the scenario of a client machine's path looking for the file. (not sure if cache is the right term)

    Initial Path from server development.. D:\Datafiles\data.xml

    The client machine(s) network path, mapped drive was Z: for example. In the excelsius model you need to bind the data path to the excel model and hardcode the Path that the client machines will go thru to access the data. This solved my issue perfectly. Z or name of the mapped drive mapped to the server.

    Z:\Datafiles\data.xml

    So now if your on the server machine and try to open the file from the swf you will incur the error message that correlates to the swf not being able to find the data. From the clients works fine but not from the server machine as the path has to be exact for the swf to find the data file.

    Hope this helps.

    I have a question for trying to deploy this same example on th server embedded into a swf movie player to the web. Might have been my path issue, cross domain policy file... But I could not get it to be deployed in a website, live. If you are familiar with this please explain to me.

    Regards,

    Mark

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.