XML Mapping

[Former Member]

If anyone is an expert in XML maps maybe they can help me. I have one xml file with 4-5 Query results streaming to it.

When I map them to excel and refresh thru excel they all also refresh properly with new data. All is ok here.

I import into excelsius and bind components to the different sheets, set up connection manager and refresh button all set to refresh on load.

Here is where it gets strange: The first component added to the canvas works properly upon refresh but anything added second whether a value or a list view selector, spreadsheet selector they all default to the first query's maps. The bindings are clearly to the respective mappings data but on refresh thru excelsius they show values from the first mapping.

I am stuck any help would be appreciated.

Mark

[sammi_sun]

Hi Mark,

I donu2019t quite understand your question. Here are my understandings:

1) You have one xml file and this xml file is the only xml data source of your excel file.

2) You have 4-5 queries based on this xml map. Do it mean you divide your xml map into 4-5 data ranges (or blocks) in your excel file?

3) You use several components binding to these data respectively

4) All of these components only get data from the first data range.

I tried and it seems everything is ok. I can get data from each data range.

Would you please give more detail explanation of your problem? It will be more helpful if you can send me your model.

[Former Member]

Thank you Sammi for a response.

1) You have one xml file and this xml file is the only xml data source of your excel file.

Yes

2) You have 4-5 queries based on this xml map. Do it mean you divide your xml map into 4-5 data ranges (or blocks) in your excel file?

Yes I divide the mappings from the one source to 4-5 blocks on different worksheets.

3) You use several components binding to these data respectively

Yes

4) All of these components only get data from the first data range.

Yes

I have also tried to have each query from the database export to its own xml file, map all of these xml files into the model, import, bind, add connection in data manager, add connection refresh button (one for all and also one for each) and same results. Only one query will be updated.....

I will e-mail you the model.

Thanks!

Mark

[Former Member]

Sammi please let me have an e-mail address to send to.

Thanks.

Mark

[sammi_sun]

Hi Mark,

Please get it from my profile. I cannot post it here.

Best wishes,

Sammi

[sammi_sun]

Hi Mark,

Iu2019m sorry to tell you that after investigation I find that this is a known bug for XML Map (currently we cannot support Multidimensional mapping well). And we hope to resolve this problem in the future version. The workaround here is to flat the XML to a row-column table with non null node (which means each row should have the same column structure even if the column value is blank.) Or you can divide your xml into three xml files (one is for Reservationsbydate, one is for Datastats and the other on for ResIntelligence ) and use three xml map connections; but using this workaround you need to have Xcelsius Enterprise version. For Xcelsius Engage we limit it to only ONE xml map connection. Sorry for all those inconveniences!

Sammi