Let's Work Together! Database Entry Fixes

Hey everyone! I wanted to make this thread for sets of database entries with a common issue that would benefit from several database managers working on them at once (as to get through them faster + not put all the pressure on one person). Post suggestions for "raid bosses" (what me and some other mods/vibs use to refer to these mass entry fixes) here, and if you're working on them/have finished off previous raid bosses!

As a preliminary, please make sure your issues require the help of a raid before posting. For Series -> Product Line fixes (or et cetera changes), make an alert for that entry instead as they can all be changed at once. If your raid boss has been cleared, use the strikethrough for the post and then mark at the bottom as finished.

For a starter raid boss (and probably one of the biggest issues i've seen so far woof), here are Book entries marked with Paper material.

Here's a format suggestion (feel free to customize if needed)

Name of Raid Boss: Books with Paper listed as Material

MFC Link

Starter # Of Entries: >1400

Goal: Remove paper from materials from these entries, since books are implied to already be made of paper it is an unneccesary addition. Materials should be added when it is notably different from other books (say if it was made out of glass for some reason).

Please let me know if you have any questions, and how progress is going! I super appreciate the help :)
CLEARED

Down to 1000. This is my kind of work, did about 100 in an hour. Can't do more tonight, but I can probably do a little chunk or more quite often.

mintbunny • 2 months ago • #110001769Down to 1000. This is my kind of work, did about 100 in an hour. Can't do more tonight, but I can probably do a little chunk or more quite often. Tysm!!! I'm gonna dedicate some time to it tonight, I was working on product lines earlier and happened upon a few but now i got lazer focus B)

Are you saying acrylic should be removed from materials if the items are already classified under 'acrylic keychain', 'acrylic stand' etc? Same for rubber stuff and so on. Im trying to understand if this logic only applies to books or any material specific item types.

giyunosakedaikon • 2 months ago • #110002182Are you saying acrylic should be removed from materials if the items are already classified under 'acrylic keychain', 'acrylic stand' etc? Same for rubber stuff and so on. Im trying to understand if this logic only applies to books or any material specific item types.This was for the category "books" rather than a classification. The categories of hanged up/misc doesn't imply a material heavily like books does, hence the removal in this case.

If you're searching for "hanged up" and "acrylic", this is a valid search, searching for "books" and "paper" is... a wee bit pointless.

tharglet • 2 months ago • #110002610This was for the category "books" rather than a classification. The categories of hanged up/misc doesn't imply a material heavily like books does, hence the removal in this case.
If you're searching for "hanged up" and "acrylic", this is a valid search, searching for "books" and "paper" is... a wee bit pointless.
In case anyone is wondering, this is staff-approved.

MeatwadBishoujo • 2 months ago • #109852716wheeeeee and we are done!! There are a couple entries left that are outliers, but otherwise this is a huge raid boss defeated!! Thank you to everyone who helped, and I'll see you for the next raid boss B)

New Raid Boss y'all! This one is extremely easy but also a lot:

Name of Raid Boss: Madoka★Magica to Madoka☆Magica Tag

MFC Link

Starter # Of Entries: Approx. 2400

Goal: Refresh the tags on entries tagged with "Mahou Shoujo Madoka★Magica" so they turn into the "Mahou Shoujo Madoka☆Magica" tag. The original name was updated 10 months ago and since tags on entries don't automatically update, they have to be done manually. This isn't the most important raid boss, but it helps keep everything together!

Refreshing tags is super easy, you literally just click the tag button and it'll auto refresh. when it opens. Thanks so much, and let me know how far you get and if you finish up!

All the best,

Jelly (cancelled, can be fixed with a mod's help-- sorry y'all!)

MeatwadBishoujo • 1 month ago • #110664190New Raid Boss y'all! This one is extremely easy but also a lot:
Name of Raid Boss: Madoka★Magica to Madoka☆Magica Tag
MFC Link
Starter # Of Entries: Approx. 2400
Goal: Refresh the tags on entries tagged with "Mahou Shoujo Madoka★Magica" so they turn into the "Mahou Shoujo Madoka☆Magica" tag. The original name was updated 10 months ago and since tags on entries don't automatically update, they have to be done manually. This isn't the most important raid boss, but it helps keep everything together!
Refreshing tags is super easy, you literally just click the tag button and it'll auto refresh. when it opens. Thanks so much, and let me know how far you get and if you finish up!
All the best,
JellyI believe a mod/admin can just change the "label" on the old tag and delete/merge the newer one.

Adamska • 1 month ago • #110664199I believe a mod/admin can just change the "label" on the old tag and delete/merge the newer one.

...AH. I will double check with them, if that turns out to be the case... case closed wahoo we did it!! (i've got some other stuff on my list but i can save that for another day lol)

Most of the items under "Limited + Exclusive" on ENTRY #7626 are actually event limited items and missing the event. Would like help cleaning them up.

vhs • 1 month ago • #111349034Most of the items under "Limited + Exclusive" on ENTRY #7626 are actually event limited items and missing the event. Would like help cleaning them up. I can try to help! I'll get on it later, are they all at the same type of event or is it scattered?

MeatwadBishoujo • 1 month ago • #111356928I can try to help! I'll get on it later, are they all at the same type of event or is it scattered?
Scattered. Its usually mentioned what event it was in the further and additional info but others don't mention where they were sold at all so it requires research

General franchise cleanup for Madoka. alot of just undated items. Items with no dates go up to mid page 2
myfigurecollection.net/browse.v4.php?mode=search&rootId=1&status=-1&categoryId=-1&notTags[]=cancelled&notTags[]=doujin_goods&notTags[]=great_eastern_entertainment&orEntries[]=1379&orEntries[]=54587&orEntries[]=127617&orEntries[]=47818&orEntries[]=35666&domainId=-1&noReleaseDate=0&releaseTypeId=0&ratingId=0&isCastoff=0&hasBootleg=0&tagId=0&noBarcode=0&clubId=0&isDraft=0&year=2022&month=8&acc=0&separator=0&sort=date&output=2&current=notTags&order=asc&page=1
just put load the url manually bc the auto linker breaks it

vhs • 1 day ago • #112354216General franchise cleanup for Madoka. alot of just undated items. Items with no dates go up to mid page 2Fixed link: browse.v4.php?m...

(Have to use escape characters for the brackets [] → %5B%5D)

vhs • 1 day ago • #112354216General franchise cleanup for Madoka. alot of just undated items. Items with no dates go up to mid page 2
myfigurecollection.net/browse.v4.php?mode=search&rootId=1&status=-1&categoryId=-1&notTags[]=cancelled&notTags[]=doujin_goods&notTags[]=great_eastern_entertainment&orEntries[]=1379&orEntries[]=54587&orEntries[]=127617&orEntries[]=47818&orEntries[]=35666&domainId=-1&noReleaseDate=0&releaseTypeId=0&ratingId=0&isCastoff=0&hasBootleg=0&tagId=0&noBarcode=0&clubId=0&isDraft=0&year=2022&month=8&acc=0&separator=0&sort=date&output=2&current=notTags&order=asc&page=1
just put load the url manually bc the auto linker breaks it

Already started on some, I can't find a solid date for ITEM #1511643 though :(

vhs • 1 day ago • #112354216General franchise cleanup for Madoka. alot of just undated items. Items with no dates go up to mid page 2
myfigurecollection.net/browse.v4.php?mode=search&rootId=1&status=-1&categoryId=-1&notTags[]=cancelled&notTags[]=doujin_goods&notTags[]=great_eastern_entertainment&orEntries[]=1379&orEntries[]=54587&orEntries[]=127617&orEntries[]=47818&orEntries[]=35666&domainId=-1&noReleaseDate=0&releaseTypeId=0&ratingId=0&isCastoff=0&hasBootleg=0&tagId=0&noBarcode=0&clubId=0&isDraft=0&year=2022&month=8&acc=0&separator=0&sort=date&output=2&current=notTags&order=asc&page=1
just put load the url manually bc the auto linker breaks it
can maybe help with a handful of these. just going to put them in a spoiler

View spoilerHide spoilerITEM #82257 and relating entries

info: www.takaratomy-...

released dec. 2011 and should have the classification "Puella Magi Madoka Magica
Little Mascot 2" (jp: 魔法少女まどか☆マギカ
リトルマスコット2)

-

ITEM #115368 and relating entries

info: www.takaratomy-...

released july 2011 魔法少女まどか☆マギカ
根付メタルプレート - Puella Magi Madoka Magica
Netsuke Metal Plate

-

ITEM #150219

info: www.madoka-magi...
official site didn't give much info but heres a surugaya link: www.suruga-ya.j... - says release date was 2012/10/06

alongside other information (dimensions)

-

ITEM #189086 (are sayaka and kyouko missing?)
also not too sure if this even classifies as hanged up, misc seems better

for the earphone soul gem holders the event started on February 10th 2012. i'm only 50/50 on the date being correct.

not the official page but here's a documentation of the items at the event (somewhat): magica.tv/%E9%A...

-

ITEM #249538

www.geestore.co... october 2014

-

ITEM #300836 and relating entries

www.madoka-magi... - i found them on the official site but no date. however they seemingly came with a drink-combo food thing for the release of the recap movies? not too sure but, perhaps the date of the movie release would be correct?

-

ITEM #366949 + ultimate madoka

www.suruga-ya.j... released 2016/05/18

note, i'm pretty sure anything in that row right of the plushes (manu by sega) are apart of the same campaign, so their release should be the same too.

-

ITEM #613034 the kuji this was apart of released 10/31/2012 (ENTRY #37936)

-

ITEM #665228 and relating entries

the campaign they were apart of released 10/26/2013 as seen on their other entries (ENTRY #74193). also i think ITEM #1044453 may have been apart of the same one.
-

anything else is something i haven't found info on because i either ran into a dead end while searching, its too specific of a search for me to find it easily, or i found official pages but 0 information about the actual date of release. also a lot of clear files are finicky so i can't help much.

i also wanted to note that ENTRY #30425 is strangely hard to find information on (like, their kyuubey items, for example). maybe i'm just bad at looking for stuff they've manufactured but i've never had luck with them.