Issue w/ Special Character in Source Folder

Feb 2 at 7:27 PM
Edited Feb 2 at 7:32 PM
Good day,

I tried to fix this, but I don't have access to the SPImporterHelp source so I am writing you here.

I have found that if the source folder has a "#" in the name and you have items inside that folder, the destination folder will be created in SharePoint without the # in the name but will not import the items that are within the source folder.

Exception importing : s:\sharepoint\$&#Test\newscommentt.txt : A file or folder with the name https://url/sites/sitename/Dev/Shared Documents/SharePoint/$& already exists.

I appreciate your help.
Feb 3 at 3:11 PM
The best solution to this problem;
  • Use FolderToData.ps1 to audit your files and folders to a CSV.
  • Load this to Excel
  • Change the destination folder names / paths to be acceptable.
  • Change the filenames to be acceptable.
  • Import folders and files from Excel source - See examples in the documentation
This approach is the best because you can;
  • Have full control over what is created in SharePoint.
  • Use Excel formula to automate
  • Leave source files intact
  • Work around limitations
If you are using SourceDataSetType FileSystemFiles illegal characters will be replaced as of DIFS 2.8