• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

Folder problems and data in wrong locations

Experts:

Below problem exists on Windows 2003 server.

See attached for folder structure.  At some point after about 9/1/2013, folder "Client Data" was inadvertantly copied, and made a subfolder of "Client Data".  From the time of the inadvertant copy to about a week ago, numerous scanned PDF's and "other" files (excel, word, etc) have been incorrectly put into the incorrect folders.  In addition, there were two users that "CORRECTLY" saved documents.  It should work:  Each file for a client should be stored in the correct year for each client.... and client ONLY exists under the root "Client Data" folder.  

Now, I have files that exist in the sub/sub folder of a client that are not in the correct location.  I also have files that have been saved to the "CORRECT" locations after 9/1/2013.  In addition, files prior to approx 9/1/2013 are duplicated in both places!

The illustration is minimalist....  We have approx 1500 clients, and each client will have approx 50-100 files each year.  We have identified specific instances of files in the wrong locations; however, it would be almost impossible to manually identify, and move files individually.


Question:  What is the most efficent way to move these files from the incorrect to correct folder....  I CANNOT just overwrite a folder off the root of "Client Data", as newer info can also be located in the correct place...

You will need to open the PDF attachment to have a clear understanding of my poor attempt to describe the problem.
FolderProblems.pdf
0
Rick Norris
Asked:
Rick Norris
  • 3
  • 2
1 Solution
 
ButlerTechnologyCommented:
You might be able to leverage ROBCOPY to merge the folders together.  I did a quick mock up with my folders being in the s Drive.

robocopy s:\clientdata\clientdata\Client1 s:\clientdata\client1 /XO

Open in new window


The /XO flag excludes older files.  I am assuming that the most recent work in the in the s:\clientdata\client1 folder.  I did a little testing, but I would recommend a bit more in-depth testing.

You may not have ROBOCOPY on the Server 2003.  It is available on the Windows 2003 Resource kit.
Tom
0
 
Rick NorrisAuthor Commented:
Tom:

thanks for the response....  I DO have robocopy on the server....

quick additional question before I award the points.

Because I have a little over 1500 subfolders (Client1, Client2, etc), can I use wild cards such as below:

s:\clientdata\clientdata\* s:\clientdata\* /XO

Thanks,
Rick
0
 
ButlerTechnologyCommented:
You don't need the wild card as it will do the entire folder structure.  I did it at the client name for testing purposes.    
robocopy 'F:\Client Data\Cient Data' 'F:\Client Data' /XO /S

Open in new window

I added the /S to include sub directories.  

Tom
0
 
Rick NorrisAuthor Commented:
Tom:

I just noticed in your comment...  "I am assuming that the most recent work in the in the s:\clientdata\client1 folder."    That is an INCORRECT assumption.  I have new work in BOTH locations of our "\client1" folder; however, all file names of new work in each location are unique.

Rick
0
 
ButlerTechnologyCommented:
The process should take all the files from the source and copy them to the Destination.  If this is a newer file in the destination then it will leave that file alone.

Good luck with this and let me know the results - especially if you find that you needed to modify the robocopy command based on your tests.  I find that my test scenarios are very basic and real life always send you a curve.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now