centrally storing and renaming user PST files

[edlcsre]

Hi there

Wonder if anyone can help, have had a look but didn't see this question in the forum i don't think.

I've been tasked with preparing our company's PST files ready for ingestion into a messaging system. The format of the file name is going to be interesting, but thats not my challenge for here. What We have is around 2000 user home drives, with PSTs located in various different locations within their sub folders, and with different names, depending on what they've called it.

I've managed to create a script which pulls out just the PST files into the existing folder structure, but what I now need is a way of renaming the files so that the file name is appended with the user's home drive folder at the start, and, in the case of more than one PST per user, the number is added to the end.

In this case, the PST information is in a folder called PSTTEST, and there is a sub directory for each user under there, with many sub directories under that, so i need to know how to set the rename to select the username for the folder name, and not the folder than the pst is located in, if that makes sense?

So, what I have at the moment is

c:\psttest\Aaaaaa\Outlook\archive.pst
c:\psttest\Aaaaaa\otherstuff\mail.pst
c:\psttest\bbbbbbb\mailbox.pst

etc etc

What i need is
c:\psttest\Aaaaaa\Outlook\aaaaaaa.pst.1
c:\psttest\Aaaaaa\otherstuff\aaaaaaa.pst.2
c:\psttest\bbbbbbb\bbbbbbb.pst.1


Does that make sense? Any ideas on how to achieve this?

Many thanks for any suggestions or ideas!

[Stefan]

First you have to decide if you want to add the parent folder name or the grand-parent one.
No program can guess what you have in mind, it only works the way you tell him.



If you want to rename with parent folder name

FROM:
c:\psttest\foo\archive.pst
c:\psttest\bar\mail.pst
c:\psttest\john\mailbox.pst

TO:
c:\psttest\foo\foo.pst
c:\psttest\bar\bar.pst
c:\psttest\john\john.pst

USE:
-- backup your files first!!!
-- File(2)[Remove]
-- Append Folder Name(9)[Prefix] Sep:[none] Levels:[ 1]

Rename.



- - -


If you want to rename with grand-parent folder name

FROM:
c:\psttest\foo\Outlook\archive.pst
c:\psttest\bar\otherstuff\mail.pst

TO:
c:\psttest\foo\Outlook\foo.pst
c:\psttest\bar\otherstuff\bar.pst

USE:
-- backup your files first!!!
-- File(2)[Remove]
-- Append Folder Name(9)[Prefix] Sep:[##] Levels:[ 2]

Do an first renaming
Result:
c:\psttest\foo\Outlook\foo##Outlook##.pst
c:\psttest\bar\otherstuff\bar##otherstuff##.pst


Now remove the parent folder name again with an second renaming:
USE:
-- Menu "Action > Reset All Criteria"
-- RegEx(1)
Match: (.+)##.+##
Repla: \1

Rename.
Result:
c:\psttest\foo\Outlook\foo.pst
c:\psttest\bar\otherstuff\bar.pst



.