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

POP3 e-mail data collection with attached CSV file


  • Hello,

    I did not find any help in the documentation to be able to configure data points to retrieve by e-mail pop3.

    Is it possible to retrieve the following data in the CSV file attached to the email? And incorporate them into the Mango software ?
    The filename of the csv file is different each day. (D190805) for yesterday , and so on.

    0_1565110931411_pop_email.png
    cordially
    0_1565110944380_pop_email2.png


  • Hi JF89,

    I did not have the occasion to test, but I believe so. There is handling in the POP3 data source for "Multipart" emails, which all parts with content types in the "text/" family are appended to one another in the text processed by the points. Offhand I would expect "text/csv" to be the attachments MIME type, but as I said I have not attempted this. What are you seeing?

    I would not expect the filename of the CSV to be available in the content.


  • @phildunlap said in POP3 e-mail data collection with attached CSV file:

    I did not have the occasion to test, but I believe so. There is handling in the POP3 data source for "Multipart" emails, which all parts with content types in the "text/" family are appended to one another in the text processed by the points. Offhand I would expect "text/csv" to be the attachments MIME type, but as I said I have not attempted this. What are you seeing?
    I would not expect the filename of the CSV to be available in the content.

    Hello Phil,
    I do not see what these check options REGEX and time Regex are.
    It seems difficult to me to set the texts of the CSV file, which will be the identifiers to load the data.
    I have errors
    Without example, it seems to me difficult to reach on my own, to extract data
    Best regards

    0_1565127287277_email datapoint.png


  • @jf89 said in POP3 e-mail data collection with attached CSV file:

    I do not see what these check options REGEX and time Regex are.

    That will run the value regex over the "Test content" provided below. It will not attempt an email fetch and then run it on that.

    I would maybe encourage using a catch all regex for the first test, to see if it gets the CSV attachment in the text or not. Something like ((?:.|\r|\n)+)