Eclipse Community Forums: Eclipse Scout » Export in Excel and Download a file

Help

Home

Home » Eclipse Projects » Eclipse Scout » Export in Excel and Download a file(RAP and Kepler version)

Show: Today's Messages :: Show Polls :: Message Navigator

Export in Excel and Download a file [message #1440415]

Wed, 08 October 2014 10:35

marco giudici

Messages: 204
Registered: February 2013
Location: Italy

Senior Member

Hi all,
I have the need to export some data to Excel and I also the need to create a XML file, creating a file on the client pc.

How can I specify the destination folder in the RAP?

The RAP filechooser you can only upload files. Download is not possible as the javadoc says:

/**
   * Load or Save
   * <ul>
   * <li><code>true</code> loads the file from the file system into the application.</li>
   * <li><code>false</code> saves the file from the application to the file system. Attention: This does not work in
   * RAP/Web-UI</li>
   * </ul>
   */

Thanks in advance for any help

[Updated on: Wed, 08 October 2014 10:37]

Report message to a moderator

Re: Export in Excel and Download a file [message #1440426 is a reply to message #1440415]

Wed, 08 October 2014 10:54

Matthias Nick

Messages: 197
Registered: August 2013

Senior Member

Hi Marco,

what I would do is to create the files on the server and provide a simple link to the user. When the user clicks on the link the download starts.

Alternatively you could try start the download automatically with the following method

org.eclipse.scout.rt.client.ui.desktop.AbstractDesktop.openUrlInBrowser(String)

I think you can use it this way

ClientSyncJob.getCurrentSession().getDesktop().openUrlInBrowser(url);

However I didn't try by myself

Report message to a moderator

Re: Export in Excel and Download a file [message #1440444 is a reply to message #1440426]

Wed, 08 October 2014 11:27

marco giudici

Messages: 204
Registered: February 2013
Location: Italy

Senior Member

Thanks Matthias for this suggestion, it's a point of view that I had not thought.

I try to follow this way, if I need help I post here my questions.

Report message to a moderator

Re: Export in Excel and Download a file [message #1442004 is a reply to message #1440444]

Fri, 10 October 2014 13:31

marco giudici

Messages: 204
Registered: February 2013
Location: Italy

Senior Member

Hi Matthias,
Now I write the file to the server and return it to the client the server path where to find the file you just created.
I can create two different file: one is a xml file (xxxx.xml) and one is Excel file (xxxx.xlsx)

I visualize the full path in a link button, but now I would like that the user can click directly on this element to open the remote file.

Is this way possible or not? If yes, I can open Excel?

To open the xml file, I can use your suggestion (see below), correct?
Quote:

Alternatively you could try start the download automatically with the following method
org.eclipse.scout.rt.client.ui.desktop.AbstractDesktop.openUrlInBrowser(String)
I think you can use it this way
ClientSyncJob.getCurrentSession().getDesktop().openUrlInBrowser(url);

Thanks in advance for any help and explanation

[Updated on: Fri, 10 October 2014 13:33]

Report message to a moderator

Re: Export in Excel and Download a file [message #1442007 is a reply to message #1442004]

Fri, 10 October 2014 13:35

Matthias Nick

Messages: 197
Registered: August 2013

Senior Member

Hi marco,

If I understand correctly you have the path of your files available on the client. So when you paste the path into the Browser (e.g. Chrome) the download of the file should start.

Now in Scout when you click on the link button, I think you can do the following:

  public class DownloadButton extends AbstractLinkButton {

    @Override
    protected String getConfiguredLabel() {
      return "Download";
    }
    

    @Override
    protected void execClickAction() throws ProcessingException {
      ClientSyncJob.getCurrentSession().getDesktop().openUrlInBrowser(PATH_OF_THE_FILE_ON_THE_SERVER);
    }
  }

Hope this helps.

Report message to a moderator

Re: Export in Excel and Download a file [message #1442018 is a reply to message #1442007]

Fri, 10 October 2014 13:59

marco giudici

Messages: 204
Registered: February 2013
Location: Italy

Senior Member

Hi Matthias,
perfect ... works fine but the function is a bit different:

ClientSyncJob.getCurrentSession().getDesktop().openBrowserWindow(PATH_OF_THE_FILE_ON_THE_SERVER);

Report message to a moderator

Re: Export in Excel and Download a file [message #1443724 is a reply to message #1442018]

Mon, 13 October 2014 06:12

Matthias Nick

Messages: 197
Registered: August 2013

Senior Member

Hi marco,

thanks for the update Smile

Glad it works.

Matthias

Report message to a moderator

Previous Topic:	Run scout server standalone?
Next Topic:	Custom Servlet => use SERVICES.getService(..)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 05:19:31 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter