When attempting to copy an item using Excel, Sharegate displays the following error message:
The requested file '<filename>' is not valid. Its destination path refers to a different file type than its source counterpart.
|Any error code ending with: -250|
The error occurs because the Excel file contains a type mismatch between the source and destination paths. During an Excel copy, the paths for a folder must contain a trailing slash at the end. This error indicates that the either the source or destination path refers to a folder while the other refers to a file.
A path for a folder should have the following format "MyFolder/" while a path for an item or a file should look like "MyFolder/MyFile.txt".
- If the source item is a folder, make sure that the destination path ends with a slash (/).
- If the source item is an item or a file, make sure that the destination path does not end with a slash (/).