Need help for relative path xml files

[Former Member]

Hi,

I am working on SAP Crystal Dashboard.

I have several xml files on a folder corresponding to differents projects.

On the spreadsheet, I have defined a cell whith the relative path of the xml file to be loaded.

So, when i select a project, the path is personalized.

How can i parameter SAP crystal Dashboard to load the selected xml file?

thank you in advance

regards

[Former Member · Accepted solution]

Hi Aziz,

Please confirm whether you have implemented any Selector to select the project name or you are passing the name with any flash variable.

If you could explain in a bit detail, would be of help.

Regards,

Tejas

[Former Member · Accepted solution]

Hi Tahmane,

I have implemented a selector to select the project name.

The project name selected is copied on the spreadsheet cell A1.

Cell A2 give the path "C/projects" (folder with xml files")

Cell A3 is concatenation of A1 & A2 & ".xml"

I create a data connection and indicate the URL path as cell A3.

I want the specified file in A3 to be loaded and copied in the spreadsheet.

But It doesn't work.

I hope it is clear

thank you

[Former Member · Accepted solution]

Hi Aziz,

Use Connection Refresh Button in this scenario. After you make a selection using the selector component, hit Connection Refresh Button.

PS: Remove default refresh option for your XML data connection and tick the the same connection in Connection Refresh Button. If you have not used Connection Refresh Button, I would advise you to go though tutorial first to understand why we use Connection Refresh Button.

Do write back if this works.

Regards,

Tejas

[Former Member · Accepted solution]

Hi Tamhane,

I have added a connection refresh button, it still doesn't work.

Can I send you the file?

thanks, regards

Aziz

[Former Member · Accepted solution]

That will be of help. Please go ahead.

Regards,

Tejas

[Former Member · Accepted solution]

Is it possible to send xlf file?

regards

Aziz

[Former Member · Accepted solution]

Change the extension to .txt and upload it here.

[Former Member · Accepted solution]

here attached

regards

Aziz

xcelsius.txt.zip

[Former Member · Accepted solution]

Doghmi, project names are blank in the excelsheet.

Where are you getting the project names from?

[Former Member · Accepted solution]

sorry here is the good file.

I get the project names from a link to database access loaded in sheet"project"

xcelsius .txt.zip

[Former Member · Accepted solution]

Please check if resulting cell gives you correct path, otherwise everything looks fine. You will not see data loading as long as a path for XML file is not correctly defined.

Regards,

Tejas

[Former Member · Accepted solution]

You can confirm this without having any selection. Just try running the dashboard with a single accurate URL for XML data connection but refresh it using Connection Refresh Button.

There could be a possibility of generating incorrect URL due to concatenation formula.

[Former Member · Accepted solution]

Hi Tamhane,

I've tried with an accurate URL for XML and it didn't work.

The problem is that the XML is in the wrong formal.

I have modified the XML manually to be at the format required by Xcelsius and it was OK.

Do you know if it is possible to transform the XML file generated by Access to be compatible with Xcelsisus?

I find this text resuming the format required by Xcelisus :

"The XML file should essentially be an array of data points, rows and columns, just like a spreadsheet.  Xcelsius grabs this XML file and simply imports it directly into an array on the spreadsheet.  It's not able to read FieldNames or anything like that.

Here is what an XML file should look like for the XML data connection:

<?xml version="1.0"?>

<data><variable name="Range_0">

<row><column>5</column><column>7</column><column>4</column></row>

<row><column>2</column><column>1</column><column>4</column></row>

<row><column>1</column><column>2</column><column>4</column></row>

<row><column>2</column><column>4</column><column>5</column></row>

</variable></data>

thank you

Aziz