>> Ed
>
>Nice VBA coding. You've achieved what I've recently been able to do, but in less
>steps! I currently use a batch file to do the same with output to a csv file.
>
>Can I ask you... is the 'date downloaded' the date that the sfv file was
>downloaded? How does your code 'decide' which line of the sfv file to extract as
>the 'real file name'? (it seems that it's mainly the first line, occassionally
>second, other times random).
>
>In order to have a truly useful database for future resource, the minimum
>required columns (variables) would be:
>1. original date posted to a.b.e.
>2. original rarset name (ie the randomly generated name)
>3. actual embedded filename (without extension and CRC32 value)
>4. full rarset size (in kB)
>5. number of files in rarset (perhaps)
>
>We currently can get 2 and 3 from the sfv file, but 4 and 5 require data from
>the par2 file (which is a much more complex data file), and 1 requires access to
>the original file posting data (via newsreader or perhaps nzbindex).
>
>Interested to hear what you think.
>
>Nhoj
>
>
>
Thanks, but I can't claim credit for all the coding... much of it I
just found lying around the internet, if you catch my drift :)
The database works by importing the contents of all text file copies
of the sfv files into a table (which is cleared before the import
starts), attaching the file name (renamed back to .sfv) to each line.
The contents of this table are then appended to the final table, and
today's date is added to each record at this point. (Thus likely to
be, but not necessarily, the download date.) The sfv file name field
of the final table is set to disallow duplicates, so only one line
from each sfv is kept - presumably the first line, but that might just
be pot luck!
Lastly a query is run to display those downloaded 'today', on the
basis that previous days' downloads will already have been viewed.
It would be easy to remove the extension and CRC32 value, which would
be neater, but I'm not sure I CBA!
Acquiring the other information suggested above looks very difficult
to me - at the very least you would have to download the par files as
well as the sfvs. Whilst it would be useful to know, it is quite easy
to find out for the files you're interested in. Let's face it, file
size is the least interesting of the dimensions associated with this
kind of material ;)
But anyone is welcome to modify the database in any way they wish!
Ed
|
|