Hi all,
I'm trying to import some patrons who purchased tickets from an outside ticket vendor. We have everything set up and the files are ready to go. When I run the Import utility in review I get the following error message: "The system cannot find the path specified. does not have a valid extension () and will be skipped."
I've tried everything the manual and forums has suggested, but can't get this to work. Any help would be really appreciated!
Thanks, Melissa
hi Melissa,
it sounds like you need to check the paths you entered in the Filepath and Format File columns in the TR_IMPORT_CONTRIBUTION_SET table. Have you made sure that the Filepath is a folder and the format file is a .xml?
I have the filepath saved as just the folder name: T:\Import and the format file saved as T:\Import_Format\OrderImportStanardFormat.xml. Does all that look correct? Or am I missing something?
Hi Melissa,
This bit from the tr_import_order_set documentation might help (this is for both the Filepath and the Format File)"The directory and corresponding files must be accessible to SQL Server and the pathname should be in UNC format (e.g.,\\myserver\myshare\order_imports\). Because the import is executed by SQL Server, the file path is interpreted from the point of view of the SQL Server, rather than the point of view of the user’s workstation. In order to use file paths with mapped drive letters (e.g., C:\My Files\order imports\), the drive letters must be mapped on the machine running SQL Server. "
So it sounds like at the very least you might need to find the full file path and use that instead of the mapped location.
Was this ever resolved? I am experiencing the exact same issue. My file paths are all correct as far as I can tell, but when I try to run the utility I get this error. "The file The system cannot find the file specified. does not have a valid extension () and will be skipped." My files are xml files, so I'm not sure what's wrong.
I had to have IT map the drive I was saving the files in to SQL server to get it to work. Once that was done, I was able to import the order information.