Vista - Can the copy-item cmdlet be used to copy public folders to C: ?

06-04-2008

Copying public folders via Outlook has a limitation on the number of
items/emails that can be copied at once. When you have a large number of
items, this makes copying very difficult to do manually. I'm hoping
Powershell can do this better.

1. Is the copy-item cmdlet usable with public folders?

2. Can the copy-item cmdlet be used to copy an Exchange public folder to the
regular file system (i.e. C:\ drive)?

3. If the copy-item cmdlet cannot do this, is there a different command in
Powershell that would be sufficient for this purpose?

Our Specs:
Exchange 2007
Windows 2003 x64 Edition

Thanks for any information and ideas,

Josh
SERA Architects

06-05-2008

I don't think you will be able to do this as the public folder is held within
an Exchange database which isn't exposed as a drive via a provider. I'm not
aware of anything in PowerShell that would do this for you

--
Richard Siddaway
All scripts are supplied "as is" and with no warranty
PowerShell MVP
Blog: http://richardsiddaway.spaces.live.com/
PowerShell User Group: http://www.get-psuguk.org.uk

"JoshGfromPortland" wrote:

Quote:

> Copying public folders via Outlook has a limitation on the number of
> items/emails that can be copied at once. When you have a large number of
> items, this makes copying very difficult to do manually. I'm hoping
> Powershell can do this better.
>
> 1. Is the copy-item cmdlet usable with public folders?
>
> 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the
> regular file system (i.e. C:\ drive)?
>
> 3. If the copy-item cmdlet cannot do this, is there a different command in
> Powershell that would be sufficient for this purpose?
>
> Our Specs:
> Exchange 2007
> Windows 2003 x64 Edition
>
> Thanks for any information and ideas,
>
> Josh
> SERA Architects

06-05-2008

RichS [MVP] wrote:

Quote:

> I don't think you will be able to do this as the public folder is held within
> an Exchange database which isn't exposed as a drive via a provider. I'm not
> aware of anything in PowerShell that would do this for you

Sounds like a great idea for a codeplex project though...

--
Author, Tech Prosaic blog (http://halr9000.com)
Webmaster, Psi (http://psi-im.org)
Community Director, PowerShellCommunity.org
Co-host, PowerScripting Podcast (http://powerscripting.net)

06-05-2008

JoshGfromPortland wrote:

Quote:

> Copying public folders via Outlook has a limitation on the number of
> items/emails that can be copied at once. When you have a large number of
> items, this makes copying very difficult to do manually. I'm hoping
> Powershell can do this better.
>
> 1. Is the copy-item cmdlet usable with public folders?
>
> 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the
> regular file system (i.e. C:\ drive)?
>
> 3. If the copy-item cmdlet cannot do this, is there a different command in
> Powershell that would be sufficient for this purpose?
>
> Our Specs:
> Exchange 2007
> Windows 2003 x64 Edition
>
> Thanks for any information and ideas,
>
> Josh
> SERA Architects

At first glance, I'm not able to see how to view a public folder, but if
you can see it in your Outlook client, then there's a good chance you
can use Outlook automation to get to the items:

http://blogs.msdn.com/jmanning/archi...utomation.aspx

Marco

--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com

06-05-2008

On Jun 4, 8:51 pm, JoshGfromPortland
<JoshGfromPortl...@xxxxxx> wrote:

Quote:

> Copying public folders via Outlook has a limitation on the number of
> items/emails that can be copied at once. When you have a large number of
> items, this makes copying very difficult to do manually. I'm hoping
> Powershell can do this better.
>
> 1. Is the copy-item cmdlet usable with public folders?
>
> 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the
> regular file system (i.e. C:\ drive)?
>
> 3. If the copy-item cmdlet cannot do this, is there a different command in
> Powershell that would be sufficient for this purpose?
>
> Our Specs:
> Exchange 2007
> Windows 2003 x64 Edition
>
> Thanks for any information and ideas,
>
> Josh
> SERA Architects

Hi Josh

If you have a sharepoint instance running somewhere, you can use:

http://www.codeplex.com/pfmigration/...ReleaseId=7674

....to put your public folders into a sharepoint site. You can then
copy them out of sharepoint to a local drive quite easily as all
sharepoint sites can be accessed via UNC syntax to expose the files
within (allowing you to do a drag and drop via explorer).

I can't offer you any help with this tool as I've never used it, but I
just remembered it from finding it in the process of looking for
something else ;-)

btw, if you don't have sharepoint anywhere, your Windows Server 2003
can add a local instance as a feature very easily (WSS 2.0).

Hope this helps,

- Oisin

06-07-2008

I think your best bet would be scripting outlook via COM. there might be
a dotnet interface to outlook as well. but searching for this against
powershell is probably going to be hard, so i'd search for scripting
outlook with vbscript or something and adapt.

JoshGfromPortland wrote:

Quote:

> Copying public folders via Outlook has a limitation on the number of
> items/emails that can be copied at once. When you have a large number of
> items, this makes copying very difficult to do manually. I'm hoping
> Powershell can do this better.
>
> 1. Is the copy-item cmdlet usable with public folders?
>
> 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the
> regular file system (i.e. C:\ drive)?
>
> 3. If the copy-item cmdlet cannot do this, is there a different command in
> Powershell that would be sufficient for this purpose?
>
> Our Specs:
> Exchange 2007
> Windows 2003 x64 Edition
>
> Thanks for any information and ideas,
>
> Josh
> SERA Architects

06-08-2008

Karl Prosser[MVP] wrote:

Quote:

> I think your best bet would be scripting outlook via COM. there might be
> a dotnet interface to outlook as well. but searching for this against
> powershell is probably going to be hard, so i'd search for scripting
> outlook with vbscript or something and adapt.

Yeah, there's a .NET interface to Outlook ("VSTO"?)... *But*, I'm pretty
sure it is just done via a wrapper for COM (tlbimp.exe?).

So just talk directly to COM from PowerShell...

Marco

--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com

06-09-2008

Thanks for the suggestion. That software utillity you recommended is able to
connect to our public folders. When I try to browse to a shared documents
folder on my Sharepoint server, or any other location on my Sharepoint
server, the scroll bar starts moving wildly and then the software utility
crashes without error.

I may be able to add a Sharepoint folder to Outlook and drag and drop from
the public folders perhaps.

I'm not familiar with accessing or using COM or COM via Powershell. I have
no background in using COM.

"Oisin (x0n) Grehan [MVP]" wrote:

Quote:

> On Jun 4, 8:51 pm, JoshGfromPortland
> <JoshGfromPortl...@xxxxxx> wrote:

Quote:

> > Copying public folders via Outlook has a limitation on the number of
> > items/emails that can be copied at once. When you have a large number of
> > items, this makes copying very difficult to do manually. I'm hoping
> > Powershell can do this better.
> >
> > 1. Is the copy-item cmdlet usable with public folders?
> >
> > 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the
> > regular file system (i.e. C:\ drive)?
> >
> > 3. If the copy-item cmdlet cannot do this, is there a different command in
> > Powershell that would be sufficient for this purpose?
> >
> > Our Specs:
> > Exchange 2007
> > Windows 2003 x64 Edition
> >
> > Thanks for any information and ideas,
> >
> > Josh
> > SERA Architects

>
> Hi Josh
>
> If you have a sharepoint instance running somewhere, you can use:
>
> http://www.codeplex.com/pfmigration/...ReleaseId=7674
>
> ....to put your public folders into a sharepoint site. You can then
> copy them out of sharepoint to a local drive quite easily as all
> sharepoint sites can be accessed via UNC syntax to expose the files
> within (allowing you to do a drag and drop via explorer).
>
> I can't offer you any help with this tool as I've never used it, but I
> just remembered it from finding it in the process of looking for
> something else ;-)
>
> btw, if you don't have sharepoint anywhere, your Windows Server 2003
> can add a local instance as a feature very easily (WSS 2.0).
>
> Hope this helps,
>
> - Oisin
>

06-09-2008

Quote:

> I'm not familiar with accessing or using COM or COM via Powershell. I have
> no background in using COM.

I'll give it another try tomorrow to see if I can show some working code.

I don't have access to Outlook right now...

Marco

06-04-2008	#1 (permalink)
JoshGfromPortland n/a posts	Can the copy-item cmdlet be used to copy public folders to C: ? Copying public folders via Outlook has a limitation on the number of items/emails that can be copied at once. When you have a large number of items, this makes copying very difficult to do manually. I'm hoping Powershell can do this better. 1. Is the copy-item cmdlet usable with public folders? 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the regular file system (i.e. C:\ drive)? 3. If the copy-item cmdlet cannot do this, is there a different command in Powershell that would be sufficient for this purpose? Our Specs: Exchange 2007 Windows 2003 x64 Edition Thanks for any information and ideas, Josh SERA Architects
My System Specs

06-05-2008	#2 (permalink)
RichS [MVP] n/a posts	RE: Can the copy-item cmdlet be used to copy public folders to C: ? I don't think you will be able to do this as the public folder is held within an Exchange database which isn't exposed as a drive via a provider. I'm not aware of anything in PowerShell that would do this for you -- Richard Siddaway All scripts are supplied "as is" and with no warranty PowerShell MVP Blog: http://richardsiddaway.spaces.live.com/ PowerShell User Group: http://www.get-psuguk.org.uk "JoshGfromPortland" wrote: Quote: > Copying public folders via Outlook has a limitation on the number of > items/emails that can be copied at once. When you have a large number of > items, this makes copying very difficult to do manually. I'm hoping > Powershell can do this better. > > 1. Is the copy-item cmdlet usable with public folders? > > 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the > regular file system (i.e. C:\ drive)? > > 3. If the copy-item cmdlet cannot do this, is there a different command in > Powershell that would be sufficient for this purpose? > > Our Specs: > Exchange 2007 > Windows 2003 x64 Edition > > Thanks for any information and ideas, > > Josh > SERA Architects
My System Specs

06-05-2008	#3 (permalink)
Hal Rottenberg n/a posts	Re: Can the copy-item cmdlet be used to copy public folders to C:? RichS [MVP] wrote: Quote: > I don't think you will be able to do this as the public folder is held within > an Exchange database which isn't exposed as a drive via a provider. I'm not > aware of anything in PowerShell that would do this for you Sounds like a great idea for a codeplex project though... -- Author, Tech Prosaic blog (http://halr9000.com) Webmaster, Psi (http://psi-im.org) Community Director, PowerShellCommunity.org Co-host, PowerScripting Podcast (http://powerscripting.net)
My System Specs

06-05-2008	#4 (permalink)
Marco Shaw [MVP] n/a posts	Re: Can the copy-item cmdlet be used to copy public folders to C:? JoshGfromPortland wrote: Quote: > Copying public folders via Outlook has a limitation on the number of > items/emails that can be copied at once. When you have a large number of > items, this makes copying very difficult to do manually. I'm hoping > Powershell can do this better. > > 1. Is the copy-item cmdlet usable with public folders? > > 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the > regular file system (i.e. C:\ drive)? > > 3. If the copy-item cmdlet cannot do this, is there a different command in > Powershell that would be sufficient for this purpose? > > Our Specs: > Exchange 2007 > Windows 2003 x64 Edition > > Thanks for any information and ideas, > > Josh > SERA Architects At first glance, I'm not able to see how to view a public folder, but if you can see it in your Outlook client, then there's a good chance you can use Outlook automation to get to the items: http://blogs.msdn.com/jmanning/archi...utomation.aspx Marco -- Microsoft MVP - Windows PowerShell http://www.microsoft.com/mvp PowerGadgets MVP http://www.powergadgets.com/mvp Blog: http://marcoshaw.blogspot.com
My System Specs

06-05-2008	#5 (permalink)
Oisin (x0n) Grehan [MVP] n/a posts	Re: Can the copy-item cmdlet be used to copy public folders to C: ? On Jun 4, 8:51 pm, JoshGfromPortland <JoshGfromPortl...@xxxxxx> wrote: Quote: > Copying public folders via Outlook has a limitation on the number of > items/emails that can be copied at once. When you have a large number of > items, this makes copying very difficult to do manually. I'm hoping > Powershell can do this better. > > 1. Is the copy-item cmdlet usable with public folders? > > 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the > regular file system (i.e. C:\ drive)? > > 3. If the copy-item cmdlet cannot do this, is there a different command in > Powershell that would be sufficient for this purpose? > > Our Specs: > Exchange 2007 > Windows 2003 x64 Edition > > Thanks for any information and ideas, > > Josh > SERA Architects Hi Josh If you have a sharepoint instance running somewhere, you can use: http://www.codeplex.com/pfmigration/...ReleaseId=7674 ....to put your public folders into a sharepoint site. You can then copy them out of sharepoint to a local drive quite easily as all sharepoint sites can be accessed via UNC syntax to expose the files within (allowing you to do a drag and drop via explorer). I can't offer you any help with this tool as I've never used it, but I just remembered it from finding it in the process of looking for something else ;-) btw, if you don't have sharepoint anywhere, your Windows Server 2003 can add a local instance as a feature very easily (WSS 2.0). Hope this helps, - Oisin
My System Specs

06-07-2008	#6 (permalink)
Karl Prosser[MVP] n/a posts	Re: Can the copy-item cmdlet be used to copy public folders to C:? I think your best bet would be scripting outlook via COM. there might be a dotnet interface to outlook as well. but searching for this against powershell is probably going to be hard, so i'd search for scripting outlook with vbscript or something and adapt. JoshGfromPortland wrote: Quote: > Copying public folders via Outlook has a limitation on the number of > items/emails that can be copied at once. When you have a large number of > items, this makes copying very difficult to do manually. I'm hoping > Powershell can do this better. > > 1. Is the copy-item cmdlet usable with public folders? > > 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the > regular file system (i.e. C:\ drive)? > > 3. If the copy-item cmdlet cannot do this, is there a different command in > Powershell that would be sufficient for this purpose? > > Our Specs: > Exchange 2007 > Windows 2003 x64 Edition > > Thanks for any information and ideas, > > Josh > SERA Architects
My System Specs

06-08-2008	#7 (permalink)
Marco Shaw [MVP] n/a posts	Re: Can the copy-item cmdlet be used to copy public folders to C:? Karl Prosser[MVP] wrote: Quote: > I think your best bet would be scripting outlook via COM. there might be > a dotnet interface to outlook as well. but searching for this against > powershell is probably going to be hard, so i'd search for scripting > outlook with vbscript or something and adapt. Yeah, there's a .NET interface to Outlook ("VSTO"?)... But, I'm pretty sure it is just done via a wrapper for COM (tlbimp.exe?). So just talk directly to COM from PowerShell... Marco -- Microsoft MVP - Windows PowerShell http://www.microsoft.com/mvp PowerGadgets MVP http://www.powergadgets.com/mvp Blog: http://marcoshaw.blogspot.com
My System Specs

06-09-2008	#8 (permalink)
JoshGfromPortland n/a posts	Re: Can the copy-item cmdlet be used to copy public folders to C: Thanks for the suggestion. That software utillity you recommended is able to connect to our public folders. When I try to browse to a shared documents folder on my Sharepoint server, or any other location on my Sharepoint server, the scroll bar starts moving wildly and then the software utility crashes without error. I may be able to add a Sharepoint folder to Outlook and drag and drop from the public folders perhaps. I'm not familiar with accessing or using COM or COM via Powershell. I have no background in using COM. "Oisin (x0n) Grehan [MVP]" wrote: Quote: > On Jun 4, 8:51 pm, JoshGfromPortland > <JoshGfromPortl...@xxxxxx> wrote: Quote: > > Copying public folders via Outlook has a limitation on the number of > > items/emails that can be copied at once. When you have a large number of > > items, this makes copying very difficult to do manually. I'm hoping > > Powershell can do this better. > > > > 1. Is the copy-item cmdlet usable with public folders? > > > > 2. Can the copy-item cmdlet be used to copy an Exchange public folder to the > > regular file system (i.e. C:\ drive)? > > > > 3. If the copy-item cmdlet cannot do this, is there a different command in > > Powershell that would be sufficient for this purpose? > > > > Our Specs: > > Exchange 2007 > > Windows 2003 x64 Edition > > > > Thanks for any information and ideas, > > > > Josh > > SERA Architects > > Hi Josh > > If you have a sharepoint instance running somewhere, you can use: > > http://www.codeplex.com/pfmigration/...ReleaseId=7674 > > ....to put your public folders into a sharepoint site. You can then > copy them out of sharepoint to a local drive quite easily as all > sharepoint sites can be accessed via UNC syntax to expose the files > within (allowing you to do a drag and drop via explorer). > > I can't offer you any help with this tool as I've never used it, but I > just remembered it from finding it in the process of looking for > something else ;-) > > btw, if you don't have sharepoint anywhere, your Windows Server 2003 > can add a local instance as a feature very easily (WSS 2.0). > > Hope this helps, > > - Oisin >
My System Specs

06-09-2008	#9 (permalink)
Marco Shaw [MVP] n/a posts	Re: Can the copy-item cmdlet be used to copy public folders to C: Quote: > I'm not familiar with accessing or using COM or COM via Powershell. I have > no background in using COM. I'll give it another try tomorrow to see if I can show some working code. I don't have access to Outlook right now... Marco
My System Specs

Similar Threads
Thread	Forum
Copy-Item : Container cannot be copied onto existing leaf item.	PowerShell
copy-item changing files attributes on network copy failures	PowerShell
copy-item down through folders	PowerShell
Getting Copy-Item to display messages (like the old COPY command in CMD.EXE) ??	PowerShell
Copy-Item or Copy-ItemProperty and Remote Registry.	PowerShell