Jan 4, 2020 6:19 AM
MAL Challenge Spreadsheet
Anime Relations:
Mudai
Automated spreadsheet for Yearly MAL Challenges
Based on last year's sheet with updated tweaks for it not to spam MAL's servers.
Link to spreadsheet
Based on last year's sheet with updated tweaks for it not to spam MAL's servers.
Link to spreadsheet
How to use:
- Fill the top right section with the information you'll use on both the 'MAL' and 'CompteRendu' tabs
- Select an anime / manga you'll be using for the challenge
- Choose on the corresponding MAL spreadsheet which topic you'll use it for
- Copy the prepared tags (from the L column), and add it to the selected anime / manga personal tags on MAL
- If the topic expects you to add more information or screenshots; put it into the H/I columns
- To update the spreadsheet; click on the big REFRESH button (this should require google's permission to edit your sheet)
- When it's time to export your participation form; simply copy / paste the post from the 'CompteRendu' tab into a notepad and then into the forum (to prevent your browser from interpolating characters)
Pros:
- Copy/paste the prepared tags into your personal entry for the anime you're planning to use and all public data will be filled in the sheet
- Almost nothing to do except watching anime / reading manga
Cons:
- It uses google apps' subset of javascript to run queries and everything can get awfully long there, just update and come back later
- On items like 2019's '(I.29) Finish an anime you put on-hold or dropped on or before July, 2018', the starting date is private, you have to set it yourself
- Only works with the new design for lists (If you're using the old design you can overwrite the formulas with your data or briefly swap to new design anyway)
- Since October 2020 or so there's a new warning with your mail address on the first run (screenshot), this is because the app is embedded in the spreadsheet and there is no single app I can have google verify. You'll just have to skip this warning.
You may report any issue you encounter as you're probably not the only one impacted.
As I don't get notified on comments please use both comments and PMs to report issues, I may then see the reports within a week.
Updates:
- December 28, 2020: I changed some parts for the sheet to update quicker
Posted by
Dysp
| Jan 4, 2020 6:19 AM |
6 comments
 |
Dysp | Jun 13, 2020 12:33 PM
My IP ban got lifted so I made another workaround if you're familiar with running code in your navigator (F12 key / console)-- Disclaimer -- Please keep in mind that running code you don't understand in your navigator is dangerous and shouldn't be done. Here are some resources if you don't trust me (you shouldn't) and want to look a bit deeper into it https://www.w3schools.com/js/js_htmldom.asp https://www.w3schools.com/js/js_json_parse.asp -- !Disclaimer -- The spreadsheet only requests MAL once to get your list and stores the data in an hidden page so if the sheet gets 403'ed and you don't you can fill this page manually - First click on the burger menu in the bottom left corner of the sheet and enable the "dataDump_[list type]" page - Clear everything that could be written there - Go to your list using your filter tag so that everything is loaded on the page (MAL loads ~250 items on page init iirc) Eg: my page is https://xss.now.cc/animelist/dysp?status=7&tag=AWC20 - Press F12, go to the console tab and paste the following code (remember to change the baseTag if yours isn't AWC20) baseTag="AWC20"; console.log(JSON.parse(document.querySelector(".list-table").dataset.items).map(item =>`${item.tags.split(/, */).filter(tag => tag.startsWith(baseTag) && tag.length > baseTag.length).map(x => x.substring(baseTag.length))[0]}\t${JSON.stringify({ title: item.anime_title || item.manga_title, id: item.anime_id || item.id, startDate: item.start_date_string, finishDate: item.finish_date_string })}`).join("\n")) - Paste the result in the "dataDump_[list type]" page (it should look like this https://puu.sh/FW1HZ/bb782c7835.png) - Go back to the other page (it should be processing your data) |
 |
Kuroiji | Jun 12, 2020 2:37 PM
Thanks for your answer!
|
|
Dysp | Jun 12, 2020 8:51 AM
There are some ongoing issues with MAL requests & 403sI'm locked out atm and the spreadsheet probably is too https://anime.plus/s/globals graph.anime.plus was stuck for several weeks but they cleared the queue today and removed the message saying they were affected by the 403s |
|
Kuroiji | Jun 11, 2020 5:17 PM
I get this error "Échec de la requête pour https://xss.now.cc. Code renvoyé : 403. Réponse tronquée du serveur : <html> <head><title>403 Forbidden</title></head> <body bgcolor="white"> <center><h1>403 Forbidden</h1></center> </body> </html> (Utilisez l'option muteHttpExceptions pour examiner la réponse entière.)" |
|
Dysp | Jan 25, 2020 3:42 AM
Diagnosis for @MrFluffyBun: this error is caused by the old list design (reference to the 3rd con)https://imgur.com/o6pnM5G -- Editing the -please report- part because I thought I'd get notifications for comments but I don't |
 |
MrFluffyBun | Jan 18, 2020 9:10 PM
Hi! I keep getting this error message when I try to run the script. SyntaxError: Unexpected token: uAlso, do the dates automatically update when you put in the anime link, name, and tag it on your MAL? |
|
Dysp | Jan 18, 2020 8:19 AM
Update 18/01Pretty dates were missing on section headers |