XML Maps and New Rows

[Former Member]

-XP

-SP3

-2007 and 2003

-9 and 10

-Xcelsius Engage 2008 Trial (5.0.0.99)

-Xcelsius Build number 12,1,0,247

-Issue Description:New data from xml map not loading

-Steps to Duplicate:Create XML file, import to excel file, load in to XCelsius. When new data loads, existing values change, but new rows are ignored.

This issue appears to be because XCelsius isn't loading new rows, but only the existing rowset. IE: the original XML import in Excel goes from rows 1-50. An hour later, it goes from 1-55. This is causing the newest 5 rows to be truncated. For testing, and to take this out of the equation, I've sent the max num of rows anywhere between 60 and 5000, with no change in results. I need to know how this can be fixed before we go forward with purchasing XCelsius... or not.

[Former Member]

Hi,

Does any one know a consultant/expert in creating live data SOAP or XML connections to Xcelsius. I will pay them...I just need someone that can make it easy.

Thank you,

Glenn

[Former Member]

My experience is that xml tables "refuse" to get larger if cells below the table (i.e., same columns, higher row numbers) are occupied with certain formulas/contents. Overkill is to make sure that the cells "beneath" an xml mapped range are completely empty, but it won't hurt.

Also, make sure that the imported data does not contain "empty" cells. Use a place holder (e.g., 0, or empty string) instead.

Hope this helps.

[former_member373751]

Also, make sure the Xcelsius component you are using is displaying all the rows it needs to display.

For instance, if your original XML data fills cells A1:A50 and you have your Xcelsius component displaying only cells A1:A50 then your Xcelsius component will not pick up the 5 new rows of XML data coming in, which would be inserted into cells A51:A55. So make sure your component is set to display ALL of the cells you will need in this project. This setting can be changed under the "General" tab in the properties of the component.

What you can do is choose to display more cells than you will need and then select "ignore empty cells" in the component properties and then your dashboard should be able to scale to your data set as it grows while ignoring the blank cells below your data set.

Jeff

[Former Member]

Has anybody experienced this? It seems like the the functionality to handle more rows of data via an XML feed would be more common place... if anybody has any experience with this, their advice would be greatly appreciated.

[Former Member]

I think, in Excel if you grab the handle at the bottom right of your xml map you will be able to extend the xml map range and then re-import it into Xcelsius. New rows should then fill the larger range. (Not tested)

Regards

Charles

[Former Member]

it seems that the only way to get Xcelsius to display more rows than expected within an excel XML Map, is to refresh the xml connection in the embedded excel at design time (In design modus right-click on the xml data->xml->refresh xml data).

I recommend for your issue using XML Data connection not the Excel XML Map.

You can bind the XML Data connection to your all of your excel sheet rows, that way all records will be displayed.

Regards

Victor