OK. Here is the solution I have developed for comparing the total contents of 2 sets of Pegasus mail folders, for instance all your current mail folders and a backup of them!
It's somewhat cumbersome, and I am not sure if it's perfect. Note, that I am comparing the total content of the 2 sets, NOT the content of individual folders, because I am not interested in looking at mails that have simply been moved from one folder to another.
You need:
PmailUnDup (the newest version I was able to find was v. 2.22 - on my own PC).
A text or document compare program like CSDiff (or MS-Word).
A spreadsheet like MS Excel Starter 2010. I tried OpenOffice 3.3 and 3.4, but there is an error in the import-text-files function that makes it very cumbersome, at least with Tab-separated fields.
The DOS commands 'copy' and 'sort'.
First you put the 2 sets of folders in 2 directories. We can call them dir-before and dir-after.
In each of these directories you do the following:
1. Use PmailUnDup to create Tab-separated text-file copies (or maybe CSV-files) of all folders (actually all PMI-files).
(You can use the statistics-function to see the total number of mail messages (and addresses) in the directory.
2. To merge all the text files into one, open the MS DOS command prompt and change the directory to where all these text files are stored. Now issue the command 'copy *.txt target.txt'
3. Import the text file in MS-Excel, but excluding the first 4 columns. Because they contain information that relates to the specific folder the message is from.
3B. Later it turned out that about 10% of all my mail messages had had there size in bytes (fsize - last column) incremented by 1, in the index-folders in the newest set. Very strange! And there were other Pegasus-peculiarities...! To minimize the problem I divided all values in the fsize-column by 10, in both sets, with this Excel formula: "=INT(F2/10)".
4. Save the file as a text-file.
5. Sort all lines (rows) of that text-file alphabetically with an MS-DOS-prompt-command looking more or less like the following:
Sort "target BEFORE fromCol5 fsizeDIV10.txt" /o "Sort output BEFORE.txt"
5B. Maybe you can do the sorting directly in Excel, before saving it, but the DOS-command is very fast.
Now you have 2 alphabetically sorted lists of all your mail from the 2 sets of folders. To compare them and see the differences I suggest you use the free program CSDiff. Choose Options! I suggest "Display line numbers", "Only show changed lines", and Show '1' unchanged line surrounding.
That's it!!
Best regards,
Henrik Rosenø
<p>OK. Here is the solution I have developed for comparing the total contents of 2 sets of Pegasus mail folders, for instance all your current mail folders and a backup of them! </p><p>It's somewhat cumbersome, and I am not sure if it's perfect. Note, that I am comparing the total content of the 2 sets, NOT the content of individual folders, because I am not interested in looking at mails that have simply been moved from one folder to another.
</p><p>You need: </p><p>PmailUnDup (the newest version I was able to find was v. 2.22 - on my own PC).</p><p>A text or document compare program like CSDiff (or MS-Word).</p><p>A spreadsheet like MS Excel Starter 2010. I tried OpenOffice 3.3 and 3.4, but there is an error in the import-text-files function that makes it very cumbersome, at least with Tab-separated fields.
</p><p>The DOS commands 'copy' and 'sort'.
</p><p>First you put the 2 sets of folders in 2 directories. We can call them dir-before and dir-after. </p><p>In each of these directories you do the following: </p><p>1. Use PmailUnDup to create Tab-separated text-file copies (or maybe CSV-files) of all folders (actually all PMI-files).
</p><p>(You can use the statistics-function to see the total number of mail messages (and addresses) in the directory.
</p><p>2. To merge all the text files into one, open the MS DOS command prompt and change the directory to where all these text files are stored. Now issue the command 'copy *.txt target.txt' </p><p>3. Import the text file in MS-Excel, but excluding the first 4 columns. Because they contain information that relates to the specific folder the message is from.</p><p>3B. Later it turned out that about 10% of all my mail messages had had there size in bytes (fsize - last column) incremented by 1, in the index-folders in the newest set. Very strange! And there were other Pegasus-peculiarities...! To minimize the problem I divided all values in the fsize-column by 10, in both sets, with this Excel formula: "=INT(F2/10)".
</p><p>4. Save the file as a text-file.</p><p>5. Sort all lines (rows) of that text-file alphabetically with an MS-DOS-prompt-command looking more or less like the following: </p><p>Sort "target BEFORE fromCol5 fsizeDIV10.txt" /o "Sort output BEFORE.txt"</p><p>5B. Maybe you can do the sorting directly in Excel, before saving it, but the DOS-command is very fast.
</p><p>Now you have 2 alphabetically sorted lists of all your mail from the 2 sets of folders. To compare them and see the differences I suggest you use the free program CSDiff. Choose Options! I suggest "Display line numbers", "Only show changed lines", and Show '1' unchanged line surrounding.
</p><p>That's it!!
</p><p>
Best regards,</p><p>Henrik Rosenø</p><p>
</p>