Uploading to birt-spreadsheet-datasource plugin

wondermike

hi, I'm using the birt-spreadsheet-datasource plugin in version 3.7.1 and I'd like to upload files to the web-app. What I already have so far is the sub folder "sheets" and an XLS file in there. The only thing I need to know how would the ordinary user upload his XLS file (with a fixed file name of course, for now) to that directory? Is that possible inside a BIRT application?

In an ideal world, that user would upload the file, the filename would be appended to the report as a parameter and the report would take it and feed it to the plugin. How would one design such a mechanism?


Thanks for any suggestions.
Regards
Michael

CBR

Hi Michael,

i m the developer of that plugin. I m currently using the plugin in some similar way. The user is able to upload a excel file. Once the upload is done it executes a certain report.
You have to add a excel file upload servlet to the webabb. Are you using the webViewer or do you have integrated the Report engine into your own webapp? If you are using the Webviewer i can sent you the servlet code with some installation instructions.

Concerning your question:
Basically the servlet upload stores the excel file to that directory with a unique filename (the filename has to be unique because my app is used by multiple users at the same time and i do not want to introduce concurrency issues: one user overwrites excel file of another user because they are using the app at the same time) That unique filename is passed to the report as a parameter. The report is setting the filename using the property binding tab of the datasource (there you can set the filename using Rhino Script).

Do you mind sharing some informations with me? Just wanted to know in which context my plugin is used and if it has issues. I would be happy to know about that because i m planning to do some enhancements to it.

Thanks!
Christian