Sage 100

Customer uses Memos to attach PDF's.  However, they have created ITEM #'s (for example) inside their folder directory. For example:

D:\Sage\Attachments\Inventory\123456
D:\Sage\Attachments\Inventory\789456
D:\Sage\Attachments\Inventory\326598 

Looking to move to a new server, new drive and share.  Is there a good utility to help with this?  I can move them if I go to each unique path, but that'll be quite painful.  I may challenge their strategy, but first I thought I'd see what the group has to offer. 

Sage 100 Advanced - version 2017.  Thanks! ​

------------------------------
John Wilder
Technology Integrators
------------------------------

You could use a bat file with folder * wildcards to move.

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Hi -

You can utilize xcopy from a command prompt or via batch file to do this.  

xcopy syntax goes like this:

xcopy {source}  {destination}  switches

The three switches I include here do the following:
/E    Copy Folders and subfolders even if they are empty
/H   Copy Hidden and system files (probably not needed for the context of what you are doing but just in case some are hidden)
/K    Copy file attributes (in case you have read only files etc)

Be sure to enclose your source and destination values in quotes to handle spaces in the directory names.

For these examples i'll assume you want to copy the contents of the Sage\Attachments\Inventory directory over to a new location on drive G.  That new location is G:\2019Sage\Attachments\Inventory.


For Command Prompt you would type:

xcopy "d:\SAGE\ATTACHMENTS\INVENTORY" "G:\2019SAGE\ATTACHMENTS\INVENTORY" /E /H /K



If you need to repeat the process occasionally you might want to put it in a Batch file.  Here would be the contents of the batch file:

echo on
cd\
xcopy "d:\SAGE\ATTACHMENTS\INVENTORY" "G:\2019SAGE\ATTACHMENTS\INVENTORY" /E /H /K



------------------------------
Marc Cregan
Technology Integrators
------------------------------

I think I would just pay Marc to do it for me.  Seems to be the simplest solution........

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 05-22-2019 21:54
From: Marc Cregan
Subject: MEMO Attachments - Server Move

Hi -

You can utilize xcopy from a command prompt or via batch file to do this.

xcopy syntax goes like this:

xcopy {source}  {destination}  switches

The three switches I include here do the following:
/E    Copy Folders and subfolders even if they are empty
/H   Copy Hidden and system files (probably not needed for the context of what you are doing but just in case some are hidden)
/K    Copy file attributes (in case you have read only files etc)

Be sure to enclose your source and destination values in quotes to handle spaces in the directory names.

For these examples i'll assume you want to copy the contents of the Sage\Attachments\Inventory directory over to a new location on drive G.  That new location is G:\2019Sage\Attachments\Inventory.


For Command Prompt you would type:

xcopy "d:\SAGE\ATTACHMENTS\INVENTORY" "G:\2019SAGE\ATTACHMENTS\INVENTORY" /E /H /K



If you need to repeat the process occasionally you might want to put it in a Batch file.  Here would be the contents of the batch file:

echo on
cd\
xcopy "d:\SAGE\ATTACHMENTS\INVENTORY" "G:\2019SAGE\ATTACHMENTS\INVENTORY" /E /H /K



------------------------------
Marc Cregan
Technology Integrators
------------------------------

I'd think the relinking in Sage would be the big hurdle, especially if the files are not in the same folder.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 05-23-2019 13:48
From: Jeff Schwenk
Subject: MEMO Attachments - Server Move

I think I would just pay Marc to do it for me.  Seems to be the simplest solution........

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 05-22-2019 21:54
From: Marc Cregan
Subject: MEMO Attachments - Server Move

Hi -

You can utilize xcopy from a command prompt or via batch file to do this.

xcopy syntax goes like this:

xcopy {source}  {destination}  switches

The three switches I include here do the following:
/E    Copy Folders and subfolders even if they are empty
/H   Copy Hidden and system files (probably not needed for the context of what you are doing but just in case some are hidden)
/K    Copy file attributes (in case you have read only files etc)

Be sure to enclose your source and destination values in quotes to handle spaces in the directory names.

For these examples i'll assume you want to copy the contents of the Sage\Attachments\Inventory directory over to a new location on drive G.  That new location is G:\2019Sage\Attachments\Inventory.


For Command Prompt you would type:

xcopy "d:\SAGE\ATTACHMENTS\INVENTORY" "G:\2019SAGE\ATTACHMENTS\INVENTORY" /E /H /K



If you need to repeat the process occasionally you might want to put it in a Batch file.  Here would be the contents of the batch file:

echo on
cd\
xcopy "d:\SAGE\ATTACHMENTS\INVENTORY" "G:\2019SAGE\ATTACHMENTS\INVENTORY" /E /H /K



------------------------------
Marc Cregan
Technology Integrators

Dump the file to Excel, do a replace to update the path, reinit the file and import back in?

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

Original Message:
Sent: 05-23-2019 13:51
From: Kevin Moyes
Subject: MEMO Attachments - Server Move

I'd think the relinking in Sage would be the big hurdle, especially if the files are not in the same folder.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 05-23-2019 13:48
From: Jeff Schwenk
Subject: MEMO Attachments - Server Move

I think I would just pay Marc to do it for me.  Seems to be the simplest solution........

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 05-22-2019 21:54
From: Marc Cregan
Subject: MEMO Attachments - Server Move

Hi -

You can utilize xcopy from a command prompt or via batch file to do this.

xcopy syntax goes like this:

xcopy {source}  {destination}  switches

The three switches I include here do the following:
/E    Copy Folders and subfolders even if they are empty
/H   Copy Hidden and system files (probably not needed for the context of what you are doing but just in case some are hidden)
/K    Copy file attributes (in case you have read only files etc)

Be sure to enclose your source and destination values in quotes to handle spaces in the directory names.

For these examples i'll assume you want to copy the contents of the Sage\Attachments\Inventory directory over to a new location on drive G.  That new location is G:\2019Sage\Attachments\Inventory.


For Command Prompt you would type:

xcopy "d:\SAGE\ATTACHMENTS\INVENTORY" "G:\2019SAGE\ATTACHMENTS\INVENTORY" /E /H /K



If you need to repeat the process occasionally you might want to put it in a Batch file.  Here would be the contents of the batch file:

echo on
cd\
xcopy "d:\SAGE\ATTACHMENTS\INVENTORY" "G:\2019SAGE\ATTACHMENTS\INVENTORY" /E /H /K



------------------------------
Marc Cregan
Technology Integrators

Fun!
This is how I would do it, after the move/migration::

1. Export from the AR_CustomerMemo file all memos with attachments to a spreadsheet.
2. Use a tool like Total Commander (https://www.ghisler.com/) to grab and move the files to the new server.  I would strongly suggest that they keep the attachments by type (Memos for customers - attachments should be under the AR<company> folder.  Then they will migrate with the next upgrade).  Items attachments should be in the IM<company> folder.
3. Update the spreadsheet by using search and replace the new path for the attachments.
4. Import into the AR_CustomerMemo file the updated paths.
5. Check for broken links using the Link Maintenance Utility (LM > Utilities > Link Maintanance).  Fix in the import file and reimport until no broken links show.
6. Repeat the above steps for inventory (IM_itemMemo)

------------------------------
Bob Sosbee
Senior Developer
Accounting Systems, Inc. (ASI)
Covina CA
803-252-6154 x245
------------------------------

Hello everyone, and thanks for the feedback.  So, sometimes the 'simplest solution' is the best.  We are simply going to move the shared folder to the new server, then dedicate the same S: drive (shared folder).  Problem solved.

------------------------------
John Wilder
Technology Integrators
------------------------------