creating a connection

wclasterwclaster Member, University Professor Posts: 43 University Professor
Hello. I am using the Extract Sentiment operator. I input some Tweets and it worked fine when I used vader or sentiwordnet. I am trying to get Aylien to work. I choose from the menu options, Connections>>Create Connections. For connection type I selected Aylien and Local Repositor and created it. I registered at Aylien and got an app_key and app_id. But when I try Test connection it says: No test performed. Then when I set the parameters on the Extract Sentiment operator, I need to enter a value for aylien connection but in the drop down box there are "no suggestions found". Does anyone know how I can fix this? Thank you.

Best Answers

  • kaymankayman Member Posts: 662 Unicorn
    Solution Accepted
    The column you want to analyze is called 'text' in your excel? 
    If not the operator will indeed not provide anything, as this is the attribute it needs. 

    Also, not sure if the aylien operator expects the attribute to be in text format (so not nominal), so better check that also. 
  • wclasterwclaster Member, University Professor Posts: 43 University Professor
    Solution Accepted
    I had the text field filled in. I received this email from the company
    "I'm afraid that we have deprecated the Text API product and stopped taking on new users over 12 months ago. So unfortunately we can't help unless you are looking to use or subscribe to the News API, our core product. 
    You can sign up for 14 day free trial access here: https://newsapi.aylien.com/signup"

Answers

  • wclasterwclaster Member, University Professor Posts: 43 University Professor
    Note, I manually typed in the name of the connection in the aylien connection field. Here is the log info:
    Feb 26, 2021 1:50:42 PM SEVERE: Process failed: operator cannot be executed. Check the log messages...

    Feb 26, 2021 1:50:42 PM SEVERE: Here: 

    Feb 26, 2021 1:50:42 PM SEVERE:           Process[1] (Process)

    Feb 26, 2021 1:50:42 PM SEVERE:            subprocess 'Main Process'

    Feb 26, 2021 1:50:42 PM SEVERE:              +- Read Excel[1] (Read Excel)

    Feb 26, 2021 1:50:42 PM SEVERE:        ==>   +- Extract Sentiment[1] (Extract Sentiment)

    Feb 26, 2021 1:50:42 PM SEVERE: java.lang.NullPointerException

  • wclasterwclaster Member, University Professor Posts: 43 University Professor

    This is the process
  • wclasterwclaster Member, University Professor Posts: 43 University Professor
    And here is the process
    <?xml version="1.0" encoding="UTF-8"?><process version="9.8.001">
      <context>
        <input/>
        <output/>
        <macros/>
      </context>
      <operator activated="true" class="process" compatibility="9.8.001" expanded="true" name="Process">
        <parameter key="logverbosity" value="init"/>
        <parameter key="random_seed" value="2001"/>
        <parameter key="send_mail" value="never"/>
        <parameter key="notification_email" value=""/>
        <parameter key="process_duration_for_mail" value="30"/>
        <parameter key="encoding" value="SYSTEM"/>
        <process expanded="true">
          <operator activated="true" class="read_excel" compatibility="9.8.001" expanded="true" height="68" name="Read Excel" width="90" x="514" y="34">
            <parameter key="excel_file" value="C:/Users/willi/Documents/testTwit.xlsx"/>
            <parameter key="sheet_selection" value="sheet number"/>
            <parameter key="sheet_number" value="1"/>
            <parameter key="imported_cell_range" value="A1"/>
            <parameter key="encoding" value="SYSTEM"/>
            <parameter key="first_row_as_names" value="true"/>
            <list key="annotations"/>
            <parameter key="date_format" value=""/>
            <parameter key="time_zone" value="SYSTEM"/>
            <parameter key="locale" value="English (United States)"/>
            <parameter key="read_all_values_as_polynominal" value="false"/>
            <list key="data_set_meta_data_information"/>
            <parameter key="read_not_matching_values_as_missings" value="true"/>
            <parameter key="datamanagement" value="double_array"/>
            <parameter key="data_management" value="auto"/>
          </operator>
          <operator activated="true" class="operator_toolbox:extract_sentiment" compatibility="2.9.000" expanded="true" height="103" name="Extract Sentiment" width="90" x="648" y="34">
            <parameter key="model" value="aylien"/>
            <parameter key="text_attribute" value="Text"/>
            <parameter key="show_advanced_output" value="true"/>
            <parameter key="use_default_tokenization_regex" value="true"/>
            <list key="additional_words"/>
            <parameter key="aylien_connection" value="Ay"/>
          </operator>
          <connect from_op="Read Excel" from_port="output" to_op="Extract Sentiment" to_port="exa"/>
          <connect from_op="Extract Sentiment" from_port="exa" 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>

Sign In or Register to comment.