Creating spreadsheet from LibriVox catalog

Post your questions & get help from friendly LibriVoxers
Post Reply
k5hsj
Posts: 656
Joined: August 17th, 2010, 12:02 am
Location: Point Richmond, CA

Post by k5hsj » September 26th, 2019, 3:41 pm

I’m interested in creating a spreadsheet of my contributions to the LibriVox catalog. Does anyone know how I might download data from the LibriVox website to import into Excel? Any help would be much appreciated!

Winston
Be kind. Be interesting. Be useful. Morality ain't hard.--Jack Butler, Living in Little Rock with Miss Little Rock

TriciaG
LibriVox Admin Team
Posts: 43187
Joined: June 15th, 2008, 10:30 pm
Location: Toronto, ON (but Minnesotan to age 32)

Post by TriciaG » September 26th, 2019, 4:30 pm

What information do you want to include? Some info is much more easy than other info.

You can use the API, but it's pretty much indecipherable if you don't know how to use it. Info here: https://librivox.org/api/info and thread here: viewtopic.php?f=24&t=44129

(And no, I don't know how to use it.)

When you're logged into the workflow (magic window), you can get a list of all your projects here: https://librivox.org/projects/5694 and sort by "reader" column. (Or is this only for admins? Try it and see...)

annise
LibriVox Admin Team
Posts: 31839
Joined: April 3rd, 2008, 3:55 am
Location: Melbourne,Australia

Post by annise » September 26th, 2019, 5:12 pm

You could try copying and pasting from your readers page and see what happens - I've never tried but it works for some other things . Takes some prettying up if it does work

Anne

Peter Why
Posts: 4464
Joined: November 24th, 2005, 3:54 am
Location: Chigwell (North-East London, U.K.)

Post by Peter Why » September 27th, 2019, 12:26 am

I just experimented; the LV reader's page entries are tab delineated, and you can display a hundred at a time. I found that copying the entries and loading into an empty LibreOffice spreadsheet worked perfectly well. You're going to need a bit of messing about to get rid of the information you don't need, but it shouldn't be too difficult.

Peter
"I think, therefore I am, I think." Solomon Cohen, in Terry Pratchett's Dodger

k5hsj
Posts: 656
Joined: August 17th, 2010, 12:02 am
Location: Point Richmond, CA

Post by k5hsj » September 27th, 2019, 1:10 pm

Thanks Anne & Peter. I’ll give that a try. Certainly sounds more straightforward than trying to decipher the API, whatever that might be :D LibriVoxers to the rescue, as usual.

Winston
Be kind. Be interesting. Be useful. Morality ain't hard.--Jack Butler, Living in Little Rock with Miss Little Rock

Post Reply