XML u2013 Structure needed in Xcelsius

[Former Member]

I am trying to trying to make my SWF read values from a XML file but am having problems u201Cconnectingu201D to the values in the XML-File. When I make the connection in Xcelsius and check the structure needed (Button Preview XML in the Data Manager) it shows a two dimensional structure (rows, cols). Is this the only structure that Xcelsius can handle or can I connect to more complex structures?

[Former Member · Accepted solution]

You cannot connect to more complex structures and have to rely on the format provided.

You may be able to do something via an ODBC driver but with an ODBC driver you would need to either import the XML file through Crystal Reports with Live Office or through Universe Designer with Web Intelligence or QAAWS.

I hope this helps in your decision making.

[Former Member]

Hi..

I have one XML file and,

I want to solution in a way that XML>>Xcelsius 2008

Means that how can I load the XML file into the Xcelsius 2008

So..please tell me the solution if you have

Thank You,

[Former Member]

Hi Drashti

Have you looked at creating an XML map in your Excel file first (Data > XML > Import). Then import that Excel source into Xcelsius and look at the Excel XML Maps data connection.

Regards

[Charles|http://www.reportex.co.uk]

[Former Member]

Hello Charles,

Thanks for your reply.Yes , I have gone through your suggestions and its works nice.

I want to import outer Excel sheet data into Xcelsius inner Excel sheet or in other words, data must be extracted through Xcelsius software. So, I have to connect Excel sheet and Xcelsius product. As per my knowledge, connectivity option in this product are XML,Web services,internal excel and and some Business Objects specific reports. but XML is best option to connect.

I have completed Excel -> XML and now facing problem of XML -> Xcelsius

Its my pleasure, If you can provide good solution of XML -> Xcelsius.

waiting for your prompt reply,

Thanks,

Drashti

[Former Member]

Hi

Open Xcelsius, and select Data > Import from the Menu Bar, you can then load your Excel spreadsheet into Xcelsius.

Hope this helps

Charles

[faisal_altaf2]

Hi, Mattias

Hi, Test the following Sample Structure there are 7 Rows and 2 Colums

Follow the Steps in Xcelsus

--> Data --> Connections

--> From the appearing Window Select Add and than select "XML DATA"

--> Past the URL in the "XML Data URL" txt Box

--> Check the Emable Load CheckBox

--> Name = empid In this Sample Code

--> Range = Select the range in the Excel window (7 Rows and 2 Colums)

--> Pick a LIST BOX and Select the Same Rows and Colums for Display Data for this List Box.

and Take the Preview or Ctrl + Enter.

Hope will disaply

Code is following .

<data>
  <variable name='empid'>
    <row>
      <column>1</column>
      <column>1000</column>
    </row>
    <row>
      <column>2</column>
      <column>2000</column>
    </row>
    <row>
      <column>3</column>
      <column>10000</column>
    </row>
    <row>
      <column>3</column>
      <column>6000</column>
    </row>
    <row>
      <column>4</column>
      <column>6000</column>
    </row>
    <row>
      <column>5</column>
      <column>6000</column>
    </row>
    <row>
      <column>6</column>
      <column>6000</column>
    </row>
  </variable>
</data>

Kind Regards,

Faisal

[Former Member]

thanks for the repsponses. It works great!

[Former Member]

i am having the xml file with 1 lakh records

is it possible to retrieve the data with condition from the xml file to xcelsius.

thanks

Ram.G

[sammi_sun]

Hi Mattias,

If you using XML data connection you should respect the exact structure youu2019ve seen from preview button. And if you want to handle or connect to more complex structures, I think the easiest way is using Excel XML Map connection. You can have a try. Of course, you can use any methods mentioned by Patrick.

Hope it is helpful to you.

Best wishes,

Sammi

[Former Member]

did you figure out what format Xcelsius is looking for with xml?

[sammi_sun]

Hi Mark,

The XML data used in XML connectivity should be a row-column structure (the exact structure that you will view using the Preview XML button in the Send section). Which means your xml structure should be exact the same as:

<data>

<variable name="test">

<row>

<column></column>

<column></column>

<column></column>

<column></column>

</row>

<row>

<column></column>

<column></column>

<column></column>

<column></column>

</row>

</variable>

</data>

You can get more detail info from help file; the session is :

Using Advanced Features in Xcelsius Engage

->Configuring the XML Data Connection

-> User Guide Sample: XML Data (Advanced)

Best Wishes,

Sammi

[Former Member]

Hi,

is there any accessible, good description about how to use the Data Manager and all the data connections in XCelsius Engage? I did not find any word about it in the help and also nothing in the installed envionment.

Can somebody help me by poining some good downloadable?

Thanks,

Peter