Articles in this section

See more

Export and import Explorer connections in PowerShell

Updated

To share your Explorer connections you can use Export-Connections to export your connections, and a foreach loop to import them with PowerShell.

Index

Export Explorer connections

Copy and paste the following script in the PowerShell application of your choice.

Import-Module Sharegate
Export-Connections -Path "C:\ExportedConnections.csv"

Adjust the path to export the file to the location of your choice with the desired name and extension. You can save it as a .csv or .xlsx file.

Run your script once it's properly adjusted.

Import Explorer connections

Copy and paste the following script in the PowerShell application of your choice.

Import-Module Sharegate
$csvFile = "C:\ExportedConnections.csv"
$table = Import-Csv $csvFile
$myUsername = "myusername"
$myPassword = ConvertTo-SecureString 'mypassword' -AsPlainText -Force
foreach ($row in $table) {
     Connect-Site -Url $row.URL -Username $myUsername -Password $myPassword -AddToExplorer
}

Adjust your script to make it work for you. Here are a few guidelines:

  • $csvFile: Adjust the path so that it points to the CSV file you exported before.
  • $myUsername and $myPassword: Replace "myusername" and 'mypassword' with your SharePoint or Microsoft 365 credentials.
  • Connect-site: If you need to change the authentication method, you will find how to do it in the Connect Site article.
  • foreach: Loops the commands between the brackets for each row in your CSV file. In this case, it adds your connections to Explorer in ShareGate Migrate.

Run your script once it's properly adjusted and tested.

Related articles