Hi Janos, okay, i have tried with an mail from 22.8.2013.
in webui table, it shows date "2013.08.24" in webui mailview, it shows "Date: Thu, 22 Aug 2013 11:31:57 +0200" > > Hello Chris, > > On 2013-08-24 22:55, Christian Vielhauer wrote: >> i have exported all mails out of openbenno where they are stored as *.gz. >> so i have to export them with zcat filename > filename.eml >> but now all mail eml-files are from same date.... >> piler imports mails successfully, but now they are all listed of date >> 20.08.2013. >> Is there a way to import mails not by date of file, but rather on >> date tag in mail-header? > > Actually it should honor the Date: header. > > Please run the pilertest utility from the piler source dir, and check > what it says about an EML email. > pilertest 4000....eml gives the following information: ..... sent: 1377163917, delivered-date: 0 hdr len: 1611 body digest: d39d18af8e5b6b0f1cae7f0c3edc8e6d842389a84074c69f8e2923aa9e38504a rules check: (null) retention period: 1598380156 attachments: direction: 3 spam: 0 _________________________________ Timestamp 1377163917 == 22/08/2013 == Date of Header > Also connect to the piler database, and run the following: > > select id, sent, archived from metadata limit 10; I think you mean column arrived, not archived, because archived is not available mysql> select id, sent, archived from metadata limit 10; ERROR 1054 (42S22): Unknown column 'archived' in 'field list' mysql> select id, sent, arrived from metadata limit 10; +----+------------+------------+ | id | sent | arrived | +----+------------+------------+ | 1 | 1322122415 | 1377158448 | | 2 | 1323787445 | 1377158448 | | 3 | 1296133257 | 1377158448 | | 4 | 1361173764 | 1377158448 | | 5 | 1325859359 | 1377158450 | | 6 | 1305890031 | 1377158450 | | 7 | 1352987456 | 1377158450 | | 8 | 1248235864 | 1377158450 | | 9 | 1370009806 | 1377158450 | | 10 | 1355389487 | 1377158450 | +----+------------+------------+ 10 rows in set (0.00 sec) Timestamp 1377158448 == 22/08/2013 !!!!! Timestamp 1322122415 == 24/11/2011 !!!!! OR from same id as the .eml file: mysql> select id, sent, arrived from metadata where piler_id='40000000521906a80dbfb10400abf0ee5405'; +--------+------------+------------+ | id | sent | arrived | +--------+------------+------------+ | 276928 | 1377371806 | 1377371806 | +--------+------------+------------+ 1 row in set (0.00 sec) Timestamp 1377371806 == 24/08/2013 !!!!! but 22/08/2013 is read by pilertest > And finally please show me the full headers of such a mail with a wrong date > in the gui. > X-Original-To: [email protected] Delivered-To: [email protected] Received: from mail.ourdomain.com [10.27.1.22] by mailarchiv.ourdomain.com with IMAP (fetchmail-6.3.18) for <piler@localhost> (single-drop); Sat, 24 Aug 2013 21:16:46 +0200 (CEST) Received: by mail.ourdomain.com (Postfix, from userid 5001) id 2E6AE1950; Thu, 22 Aug 2013 11:31:59 +0200 (CEST) Received: from [10.27.5.10] (mail.ourdomain.com [10.27.1.22]) by mail.ourdomain.com (Postfix) with ESMTPSA id 8B4C0194D; Thu, 22 Aug 2013 11:31:58 +0200 (CEST) Received: from [10.27.5.10] ([10.27.5.10] helo=[10.27.5.10]) by ASSP.nospam with SMTPS(CAMELLIA256-SHA) (2.3.4); 22 Aug 2013 11:31:58 +0200 Message-ID: <[email protected]> Date: Thu, 22 Aug 2013 11:31:57 +0200 From: AL <[email protected]> User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Thunderbird/17.0 MIME-Version: 1.0 To: MW <[email protected]> CC: MS <[email protected]>, AS <[email protected]> Subject: Catia-Lizenzen References: <3926CD1E983C074FA14D90C5E6D20EFC4B809798@uniserv.otherdomain.local> In-Reply-To: <3926CD1E983C074FA14D90C5E6D20EFC4B809798@uniserv.otherdomain.local> Content-Type: multipart/alternative; boundary="------------050909050609060902060806" X-Assp-Version: 2.3.4(13233) on ASSP.nospam X-Assp-ID: ASSP.nospam m1-63918-04647 X-Assp-Session: 7FB7A50ECB20 (mail 1) X-Assp-Client-TLS: yes X-Assp-Server-TLS: yes X-Copyrighted-Material: Please visit http://www.ourdomain.com This is a multi-part message in MIME format. --------------050909050609060902060806 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Chris
