Many thanks, Tricia.
I'll check out the "ZZ" or "ZZ-Nonproject" folder.
Many thanks, Tricia.
I found XX-nonproject but not ZZ-nonproject
They're hosted at Archive.org, which is pretty fast/reliable, I think.I was also wondering btw if anyone has thought about mirroring the recordings themselves someplace that would be faster / more reliable than the librivox site.
Not at all, here. I know what Access is, but I never did figure it out. I have no idea what VBA is.It's not likely, but I'll ask anyway: is anyone reading this posting competent in MS ACCESS and VBA?
I worried about that. Should I find some way to delete or overlay that modified link? Or, will people be smart enough to re-type the bold/red letters without the [...] mark ups?TriciaG wrote: ↑April 1st, 2021, 3:03 pmNot at all, here. I know what Access is, but I never did figure it out. I have no idea what VBA is.It's not likely, but I'll ask anyway: is anyone reading this posting competent in MS ACCESS and VBA?
P.S. Adding formatting to a link breaks the link. You'll want to remove the red and bolding to make that readme link work.
I've made it so it's clickable and bold. I can't color it.I worried about that. Should I find some way to delete or overlay that modified link? Or, will people be smart enough to re-type the bold/red letters without the [...] mark ups?
Thanks.
Familiar with VBA, but not competent. I've used it a few times to write macros for excel.williamjones wrote: ↑April 1st, 2021, 2:40 pm Uploaded three .zip files to the xx-nonproject area:
https://librivox.org/uploads/xx-nonproject/AllBooksReadMe.zip
https://librivox.org/uploads/xx-nonproject/AllBookData.zip 3.27 KB
https://librivox.org/uploads/xx-nonproject/AllBooksViews.zip 5.13 KB
See the AllBooksReadMe.TXT file contained in the eponymous zip file for the contents.
It's not likely, but I'll ask anyway: is anyone reading this posting competent in MS ACCESS and VBA?
modomodo, These downloads are the results of my programming in an ACCESS database, employing several Microsoft internet object libraries such as: msml6.dll, ieframe.dll, stdole2.tlb, mshtml.tlb, etc. A couple of months of banging my head against the brick wall of the API, I have determined that there are some buffer/variable size problems in the API code which place a practical limit on how many fields can be dependably asked for from the API. I have tested with the limit parameter set from 2( ) to 2000 books at a time and have found serious corruption of the XML returned data after a certain point. I had to find a "sweet spot" between the LIMIT parameter and the number of fields asked for. So, the data collected and then displayed in the uploaded .xlsx files is as of 29 MAR 21 downloading only 5 books' data at a time and only a useful selection of the metadata components. Another factor is that the LV servers are frustratingly prone to throwing errors. I had to devote a great deal of code to catching msxhtml errors and looping until getting a successful page request.modomodo wrote: ↑April 1st, 2021, 9:01 pm Hi williamjones. Thanks for these exports, but is this really all the info available via the api? (I actually used the api a couple years ago and forgot everything about it and just noticed this post and was going to try your download before trying to work with the api again.). There seems to be lots of metadata that they have presented on the site that is not here, e.g. the category/genre , the language, the summary, etc.
Sorry if this was discussed earlier in the thread. This discussion is very long, and I didn't read every post from the beginning.