Sage 100

 View Only
  • 1.  I have a client that recently consolidated 3 separ

    Posted 08-23-2018 20:49
    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?


  • 2.  RE: I have a client that recently consolidated 3 separ

    Posted 08-23-2018 21:08
    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.


  • 3.  RE: I have a client that recently consolidated 3 separ

    Posted 08-23-2018 21:14
    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.


  • 4.  RE: I have a client that recently consolidated 3 separ

    Posted 08-23-2018 21:20
    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


  • 5.  RE: I have a client that recently consolidated 3 separ

    Posted 08-23-2018 21:23
    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.


  • 6.  RE: I have a client that recently consolidated 3 separ

    Posted 08-23-2018 21:26
    sounds doable..


  • 7.  RE: I have a client that recently consolidated 3 separ

    Posted 08-24-2018 10:39
    Jim, seems like a useful utility when people have been running Paperless for many years and then change servers.


  • 8.  RE: I have a client that recently consolidated 3 separ

    Posted 08-24-2018 10:49
    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..


  • 9.  RE: I have a client that recently consolidated 3 separ

    Posted 09-12-2018 09:38
    @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.


  • 10.  RE: I have a client that recently consolidated 3 separ

    Posted 04-15-2020 14:16
    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
    ------------------------------