LAE

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

Discussions

Members

Resources

Events

 View Only

  • 1.  Which node to use?

    Employee
    Posted 03-30-2016 08:05

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

    Originally posted by: Jagdev

    Hi,

    I have date in Single File web page format file. Please let me know how can I pull this data in Lavastrom.

    Regards,
    Jagdev


  • 2.  RE: Which node to use?

    Employee
    Posted 03-30-2016 08:25

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

    Originally posted by: stonysmith

    Look under Interfaces.. you'll see an HTTP node.
    That can be setup to pull data from a website.
    It can be tricky to pull the data if login credentials, etc are required by the website.

    You'll have to tell us more info about the site for us to provide a proper example.


  • 3.  RE: Which node to use?

    Employee
    Posted 03-30-2016 08:38

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

    Originally posted by: Jagdev

    Hi Stony,

    I think, I quote it wrong above. I am not extracting data from any site. I received an excel file which prompt message when we try to open it. When you try to save as the file in the file type section it shows Single File web page format. I believe it is in this format and system generated. I am trying to pull the data with Excel node and it is throwing an error. I am even not able to attached the file here. Is there any way I can send you the empty sample file for your understanding.


  • 4.  RE: Which node to use?

    Employee
    Posted 03-30-2016 09:08

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

    Originally posted by: stonysmith

    Ah.. okay.. That format is an HTML file, but it's really XML inside.

    If you need to do this just once, then open the file in Excel and change the type to XLSX as you save it, then use the ExcelReader node to bring it in.

    If you need to do this on a repeated basis, then there is a chance that we could use the XML_Data node to process the file.


  • 5.  RE: Which node to use?

    Employee
    Posted 03-30-2016 09:29

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

    Originally posted by: Jagdev

    Hi Stonysmith,

    I sent you the sample file. Looking forward for your reply on this.

    Regards,
    Jagdev