cancel
Showing results for 
Search instead for 
Did you mean: 

XML MAPPING - swf not updating

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

sammi_sun
Explorer
0 Kudos

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

Former Member
0 Kudos

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...

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

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