Solved

Folder problems and data in wrong locations

Posted on 2013-12-30
5
447 Views
Last Modified: 2013-12-31
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
Comment
Question by:Rick Norris
  • 3
  • 2
5 Comments
 
LVL 6

Accepted Solution

by:
ButlerTechnology earned 500 total points
Comment Utility
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
 

Author Comment

by:Rick Norris
Comment Utility
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
 
LVL 6

Expert Comment

by:ButlerTechnology
Comment Utility
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
 

Author Comment

by:Rick Norris
Comment Utility
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
 
LVL 6

Expert Comment

by:ButlerTechnology
Comment Utility
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

Are your corporate email signatures appalling?

Is it scary how unprofessional your email signatures look? Do users create their own terrible designs and give themselves stupid job titles? You can make this a lot easier for yourself by choosing an email signature management solution from Exclaimer today.

Join & Write a Comment

Our Group Policy work started with Small Business Server in 2000. Microsoft gave us an excellent OU and GPO model in subsequent SBS editions that utilized WMI filters, OU linking, and VBS scripts. These are some of experiences plus our spending a lo…
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
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…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

744 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

16 Experts available now in Live!

Get 1:1 Help Now