LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jagdev

Hi,

I received few excel protected view files, but when I am trying to add these files in the lavastorm excel node, it is throwing an error (as unsupported file type). Is there anyway to deal with this issue.

Regards,
Jagdev

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi Jagdev,

I tested some .xls and .xlsx files that I downloaded from our web-based document management system to my local machine (to force them into Protected View status) but the files were imported without any errors. Do the files open successfully in Excel? Would you be able to provide me with a sample file that exhibits this problem

Update: I also tested files where an individual sheet was protected and the structure of the document was protected and they were also successfully imported.

The Excel File node does not currently support files that are Password protected to open the file - is this the situation you are encountering?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jagdev

Hi Adain,

Our last point is something I am currently encountering with Excel node does not support such files. Is there any node which will help me to import such file into lavastorm platform.

Regards,
Jagdev

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

Hi Jagdev,

Unfortunately, none of the Excel file acquisition nodes currently support password protected files. It is a feature enhancement that we want to introduce into Lavastorm but there is no specified timescales for its release at this time.

Regards,
Adrian

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Jagdev

Hi Adrain,

Thanks for the update, we are looking forward for this enhancement.

Regards,
Jagdev

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

One work-around to enable Lavastorm to access password protected Excel files could be to use a node based on the add-on Open Source R node.
However this approach has a number of dependencies so may not be suitable for everyone.

The attached dataflow provides a node that will operate on Windows machines only as it leverages the Microsoft Excel application during its operation.
The node uses the Open Source 'RDCOMClient' CRAN package. Due to licensing restrictions, this package must be downloaded separately if it is not
already installed on the machine. However, as a convenience, the node will download and install this package provided you consent to this operation
by accepting the licence agreement on the node's License tab.

The node requires access to a running R server. By default, the node will try to connect to an Rserve instance on the local machine but this can be
configured on the node's Connection tab. The machine hosting the R server needs to have Excel installed.

The node imports data from the specified sheet within the Excel file (or the first sheet if the sheet index is not specified).

R_Node_Read_Excel_Sheet_v1.0.brg


The R node installer is available from the Lavastorm website. Normally the installers can be found here:

http://www.lavastorm.com/lavastorm-installers/ (which redirects to a repository in Salesforce)

However, a new version of the website is being launched today but this does not currently include this link.
You can access the Lavastorm installers repository by either typing "Lavastorm Installers" into Google or going to the relevant
Salesforce page directly:

http://na3.salesforce.com/_ui/selfse...0150000000s09A

From the Lavastorm Installers page follow the "Download Lavastorm Analytics Library" link (the direct link is below)

http://na3.salesforce.com/_ui/selfse...0150000000pH2G

And download and install the version of the R Analytics installer that matches the version of Lavastorm you are using *and* the architecture
of the Lavastorm application you have installed (32-bit / 64-bit).

See the release notes for installation and set-up information, and how to start Rserve.