Adding multiple SharePoint on premise or SharePoint Online sites becomes a tedious process past the first few entries. LinkFixer Advanced now has the ability to bulk import SharePoint sites or site collections via the "Import" feature under "Network Locations."


How to bulk import multiple SharePoint sites/site collections:

1. Go to the "hamburger" menu on the top left

2. Go to "Network Locations"


3. Under "Network Locations," both the "Import" and the "Export" options are available. 




4. You have the option of adding one or two SharePoint on premise and/or SharePoint Online sites/site collections, then the ability to export the mapped sites/site collections into a CSV file. 

  1.     Map a SharePoint site - How to add a new SharePoint site to LinkFixer Advanced
  2.    Click "Export" on the top mid-right hand corner of the Network Locations page.
  3.     Export the current SharePoint sites as a CSV file and store it somewhere accessible
  4.     Open the CSV file in MS Excel
  5.     Enter fields as necessary - Sample CSV Import list: 
    • Column A - Enabled: Value should be set to "True" if we want the site added or enabled, and "False" if otherwise.
    • Column B - Type: Should be set to "SharePoint" for SharePoint on-premise and SharePoint Online. Set to "OneDrive" if we're adding a OneDrive personal site.
    • Column C - Site Collection URL: Enter the SharePoint on-premise or SharePoint Online site collection URL.
      example: https://linktek.sharepoint.com/sites/testsite/
    • Column D - SharePoint Online: Should be set to "True" for SharePoint Online and "False" for SharePoint on-premise.
    • Column E - Authentication values:
      • WindowsIntegrated - when you have federated (single sign-on) SharePoint account and your computer is connected to your company's network. LinkFixer Advanced will contact your company's Active Directory Federation Services (ADFS) server to perform authentication. This authentication method only applies to SharePoint on-premises, not to SharePoint Online. 
      • UsernamePassword - when you have a managed (cloud) SharePoint Online account or your computer is not connected to your company's network. LinkFixer Advanced will use the credentials you provide to perform authentication.
      • Office365NoConsent - when you wish to sign in using your Office 365 login. Office 365 authentication supports features such as multi-factor authentication (MFA) and SAML-based third-party identity providers like Okta.
        Important: "Office365NoConsent" is not guaranteed to maintain file modification timestamps. If this is important to you, use "Office365" authentication.
      • Office365 - Is everything as "Office365NoConsent" plus the ability to restore the file modification timestamps, the "modified by" field, as well as support for links to be fixed in Document ID form, instead of a regular SharePoint Online URL. 
        Important: "Office365" requires that the Global Admin grant consent, just once, to be able to register LinkFixer Advanced as an enterprise application in Azure AD. The Global Admin's credentials are in no way stored or used for any other purposes, apart from granting consent.

     

  • Column F - Enter SharePoint or OneDrive account user name. 
    example: LinkFixer1@LinkTek.com
  • Column G - Enter password for account. Leave this field empty for except only when "UsernamePassword" is used for Column E. 
  • Column H - Set to "True" only when "UsernamePassword" is used for Column E. Set to "False" for all other authentication values.
  • Column I - Leave as is. This is the hash for the authentication, which is only available when an already authenticated account or set of accounts are exported to a CSV file. 


f.  Save and close the CSV SharePoint site/site collection list

g. Import the CSV file by clicking "Import"

h. Wait for all SharePoint sites to connect. 

    Note: For SharePoint Online sites/site collections using the "Office 365" or "Office 365 with admin consent" authentication, a SharePoint login dialog box will appear asking for the account password. 


5. How to add multiple SharePoint Online/OneDrive accounts to mitigate throttling.

Note: This only applies to SharePoint Online and OneDrive.


a. In the same CSV, add an extra row under the SharePoint Online/OneDrive site that we want to add an additional account to. 

b. Only fill out columns E, F, G, and H, leaving all the other fields empty. 

c. Add as many additional columns, following item 5.b, with each column with its own unique account.


For questions or inquiries, please send a support ticket, call +1-727-422-1822 or email support@LinkTek.com.


Related: How to Import multiple SharePoint Online IDs from a CSV file