Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

Use CSV File in EVPM Script

Updated: 21 May 2010 | 5 comments
karthik.srikumar@hawaiianair.com's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

Hi,

How can i run the EVPm Script to create folders taking the mailbox names (CN)  from aCSV File which i have created that has all the Mailbox entries

Discussion Filed Under:

Comments

MichelZ's picture
20
Jun
2009
3 Votes +3
Login to vote

Hi You could use VBScript for

Hi

You could use VBScript for this (not tested):

--------------------------------------------------------------
Const ForReading = 1
Const ForWriting = 2
Const OpenAsUnicode = -1
Const OverwriteIfExist = -1

Dim objFSO
Dim objShell, evpm

evpm = "c:\program files\enterprise vault\evpm.exe"
Set objFSO = CreateObject("Scripting.FileSystemObject")

Set objInputFile = objFSO.OpenTextFile("C:\temp\test.txt", ForReading)
Do Until objInputFile.AtEndOfStream
Set objOutputFile = objFSO.CreateTextFile("C:\temp\evpm.ini", OverwriteIfExist, OpenAsUnicode)
strLine = objInputFile.ReadLine

objOutputFile.WriteLine "[Directory]"
objOutputFile.WriteLine "directorycomputername = myserver"
objOutputFile.WriteLine "sitename = MattSite"
objOutputFile.WriteLine "[Filter]"
objOutputFile.WriteLine "name = filter1"
objOutputFile.WriteLine "CreateShortcut = true"
objOutputFile.WriteLine "DeleteOriginal = true"
objOutputFile.WriteLine "unreadMAIL = false"
objOutputFile.WriteLine "UseInactivityPeriod = true"
objOutputFile.WriteLine "InactivityUnits = months"
objOutputFile.WriteLine "InactivityPeriod = 1"
objOutputFile.WriteLine "[Mailbox]"
objOutputFile.WriteLine "distinguishedname = " & strLine
objOutputFile.WriteLine "[Folder]"
objOutputFile.WriteLine "name = \personal archive"
objOutputFile.WriteLine "filtername = filter1"
objOutputFile.WriteLine "retentioncategory = personal"

set objShell = wscript.createObject("wscript.shell")

strExec = evpm & " -e <exchange> -m <alias> -f c:\temp\evpm.ini"

objShell.Run strExec

objOutputFile.Close

Loop

objInputFile.Close
--------------------------------------------------------------

Make sure you change the bold lines as well as the whole EVPM script to suit your needs.

Alternatively, maybe you could use an LDAPQuery to get what you want?
Like all users which are in a special Windows Group?

Cheers

www.quadrotech-it.com - All your EV Tools

Wayne Humphrey's picture
20
Jun
2009
0 Votes 0
Login to vote

I have got a script that does

I have got a script that does just this some-ware, I will dig it up for you....

www.quadrotech-it.com - All your EV Tools

AndrewB's picture
22
Jun
2009
0 Votes 0
Login to vote

Sounds like something worth

Sounds like something worth posting in the downloads section!

Andy Becker | Authorized Symantec Consultant | Trace3 | Symantec National Partner | www.trace3.com

MichelZ's picture
22
Jun
2009
0 Votes 0
Login to vote

That would give me too much

That would give me too much points.
I'm shy... ;) :)

www.quadrotech-it.com - All your EV Tools

Scanner001's picture
22
Jun
2009
0 Votes 0
Login to vote

 I think you should write an

 I think you should write an article about it as it does provide a complete solution to a technical problem

Liam Finn