Sage 100

Moving Sage 100 2013 to 2016 and using the Library Master - Link Maintenance Utility with 10s of thousands of records of paperless office documents to be moved to a new server. I have copied all over through windows but the utility is taking forever to load the screen and bring up the relink button and the hum of the servers is putting me to sleep. No VI so I can't import the new path into the current records (if that is even possible).

@JimWoodhead

Importing isn't possible. But Wayne is right - Jim helped me out a while back with a script he designed.

Sane thing has happened to me. In order to confirm everything is working...I decided to do it by company and module...there the volume was smaller and quicker

I have narrowed to a single company but even the one company has 24K records. It is taking for-ev-er.

Gotta love SQL for that reason alone!

But they love their PR and JC.

In our Evernote, LM, Upgrades, Paperless, look at PDFlogconvert

Not sure how many companies you have but I took the same approach as @LourdesSobrino and that worked for me. The largest module I had was 15K.

That's how I've been doing it, too. I can't stand the waiting.

@LarryBradford I need the old location and the new location. I can create a quick script for you.

I thought Jim had a solution that was posted in Evernote???? PATH CHANGE UTILITY Sage offers a way to change paths when you move paperless from one server to another. However that can be very slow for large quantities of documents. Below is an alternative which will do a search and replace on the server name/directory. Much faster. Be sure you make a backup of everything the instructions say will change. Installation 1. Copy or Save as the program, PDFLogConvertDirectoryV2, to the /MAS90/UTILITY subfolder. Note: The following tables in the /MAS90/MAS_SYSTEM folder will be changed (MAKE A BACKUP): * PL_JOURNALPDFLOG.M4T * PL_PERIODENDPDFLOG.M4T * PL_REPORTPDFLOG.M4T The follow tables with be changed for the current company (MAKE A BACKUP): * AR_CustomerPDFLog (if A/R is activated for the current company code) * AP_VendorPDFLog (if A/P is activated for the current company code) * PR_EmployeePDFLog (if P/R is activated for the current company code) Steps to run this program: 1. Make a backup of the above files. 2. At the MAS 90/200 Launcher menu, click on File/Run 3. Type in SYZCON and click OK. This will pop up a command mode screen 4. At the -> prompt, type RUN ""../UTILITY/PDFLogConvertDirectoryV2 and press <ENTER>.........

He is using the using the above technique. the issue is with a LOT of records the Sage Path change is slow. I can create a script to change the path instead of using the Sage Path Change utility. My script will take minutes.

I am going to log in and get the old and new path in just a minute.

I was using the Library Master - Utilities option

yeah my script is MUCH faster.

Well, they are currently using about 10 paths and I am consolidating to one path. I also cannot get my VPN connection and MSTSC to work.

I just need the part that changes. I will likely use a Find and replace logic. So if it is the same structure with a different server name just document it.,, or I can change it to one path. up to you.

All records.

It needs to change to \\masvirtual\sage\paperless office\

let me know how it goes.

I have time now to wait for that magical script that you might be offering...

Never mind. I see Magic in my mailbox.