All Sign-Ups (aka CSV?)
Sep. 21st, 2017 01:11 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
pumpkinkingmod posting in ![[community profile]](https://www.dreamwidth.org/img/silk/identity/community.png){kind=small}
trickortreatexThere is a problem with the CSV for Trick or Treat. I can't download it. For those who don't know, AO3 generates a spreadsheet with all the sign-ups that mods can access. The people waiting to make spreadsheets of the AO3 sign-ups have been waiting for it. I have been in contact with AO3 support but it sounds like this might not be fixable in time for this exchange.
To help out, and ensure that those that didn't post letters can be easily searched for as well, I made a google doc with all the sign-ups on the AO3 side. This was done fast and quick. It does not contain any letter links. I have allowed commenting so that people can add links to their letters and any others that they know of. Don't abuse the commenting or I will turn it off.
I am a bit rushed right now, so the livejournal post will go up later.
Feel free to use this in whatever way you want for making any other documents to help participants.
Google Doc Link
EDIT: I have good news and bad news. So the underlying issue is still unknown. However, an AO3 database person was able to get me the CSV file and it was emailed to me. I will be sending it to the people that requested it for working on spreadsheets with the emails and offers removed. The bad news is that it did some pretty funky stuff to some of the tags.
Examples:
レ・ミゼラブル 少女コゼット | Les Misérables: Shoujo Cosette
文豪ストレイドッグス | Bungou Stray Dogs
It mostly seems to be fandoms with characters not used in English in the tag.
To help out, and ensure that those that didn't post letters can be easily searched for as well, I made a google doc with all the sign-ups on the AO3 side. This was done fast and quick. It does not contain any letter links. I have allowed commenting so that people can add links to their letters and any others that they know of. Don't abuse the commenting or I will turn it off.
I am a bit rushed right now, so the livejournal post will go up later.
Feel free to use this in whatever way you want for making any other documents to help participants.
Google Doc Link
EDIT: I have good news and bad news. So the underlying issue is still unknown. However, an AO3 database person was able to get me the CSV file and it was emailed to me. I will be sending it to the people that requested it for working on spreadsheets with the emails and offers removed. The bad news is that it did some pretty funky stuff to some of the tags.
Examples:
レ・ミゼラブル 少女コゼット | Les Misérables: Shoujo Cosette
文豪ストレイドッグス | Bungou Stray Dogs
It mostly seems to be fandoms with characters not used in English in the tag.
no subject
Date: 2017-09-22 12:52 pm (UTC)For now, you can fix your garbled tags using this online encoder: http://toolswebtop.com/text/process/encode/windows-1252
Leave source encoding as "auto" and paste in your text. The file uploader may take a CSV, I'm not sure. When I pasted in your examples I got these back, which are correct tags.
レ・ミゼラブル 少女コゼット | Les Misérables: Shoujo Cosette
文豪ストレイドッグス | Bungou Stray Dogs
Hope this helps?!