When defining hierarchical structures, I personally prefer using an XML file, but there is still a place for the good old Comma-separated values (CSV) format. Firstly, it is easier to create and modify a CSV file – especially when using an application like Excel – and as the format has been around for a while, most people find it easier to read and understand. Despite its flaws, this must be the major reason why Microsoft decided to use CSV as the format for the Managed Metadata import file in SharePoint 2010.
Now we have the New-SPWeb PowerShell cmdlet introduced in SharePoint 2010, creating individual sites and sub-sites is easy enough to do without needing to visit the browser UI, but you still need to put in a bit of work if you are looking to create an entire site hierarchy using PowerShell.
To help you out, I have uploaded a “Create SharePoint Sites from CSV” PS1 script file to Codeplex for download. This script can be used to create multiple SharePoint sites in bulk from a CSV file and also set permissions on each site during creation.
It includes the following features:
- Choose any site from which to start creating sub-sites
- Create a full site hierarchy with sub-sites down to three levels from the start site
- Specify a site title, description, and URL name
- Specify whether to inherit parent site top navigation bar
- Specify whether to inherit parent site permissions
- If breaking permission inheritance, specify whether to add new permissions from scratch or by copying over permissions from the parent site and adding to those
- Assign site permissions to SharePoint groups, Active Directory users or Active Directory groups, specifying the permission level required
- Create the specified SharePoint group or Active Directory account in the site, if they do not already exist
You can download the script, documentation and an example CSV file at http://spcreatesitesfromcsv.codeplex.com. As always, I welcome any comments, suggestions, ideas or contributions for any new features if you have them.
Hi,
ReplyDeleteIs it possible to creates sites with powershell based on a csv file and custom site templates that are stored in the Solution gallery?.
Hi - you will need to use the script I refer to above in combination with this script from darko - http://mkdot.net/blogs/darko/archive/2011/02/17/create-web-from-custom-template-in-sharepoint-2010.aspx
ReplyDeletePhil - Love the site. I'm using the script above to create a large number of sites. When the script gets to the permissions area it errors out anytime I attempt to add a new SPGroup (doesn't exist / create new). If I add a SPGroup that exist it does great. What do I need to look at?
ReplyDeleteThank you!
Hi, you could try adding the group to the site collection first as part of the script: http://get-spscripts.com/2011/02/add-sharepoint-or-ad-groupuser-to-all.html
ReplyDeleteHi Phil,
ReplyDeleteIt is a great post. I'm having a problem when I'm using custom Site Template. Is there any way to use custom Site Template?
Thanks
Volmiro
Hi Volmiro, I have already answered this question above....
DeletePhil,
DeleteMy mistake, I think I checked the site before and I have just skipped because there are so many things on the site. :( I'm looking for it now. Thank You
Again, it is a great post, and it is crucial to environment.
Thanks
Volmiro
Hi Phil
ReplyDeleteThanks for this great script! I did install the script and ran the commands per the instructions. However i get an error -> "The script has stopped because there has been an error". Any suggestions on what i am doing wrong ? Thanks!
Forgot to mention above that the site gets created but the error shows up while trying to create the groups. I am not inheriting permissions from the parent site and trying to create new groups. Under Site permissions of the site, i only see the system account with full control. No other groups get created
DeleteDoes anybody know if this works with SP2013?
ReplyDeleteI'm currently testing with SP2013, I had it working yesterday and managed to create ~20 sites each with 5 subsites, today it is refusing to do anything, getting error "The script has stopped because there has been an error" as soon as the script tries to run but I cannot determine why.
ReplyDeleteI found the reason - the instructions say to use "team site" as template name for -SiteTemplate, I found I had to use the corresponding code instead, for team site this is STS#0
ReplyDeleteTo find the codes for templates type:
Get-SPWebTemplate | Sort-Object "name"
in the Management Shell, this will list all codes for default templates.
2015-12-7 xiaozhengm
ReplyDeletefitflops clearance
michael kors uk
tory burch outlet
oakley sunglasses
nike outlet
louis vuitton outlet
louis vuitton pas cher
kate spade outlet
gucci outlet
coach outlet
michael kors outlet
canada goose uk
coach factory outlet
christian louboutin shoes
nike blazer
jordan 8s
michael kors handbags
jordan 3 infrared
caoch outlet
true religion outlet
air jordan uk
michael kors
longchamp outlet
adidas shoes uk
coach factory outlet
coach factory outlet
nike blazers
ugg australia
nike uk
coach factory outlet
tiffany and co
basketball shoes
michael kors outlet uk
louboutin
air jordans
chaussure louboutin
air jordan 13
ugg outlet
louis vuitton outlet
Great Article..
ReplyDeleteOnline DotNet Training
.Net Online Training
Dot Net Training in Chennai
Tiny Tanks is a popular game that all of you would like. In which you can play Tiny Planes, Run 3 Unblocked Run 4 Unblocked Hacked unblocked Games. Or you can go to play Tiny Planes Tiny Planes Beta
ReplyDeleteRun 3 Unblocked
Run 4 Unblocked
Run Unblocked
Car Racing Games
Super Mario Unblocked.
Donkey Kong Unblocked.
With football we always have exciting games such as head soccer and head soccer unblocked and soccer heads and head soccer 2 or big head basketball big head soccer or head soccer will bring to everyone the good entertainment Best.
ReplyDeletetrue religion jeans
ReplyDeletecoach outlet
true religion jeans
michael kors handbags
louis vuitton
christian louboutin flats
adidas ultra boost
insanity workout
coach outlet store online
toms outlet
rolex watches outlet
ghd hair straighteners
celine handbags
hollister clothing
cheap jordans
air jordan 13
ray ban sunglasses
coach outlet
nike air max 90
michael kors outlet
coach outlet
beats headphones wireless
coach factory outlet
coach outlet store online
cheap ray ban sunglasses
oakley sunglasses
cheap jerseys
coach outlet store online clearances
michael kors outlet clearance
cheap oakley sunglasses
louis vuitton outlet stores
ralph lauren polo
cheap jordans
burberry handbags
adidas yeezy
ray ban sunglasses
kate spade handbags
supra shoes
abercrombie and fitch
michael kors uk
20168.8wengdongdong
louis vuitton outlet stores
ReplyDeletecavaliers jerseys
michael kors outlet store
adidas yeezy 350 boost
abercrombie outlet
air jordan 6
uggs outlet
michael kors outlet
ugg on sale
ugg boots
20169.27chenjinyan
new balance shoes
ReplyDeletelouis vuitton
louis vuitton outlet
north face jackets
ysl outlet
prada sunglasses
lacoste pas cher
michael kors handbags
oakley sunglasses
michael kors clearance
chanyuan10.11
abercrombie and fitch
ReplyDeletecavaliers jerseys
coach outlet
coach handbags
uggs outlet
louis vuitton outlet
louis vuitton handbags
louis vuitton outlet
ralph lauren
ray ban pas cher
20173.9chenjinyan
swarovski crystal
ReplyDeleterolex watches
nike store uk
louis vuitton outlet
coach factory outlet
burberry outlet
rolex watches
oakley sunglasses
coach outlet online
cheap jordans
20170323lck
coach outlet online
ReplyDeletechristian louboutin pas cher
polo ralph lauren outlet
ralph lauren sale clearance uk
nfl jerseys cheap
michael kors outlet canada
pandora charms
fitflop shoes
coach outlet online
nfl jerseys wholesale
0324shizhong
adidas originals shoes
ReplyDeletechristian louboutin sale
nike roshe run
ray ban clubmaster
michael kors outlet clearance
ray ban wayfarer
michael kors handbags
nike air max 90
cheap nba jerseys
vans outlet
hzx20170415
adidas outlet
ReplyDeletenike air max
adidas yeezy boost 350 v2
polo ralph lauren outlet
michael kors bags
christian louboutin shoes
kd 7 shoes
adidas nmd xr1
prada handbags
oakley sunglasses
2017.5.15chenlixiang
coach outlet online
ReplyDeletecoach handbags outlet
prada sunglasses for women
nba jerseys wholesale
michael kors outlet online
mulberry outlet
louis vuitton handbags
oakley sunglasses
cheap football shirts
fitflops uk
chanyuan2017.06.08
Aurora HDR 2018 With Full Crack
ReplyDeleteCCleaner Crack
Microsoft Office 2016 Product Key
EaseUS Partition Master 12.8 Key
Avast Internet Security License Key
COREL DRAW X8 Keygen + Crack
you can dowmload here more and more..........
ReplyDeleteccleaner crack
CCleaner is the number-one tool for cleaning your Windows PC. It protects your privacy online and makes your computer faster and more secure....
Aurora HDR 2018 With Full Crack
Aurora HDR 2018 is a handy photography editor which has got some advanced tools for creating some stunning portraits as it relies on the innovative technology.
http://productkeypro.com/aurora-hdr-2018-crack-full/
camtasia-studio-9-1-crack
Camtasia Studio 9.1 Crack is a very famous and great effective display screen recording software that creates the video on-screen.
This information is very useful. thank you for sharing. and I will also share information about health through the website
ReplyDeletePenyebab Benjolan dileher seperti jakun
Pengobatan penyakit Meningioma
Pengobatan Alami Tuntaskan Keputihan
Obat Luka Bernanah bekas Caesar
Obat Alami Menurunkan tekanan Darah Tinggi
Obat Penyakit kulit Eksim
If you have a history of illness that is difficult to recover, maybe our next article will help you to recover
ReplyDeleteObat untuk Menghilangkan Psoriasis
Cara Mengatasi Batuk pada Ibu Hamil
Cara Merawat Luka Bakar
Obat untuk menghilangkan Bisul
Obat G-Sea Jelly Gamat
Great article! That is the kind of information that are
ReplyDeletemeant to be shared across the net. Disgrace on the seek engines for no longer positioning this post higher!
Come on over and seek advice from my website . Thank you =)
TeamSpeak 2018
ZipGenius 2018
Platform Update 2018
FotoSketcher 2018
Stick Wars (Hacked Version) 2018
NTLite Enterprise 1.5.0.5855 with Crack
his article is very helpful at all thanks
ReplyDeleteObat Penyakit Asam Urat
Obat Mata Juling
Obat Kanker Rahim
Cara Mengobati Sakit Pinggang
Cara Mengobati Benjolan Di Vagina
Pengobatan Alami Penyakit vertigo
Very nice article, thanks for sharing the information
ReplyDeleteObat Tradisional Gangguan Jantung
Obat Penyakit Kencing Manis
Obat Tumor Miom
Obat Osteoarthritis Tradisional
Obat TBC Anak
Obat Untuk Mengatasi ISPA
https://myserviceshome.com/company-cleaning-houses-in-riyadh/
ReplyDeletehttps://myserviceshome.com/isolating-surfaces-in-riyadh/
https://myserviceshome.com/leak-detection-company-in-riyadh/
https://myserviceshome.com/furniture-transport-in-medina/
https://myserviceshome.com/cleaning-houses-in-riyadh/
También puede visitar una tienda de ladrillo y mortero de Michael Kors o su sitio web y comprar directamente un bolso Michael Kors desde allí. Usar un bolso de Michael Kors les permite a los demás reconocer que el habitante urbano educado toma la moda realmente con seriedad. Los bolsos de hombro son particularmente refinados y elegantes.
ReplyDelete{Bolsas Michael Kors Precios | Bolsos Michael Kors Outlet | Michael Kors Rebajas}
En vacker konstnärlig skapelse av vävt läder, som ger ett skalskaligt utseende - liknar en snakeskin eller fiskhud, linjer utsidan av påsen. Läderens bältros är små läderringar. Det finns också gyllene accenter på väskan. Slutresultatet är svagt liknar kedjepost.
{Michael Kors Rea | Michael Kors Väska Rea | Michael Kors Plånbok}
20181018 xiaoou
ReplyDeletepandora charms
pandora jewelry outlet
christian louboutin sale
coach outlet
cheap jordan shoes
kate spade handbags
cheap ray ban sunglasses
ugg outlet online
coach outlet online
kate spade outlet online
The information you provide is very helpful and adds to my insight. Waiting for the next article, we always wait. If you wish, visit our site :
ReplyDeleteCara mengatasi keputihan bercampur darah
Obat darah tinggi ampuh
Cara menyembuhkan jantung bocor
Cara menyembuhkan jantung bocor pada orang dewasa
Cara menyembuhkan jantung bocor pada bayi
Cara menyembuhkan disentri
cheap nfl jerseys
ReplyDeletecheap jerseys
cheap jerseys from china
wholesale jerseys
cheap nfl jerseys from china
china jerseys
nfl jerseys china
wholesale nfl jerseys
cheap authentic nfl jerseys
cheap jerseys online
cheap authentic jerseys
cheap sports jerseys
cheap wholesale jerseys
china wholesale jerseys
discount nfl jerseys
cheap authentic jerseys from china
discount jerseys
custom cowboys jersey
nfl jerseys cheap
cheap nfl jerseys china
authentic nfl jerseys
I can only express a word of thanks. Because with the content on this blog I can add knowledge I, thank has been sharing this information. Do not forget to visit our website to share information and knowledge about health. |
ReplyDeletecara mengobati kelenjar getah bening |
obat pusing berkepanjanagn |
cara mengobati mata ikan |
DISTRIBUTOR QNC JELLY GAMAT |
obat oles penyakit dompo |
obat penyakit ispa
شركة اللمسة الأخيرة تقدم لك الحل الأمثل فلا حشرات بعد اليوم ولن تعود مرة أخرى. فنحن نستخدم أفضل المبيدات العالمية الفعالة صديقة البيئة التي لا تترك رائحة ولا سيوثر على صحة الأنسان ويقوم باستخدامها عمال مدربون يقومون برش المبيدات بشكل علمي مما يضمن لك الراحة التامة نرجو التواصل على هذا الرقم 0580002467
ReplyDeleteشركة رش مبيدات بأبها
شركة مكافحة حشرات بأبها
شركة مكافحة النمل الابيض بأبها
شركة رش مبيدات بخميس مشيط
شركة مكافحة حشرات بخميس مشيط
شركة مكافحة النمل الابيض بخميس مشيط
شركة رش مبيدات بالقصيم
شركة مكافحة حشرات بالقصيم
شركة مكافحة حشرات بجازان
شركة رش مبيدات بجازان
شركة اللمسة الأخيرة تقدم لك الحل الأمثل فلا حشرات بعد اليوم ولن تعود مرة أخرى. فنحن نستخدم أفضل المبيدات العالمية الفعالة صديقة البيئة التي لا تترك رائحة ولا سيوثر على صحة الأنسان ويقوم باستخدامها عمال مدربون يقومون برش المبيدات بشكل علمي مما يضمن لك الراحة التامة نرجو التواصل على هذا الرقم 0580002467
ReplyDeleteشركة رش مبيدات بأبها
شركة مكافحة حشرات بأبها
شركة مكافحة النمل الابيض بأبها
شركة رش مبيدات بخميس مشيط
شركة مكافحة حشرات بخميس مشيط
شركة مكافحة النمل الابيض بخميس مشيط
شركة رش مبيدات بالقصيم
شركة مكافحة حشرات بالقصيم
شركة مكافحة حشرات بجازان
شركة رش مبيدات بجازان
هناك العديد من المؤسسات التى تعتمد على أيدي عاملة ذات جنسية واحده إلا أن فى شركتنا لاغير متاح لدينا 4 انواع من الأيدي العاملة التى ترغب بها إلا أن كلهم ذو خبرة واحده ومدربون على نحو متساوى ويحترمون نُظم وقوانين المؤسسة .
ReplyDeleteشركة النجوم لخدمات التنظيف
شركة تنظيف فلل بالطائف
شركة تنظيف مجالس بالطائف
شركة نقل اثاث بالطائف
A beautiful purse or handbag from Coach Outlet Online can last for many years, and represent a great overall value.
ReplyDeleteThere are Michael Kors Bags Outlet in a large number of shopping malls located throughout the country.
Cheap Michael Kors Bags is a great way to determine which models best suit your needs.
Official Coach Factory Outlet Online all strive to provide comfort and convenience for their owners and the seams are double-stitched for maximum durability.
Michael Kors Factory Store, has one of the most popular handbag and accessory lines on the market today.
Coach Handbags Wholesale says a lady is classy, elegant and sophisticated.
Coach Store Near Me trends come and go, but a Coach stands the test of time.
The official Michael Kors Handbags On Sale Outlet regularly posts various handbags being offered for sale.
Compare your Coach Bags On Sale Outlet to the logo provided on the website to make sure it is similar.
All Michael Kors Outlet Online Store have serial numbers.
No matter what type of Michael Kors Bags Outlet each individual got, they all had one thing in common. We all know that getting something on sale is like winning a mini lottery, but to find a name brand handbag like Michael Kors Black Friday Sale for instance, discounted is like a slice of heaven on earth. I have personally attacked my husband with hugs and kisses when finding Official Coach Outlet Online at discounted prices.
ReplyDeleteMichael Kors Factory Outlet stores can be found in malls all over. MK Outlet and other Coach merchandise can also be found in some boutiques. Inspired by the same material baseball gloves are made from, these Coach Bags On Sale Online are versatile and stylish. Since it's conception, the Michael Kors Handbags Outlet has been produced into a variety of designs, colors, shapes, and styles that have won top pick of millions of women the world over.
New Michael Kors Bags are the most sought after handbag. Since Coach Outlet Online is one of the most recognized name brands in the world of fashion, you will find A-list celebrities down to small girls wearing them.
tags:Coach Outlet|Coach Bags Factory Outlet|Coach Purses Outlet
Thanks for provide great informatic and looking beautiful blog, really nice required information & the things i never imagined and i would request, wright more blog and blog post like that for us. Thanks you once agian
ReplyDeleteBirth certificate in delhi
Birth certificate in ghaziabad
Birth certificate in gurgaon
Birth certificate in noida
How to get birth certificate in ghaziabad
how to get birth certificate in delhi
birth certificate agent in delhi
how to download birth certificate
birth certificate in greater noida
birth certificate agent in delhi
Birth certificate delhi