Open File - not returning data from url

User: "kludikovsky"
New Altair Community Member
Updated by Jocelyn

The "Open File" operator does not return anything.

 

I have tried the following example

http://www.neuralmarkettrends.com/Extracting-OpenStreetMap-Data-In-RapidMiner/ 

which returned an error.

 

By analysing the cause I found that the Open File Operator seemed to not return anything useful (even if so said).

I have modified the Read CSV and all work from there on.

But this is no the solution if someone likes to retrieve information from a url.

Can someone please verify my experience and/or explain what's wrong.

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "sgenzer"
    Altair Employee
    Accepted Answer

    ok that was a fun puzzle.  :) So that URL http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_day.csv is a redirect to a https link.  This is why the Open File did not work.  If you change your URL to https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_day.csv, it works perfectly.  :)

     

    <?xml version="1.0" encoding="UTF-8"?><process version="7.6.001">
    <context>
    <input/>
    <output/>
    <macros/>
    </context>
    <operator activated="true" class="process" compatibility="7.6.001" expanded="true" name="Process">
    <process expanded="true">
    <operator activated="true" class="open_file" compatibility="7.6.001" expanded="true" height="68" name="Open File" width="90" x="45" y="34">
    <parameter key="resource_type" value="URL"/>
    <parameter key="filename" value="http://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_day.csv"/>
    <parameter key="url" value="https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_day.csv"/>
    <description align="center" color="transparent" colored="false" width="126">Open USGS URL</description>
    </operator>
    <operator activated="true" class="read_csv" compatibility="7.6.001" expanded="true" height="68" name="Read CSV" width="90" x="179" y="34">
    <parameter key="csv_file" value="/Users/genzerconsulting/Desktop/2.5_day.csv"/>
    <parameter key="column_separators" value=","/>
    <parameter key="first_row_as_names" value="false"/>
    <list key="annotations">
    <parameter key="0" value="Name"/>
    </list>
    <parameter key="encoding" value="UTF-8"/>
    <list key="data_set_meta_data_information">
    <parameter key="0" value="time.true.polynominal.attribute"/>
    <parameter key="1" value="latitude.true.real.attribute"/>
    <parameter key="2" value="longitude.true.real.attribute"/>
    <parameter key="3" value="depth.true.real.attribute"/>
    <parameter key="4" value="mag.true.real.attribute"/>
    <parameter key="5" value="magType.true.polynominal.attribute"/>
    <parameter key="6" value="nst.true.integer.attribute"/>
    <parameter key="7" value="gap.true.integer.attribute"/>
    <parameter key="8" value="dmin.true.real.attribute"/>
    <parameter key="9" value="rms.true.real.attribute"/>
    <parameter key="10" value="net.true.polynominal.attribute"/>
    <parameter key="11" value="id.true.polynominal.attribute"/>
    <parameter key="12" value="updated.true.polynominal.attribute"/>
    <parameter key="13" value="place.true.polynominal.attribute"/>
    <parameter key="14" value="type.true.polynominal.attribute"/>
    <parameter key="15" value="horizontalError.true.real.attribute"/>
    <parameter key="16" value="depthError.true.real.attribute"/>
    <parameter key="17" value="magError.true.real.attribute"/>
    <parameter key="18" value="magNst.true.integer.attribute"/>
    <parameter key="19" value="status.true.polynominal.attribute"/>
    <parameter key="20" value="locationSource.true.polynominal.attribute"/>
    <parameter key="21" value="magSource.true.polynominal.attribute"/>
    </list>
    </operator>
    <connect from_op="Open File" from_port="file" to_op="Read CSV" to_port="file"/>
    <connect from_op="Read CSV" from_port="output" to_port="result 1"/>
    <portSpacing port="source_input 1" spacing="0"/>
    <portSpacing port="sink_result 1" spacing="0"/>
    <portSpacing port="sink_result 2" spacing="0"/>
    </process>
    </operator>
    </process>

    Scott