Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

  • Hey again,

    I'm working on setting up a POP3 data source and I've been running into issues getting data out of the emails. To be honest, I'm not sure if the issue is with data source not being configured properly causing it to fail to connect with the account (I've tried both gmail and outlook accounts). Or if it is an issue with the way I've set up the datapoint causing it to not properly read the data in the emails.

    I wanted to start simple with something I knew worked so I was using the configuration and data in the thread linked below. But no luck.
    https://forum.mango-os.com/topic/3950/extracting-data-from-pop3-email?_=1608212175632

    The feedback from the system is:

    Datapoint: No values

    Runtime status: Shows the polls are being aborted with no return (which probably explains the lack of values for the data point)

    Current Alarms: displays a message saying: 'emailtest2': EOF on socket

    My data source and data point is set up like this:

    {
      "dataSources":[
        {
          "xid":"DS_b6a7f349-69da-40ca-a948-7722447aba3b",
          "name":"emailtest2",
          "enabled":true,
          "type":"POP3",
          "alarmLevels":{
            "INBOX_EXCEPTION":"URGENT",
            "MESSAGE_READ_EXCEPTION":"URGENT",
            "POLL_ABORTED":"URGENT",
            "PARSE_EXCEPTION":"URGENT"
          },
          "purgeType":"YEARS",
          "updatePeriods":1,
          "updatePeriodType":"MINUTES",
          "password":"*******",//Hidden
          "pop3Server":"outlook.office365.com",
          "port":995,
          "username":"*******@outlook.com",//hidden
          "quantize":false,
          "useCron":false,
          "editPermission":"",
          "purgeOverride":false,
          "purgePeriod":1
        }
      ],
      "dataPoints":[
        {
          "xid":"DP_ea9dd5ff-10c0-4597-a895-205310281232",
          "name":"209",
          "enabled":true,
          "loggingType":"INTERVAL",
          "intervalLoggingPeriodType":"MINUTES",
          "intervalLoggingType":"INSTANT",
          "purgeType":"YEARS",
          "pointLocator":{
            "dataType":"NUMERIC",
            "findInSubject":false,
            "ignoreIfMissing":true,
            "timeFormat":"",
            "timeRegex":"",
            "useReceivedTime":true,
            "valueFormat":"#",
            "valueRegex":"209start (\\d+) end"
          },
          "eventDetectors":[
          ],
          "plotType":"SPLINE",
          "rollup":"NONE",
          "unit":"",
          "simplifyType":"NONE",
          "chartColour":"",
          "chartRenderer":{
            "type":"IMAGE",
            "timePeriodType":"DAYS",
            "numberOfPeriods":1
          },
          "dataSourceXid":"DS_b6a7f349-69da-40ca-a948-7722447aba3b",
          "defaultCacheSize":1,
          "deviceName":"emailtest2",
          "discardExtremeValues":false,
          "discardHighLimit":1.7976931348623157E308,
          "discardLowLimit":-1.7976931348623157E308,
          "intervalLoggingPeriod":1,
          "intervalLoggingSampleWindowSize":0,
          "overrideIntervalLoggingSamples":false,
          "preventSetExtremeValues":false,
          "purgeOverride":false,
          "purgePeriod":1,
          "readPermission":"",
          "setExtremeHighLimit":1.7976931348623157E308,
          "setExtremeLowLimit":-1.7976931348623157E308,
          "setPermission":"",
          "tags":{
          },
          "textRenderer":{
            "type":"ANALOG",
            "useUnitAsSuffix":false,
            "suffix":"",
            "format":"0.00"
          },
          "tolerance":0.0
        }
      ]
    }
    

    The email in my inbox is set up as follows:
    Screen Shot 2020-12-17 at 11.57.28 AM.png

    My goal here is to return the value in the email and set them as values for the datapoint. Any help here would be much appreciated.

    Thanks

    Gord


  • I don't know about version 4, but I use one and it only supports non ssl server connections.
    I set up a local mail server which receives only and got mango to parse the emails sent to it.

    Fox


  • Ahh! That make sense. Thanks @MattFox !