Secure Copy 7.6.3 - User Guide

Creating a link map .ini file

Information in an .ini file is grouped by section headers, which are names that are enclosed in brackets such as [SectionName]. The section header defines what the section represents. The data to be updated is specified after the [SectionName]. Use the section header [LinkMap] in an .ini file used with the Link Updater.

The .ini file must be saved using ANSI encoding. The file can be edited with a text editor or a word processor that imports ASCII files.

The target path must include the folder in which the files now reside. For example, the .ini file content for remapping the location information for the OLE links in files might look as follows:

[LinkMap]

C:\Corporate\HR Docs = G:\Corporate\HR Docs\Excel

D:\Documents = G:\Documents

Example

You have a Microsoft Word file with links to different types of files in several different folders. You have created an .ini file that maps the old locations of the linked files to the new locations. The name of the.ini file is remap.ini and is located in C:\Migration.

LU "\\ServerA\Sales 2005\Company X RFP.doc" /F=C:\Migration\remap.ini

Running Link Updater from the command line

The Link Updater (LU.exe) is located in: C:\Program Files\Quest\Secure Copy 7\Tools.

You should only run the Link Updater during a time when users do not need to access files on the server or when it is possible for you to lock out all users and prevent them from accessing files on the server. You must run the LU.exe file from the Secure Copy server because of the licensing check the file performs.

Use the following syntax to run Link Updater from the command line and manually specify the paths to be updated:

LU FullFilePath SourcePath TargetPath [/r] [/t= n] [/c] [/z]

Table 26. Required Parameters

Table 27. Optional Parameters

Correct

LU *.doc C:\SourceFolder\ D:TargetFolder\

Incorrect

LU *.doc C:\SourceFolder\ D:TargetFolder

Since the incorrect example has \ after SourceFolder but not after TargetFolder, the Link Updater replaces C:\SourceFolder\ with D:\TargetFolder. So, in effect, the TargetFolder name is incorrect as a prefix to the updated file links. The Link Updater would determine that the target path does not exist and the files are not updated.

Example for specifying path information

You want to update the links for migrated Microsoft Word files located here: C:\Folder1.

The Word files have links to PowerPoint files that were previously located here: D:\Corporate\DivisionB. The PowerPoint files are now located here: D:\Corporate\HR\PP.

LU C:\Folder1\*.doc D:\Corporate\DivisionB D:\Corporate\HR\PP

Identifying all source paths

You can use the test report option to show all source paths. To do this, you enter \\ instead of specifying the source path.

The syntax to produce a test report that shows all source paths is as follows:

LU FullFilePath \\ TargetPath /t

Since you are running the Link Updater in test mode and no links are updated, you can enter a dummy path as the target path. For example, you could enter \\Test as the target path.

Using a .ini file from the command line

Use the following syntax to run Link Updater from the command line using an .ini file to specify the paths:

LU FullFilePath /F= INIFile [/r] [/t= n] [/c] [/z]

INIFile is the full path name for the .ini file that contains the update information about the source computer and the target computer for the linked files.

Link Updater for Access

Link Updater for Microsoft Access updates external table links to other Microsoft Access databases and Excel spreadsheets, and updates hyperlinks found in Access table records. This utility performs automatic backups of the Access database file.

To update external table links

1    Click Update Utilities, and click Link Updater for Access.

2    Open the Settings tab.

3    Type the path or browse to locate the Microsoft Access files that contain links you want to update.

4    Type the path or browse to locate the link map file that maps the old locations of linked files to the new locations.

5    Set options for the update.

Test Mode (no updates)
By default, the Link Update runs in test mode, which allows you to scan the path and see the updates without making changes to the file.

Enable Debug Logging
Select to see detailed level logging.

6    Open the Microsoft Access tab.

7    Set options for Microsoft Access.

Enable Microsoft Access Database Updates
Select to check Microsoft Access files for external table links and hyperlinks.

Update external table links
Select to check and update external table links. The current link types supported are links to other tables in external Microsoft Access files, and links to external Microsoft Excel spreadsheets.

Update Hyperlink fields in table records
Select to scan table records for hyperlink fields. This process may take some time if the table has many records.

Back up Access database file before updating
Select to create a backup copy of the .mdb or .accdb file made to the same location as the existing file. The file will have an extension of .BAK. The backup is made before scanning the Microsoft Access database file for changes. If no changes are made, the backup file is removed.

8    Open the Scan tab.

9    Click Scan. The Statistics area updates as the scan progresses.

10  To display the log file containing a summary of the actions performed, click View Log.