Issue with apostrophes in folder names when using Copy/Duplicate

[martinrkjl]

Hello @Barbarur

I have several folders in single document library I'm looking to duplicate from one site to another.

When running in report mode, no errors are logged/encountered, however, when running in action mode no files are copied and the report shows each file erroring with...

The system cannot find the file specified. (Exception from HRESULT: 0x80070002)

I've tried a few different folders and it appears if the source OR destination has a apostrophe in the folder name its omitted once NovaPoint starts the copying process, this is also seen in the logs as even though the source and destination are added with apostrophes, these are omitted later in the process

Have lifted some off the logs below

[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "Version: v0.14.4"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "Solution parameters"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "========== ========== =========="
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "ReportMode: True"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "IsMove: True"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "AddAdmin: True"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "RemoveAdmin: False"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "SourceSiteURL: https://mysite.sharepoint.com/sites/Jobs2001-2200Docs"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "SourceListTitle: Documents"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "AllItems: False"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "FolderSiteRelativeUrl: /Shared Documents/TEST/2025 St Paul's Services"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "DestinationSiteURL: https://mysite.sharepoint.com/sites/JobsSupersededDocs"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "DestinationListTitle: Documents"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "DestinationLibraryRelativeUrl: /TEST/2025 St Paul's Services"
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "========== ========== =========="
[2025/04/25 12:07:41] , [Info] , [0] , [LoggerSolution] , "Solution has started, please wait to the end"

.............

[2025/04/25 12:07:42] , [Info] , [0] , [CopyDuplicateFileAuto] , "Getting source library."
[2025/04/25 12:07:42] , [Info] , [0] , [CopyDuplicateFileAuto] , "Getting destination library."
[2025/04/25 12:07:42] , [Info] , [0] , [SPOFolderCSOM] , "Start getting Folder '/sites/JobsSupersededDocs/Shared Documents/TEST/2025 St Paul's Services' from 'https://mysite.sharepoint.com/sites/JobsSupersededDocs'"

............

[2025/04/25 12:08:15] , [Debug] , [0] , [CopyDuplicateFileAuto] , "Caching information for item (2019) '/sites/Jobs2001-2200Docs/Shared Documents/AEC/2025 St Paul's Services/7. Design/7.1 - Drawings/7.1.3 - Bid Stage'"

[2025/04/25 12:08:15] , [Debug] , [0] , [SqliteHandler] , "INSERT INTO RESTCopyMoveFileFolder (Depth,SiteUrl,SourceServerRelativeUrl,DestinationServerRelativeUrl) VALUES ('8','https://mysite.sharepoint.com/sites/Jobs2001-2200Docs','/sites/Jobs2001-2200Docs/Shared Documents/AEC/2025 St Pauls Services/7. Design/7.1 - Drawings/7.1.3 - Bid Stage','/sites/JobsSupersededDocs/Shared Documents/AEC/2025 St Pauls Services/7. Design/7.1 - Drawings/7.1.3 - Bid Stage')"

............

Once the CopyMoveFileFolder routine starts, any apostrophes in the source/destination folder are omitted, I've tried to enter the source/destination folder into Novapoint as an URL encoded format but this doesn't appear to work either.

2025 St Paul's Services = 2025%20St%20Paul%27s%20Services

Any assistance would be great :)

Martin

[Barbarur]

Hi @martinrkjl ,

The logs shared are useful, though those are for caching the data before start coping.

From the logs file, can you also share the full error, error trace and few of the logs before the error?

[Fantasillion]

Hi @Barbarur ,

I can reproduce this with folders. If you need more info, I'd be happy to provide. :)

I have a source library with a subfolder (with an apostrophe) containing files (also with an apostrophe) that gave me a processing error. The PowerShell CSOM part in the log lists the source and destination accurately with apostrophe so it doesn't look like it's PowerShell that produces the bug. Could it be because the apostrophe ' is not escaped properly in the sqlite table? I remember something about if you have 1 apostrophe then double it so that it is instead 2 apostrophes. If you already have 2 then double them and make them into 4 etc. Don't know if this helps at all.
Also, I tried renaming something that had an apostrophe and that has this bug and I added an additional apostrophe and then retried the CopyDuplicateFileAuto but it didn't work - both apostrophe's are still stripped the same as before.

I've sanitized the data from my log somewhat but kept the folder/filename with apostrophe in it so you can see where it disappears:

[2025-05-28 10:52:54] , [Debug] , [0] , [CopyDuplicateFileAuto] , "Caching information for item (125) '/sites/old_site/old_site_subsite/library/folder/Interne NDA'er'"
[2025-05-28 10:52:54] , [Debug] , [0] , [SqliteHandler] , "INSERT INTO RESTCopyMoveFileFolder (Depth,SiteUrl,SourceServerRelativeUrl,DestinationServerRelativeUrl) VALUES ('6','https://tenant.sharepoint.com/sites/old_site/old_site_subsite','/sites/old_site/old_site_subsite/library/folder/Interne NDAer','/sites/new_site/Shared Documents/General/folder/subfolder/Interne NDAer')"

Here's the visual indicator that there is something wrong - which is really helpful in finding out which files to check up on:

Also, a typo I noticed - Copying is missing the "y":
[2025-05-28 11:34:15] , [Info] , [0] , [CopyDuplicateFileAuto] , "Coping items..."

And a HUGE thanks for this tool! You've saved my day/week!

[martinrkjl]

Apologies @Barbarur - been away from my computer for a while, however @Fantasillion's post shows exactly the same issue I've been getting - either a source or destination folder with an apostrophe causes an error.

[martinrkjl]

Hi @Barbarur - any update on this issue ? we'd love to start using Novapoint to duplicate some large document libraries.

[Cyclone47]

I am experiencing the same issue with folders that contain a '
I assume it's an escaping issue.

Edit: I have created a pull request to fix it.

[Barbarur]

Thank you for the help @Cyclone47 .