<html><body><br/>Hi everyone, <br/><br/>i hope someone can help me. <br/><br/>There is one folder in a mailbox for user a<br/><br/>i need to export the following information about the mails in this folder<br/><br/>from, to, subject, date<br/><br/>is there a script for this? <br/><br/>doveadm dump shows me to much and i am not able to export those informations in a csv<br/><br/>if there is a way to use doveadm dump to export into a csv i would be happy<br/><br/>every mail is one file in this folder. <br/><br/>thanks in advance <br/><br/>Greetings <br/>Marcel <br/>--<br/>Diese Nachricht wurde von meinem Android Mobiltelefon mit <a href="http://WEB.DE">WEB.DE</a> Mail gesendet.</body></html>
<!doctype html> <html> <head> <meta charset="UTF-8"> </head> <body> <div> <br> </div> <blockquote type="cite"> <div> On 05/07/2020 18:07 Marcel Blenkers <marcel.blenkers@web.de> wrote: </div> <div> <br> </div> <div> <br> </div> <br>Hi everyone, <br> <br>i hope someone can help me. <br> <br>There is one folder in a mailbox for user a <br> <br>i need to export the following information about the mails in this folder <br> <br>from, to, subject, date <br> <br>is there a script for this? <br> <br>doveadm dump shows me to much and i am not able to export those informations in a csv <br> <br>if there is a way to use doveadm dump to export into a csv i would be happy <br> <br>every mail is one file in this folder. <br> <br>thanks in advance <br> <br>Greetings <br>Marcel <br>-- <br>Diese Nachricht wurde von meinem Android Mobiltelefon mit <a href="http://WEB.DE">WEB.DE</a> Mail gesendet. </blockquote> <div> <br> </div> <div class="default-style"> doveadm -ftab fetch -u user "hdr.from hdr.to date hdr.subject" mailbox FooBox | sed -e "s/\t/;/g" > result.csv </div> <div class="default-style"> <br> </div> <div class="default-style"> Might need bit of tuning </div> <div class="io-ox-signature"> <pre>--- Aki Tuomi</pre> </div> </body> </html>
On 05 Jul 2020, at 09:10, Aki Tuomi <aki.tuomi at open-xchange.com> wrote:> doveadm -ftab fetch -u user "hdr.from hdr.to date hdr.subject" mailbox FooBox | sed -e "s/\t/;/g" > result.csv > > Might need bit of tuninghdr.date. Other than that, seems to work fine. -- "Are you pondering what I'm pondering?" "I think so, Brain, but should we use dishwashing liquid or cooking oil?"