Solved

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

Posted on 2008-06-16
8
5,970 Views
Last Modified: 2008-08-26
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
0
Comment
Question by:LaranjaCarioca
  • 5
  • 3
8 Comments
 
LVL 18

Expert Comment

by:BSonPosh
ID: 21795823
Get-PublicFoler | export-csv <your file> -NoType
0
 
LVL 18

Expert Comment

by:BSonPosh
ID: 21795827
sorry

get-publicfolder not Get-publicfoler
0
 
LVL 18

Expert Comment

by:BSonPosh
ID: 21795929
btw... if you want all you need to add the -recurse

Get-PublicFolder -Recurse | Export-Csv <CSV File> -noType
0
 

Author Comment

by:LaranjaCarioca
ID: 21796026
Sorry BSonPosh....what is -Recurse ?   if I want ALL, I did not get what you mean.
0
Can’t get the mobile email signature right?

Not having any luck when trying to create an email signature for mobile devices? Does the formatting keep messing up? Make sure you have great email signatures on all devices by using Exclaimer Cloud - Signatures for Office 365.

 
LVL 18

Expert Comment

by:BSonPosh
ID: 21796135
-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
 

Author Comment

by:LaranjaCarioca
ID: 21796240
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
 
LVL 18

Accepted Solution

by:
BSonPosh earned 250 total points
ID: 21796314
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
 

Author Comment

by:LaranjaCarioca
ID: 21796540
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
In this video we show how to create an Accepted Domain in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Ac…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now