Guest millin Posted July 24, 2008 Posted July 24, 2008 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
Guest Pegasus \(MVP\) Posted July 24, 2008 Posted July 24, 2008 Re: File search "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.
Guest millin Posted July 24, 2008 Posted July 24, 2008 Re: File search 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. > > >
Guest Pegasus \(MVP\) Posted July 24, 2008 Posted July 24, 2008 Re: File search 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. >> >> >>
Guest millin Posted July 24, 2008 Posted July 24, 2008 Re: File search 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. > >> > >> > >> > > >
Guest Pegasus \(MVP\) Posted July 24, 2008 Posted July 24, 2008 Re: File search 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. >> >> >> >> >> >> >> >> >>
Guest millin Posted July 25, 2008 Posted July 25, 2008 Re: File search 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. > >> >> > >> >> > >> >> > >> > >> > >> > > >
Guest Pegasus \(MVP\) Posted July 25, 2008 Posted July 25, 2008 Re: File search "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.
Guest millin Posted July 25, 2008 Posted July 25, 2008 Re: File search 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. > > >
Recommended Posts