Loading

Database ManagersLet's Work Together! Database Entry Fixes

  • MeatwadBishoujo
    MeatwadBishoujoba-la-lai-i-ka!Very Important Boarder • lv42
    Offline44 replies
    #1
    2 months ago • Updated 2 months ago
    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.
  • MeatwadBishoujo
    MeatwadBishoujoba-la-lai-i-ka!Very Important Boarder • lv42
    Offline44 replies
    #2
    2 months ago • Updated 2 months ago
    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
  • mintbunny
    mintbunnyThe Geeky BunnyVery Important Boarder • lv26
    Offline627 replies
    #3
    2 months ago
    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.
  • MeatwadBishoujo
    MeatwadBishoujoba-la-lai-i-ka!Very Important Boarder • lv42
    Offline44 replies
    #4
    2 months ago
    mintbunny2 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)
  • giyunosakedaikon
    giyunosakedaikonRegular Boarder • lv66
    Offline405 replies
    #5
    2 months ago • Updated 2 months ago
    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.
    Do NOT participate in any GO this user hosts so this user does not host any GO.
  • tharglet
    thargletVery Important Boarder • lv23
    Offline906 replies
    #6
    2 months ago
    giyunosakedaikon2 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.
  • lorddralnu
    lorddralnuModerator • lv42
    Offline17 replies
    #7
    2 months ago
    tharglet2 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
    MeatwadBishoujoba-la-lai-i-ka!Very Important Boarder • lv42
    Offline44 replies
    #8
    2 months ago • Updated 2 months ago
    MeatwadBishoujo2 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)
  • MeatwadBishoujo
    MeatwadBishoujoba-la-lai-i-ka!Very Important Boarder • lv42
    Offline44 replies
    #9
    1 month ago • Updated 1 month ago
    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!)
  • Adamska
    AdamskaVery Important Boarder • lv28
    Offline66 replies
    #10
    1 month ago
    MeatwadBishoujo1 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,
    Jelly
    I believe a mod/admin can just change the "label" on the old tag and delete/merge the newer one.
  • MeatwadBishoujo
    MeatwadBishoujoba-la-lai-i-ka!Very Important Boarder • lv42
    Offline44 replies
    #11
    1 month ago
    Adamska1 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)
  • vhs
    vhsVery Important Boarder • lv27
    Offline108 replies
    #12
    1 month ago
    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.
  • MeatwadBishoujo
    MeatwadBishoujoba-la-lai-i-ka!Very Important Boarder • lv42
    Offline44 replies
    #13
    1 month ago
    vhs1 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?
  • vhs
    vhsVery Important Boarder • lv27
    Offline108 replies
    #14
    1 month ago
    MeatwadBishoujo1 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
  • vhs
    vhsVery Important Boarder • lv27
    Offline108 replies
    #15
    1 day ago
    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
  • Adamska
    AdamskaVery Important Boarder • lv28
    Offline66 replies
    #16
    1 day ago
    vhs1 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)
  • MeatwadBishoujo
    MeatwadBishoujoba-la-lai-i-ka!Very Important Boarder • lv42
    Offline44 replies
    #17
    1 day ago
    vhs1 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 :(
  • jestersparade
    jestersparadeRegular Boarder • lv14
    Offline156 replies
    #18
    1 day ago • Updated 1 day ago
    vhs1 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.
    https://64.media.tumblr.com/b25c7d7fd36ac1e6c7f5ce7623a0c978/ad0d95aaf5e168ae-f6/s400x600/64bc9775d851fdd9589eb9ae8948061222cf9245.png
    don't disturb him, he's fishing
  • Join the club to join the discussion.
  • 18 replies