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
  • 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

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Question has a verified solution.

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

Suggested Solutions

Synchronize a new Active Directory domain with an existing Office 365 tenant
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now