Sage 100

I have a client that recently consolidated 3 separate Sage 100 installations into a single 2018 Advanced install. They have a new server in one of the 3 locations and that server now hosts all the MAS_XXX databases from the other two remote locations. None of the 3 installations used paperless office, but all 3 have a huge number of scanned PDF check images associated with vendor memos. It's possible to use the relinking tool in the utilities menu to relink these PDFs to the new UNC path on the new server. They have thousands of PDFs which need to be relinked and this could take a really long time. I'm familiar with the PL_logmerge and PDFLogConvertDirectoryV2 utilities to relink paperless office PDFs, but these only work on the PL_......pdflog files. Does anyone know of a similar utility that could work on the AP_VendorMemo.M4T files?

I wrote a utility for Moira to do this. Is it a simple change and replace of the server name or is it more complicated. Let me know if you need help.

Yes, it's relatively simple, but unfortunately for some companies they've created individual folders for each vendor, meaning that the utility will need to be run on 1 file or maybe 5, that are in the same folder. In other cases all the PDFs for one company are in one folder and therefore in these cases there maybe 4 or 5 thousand PDFs that can be relinked all at once. The advantage of using a utility program would be to avoid the refresh loading that takes place when using the default sage relinking utility. That ""loading"" process can take 10 to 15 minutes each time. So in the case where 1 file has been relinked, you have to wait for the load to finish before you can start on the next relink. I hope I explained that clearly enough Jim.

Send me the details of the change and replace. I can create a utility for you. Email me jimw@dsdinc.com. Get Outlook<https://aka.ms/qtex0l> for iOSo

I will try to get a remote session with their IT guy tomorrow and get you a document with the UNC paths of at least the larger number PDF folders, source and new destination folders. Good night.

sounds doable..

Jim, seems like a useful utility when people have been running Paperless for many years and then change servers.

the PDFLogConvertDirectoryV2 works for most of the files but it didn't do the Memos links. I reworked the code to do the files individually but they are a hardcoded. but work great..

@JimWoodhead Hey Jim. I finally heard back from the client's IT on this issue. I'm going to forward you his email and you can let me know if you think it's feasible to hard code something for the utility.

Related to the Paperless 'PDFLogConvertDirectoryV2' Utility, is the only option for Memos still to do something custom like @Jim Woodhead did (above)?  Or is there something readily-available?

------------------------------
- Brett
------------------------------

Original Message:
Sent: 09-12-2018 09:38
From: John Kerr
Subject: I have a client that recently consolidated 3 separ

@JimWoodhead Hey Jim. I finally heard back from the client's IT on this issue. I'm going to forward you his email and you can let me know if you think it's feasible to hard code something for the utility.