Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Lavastorm Excel Acquisition Node

    Employee
    Posted 05-15-2018 19:05

    Excel node fails when trying to import data from a  file in SharePoint.

    Can't use the sharepoint path in the excel node directly so using the 'Download for sharepoint 2010' node first to access the folder and then using the excel node to import data into lavastorm but getting an error message 'ERROR: Parameter FilenameExpr references the file: E:\Shared Documents\Mojo Automation\M19 - Wholesale invoice preparation and journal automation - TA1TA2\Inputs\XXXX.xlsx. However this file does not exist on the file system.
    Error Code: brain.node.referencedFileDoesNotExist'

    Looks like excel node works only when complete path is provided , how to overcome this as we need to pull data from files on sharepoint.

     

    Pls help



  • 2.  RE: Lavastorm Excel Acquisition Node

    Employee
    Posted 05-15-2018 22:29

    Error fixed, just had to use 'Download for sharepoint' node instead of 'Folder List for sharepoint' node.