POP3 e-mail data collection with attached CSV file

[JF89]

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.

cordially

[phildunlap]

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.

[JF89]

@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

[phildunlap]

@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)+)