Windows 2000 File search

  • Thread starter Thread starter millin
  • Start date Start date
M

millin

Hi All,

I want to find a solution for one of our file structure implemented in our
organization.

We are having a Kofax scanner that scans all the incoming documents
(drawings) and place automatically in a network shared folder this is
ongoing for last 10 years or so. The software does it by copying every 500
files in a single folder so you can image how many number of files are there
in that shared folder, like that we have got 500 folders.

So anybody can give me a quicker solution for finding the obsolete drawings
on each folder by not going to each folder, looking for the pdf documents and
delete one by one looking for the issue numbers.

eg:- Suppose the folder called example-000,the files inside are called
example-000-1.pdf,example-000-2.pdf, example-000-3.pdf, etc(3 is the latest
issue number for that Drawing, I want to delete the rest of the files).

Thanks in advance,

mil
 
"millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
news:5A389034-8639-4135-8E62-24E39C2F74CF@microsoft.com...
> Hi All,
>
> I want to find a solution for one of our file structure implemented in our
> organization.
>
> We are having a Kofax scanner that scans all the incoming documents
> (drawings) and place automatically in a network shared folder this is
> ongoing for last 10 years or so. The software does it by copying every 500
> files in a single folder so you can image how many number of files are
> there
> in that shared folder, like that we have got 500 folders.
>
> So anybody can give me a quicker solution for finding the obsolete
> drawings
> on each folder by not going to each folder, looking for the pdf documents
> and
> delete one by one looking for the issue numbers.
>
> eg:- Suppose the folder called example-000,the files inside are called
> example-000-1.pdf,example-000-2.pdf, example-000-3.pdf, etc(3 is the
> latest
> issue number for that Drawing, I want to delete the rest of the files).
>
> Thanks in advance,
>
> mil
>


Your filing system is far from clear - please elaborate, preferably with
some
detailed examples.
 
Example Folder name is XY10529 which is created automatically while we scan
the document with a bar code label XY10529 placed at the back of the incoming
document (ICRN) and all the files inside that folder are XY10529-1,
XY10529-2, XY10529-3, XY10529-4.pdf.(-1,-2,-3 and -4 stands for issue number
or the drawings).This folder is in a network shared server folder.

Our target is to keep only the last issue which is issue number 4 in this
exampleXY10529-4.pdf,and all other files in the folder should be copied in to
a temp folder(keeping the folder hierarchy) for further future reference.

As I mentioned earlier we have got at least 500 of these type of folders and
in each folder drawing files have been saved as <foldername-1.pdf,-2,-3 and
-4.pdf etc)

I hope this is making sense.

Thanks
mil

"Pegasus (MVP)" wrote:

>
> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
> news:5A389034-8639-4135-8E62-24E39C2F74CF@microsoft.com...
> > Hi All,
> >
> > I want to find a solution for one of our file structure implemented in our
> > organization.
> >
> > We are having a Kofax scanner that scans all the incoming documents
> > (drawings) and place automatically in a network shared folder this is
> > ongoing for last 10 years or so. The software does it by copying every 500
> > files in a single folder so you can image how many number of files are
> > there
> > in that shared folder, like that we have got 500 folders.
> >
> > So anybody can give me a quicker solution for finding the obsolete
> > drawings
> > on each folder by not going to each folder, looking for the pdf documents
> > and
> > delete one by one looking for the issue numbers.
> >
> > eg:- Suppose the folder called example-000,the files inside are called
> > example-000-1.pdf,example-000-2.pdf, example-000-3.pdf, etc(3 is the
> > latest
> > issue number for that Drawing, I want to delete the rest of the files).
> >
> > Thanks in advance,
> >
> > mil
> >

>
> Your filing system is far from clear - please elaborate, preferably with
> some
> detailed examples.
>
>
>
 
According to your description, you expect this to happen:
- Each folder to contain exactly one file.
- This file should be the one with the highest issue number.
- All other files should be moved to a temp folder.

This might translate into the following pseudo-code, assuming that
your folders are kept in D:\Scanned Files:
1. Move the folder "D:\Scanned Files" to "X:\Temp\Scanned Files",
complete with all subfolders & files.
2. Move the most recent file in each folder back to D:\Scanned Files.

Is this a correct interpretation?
What is the extension of your files?

"millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
news:90A6A6EA-E91D-4F94-A012-FB1BC1067A53@microsoft.com...
> Example Folder name is XY10529 which is created automatically while we
> scan
> the document with a bar code label XY10529 placed at the back of the
> incoming
> document (ICRN) and all the files inside that folder are XY10529-1,
> XY10529-2, XY10529-3, XY10529-4.pdf.(-1,-2,-3 and -4 stands for issue
> number
> or the drawings).This folder is in a network shared server folder.
>
> Our target is to keep only the last issue which is issue number 4 in this
> exampleXY10529-4.pdf,and all other files in the folder should be copied in
> to
> a temp folder(keeping the folder hierarchy) for further future reference.
>
> As I mentioned earlier we have got at least 500 of these type of folders
> and
> in each folder drawing files have been saved as <foldername-1.pdf,-2,-3
> and
> -4.pdf etc)
>
> I hope this is making sense.
>
> Thanks
> mil
>
> "Pegasus (MVP)" wrote:
>
>>
>> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
>> news:5A389034-8639-4135-8E62-24E39C2F74CF@microsoft.com...
>> > Hi All,
>> >
>> > I want to find a solution for one of our file structure implemented in
>> > our
>> > organization.
>> >
>> > We are having a Kofax scanner that scans all the incoming documents
>> > (drawings) and place automatically in a network shared folder this is
>> > ongoing for last 10 years or so. The software does it by copying every
>> > 500
>> > files in a single folder so you can image how many number of files are
>> > there
>> > in that shared folder, like that we have got 500 folders.
>> >
>> > So anybody can give me a quicker solution for finding the obsolete
>> > drawings
>> > on each folder by not going to each folder, looking for the pdf
>> > documents
>> > and
>> > delete one by one looking for the issue numbers.
>> >
>> > eg:- Suppose the folder called example-000,the files inside are called
>> > example-000-1.pdf,example-000-2.pdf, example-000-3.pdf, etc(3 is the
>> > latest
>> > issue number for that Drawing, I want to delete the rest of the files).
>> >
>> > Thanks in advance,
>> >
>> > mil
>> >

>>
>> Your filing system is far from clear - please elaborate, preferably with
>> some
>> detailed examples.
>>
>>
>>
 
Yes you are almost right.
The file extension is PDF.

If you move the files from the shared folder "<Servername>:\Scanned Files:"
to "X:\Temp\Scanned Files", it will create "chaos" because people are still
accessing this folder and uploading documents from it to another application.

what I want to do is instead of moving the files, copy the files from the
source path to the destination path which is "X:\Temp\Scanned Files", which I
can do but I don’t know how we can keep the latest issue file in the
"<Servername>:\Scanned Files:" and move the rest of the files in each folder
follwing the folder hierarchy in to a temp folder.

Yes. The main target is to leave the latest issue number at the original
location and move the rest of the files in to the "X:\Temp\Scanned Filesâ€,
following the folder hierarchy, even if it's not possible following the
folder hierarchy it's fine.

Thanks
mil

"Pegasus (MVP)" wrote:

> According to your description, you expect this to happen:
> - Each folder to contain exactly one file.
> - This file should be the one with the highest issue number.
> - All other files should be moved to a temp folder.
>
> This might translate into the following pseudo-code, assuming that
> your folders are kept in D:\Scanned Files:
> 1. Move the folder "D:\Scanned Files" to "X:\Temp\Scanned Files",
> complete with all subfolders & files.
> 2. Move the most recent file in each folder back to D:\Scanned Files.
>
> Is this a correct interpretation?
> What is the extension of your files?
>
> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
> news:90A6A6EA-E91D-4F94-A012-FB1BC1067A53@microsoft.com...
> > Example Folder name is XY10529 which is created automatically while we
> > scan
> > the document with a bar code label XY10529 placed at the back of the
> > incoming
> > document (ICRN) and all the files inside that folder are XY10529-1,
> > XY10529-2, XY10529-3, XY10529-4.pdf.(-1,-2,-3 and -4 stands for issue
> > number
> > or the drawings).This folder is in a network shared server folder.
> >
> > Our target is to keep only the last issue which is issue number 4 in this
> > exampleXY10529-4.pdf,and all other files in the folder should be copied in
> > to
> > a temp folder(keeping the folder hierarchy) for further future reference.
> >
> > As I mentioned earlier we have got at least 500 of these type of folders
> > and
> > in each folder drawing files have been saved as <foldername-1.pdf,-2,-3
> > and
> > -4.pdf etc)
> >
> > I hope this is making sense.
> >
> > Thanks
> > mil
> >
> > "Pegasus (MVP)" wrote:
> >
> >>
> >> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
> >> news:5A389034-8639-4135-8E62-24E39C2F74CF@microsoft.com...
> >> > Hi All,
> >> >
> >> > I want to find a solution for one of our file structure implemented in
> >> > our
> >> > organization.
> >> >
> >> > We are having a Kofax scanner that scans all the incoming documents
> >> > (drawings) and place automatically in a network shared folder this is
> >> > ongoing for last 10 years or so. The software does it by copying every
> >> > 500
> >> > files in a single folder so you can image how many number of files are
> >> > there
> >> > in that shared folder, like that we have got 500 folders.
> >> >
> >> > So anybody can give me a quicker solution for finding the obsolete
> >> > drawings
> >> > on each folder by not going to each folder, looking for the pdf
> >> > documents
> >> > and
> >> > delete one by one looking for the issue numbers.
> >> >
> >> > eg:- Suppose the folder called example-000,the files inside are called
> >> > example-000-1.pdf,example-000-2.pdf, example-000-3.pdf, etc(3 is the
> >> > latest
> >> > issue number for that Drawing, I want to delete the rest of the files).
> >> >
> >> > Thanks in advance,
> >> >
> >> > mil
> >> >
> >>
> >> Your filing system is far from clear - please elaborate, preferably with
> >> some
> >> detailed examples.
> >>
> >>
> >>

>
>
>
 
Try the following batch file:
01. @echo off
02. set SourceDrive=D:\Test Folder
03. set Target=E:\Temp Folder
04.
05. for /F "tokens=*" %%* in ('dir /b "%Source%"') do call :Sub %%*
06. del c:\exclude.txt
07. goto :eof
08.
09. :Sub
10. attrib +a "%Source%\%*\*.*"
11. for /F %%b in ('dir "%Source%\%*" /on /b') do echo %%b>c:\exclude.txt
12. xcopy /y /m /exclude:c:\exclude.txt "%Source%\%*\*.*" "E:\Temp\%*\"
13. del "%Source%\%*\*.*" /A:-A /Q

Instructions:
1. Set up a test bed with a number of folders and files.
2. Adjust Lines #02 and #03 to reflect your test bed.
3. Remove all line numbers.
4. Run the batch file.
5. Check if it did what you expected.
6. If yes, adjust Lines 2 and 3 to reflect your production environment.
Warning: Do not retype the code - use copy & paste instead!


"millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
news:3E8C4BD7-031B-4F84-8241-CD8300517D23@microsoft.com...
> Yes you are almost right.
> The file extension is PDF.
>
> If you move the files from the shared folder "<Servername>:\Scanned
> Files:"
> to "X:\Temp\Scanned Files", it will create "chaos" because people are
> still
> accessing this folder and uploading documents from it to another
> application.
>
> what I want to do is instead of moving the files, copy the files from the
> source path to the destination path which is "X:\Temp\Scanned Files",
> which I
> can do but I don't know how we can keep the latest issue file in the
> "<Servername>:\Scanned Files:" and move the rest of the files in each
> folder
> follwing the folder hierarchy in to a temp folder.
>
> Yes. The main target is to leave the latest issue number at the original
> location and move the rest of the files in to the "X:\Temp\Scanned Files",
> following the folder hierarchy, even if it's not possible following the
> folder hierarchy it's fine.
>
> Thanks
> mil
>
> "Pegasus (MVP)" wrote:
>
>> According to your description, you expect this to happen:
>> - Each folder to contain exactly one file.
>> - This file should be the one with the highest issue number.
>> - All other files should be moved to a temp folder.
>>
>> This might translate into the following pseudo-code, assuming that
>> your folders are kept in D:\Scanned Files:
>> 1. Move the folder "D:\Scanned Files" to "X:\Temp\Scanned Files",
>> complete with all subfolders & files.
>> 2. Move the most recent file in each folder back to D:\Scanned Files.
>>
>> Is this a correct interpretation?
>> What is the extension of your files?
>>
>> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
>> news:90A6A6EA-E91D-4F94-A012-FB1BC1067A53@microsoft.com...
>> > Example Folder name is XY10529 which is created automatically while we
>> > scan
>> > the document with a bar code label XY10529 placed at the back of the
>> > incoming
>> > document (ICRN) and all the files inside that folder are XY10529-1,
>> > XY10529-2, XY10529-3, XY10529-4.pdf.(-1,-2,-3 and -4 stands for issue
>> > number
>> > or the drawings).This folder is in a network shared server folder.
>> >
>> > Our target is to keep only the last issue which is issue number 4 in
>> > this
>> > exampleXY10529-4.pdf,and all other files in the folder should be copied
>> > in
>> > to
>> > a temp folder(keeping the folder hierarchy) for further future
>> > reference.
>> >
>> > As I mentioned earlier we have got at least 500 of these type of
>> > folders
>> > and
>> > in each folder drawing files have been saved as <foldername-1.pdf,-2,-3
>> > and
>> > -4.pdf etc)
>> >
>> > I hope this is making sense.
>> >
>> > Thanks
>> > mil
>> >
>> > "Pegasus (MVP)" wrote:
>> >
>> >>
>> >> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
>> >> news:5A389034-8639-4135-8E62-24E39C2F74CF@microsoft.com...
>> >> > Hi All,
>> >> >
>> >> > I want to find a solution for one of our file structure implemented
>> >> > in
>> >> > our
>> >> > organization.
>> >> >
>> >> > We are having a Kofax scanner that scans all the incoming documents
>> >> > (drawings) and place automatically in a network shared folder this
>> >> > is
>> >> > ongoing for last 10 years or so. The software does it by copying
>> >> > every
>> >> > 500
>> >> > files in a single folder so you can image how many number of files
>> >> > are
>> >> > there
>> >> > in that shared folder, like that we have got 500 folders.
>> >> >
>> >> > So anybody can give me a quicker solution for finding the obsolete
>> >> > drawings
>> >> > on each folder by not going to each folder, looking for the pdf
>> >> > documents
>> >> > and
>> >> > delete one by one looking for the issue numbers.
>> >> >
>> >> > eg:- Suppose the folder called example-000,the files inside are
>> >> > called
>> >> > example-000-1.pdf,example-000-2.pdf, example-000-3.pdf, etc(3 is the
>> >> > latest
>> >> > issue number for that Drawing, I want to delete the rest of the
>> >> > files).
>> >> >
>> >> > Thanks in advance,
>> >> >
>> >> > mil
>> >> >
>> >>
>> >> Your filing system is far from clear - please elaborate, preferably
>> >> with
>> >> some
>> >> detailed examples.
>> >>
>> >>
>> >>

>>
>>
>>
 
Hi,

Can I run it using a command prompt,what is the extension of this file if I
want to use it for saving this file. is it .bat file.

May be it is some silly questions which I am asking but truth is that I am
not really very good at writing scripts(batch) files. I REALLY WANT TO LEARN
MORE ABOUT RUNNING BATCH FILES,SCRIPTS FOR GIVING MORE CONTROL OF NETWORK
FOLDERS AND FILES,CAN YOU HELP ME TO FIND SOME GOOD WEB LINKS WHERE I CAN
FIND SOME GOOD SOURCE FILES FOR FOLDERS,AD,LDAP SCRIPTING.

Anyway thanks for all your responses.

mil.


"Pegasus (MVP)" wrote:

> Try the following batch file:
> 01. @echo off
> 02. set SourceDrive=D:\Test Folder
> 03. set Target=E:\Temp Folder
> 04.
> 05. for /F "tokens=*" %%* in ('dir /b "%Source%"') do call :Sub %%*
> 06. del c:\exclude.txt
> 07. goto :eof
> 08.
> 09. :Sub
> 10. attrib +a "%Source%\%*\*.*"
> 11. for /F %%b in ('dir "%Source%\%*" /on /b') do echo %%b>c:\exclude.txt
> 12. xcopy /y /m /exclude:c:\exclude.txt "%Source%\%*\*.*" "E:\Temp\%*\"
> 13. del "%Source%\%*\*.*" /A:-A /Q
>
> Instructions:
> 1. Set up a test bed with a number of folders and files.
> 2. Adjust Lines #02 and #03 to reflect your test bed.
> 3. Remove all line numbers.
> 4. Run the batch file.
> 5. Check if it did what you expected.
> 6. If yes, adjust Lines 2 and 3 to reflect your production environment.
> Warning: Do not retype the code - use copy & paste instead!
>
>
> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
> news:3E8C4BD7-031B-4F84-8241-CD8300517D23@microsoft.com...
> > Yes you are almost right.
> > The file extension is PDF.
> >
> > If you move the files from the shared folder "<Servername>:\Scanned
> > Files:"
> > to "X:\Temp\Scanned Files", it will create "chaos" because people are
> > still
> > accessing this folder and uploading documents from it to another
> > application.
> >
> > what I want to do is instead of moving the files, copy the files from the
> > source path to the destination path which is "X:\Temp\Scanned Files",
> > which I
> > can do but I don't know how we can keep the latest issue file in the
> > "<Servername>:\Scanned Files:" and move the rest of the files in each
> > folder
> > follwing the folder hierarchy in to a temp folder.
> >
> > Yes. The main target is to leave the latest issue number at the original
> > location and move the rest of the files in to the "X:\Temp\Scanned Files",
> > following the folder hierarchy, even if it's not possible following the
> > folder hierarchy it's fine.
> >
> > Thanks
> > mil
> >
> > "Pegasus (MVP)" wrote:
> >
> >> According to your description, you expect this to happen:
> >> - Each folder to contain exactly one file.
> >> - This file should be the one with the highest issue number.
> >> - All other files should be moved to a temp folder.
> >>
> >> This might translate into the following pseudo-code, assuming that
> >> your folders are kept in D:\Scanned Files:
> >> 1. Move the folder "D:\Scanned Files" to "X:\Temp\Scanned Files",
> >> complete with all subfolders & files.
> >> 2. Move the most recent file in each folder back to D:\Scanned Files.
> >>
> >> Is this a correct interpretation?
> >> What is the extension of your files?
> >>
> >> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
> >> news:90A6A6EA-E91D-4F94-A012-FB1BC1067A53@microsoft.com...
> >> > Example Folder name is XY10529 which is created automatically while we
> >> > scan
> >> > the document with a bar code label XY10529 placed at the back of the
> >> > incoming
> >> > document (ICRN) and all the files inside that folder are XY10529-1,
> >> > XY10529-2, XY10529-3, XY10529-4.pdf.(-1,-2,-3 and -4 stands for issue
> >> > number
> >> > or the drawings).This folder is in a network shared server folder.
> >> >
> >> > Our target is to keep only the last issue which is issue number 4 in
> >> > this
> >> > exampleXY10529-4.pdf,and all other files in the folder should be copied
> >> > in
> >> > to
> >> > a temp folder(keeping the folder hierarchy) for further future
> >> > reference.
> >> >
> >> > As I mentioned earlier we have got at least 500 of these type of
> >> > folders
> >> > and
> >> > in each folder drawing files have been saved as <foldername-1.pdf,-2,-3
> >> > and
> >> > -4.pdf etc)
> >> >
> >> > I hope this is making sense.
> >> >
> >> > Thanks
> >> > mil
> >> >
> >> > "Pegasus (MVP)" wrote:
> >> >
> >> >>
> >> >> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
> >> >> news:5A389034-8639-4135-8E62-24E39C2F74CF@microsoft.com...
> >> >> > Hi All,
> >> >> >
> >> >> > I want to find a solution for one of our file structure implemented
> >> >> > in
> >> >> > our
> >> >> > organization.
> >> >> >
> >> >> > We are having a Kofax scanner that scans all the incoming documents
> >> >> > (drawings) and place automatically in a network shared folder this
> >> >> > is
> >> >> > ongoing for last 10 years or so. The software does it by copying
> >> >> > every
> >> >> > 500
> >> >> > files in a single folder so you can image how many number of files
> >> >> > are
> >> >> > there
> >> >> > in that shared folder, like that we have got 500 folders.
> >> >> >
> >> >> > So anybody can give me a quicker solution for finding the obsolete
> >> >> > drawings
> >> >> > on each folder by not going to each folder, looking for the pdf
> >> >> > documents
> >> >> > and
> >> >> > delete one by one looking for the issue numbers.
> >> >> >
> >> >> > eg:- Suppose the folder called example-000,the files inside are
> >> >> > called
> >> >> > example-000-1.pdf,example-000-2.pdf, example-000-3.pdf, etc(3 is the
> >> >> > latest
> >> >> > issue number for that Drawing, I want to delete the rest of the
> >> >> > files).
> >> >> >
> >> >> > Thanks in advance,
> >> >> >
> >> >> > mil
> >> >> >
> >> >>
> >> >> Your filing system is far from clear - please elaborate, preferably
> >> >> with
> >> >> some
> >> >> detailed examples.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>

>
>
>
 
"millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
news:D2E52F72-E2C3-43BD-8662-CEB376FAB743@microsoft.com...
> Hi,
>
> Can I run it using a command prompt,what is the extension of this file if
> I
> want to use it for saving this file. is it .bat file.


Batch files are mostly saved with a .bat extension but a .cmd
extension will work too. You should run them from a Command
Prompt during the debugging phase so that you can see error
messages if they occur.
 
Thanks Pegasus.
Let me try and come back to you later.
mil

"Pegasus (MVP)" wrote:

>
> "millin" <ssuj@discussions.microsoft.com(No Spam)> wrote in message
> news:D2E52F72-E2C3-43BD-8662-CEB376FAB743@microsoft.com...
> > Hi,
> >
> > Can I run it using a command prompt,what is the extension of this file if
> > I
> > want to use it for saving this file. is it .bat file.

>
> Batch files are mostly saved with a .bat extension but a .cmd
> extension will work too. You should run them from a Command
> Prompt during the debugging phase so that you can see error
> messages if they occur.
>
>
>
 
Back
Top