How To - Check for File Not Found Error. Document Handling.

How to Check for File not found error.

This guide will explain how to identify the "File not Found" error when attempting to open a document. The error typically appears as shown in the screenshot below.

• When encountering such errors, the initial step is to check the specific folder to verify if the files are present. If the files exist, ensure they can be opened and are not corrupted. 
• If the files are not found in the mentioned folder, proceed to search for them in any other folders where they may have been saved.
• Upon locating the folder where the files are saved, the next step is to update the path in TM Master to ensure accessibility to the designated folder.
• To modify the path, please adhere to the steps outlined below.

1. Press and hold the Ctrl key on the keyboard. Simultaneously, right-click on the mouse to access the "Get Debug SQL" option. Refer to the screenshot below.

1. After clicking on "Get Debug SQL," paste the generated query into Notepad. The query will resemble the following:

Please note that the TMFileID will be different for each file.

1. Now, go to System > Import and export > SQL. Next, paste the SQL query we copied into the designated box. (Example: Select * From TmFile Where TmFileID = '2811a02f-46b5-4170-a617-a6e4f3f45b63'). Please refer to the screenshot below.

1. After clicking on the SQL -> XML button, you will be prompted to save the file. Provide a filename and save the file. Once you open the file, it will open in Notepad and resemble the screenshot below.

1. In the Notepad file, locate the <Name> tags. Update the current file path where the documents are stored. The format should be as follows:

<Name>LAM\ComponentJob\IMG_4002.JPG</Name>The first part represents the directory name, while the last part represents the file name with its extension. Update accordingly.

1. After updating the <Name> tags, save the file with the new name. Then, navigate to TM Master > System > Import and Export > Import tab. Click on "Import xml/v2z file". This will open the folder tab where you need to select the updated XML File that was saved after changing the <Name> tags.

1. Once you select the file, a pop-up will appear indicating that the XML has been successfully imported.

1. You can restart TM Master to ensure that the changes are applied, and the file should now open without errors.