Shareoint Site Structure via Powershell and Excel

This topic contains 0 replies, has 1 voice, and was last updated by Profile photo of Forums Archives Forums Archives 5 years, 5 months ago.

  • Author
    Posts
  • #6409

    by bronyx85 at 2013-02-07 01:16:24

    Hi,

    Can someone advise on how I can create a site structure in SP13 ONLINE site structure using a Excel spreadsheet.

    i.e. my site structure is on the spreadsheet, so what I would like to do is tell powershell to look at the SpreadSheet and create the site collections, sites, lists and libraries which are on that spreadsheet.

    Is that possible?

    Thanks

    by DonJ at 2013-02-07 09:36:44

    Reading information from an XLS isn't impossible, but it can be pretty tricky. If you could export that to CSV, it becomes much easier – PowerShell has an Import-CSV command, and that'd let you get the data into the shell.


    $sites = Import-CSV sites.csv
    foreach ($site in $sites) {
    # refer to CSV columns like this: $site.name, $site.whatever, assuming
    # "name" and "whatever" are columns from the CSV
    }

    You can then use the data to run whatever commands you need to.

You must be logged in to reply to this topic.