Folder problems and data in wrong locations

Posted on 2013-12-30
Last Modified: 2013-12-31

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.
Question by:Rick Norris
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Accepted Solution

ButlerTechnology earned 500 total points
ID: 39746969
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.

Author Comment

by:Rick Norris
ID: 39748100

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


Expert Comment

ID: 39748111
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.  


Author Comment

by:Rick Norris
ID: 39748113

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.


Expert Comment

ID: 39748958
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.

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Uncontrolled local administrators groups within any organization pose a huge security risk. Because these groups are locally managed it becomes difficult to audit and maintain them.
Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question