?
Solved

Folder problems and data in wrong locations

Posted on 2013-12-30
5
Medium Priority
?
467 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
[X]
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
5 Comments
 
LVL 6

Accepted Solution

by:
ButlerTechnology earned 2000 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.
Tom
0
 

Author Comment

by:Rick Norris
ID: 39748100
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
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.  

Tom
0
 

Author Comment

by:Rick Norris
ID: 39748113
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
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.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

770 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