RE: Search Issues

2015-10-01 Thread Janos SUTO


On 2015-09-30 22:47, srisin...@meintl.com wrote:


Janos, we can do multiple searches if MailPiler can't handle a complex
search like we were attempting. (I don't know if other archivers can
do it, either, so don't think I'm slamming MailPiler!) We were able to
find the data we needed; it just seemed more difficult than it should
have been.


well, try the single query, start with the date, and see if the result
looks ok.


RE: eml file names... That is a good point. If you try to save
multiple emails from Outlook, for example, it prompts saying that it
already has a file saved with that name (after the first). So, even
Microsoft doesn't automatically handle it. Would it be possible to
export the emails by subject, appending a number based of sent time
(1,2,3, etc., oldest being 1, incrementing the number with newer
emails)?


ok, I'll add a hack the lets you do that. Would you open a feature
request on bitbucket? It's more likely to stay on my radar.


RE: Time & Date search...  Is this something that can't be done? Or
would this better be served as a feature request on BitBucket?


yes. Anyway even the year-month-day date trio has several possible
combinations, so I tried to optimise the routine for parsing it.

Adding hours and minutes is definitely possible just makes my job
parsing the date string more difficult.

Janos




Re: Search Issues

2015-09-30 Thread Janos SUTO


Hello Stephen,

On 2015-09-30 16:37, srisin...@meintl.com wrote:

We received a request to pull emails to-or-from three emails from a
certain date forward.

We tried several different search methods, and I used the Sphinx
advanced search criteria to come up with something like the following:

(from: ema...@domain.com| ema...@domain.com | ema...@domain.com)

When we ran this search, we seemed to get the proper amount of emails,
but no text appeared in the email results. If we released an email,
the email released correctly (text and images were present).

We were finally able to get the complete search results we needed, by
using the following search:

from: ema...@domain.com|ema...@domain.com|ema...@domain.com | to:
ema...@domain.com|ema...@domain.com|ema...@domain.com, date1:
2015-09-18

Is there a specific order that search terms need to be? Why did the
initial search not include the email text? Also, is it possible to


well, check the maillog if the parsed query looks OK. Anyway it might
be easier to do two search queries:

from: ema...@domain.com OR ema...@domain.com OR ema...@domain.com, 
date1: 2015-09-18


then another:

to: ema...@domain.com OR ema...@domain.com OR ema...@domain.com, date1: 
2015-09-18


If you insist on running a single query, then start with the date:

date1: 2015-09-18, (from: ema...@domain.com OR ema...@domain.com OR 
ema...@domain.com)

OR (to: ema...@domain.com OR ema...@domain.com OR ema...@domain.com)

Also check the maillog if the sphinx query is built properly.


change the *.eml filename to better reflect the email, perhaps using
the subject, for example?


might be possible, however how to deal with a message thread having 5 
messages

with the same subject, eg. Re: what was this?



I also can't figure out how to search for times. Adding time to a date
(-MM-DD hh:mm:ss) changes the search to incorrect results or gives
no results whatsoever. What gives? (aka, I feel like I'm doing this
wrong. Am I, or is this a bug in the search?)


well, the date parser handles year, month and day only. Don't specify 
anything else.


Btw. James is right with the highlighting, it was fixed recently in the 
master branch.


Janos



RE: Search Issues

2015-09-30 Thread srisinger
Thanks for the followup, guys!

James, I implemented what you talked about from Issue 601. I think that will 
definitely help!

Janos, we can do multiple searches if MailPiler can't handle a complex search 
like we were attempting. (I don't know if other archivers can do it, either, so 
don't think I'm slamming MailPiler!) We were able to find the data we needed; 
it just seemed more difficult than it should have been.

RE: eml file names... That is a good point. If you try to save multiple emails 
from Outlook, for example, it prompts saying that it already has a file saved 
with that name (after the first). So, even Microsoft doesn't automatically 
handle it. Would it be possible to export the emails by subject, appending a 
number based of sent time (1,2,3, etc., oldest being 1, incrementing the number 
with newer emails)?

RE: Time & Date search...  Is this something that can't be done? Or would this 
better be served as a feature request on BitBucket?

-- 
Regards,

Stephen R. Risinger .  Systems Administrator  .  srisin...@meintl.com
Meetings & Events International  |  www.meintl.com

-Original Message-
From: Janos SUTO [mailto:s...@acts.hu] 
Sent: Wednesday, September 30, 2015 2:28 PM

Hello Stephen,

well, check the maillog if the parsed query looks OK. Anyway it might be easier 
to do two search queries:

from: ema...@domain.com OR ema...@domain.com OR ema...@domain.com,
date1: 2015-09-18

then another:

to: ema...@domain.com OR ema...@domain.com OR ema...@domain.com, date1: 
2015-09-18

If you insist on running a single query, then start with the date:

date1: 2015-09-18, (from: ema...@domain.com OR ema...@domain.com OR
ema...@domain.com)
OR (to: ema...@domain.com OR ema...@domain.com OR ema...@domain.com)

Also check the maillog if the sphinx query is built properly.

> change the *.eml filename to better reflect the email, perhaps using 
> the subject, for example?

might be possible, however how to deal with a message thread having 5 messages 
with the same subject, eg. Re: what was this?


> I also can't figure out how to search for times. Adding time to a date
> (-MM-DD hh:mm:ss) changes the search to incorrect results or gives
> no results whatsoever. What gives? (aka, I feel like I'm doing this
> wrong. Am I, or is this a bug in the search?)

well, the date parser handles year, month and day only. Don't specify 
anything else.

Btw. James is right with the highlighting, it was fixed recently in the 
master branch.

Janos




Search Issues

2015-09-30 Thread srisinger
We received a request to pull emails to-or-from three emails from a certain 
date forward.

We tried several different search methods, and I used the Sphinx advanced 
search criteria to come up with something like the following:
(from: ema...@domain.com| ema...@domain.com | 
ema...@domain.com)
When we ran this search, we seemed to get the proper amount of emails, but no 
text appeared in the email results. If we released an email, the email released 
correctly (text and images were present).

We were finally able to get the complete search results we needed, by using the 
following search:
from: ema...@domain.com|ema...@domain.com|ema...@domain.com | to: 
ema...@domain.com|ema...@domain.com|ema...@domain.com, date1: 2015-09-18

Is there a specific order that search terms need to be? Why did the initial 
search not include the email text? Also, is it possible to change the *.eml 
filename to better reflect the email, perhaps using the subject, for example?

I also can't figure out how to search for times. Adding time to a date 
(-MM-DD hh:mm:ss) changes the search to incorrect results or gives no 
results whatsoever. What gives? (aka, I feel like I'm doing this wrong. Am I, 
or is this a bug in the search?)

Piler -V results: 1.2.0-master build 919

--
Regards,

Stephen R. Risinger *  Systems Administrator  *  
srisin...@meintl.com
Meetings & Events International  |  www.meintl.com



Re: Search Issues

2015-09-30 Thread James Macdonell
I ran into this bug too.  There is a regular expression in 
webui/model/search/message.php that needs tweaking.


https://bitbucket.org/jsuto/piler/issues/601

-  $terms = preg_replace("/(\'|\"|\=|\>|\<)/", "", $terms);
+  $terms = preg_replace("/[^\w\s]/", "", $terms);



On 09/30/2015 07:37 AM, srisin...@meintl.com wrote:


(from: ema...@domain.com| ema...@domain.com | ema...@domain.com 
)


When we ran this search, we seemed to get the proper amount of emails, 
but no text appeared in the email results.




--
James Macdonell
Information Security & Emerging Technologies
California State University, San Bernardino
5500 University Parkway
San Bernardino, CA 92407-2393
Main Line: 909/537-7262
http://its.csusb.edu/
PGP: 0xBE849E4B



smime.p7s
Description: S/MIME Cryptographic Signature