Sage 100

 View Only
  • 1.  Paperless office Move Utility Advanced to Premium..

    Posted 07-29-2022 20:05
    Hi All,
       I am doing a platform change for a client.  They have 17 modifications so I am not at all anxious to remigrate the system files.  I have the Utility to Move Paperless Fles,  It does seem to presume Providex files.  Is there a way to get the Providex files into SQL?   Generally utilities like this have to be specific for SQL   

    Keeping my fingers crossed and thanks in advance for any info on this.

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------


  • 2.  RE: Paperless office Move Utility Advanced to Premium..

    Posted 07-29-2022 20:54
    Bob, 

    You can use the PL_Logmerge routine for PVX to SQL.  Just place the PL_JournalPDFLogold.M4T in the MAS_System folder and it will merge the old file into the SQL table.   Also if you need the other logs, I have a specific  LogMerge  routine for each (i.e.  PeriodEnd and Reports ) 

    Let me know

    Here is a link to the programs     https://community.90minds.com/viewdocument/moving-paperless-docs-to-new-server?CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=librarydocuments

    (I am around if you need help)

    ------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ------------------------------



  • 3.  RE: Paperless office Move Utility Advanced to Premium..

    Posted 07-29-2022 21:03
    Hi Jim,
      Thanks so much!   Great to know and wonderful programming!

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------



  • 4.  RE: Paperless office Move Utility Advanced to Premium..

    Posted 07-30-2022 12:54

    HI Jim,

      I followed the steps.  I put the two files (PL_LOGMERGE & PDFLogConvertDirectoryV2) in the SOA folder.  I copied the Pl_JournalLogPdf.M4T to the MAS_System (they don't PDF Period End or Reports).   I ran syzcon & typed in RUN "PL_MERGELOG" and I get an error #12 File does not exist.   I reextracted the files and put them in place again, I checked security on the SOA folder, I pasted the file name into syzcon (to be 100% sure I was not typing it incorrectly) all with no luck.     Any thoughts on what I am missing?

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378    f 714.282.0235  Direct 714.439.9467

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     






  • 5.  RE: Paperless office Move Utility Advanced to Premium..

    Posted 07-30-2022 13:10
    you need it Add the word old to the end of the file name . Look at my original reply.

    ---------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ---------------------------------





  • 6.  RE: Paperless office Move Utility Advanced to Premium..

    Posted 07-30-2022 13:15

    Hi Jim

      Sorry, Ya just figured that out.  Glossed over as I thought it was a backup step.   Thanks much! 

     

    Thank you,

     

    Bob Osborn

    ACI Consulting

    p 714.282.0378    f 714.282.0235  Direct 714.439.9467

     

    Bob@ACIconsulting.com

     

     ACISignature1                  

    This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

     






  • 7.  RE: Paperless office Move Utility Advanced to Premium..

    Posted 07-30-2022 15:58
    Glad you got it to work!! :).

    ---------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ---------------------------------





  • 8.  RE: Paperless office Move Utility Advanced to Premium..

    Posted 08-03-2022 13:50
    HI Jim,
       Quick question on the move utility.  Does it add to or replace the Pl_JournalLogPdf.M4T table?   My client is saying some things are missing and wondering if I can add them (if I can find them) with the utility.

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------



  • 9.  RE: Paperless office Move Utility Advanced to Premium..

    Posted 08-03-2022 14:10
    The utility merges the files together. Did the company numbers change? This file is linked with the company number not the 3 letter code. You might need to a change and replace. Open the file in DFDM and figure if it is out there.

    ---------------------------------
    Jim Woodhead
    DSD Business Systems
    619-990-3946
    ---------------------------------