Link Maintenance painfully slow

Question

Every time I use Link Maintenance to relink paperless office files, this utility is super slow. 
 There has to be a better way to relink thousands of PDFs. I have also tried the "move" button in the paperless office viewers. It is also very slow. This is very frustrating. Does anyone have any ideas or workarounds for speeding up this process?

David Speck · Accepted Answer

Here is a utility I wrote to handle updating paperless office paths on Standard, Advanced and Premium editions. 
 After unzipping it, the .pvs extension should allow you to execute it on a system with the Sage 100 Workstation installed. You MUST extract both the .pvs and .pdf files to the same directory. 
 https://www.dropbox.com/sh/i1us3lop26h6s46/AACbRXWbS8I0rxDyo7zwDwnLa?dl=0 
 Below are my latest notes regarding this. The zip contains a ReadMe in .pdf format as well. 
 
 The utility can be launched by double clicking it via Windows Explorer as long as the Sage 100 Workstation has been installed or it can be "CALL"'ed via File > Run > SYZCON like the previous versions. 
 The utility will display the current MAS90 directory that it is working out of in the area seen in the image below. This directory is automatically set based on the last directory used to launch an instance of the Sage 100 workstation. This directory is updated even if you don&rsquo;t login, just launching sage 100 and canceling at the logon screen is sufficient to update the working directory. Do this if you need to toggle a specific instance, such as between the production install and a staging copy for testing. 
 
 When &ldquo;Scan Paths&rdquo; is clicked, the utility will scan tables per selected company as well as the system level tables and it will load UNIQUE, not ALL, paths as a result of the scan into the &ldquo;Search For&rdquo; column as well as write the output to a text file under MAS90\Home\Textout which it will open once complete. 
 The &ldquo;Company&rdquo; list box allows multiple companies to be selected by holding CTRL and LEFT CLICKING each company, although I recommend clicking the &ldquo;Select All&rdquo; button for production purposes, individual companies can be scanned for testing purposes. 
 Here is a list of tables scanned per company. 
 
 AP_VendorPDFLog 
 AR_CustomerPDFLog 
 PR_EmployeePDFLog 
 
 Here is a list of system tables scanned regardless of companies selected. 
 
 PL_JournalPDFLog 
 PL_PeriodEndPDFLog 
 PL_ReportPDFLog 
 PL_JournalRegister 
 PL_PeriodEndReport 
 PL_Report 
 PL_Form 
 
 Once the grid is loaded, it will be cleared if you make any changes to the selected companies by changing the selection in the list box, by clicking &ldquo;Select All&rdquo;, or by clicking &ldquo;Select None&rdquo;. 
 Here is a sample of the grid loaded with results. 
 
 You can optionally insert rows and delete rows if you want to change what you are searching for. The order the rows appear in are important as this is case sensitive so if you plan to have a hierarchy of replacements, make sure they are in the correct order. 
 You can also overwrite the contents of the &ldquo;Search For&rdquo; column. 
 Once you are ready to proceed, click the &ldquo;Proceed&rdquo; button. Once complete, it will display a message box with the total number of records read and the total number of records updated. You can click &ldquo;Scan Paths&rdquo; again to confirm the results of the previous attempt. 
 Given the above example, I could use the following to update rows 1 and 2 to the same path. 
 
 The utility will force all forwarded slashes (/) to be replaced with backward slashes (\) before any custom replacements occur. 
 I recommend including the backward slashes before and after the string you are searching for and replacing with when possible to reduce the chance of replacing a common string somewhere else within the path otherwise you can leave the full path in the &ldquo;Search For&rdquo; column and specify a full replacement path in the &ldquo;Replace With&rdquo; to be absolutely sure you are replacing the correct strings. 
 The utility will create backup copies of every file it processes that it updates by appending a date and time stamp to the file name as seen below.

David_Speck · Answer

I have updated the utility to address an issue on Standard/Advanced editions when using version 1.08 where it only updates a single record in each table each time it processes. The latest version is 1.09 and can be downloaded using the link in the previous post or this link below. 
 https://www.dropbox.com/sh/i1us3lop26h6s46/AACbRXWbS8I0rxDyo7zwDwnLa?dl=0

Sage 100

Link Maintenance painfully slow

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING