![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
Hello! Given the fact that 8tracks recently announced that they will be closing down on December 31st, fans have been trying to save all the fandom playlists they can so they don't get lost when the website shuts down. Good news! There is a way to easily extract the information of all the playlists in a 8tracks tag. Here's a post explaining how to do it.
This post is meant to be a place where people who are extracting URLs from tags (of any fandom!) on 8tracks before the closing of the site can post their progress in a comment to avoid extracting the same tags multiple times. Not everyone extracting URLs will know about this post so it will be incomplete, this is just one attempt to avoid unnecessary duplicates. Anonymous commenting is enabled, so you don’t need an account to let us know your progress!
UPDATE:
Thanks to VidderKidder, we now have an excel spreadsheet that will archive the playlist info (note: the playlist text file will be in a json format, but using the spreadsheet is a super fast way to getting the metadata and the covers).
**********************
Download: http://bit.ly/8trackback
(you will need to have Macros enabled to run the spreadsheet)
https://powerspreadsheets.com/how-to- enable-macros-excel/
Use the first sheet tab to paste your URLs and click the button to run.
What it will do:
*Extract relevant meta data from the playlist page and put it in your Excel Spreadsheet
*Download the JSON file with the playlist details to a folder on your desktop (8tracks)
*Download the cover photo for each playlist to a folder on your desktop (8tracks)
What you should do:
*Paste urls on the first column of the first sheet tab
*Create a folder on your desktop called 8tracks
*Click the button.
*When you are done and you want to run a new batch copy the info to the second tab
*Clear out the old urls and relevant info on the first tab and paste in the new urls and run again.
Here's a video showing how it works: https://youtu.be/4WlI4yGW-8M
If you have any questions you can contact
morgandawn at admin@vidders.net
This post is meant to be a place where people who are extracting URLs from tags (of any fandom!) on 8tracks before the closing of the site can post their progress in a comment to avoid extracting the same tags multiple times. Not everyone extracting URLs will know about this post so it will be incomplete, this is just one attempt to avoid unnecessary duplicates. Anonymous commenting is enabled, so you don’t need an account to let us know your progress!
UPDATE:
Thanks to VidderKidder, we now have an excel spreadsheet that will archive the playlist info (note: the playlist text file will be in a json format, but using the spreadsheet is a super fast way to getting the metadata and the covers).
**********************
Download: http://bit.ly/8trackback
(you will need to have Macros enabled to run the spreadsheet)
https://powerspreadsheets.com/how-to-
Use the first sheet tab to paste your URLs and click the button to run.
What it will do:
*Extract relevant meta data from the playlist page and put it in your Excel Spreadsheet
*Download the JSON file with the playlist details to a folder on your desktop (8tracks)
*Download the cover photo for each playlist to a folder on your desktop (8tracks)
What you should do:
*Paste urls on the first column of the first sheet tab
*Create a folder on your desktop called 8tracks
*Click the button.
*When you are done and you want to run a new batch copy the info to the second tab
*Clear out the old urls and relevant info on the first tab and paste in the new urls and run again.
Here's a video showing how it works: https://youtu.be/4WlI4yGW-8M
If you have any questions you can contact
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
Tags whose URLs I've extracted as of 5:45 PM UTC
Date: 30/12/19 17:45 (UTC)no subject
Date: 30/12/19 17:56 (UTC)I asked archive team about this: "when we were working with the infinite scroll pages, we ran into a 1000 limit. It didn't matter whether we specified 1 per page or 10 or 20. Still was limited to 1000 results in total divided by however many pages"
As a result they dropped trying to archive by tags , instead they're running 3.5 million random numbers in the hopes of grabbing what they can . On the back end of 8tracks, the playlist data is not stored by URL, or by tag, but by unique numeric identifier.
Because of the volume that they have to run, the archive team will not be archiving the "look and feel (user profile icons). only basic metadata and the raw cover art
https://8tracks.com/mixes/6439105/tracks_for_international.jsonh
Supernatural pairings and fandom tags
Date: 30/12/19 18:06 (UTC)Supernatural pairings
destiel
deancas
wincest
sam/dean
dean/sam
the winchesters
winchesters
sabriel
Fandom
Supernatural
spn
no subject
Date: 30/12/19 18:23 (UTC)- christopher pike
- pavel chekov
- worf
- star trek discovery
- daforge
- jaylah
- leonard mccoy
(no subject)
From:(no subject)
From:(no subject)
From:no subject
Date: 30/12/19 18:24 (UTC)Thanks to VidderKidder, we now have an excel spreadsheet that will archive the playlist info (note: the playlist text file will be in a json format, but using the spreadsheet is a super fast way to getting the metadata and the covers).
**********************
Download: http://bit.ly/8trackback
(you will need to have Macros enabled to run the spreadsheet)
https://powerspreadsheets.com/how-to-enable-macros-excel/
Use the first sheet tab to paste your URLs and click the button to run.
What it will do:
*Extract relevant meta data from the playlist page and put it in your Excel Spreadsheet
*Download the JSON file with the playlist details to a folder on your desktop (8tracks)
*Download the cover photo for each playlist to a folder on your desktop (8tracks)
What you should do:
*Paste urls on the first column of the first sheet tab
Create a folder on your desktop called 8tracks
Click the button.
When you are done and you want to run a new batch copy the info to the second tab
Clear out the old urls and relevant info on the first tab and paste in the new urls and run again.
If you have any questions let me know.
Just reply to this email. My email is admin@vidders.net.
I have assisted on projects to backup tumblr, Yahoo Groups and now 8tracks.
I am the admin of vidders.net the largest streaming vidding network online.
You can share this sheet with anyone who would like to do the same thing you are about to do
Again if there are any questions just email.
(no subject)
From: (Anonymous) - Date: 30/12/19 19:00 (UTC) - Expand(no subject)
From:(no subject)
From:Comments / column K
From:Re: Comments / column K
From:no subject
Date: 30/12/19 22:27 (UTC)-Arthur Pendragon
-Merthur
-BBC_Merlin
-inception
-arthur/eames
-one direction
-larry stylinson
-The Social Network
(no subject)
From:no subject
Date: 30/12/19 23:57 (UTC)- Doki Doki Literature Club / ddlc
- Ava's Demon / avas demon
- Undertale (as much as possible considering there's >3000)
no subject
Date: 31/12/19 00:55 (UTC)Arrested Development
Transgender
I don't think I'll have time for anything else.
(no subject)
From:no subject
Date: 31/12/19 01:48 (UTC)So far I've collected links for variations of
Dean/Benny
Dean/Lisa
Sam/Castiel
Bobby/Crowley
Sam/Jessica
+some tiny ships
Plus whatever characters I can think of
Also got about 2,300 out of 3,600 for Dean Winchester
+ Almost Human (fandom)
(no subject)
From:Vid show Playlists
Date: 31/12/19 02:00 (UTC)Another Tip: Collections
Date: 31/12/19 02:02 (UTC)Ex:
https://8tracks.com/super_redhead/collections/a-big-star-wars-collection
https://8tracks.com/vaguelydownward/collections/star-trek
Collections are hard to find so if you come across any mention them here
Re: Another Tip: Collections
From:Re: Another Tip: Collections
From:Re: Another Tip: Collections
From:Anime
Date: 31/12/19 03:57 (UTC)Re: Anime
From:Re: Anime
From:no subject
Date: 31/12/19 04:28 (UTC)(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:no subject
Date: 31/12/19 04:44 (UTC)- agent carter
- peggy carter
- rogue one
- feanorians
(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From:(no subject)
From: (Anonymous) - Date: 31/12/19 15:54 (UTC) - ExpandVid show Playlists
From:Vid show Playlists
From:(no subject)
From:Vid show Playlists
From:(no subject)
From:(no subject)
From: (Anonymous) - Date: 31/12/19 17:28 (UTC) - Expand(no subject)
From:(no subject)
From:no subject
Date: 31/12/19 05:19 (UTC)no subject
Date: 31/12/19 05:30 (UTC)- undertale
- chara / chara (undertale)
- sans
- frisk
- mettaton / mettaton ex
- genocide route
- pacifist route
- papyrus
- asriel dreemurr
- flowey
- undertale spoilers
(basically all the top tags)
so I think that covers most of it
(no subject)
From:no subject
Date: 31/12/19 06:04 (UTC)-night in the woods-we know the devil
-wktd
-fallen london
-echo bazaar
-echobazaar
-sunless sea
(i'm thinking of getting more, but the computer i'm using for this is really slow so we'll see.)
-rick and mortyno subject
Date: 31/12/19 06:18 (UTC)Also did:
- Lucifer (FOX)
- Good Omens
- Sense8
But I'll have to find someone to grab the info because I can't run the macro
(no subject)
From: (Anonymous) - Date: 31/12/19 06:36 (UTC) - Expand(no subject)
From: (Anonymous) - Date: 31/12/19 06:58 (UTC) - Expand(no subject)
From:no subject
Date: 31/12/19 06:41 (UTC)Currently working on the Les Mis tag (it does have over 1000, so I'm missing some). Got everything in the Combeferre tag as a test run to make sure I was doing it right. I'll probably try to grab some Classics-related tags as well.
(no subject)
From: (Anonymous) - Date: 31/12/19 07:53 (UTC) - Expand(no subject)
From: (Anonymous) - Date: 31/12/19 07:59 (UTC) - Expand(no subject)
From: (Anonymous) - Date: 31/12/19 15:04 (UTC) - Expand(no subject)
From: (Anonymous) - Date: 31/12/19 16:03 (UTC) - Expandno subject
Date: 31/12/19 07:54 (UTC)https://youtu.be/4WlI4yGW-8M
(no subject)
From:no subject
Date: 31/12/19 09:39 (UTC)"black sails" is ran through with the macro! there are some small benefits to being a small fandom.
"enjoltaire" is ran through meanwhile
edited because of the noob questions, hah
(no subject)
From:(no subject)
From:Vid show Playlists
From:Re: Vid show Playlists
From:no subject
Date: 31/12/19 14:10 (UTC)- fe* (where * is 1-15) (also fire emblem awakening)
- ryu ga gotoku (also yakuza, kiryu kazuma, goro majima, yakuza 0)
- the world ends with you (also twewy)
- noragami
- mdzs (also mo dao zu shi)
- kingdom hearts [whatever number it is]/4 days, chain of memories (roxas, ienzo, zexion, vexen)
- eragon
- time riders
- run lola run
- watership down
- bravely default
+ some random stuff I had in collections. There's a bit of steven unvierse and a bit of dragon age, some tolkien-related things, and some random other splatterings. Possibly inception? I didn't check it fully, just pulled the links when I was playing around.
Have also run them through the wayback machine using the email, just in case.
Also, mostly with the noragmi ones but some others, I have noticed some of the files come out with a size of zero. Opening them as text reads them empty. The pictures still download and the spreadsheet list fills in, but the tracklists and all that are not in the files. I've tried rerunning them and no banana. The unifying link between them seems to be that they all contain non-european characters (odd fonts, love hearts, Cyrillic, japanese characters, etc).
(no subject)
From: (Anonymous) - Date: 1/1/20 08:59 (UTC) - Expand(no subject)
From: (Anonymous) - Date: 1/1/20 10:49 (UTC) - ExpandRunning the Excel VBA Macro
Date: 31/12/19 17:00 (UTC)1) Won't work well with Mac versions of Excel.
2) Works better with the playlists links. What do I mean? There are different kind of playlist links. Version 2 got me results while version 1 returned "Not found"
Version 1 - https://8tracks.com/talathamanya/we-move-lightly#smart_id=tags:clintasha&play=1
Version 2 - https://8tracks.com/talathamanya/we-move-lightly
Vid show Playlists
From:Re: Running the Excel VBA Macro
From:no subject
Date: 31/12/19 17:23 (UTC)Ones I need help with (warning most are large and will take hours to run on a good machine)
*Homestuck (small)
*
LOTR (3ooo groups, ready to go)*
Marvel (11,000 groups ready to go)*random set of 'Goofy" - 200 multiple fandoms (small)
*Star Wars 2500 ready to go
*Good Omens (pending)
*Sense8 (pending)
*Buffy (pending)
*Another set of random ones - we need more keywords and pairings for Firefly/Serenity because the search I used on this one pulled in a lot of non-fandom
*Roleplay (pending..don;t know the size but it will be large)
UPDATED 08:00 UTC 1/4/2020 | Various fandoms & coding progress
From:JSONs so far
Date: 31/12/19 19:09 (UTC)I have done:
-xena warrior princess
-femslash
-supercorp
-supergirl
-eurovision
And I'm trying to get *everything* from the doctor who tag. I got everything that wasn't tagged with a distinct tag, and have done these <1000s: doctor x rose, romana, romana x doctor, academy era, mickey smith, vastra/jenny, sally sparrow .torchwood, trock, osgood, classic who, faction paradox, big finish, doctor who eu . koschei .trock .companions .the rani . cybermen . charley pollard . dw . the companions the ponds .rory williams . gallifrey . bad wolf . tardis . clara x danny .twissy .time hunter .tentoo x rose . blake’s seven .
still got a lot more to do but, keeping at it... I hope someone gets some Glee and Harry Potter ones. I sadly only have time to do 1 big fandom ):
Re: JSONs so far
From: (Anonymous) - Date: 31/12/19 19:49 (UTC) - ExpandRe: JSONs so far
From:Re: JSONs so far
From: