Insert values from SWF in a XML file

[Former Member]

Is it possible to insert values in the swf to a xml file?

[former_member186358 · Accepted solution]

Mattias,

Are you looking for an option to export data from dashboard to xml file...? If Yes...

Ans is.. No you do not have any option as such...in Xcelsius.

-Anil

[Former Member · Accepted solution]

What does then the functionality "Enable Send" do if not to send data entered in the swf to a xml file?

[former_member186358 · Accepted solution]

Mattias,

This option will allow user to pass values to the url and will retrieve the data based on the user Input...

-As per user guide:

Select this check box to send the XML data to the URL from the Send

Ranges when the button is triggered. Edit the ranges that are translated

to XML and sent to the URL. The translated ranges are sent via HTTP

using the POST method.

I was under impression that you are looking for Exporting data from swf file to XLF file...say loading entire data from swf file to xml file..

However, if you are looking for user passing values to the URL and retrieve the data based on the user input...then you can use this option..

-Anil

[Former Member · Accepted solution]

What I want is to write data entered in the swf file to a xml file. Have tried to make a connection according to the information in the help section, but without success.

[former_member186358 · Accepted solution]

Not a problem...we are here to help you..

Just let us know steps in detail..and where you got stuck...

-Anil

[Former Member · Accepted solution]

Hi Anil.

This is what i have done:

Added a xml-data connector, entering the path for my xml file, mime-type.

Connected the values / fields to the area that I want to write to the xml.

Added fields to my canvas and connected them to the cells in the excel sheet.

Added a refresh button.

Exported the swf as a PDF

Entered the values in the field that I want to write to the xml file.

Then clicked the refresh button.

Expected to have the values in the XML files but no success.

[former_member186358 · Accepted solution]

Mattias,

You may wish to refer the link below..

http://resources.businessobjects.com/support/cx/samples/learning/downloads/ttv4-xml_data_button.pdf

-Anil

[Former Member · Accepted solution]

Hi Anil

Thanks for you answer.

Sadly this does not solve my problem. I want to have values entered in the swf saved locally as a xml file, without having to us a server script. Is this possible?

Is it possible to have the swf create a file of any sort on the local machine?

Kind regards

Mattias

[former_member186358 · Accepted solution]

Mattias,

Is it possible to have the swf create a file of any sort on the local machine?

Unfortunately, there is no option as such to create a file on the local machine from swf...however that is a good idea.

-Anil

[Former Member · Accepted solution]

Hi Anil

Not the answer I was hoping for, but thanks for your help.

//

Mattias

[former_member186358 · Accepted solution]

SAP,

File --> Snapshot --> Current Excel Data, exports data to excel sheet... (in Preview Mode)

How about having it as a component... "Export to Excel"

Just a click and it exports to a local file.

Matt/Charles,

Can you please shed some light on this...if this is a good idea?

Such component will surely help...

Having an option like..

-->Selecting a range of cells (Properties) which should be exported.

-->Exporting in CSV/ XML format

-Anil

[Former Member · Accepted solution]

Hi Anil,

It is a good idea but Flash is not allowed access to the file system so it cannot write a file out.

If you use the XML Data connector and have bound it to a range of cells in the spreadsheet you can click Preview XML in the Property Sheet to generate an XML file with the current Excel values in it, again this is only possible at design time.

Regards

Matt