-
July 15th, 2021, 02:37 PM
#1
Find all files from a certain date (younger than 30 days) in a directory which contai
Hi Guys
I can no longer work with the explorer search and I have no other help.
There are over 1.5 million test reports in a network folder and sometimes I have to search for something.
It takes 30 minutes for Windows to display all of the files.
And 60-Min to sort them by date
Is there a possibility with a VB6 command to create a directory content. only the most recently created reports <30 days?
Thanks Erwin
-
July 17th, 2021, 05:36 AM
#2
Re: Find all files from a certain date (younger than 30 days) in a directory which co
> There are over 1.5 million test reports in a network folder
That's 100 per day (aka once every 15 minutes), every day, for 40 years.
How fast are these reports being generated?
> only the most recently created reports <30 days?
So of the 1.5 million, how many results satisfy that criteria?
You're basically screwed if you have all the files in one directory.
From a command line prompt, time how long this takes (note, you won't see anything on screen)
Code:
dir /b/s \\network\path\to\reports >nul:
That will be about as close as it's possible to even fetch the most basic information across the network. Nothing you could write in any language would transform that time into anything vastly quicker.
Try organising things into
reports\199x
reports\199x\1990\01 Jan 1990
reports\199x\1990\12 Dec 1990
ditto through to
reports\199x\1999\12 Dec 1999
Then start on
reports\200x
reports\200x\2000\01 Jan 1990
reports\200x\2000\12 Dec 1990
ditto through to
reports\200x\2009\12 Dec 2009
OK, maybe you'd like reports\current for this year (and maybe last year), but sooner or later, moving the increasingly historic stuff out of the way should be part of your monthly/quarterly routine.
-
July 17th, 2021, 07:52 AM
#3
Re: Find all files from a certain date (younger than 30 days) in a directory which co
Yes, it is actually like this:
there are around 15 workplaces, electronic circuits are checked with software and these reports are saved in the network folder.
I do not have the opportunity to prescribe something to the responsible engineer
Some employees serve several workplaces, up to 5 stations in rotation.
This sometimes creates uncertainties and we have to look in this folder,
so we have to check the name and serial number of the report with the serial number of the circuit.
Your suggestion would really be the best, we thought so too, but the engineer can or does not want to change that.
All the test programs can only use one same folder for the output.
The data (per day) in this folder are copied into the large collection folder every midnight.
Of course we could easily copy the reports into the appropriate folder with a batch: xCopy "/ D: M-T-J".
But as I already wrote, the engineer refuses and we have no rights to create a new directory with copies on the network and look there in smaller directories :-(
But I have found a solution and would like to point it out here in case someone else runs into the same problem.
After a very long and intensive search, I came across a new solution :-)
I don't have to generate a list of all documents, I need a program that registers "changes" in the network folder
and saves them in its own index for a maximum of 90 days.
Obviously you can monitor Windows for this (changes) and only get the 5-30 accesses per minute displayed.
And I have found a program which solves this very well and you can search / sort in its index by name or part of a file name and by date.
wizfile.exe (Sorry for the advertising.)
After coming across this new approach, this program got installed on a local PC and everyone is happy.
I will consider this approach later and try to develop my own little program for it if possible with VB6
Thanks for your Interest Erwin
-
July 17th, 2021, 07:56 AM
#4
Re: Find all files from a certain date (younger than 30 days) in a directory which co
-
July 17th, 2021, 07:59 AM
#5
Re: Find all files from a certain date (younger than 30 days) in a directory which co
Yes, it is actually like this: -O
there are around 15 workplaces, electronic circuits are checked with software and these reports are saved in the network folder.
I do not have the opportunity to prescribe something to the responsible engineer :-(
Some employees serve several workplaces, up to 5 stations in rotation. This sometimes creates uncertainties and we have to look in this folder. and check the name and serial number of the report with the serial number of the circuit.
Your suggestion would really be the best, we thought so too, but the engineer can or does not want to change that.
The test programs can only use a fixed folder for the output.
The data (per day) in this folder are copied into the large collection folder every midnight.
Of course we could easily copy the reports into the appropriate folder with a batch: xCopy "/ D: M-T-J".
But as I already wrote, the engineer refuses and we have no rights to create a new directory with copies on the network and look there in smaller directories :-(
-
July 17th, 2021, 08:00 AM
#6
Re: Find all files from a certain date (younger than 30 days) in a directory which co
But I have found a solution and would like to point it out here in case someone else runs into the same problem.
After a very long and intensive search, I came across a new solution :-)
I don't have to generate a list of all documents, I need a program that registers "changes" in the network folder and saves them in its own index for a maximum of 90 days.
Obviously you can monitor Windows for this (changes) and only get the 5-30 accesses per minute displayed.
And I have found a program which solves this very well and you can search / sort in its index by name or part of a file name and by date.
wizfile.exe (Sorry for the advertising.)
After coming across this new approach, this program got installed on a local PC and everyone is happy.
I will consider this approach later and try to develop my own little program for it if possible with VB6
Thanks for your interest Erwin
-
September 11th, 2021, 09:05 AM
#7
Re: Find all files from a certain date (younger than 30 days) in a directory which co
If you sort the directory in descending order, which takes 60 minutes you have said, then open the directory after adding more files, are you seeing the new files added to the top of the directory ?
(On the basis that newly added files have the current date and time - Date Modified)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|