How to export Public Folders into a CSV file by using Powershell

Hello Guys,

I am totally new with PowerShell and I will need to understand which commands I can use to import and export to a CSV file into Exchange 2007 environment.
I used to do the same with Exchange 2003 only by clicking with the right-button on the Public Folders and then "Export List". Does any one have an idea how I would be able to proceed? Maybe if you guys could give me just an idea I will be able to do it.
Thanks, LaranjaCarioca
LaranjaCariocaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
BSonPoshConnect With a Mentor Commented:
If your wanting a specific Public folder you need to use the -id parameter.

How many public folders do you have?

I would step through the command (it doesnt change anything.)

PS> Get-PublicFolders
What did you get?

PS> Get-PublicFolders -recurse
Did you get more folders? Did you get the ones you wanted? To many?

Use "Get-Help Get-PublicFolders -full" for detailed help

0
 
BSonPoshCommented:
Get-PublicFoler | export-csv <your file> -NoType
0
 
BSonPoshCommented:
sorry

get-publicfolder not Get-publicfoler
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
BSonPoshCommented:
btw... if you want all you need to add the -recurse

Get-PublicFolder -Recurse | Export-Csv <CSV File> -noType
0
 
LaranjaCariocaAuthor Commented:
Sorry BSonPosh....what is -Recurse ?   if I want ALL, I did not get what you mean.
0
 
BSonPoshCommented:
-recurse means to process the entire tree (almost like a directory tree.)

If you do not use -recurse then it will only get one level of public folders
0
 
LaranjaCariocaAuthor Commented:
BSonPosh,

Really thanks for your help...do you think the following command would work?

Get-PublicFolder -Database server\storage group\public folder database -recurse | Export-Csv c:\PFcsvFile.csv
0
 
LaranjaCariocaAuthor Commented:
Hello BSonPosh,

As a matter of fact it is just an example. Soon I will need to work with this and I just wanted to make sure how to get the public folders on a specific public folder and then save it into a CSV file.
Probably it will be lots of folders and subfolders.
I read the -full help for this command and I think it would work. As soon I get back something from the production mode, I will let you know...THANKS!

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.