Lewis Hulbert

Welcome to Wikidata, Lewis Hulbert!

Wikidata is a free knowledge base that you can edit! It can be read and edited by humans and machines alike and you can go to any item page now and add to this ever-growing database!

Need some help getting started? Here are some pages you can familiarize yourself with:

• Introduction – An introduction to the project.
• Wikidata tours – Interactive tutorials to show you how Wikidata works.
• Community portal – The portal for community members.
• User options – including the 'Babel' extension, to set your language preferences.
• Contents – The main help page for editing and using the site.
• Project chat – Discussions about the project.
• Tools – A collection of user-developed tools to allow for easier completion of some tasks.

Please remember to sign your messages on talk pages by typing four tildes (~~~~); this will automatically insert your username and the date.

If you have any questions, don't hesitate to ask on Project chat. If you want to try out editing, you can use the sandbox to try. Once again, welcome, and I hope you quickly feel comfortable here, and become an active editor for Wikidata.

Best regards! Jon Harald Søby (talk) 01:32, 11 October 2017 (UTC)

Wikidata:Property proposal/cpcrulez

Thank you for your update on this property proposal. Indeed, I'm a newbie in Wikidata and so, I didn't know the syntax for the formatter URL. Many many thanks to you! YotaMoteuchi (talk) 07:20, 28 August 2018 (UTC)

Wikidata:Property proposal/IGDB game ID

Hey,

Thank you for proposing this property! Next time, can you please make sure to ping the Wikiproject (using {{ping project|Video games}})? I likely would have liked to give input on this (and I can imagine that User:Diggr would have had too).

Thanks :)

Jean-Fred (talk) 13:21, 7 September 2018 (UTC)

In this case (and that’s the reason why I had not proposed that property myself yet :) ) there is likely an argument to be made on whether we should record the slug or the id − cf the data structure returned by their API:

  {
    "id": 1942,
    "name": "The Witcher 3: Wild Hunt",
    "slug": "the-witcher-3-wild-hunt",
    "url": "https://www.igdb.com/games/the-witcher-3-wild-hunt",
    …
  }

Jean-Fred (talk) 13:25, 7 September 2018 (UTC)

@Jean-Frédéric: I’m sorry about that and I’ll ping the project in future proposals, I’ve just always been worried about pinging too much and being an annoyance. The property is still barely in use so a discussion could still be started on which ID to use. I couldn’t find any formatter URL that uses the id, but if there was one, it seems like it could be more stable than using the slug. Lewis Hulbert (talk) 22:41, 7 September 2018 (UTC)

@Lewis Hulbert: No worries :) Initially I was also worried of spamming people with too many pings, but I think Property proposals are worth it. Also, I would like the project to be a bit more alive − I notice several people doing great work, but we’re not really collaborating much, bouncing ideas off each other. I think I’d rather have too many pings showing me other people doing good work, rather than not enough and it feels like a deserted area ;-)

Jean-Fred (talk) 11:12, 10 September 2018 (UTC)

Hi there! I asked on the igdb discord channel and here is the answere: "You can base36 encode the I'd to create a short url like https://www.igdb.com/g/7ef" So, I think, this doesn't work with wikidata... Diggr (talk) 15:51, 10 September 2018 (UTC)

How to improve your Animal Crossing items

• Please remember to include from narrative universe (P1080): Animal Crossing universe (Q93597446)
• As these are anthropomorphic characters you should use sex or gender (P21) female/male instead of female organism/male organism
• Remember to include first appearance (P4584)

--Trade (talk) 13:24, 8 May 2020 (UTC)

@Trade: Thanks for letting me know. I was never sure about sex or gender (P21) and assumed that being an instance of Q89598576 made the fictional universe property redundant. I'll go make sure first appearance (P4584) is included on all of them. Lewis Hulbert (talk) 15:00, 8 May 2020 (UTC)

You should also remember using instance of anthropomorphic fox (Q88555103) instead of fictional fox (Q19594662))--Trade (talk) 15:05, 8 May 2020 (UTC)

We sent you an e-mail

Hello Lewis Hulbert,

Really sorry for the inconvenience. This is a gentle note to request that you check your email. We sent you a message titled "The Community Insights survey is coming!". If you have questions, email surveys@wikimedia.org.

You can see my explanation here.

MediaWiki message delivery (talk) 18:46, 25 September 2020 (UTC)

Offline TV

I'm a bit confused why you manually reverted my edit and then later re-added the exact same information? --Jeanjung212 (talk) 07:38, 16 October 2020 (UTC)

I wasn't sure how I removed it, so I added it back when I noticed it was missing. I'm not sure what a "Manual revert" is, I see it there on the edit history but I'm not sure what button I pressed to actually do it. Lewis Hulbert (talk) 18:23, 19 November 2020 (UTC)

1M+ subscribers (youtube.fandom.com)

Not sure if you've noteiced it but the links are dead. --Trade (talk) 09:39, 29 March 2021 (UTC)

• @Trade: Yeah, couldn't work out how to fix it last night and gave up. Seems like mix'n'match automatically pulls the formatter URL from Fandom article ID (P6262) rather than me being able to enter it manually now - but it's using the first formatter URL which is deprecated rather than any of the preferred ones. Lewis Hulbert (talk) 12:11, 29 March 2021 (UTC)

  Could you write an guide on how to use M'n'M to pull entries from Fandom categories? The current guides are rather incomprehensible --Trade (talk) 12:15, 29 March 2021 (UTC)

  @Trade: I've actually never been able to understand the feature intended for Mediawiki categories either. I've just been using Special:Export on the wiki itself (example on YouTube.fandom) and loading the data into a spreadsheet for import. Lewis Hulbert (talk) 12:20, 29 March 2021 (UTC)

  Are the -xml file supposed to include all the Wiki text from each individual Fandom article? I'm unsure how i'm supposed to fit this into a spreadsheet. --Trade (talk) 09:18, 30 March 2021 (UTC)

  This is what i got (justpaste. it/9q40o)--Trade (talk) 09:23, 30 March 2021 (UTC)

  @Trade: apologies for the (very) late response. The only part I use from the XML export is the <title> attributes after using regex on them in a text editor. You need a minimum of 3 columns to import the data into Mix'n'Match, ID, Name and Description. I'll use <title>Carl Johnson</title> as the example.

ID: add the wiki prefix (in this case it's gta:) to the start of the line and replace the spaces with underscores, gta:Carl_Johnson

Name: for the most part you can just leave this exactly the same as the original value but you might want to remove any suffixes like (character) to make the auto matching work better, Carl Johnson

Description: usually it's pretty difficult to automatically pick something out of the data itself so I pick something generic that can apply to every article I've exported, in this case character from Grand Theft Auto would work. You should end up with a table that looks like this:

ID	Name	Description
gta:Carl_Johnson	Carl Johnson	character from Grand Theft Auto
gta:Stretch_(character)	Stretch	character from Grand Theft Auto
gta:Brucie_Kibbutz	Brucie Kibbutz	character from Grand Theft Auto

Apologies that I can't make a complete spreadsheet for an example right now as I only have access to a phone. Lewis Hulbert (talk) 11:59, 8 May 2021 (UTC)

Late reply. Could you elaborate on "after using regex on them in a text editor" I assume you are using the text editor to delete everything not between <title> and </title> Trade (talk) 00:13, 28 March 2024 (UTC)

Honestly, I can't really remember what I was doing 3 years ago - but I've figured out something close enough. It's probably not the best way to do it because I'm not too proficient with RegEx, but it does the job.

• Find and replace ^(?!<title>.+<\/title>).*$ with an empty string (deletes every line that isn't a title)
• Replace ^\n$ with an empty string, or use the text editor's built-in method to clear up empty lines.
• Replace <title>(.*)</title> with gta:$1\t$1\tcharacter from Grand Theft Auto (formats the lines in TSV format for M'n'M)
• Replace ^([^\t]*)[ ] with $1_ until there's no more results. (replaces spaces with underscores in the ID)

Then the result should be something like justpaste. it/ae0da, created from the paste you sent before. I could alternatively make a script for this if needed, but I never bothered because I only did this a handful of times.

--Lewis Hulbert (talk) 05:23, 28 March 2024 (UTC)

Does this work with Miraheze as well? Trade (talk) 23:01, 14 April 2024 (UTC)

I've never actually tried, but I imagine it should work for any MediaWiki website. Lewis Hulbert (talk) 09:14, 15 April 2024 (UTC)

I remember i used a free word processor with green UI by default when making batches but i forgot the name of it. Any ideas? I haven't downloaded one yet after reinstalling my PC Trade (talk) 20:27, 25 April 2024 (UTC)

Property creator

Following your request, I have granted you the property creator flag. Regards, Esteban16 (talk) 18:29, 8 February 2024 (UTC)

SteamGridDB

Do you have time to make a Mix'n'Match catalogue of the database at some point? Trade (talk) 00:12, 28 March 2024 (UTC)

@Trade: I will definitely try - I haven't figured out if there's any way to reasonably extract the data yet. There was a specific endpoint for looking up by Steam ID, which has given me 50,000+ IDs ready to import - though it would be very nice to have a Mix'n'Match catalogue for the non-Steam games. (also replied to the message up above, didn't want to ping twice) --Lewis Hulbert (talk) 05:31, 28 March 2024 (UTC)

You can just make a catalog for Wii U games for an start

https://www.steamgriddb.com/projects/wii-u Trade (talk) 04:43, 29 March 2024 (UTC)

I don't think Mix'n'Match is working properly right now, but the catalogue will be at https://mix-n-match.toolforge.org/#/catalog/6277 whenever it's working again. Lewis Hulbert (talk) 05:18, 29 March 2024 (UTC)

Could i please get a vote on Touhou Wiki ID?--Trade (talk) 20:25, 2 April 2024 (UTC)

Sure. I've never really known much about Touhou, but it does seem like a high quality wiki. --Lewis Hulbert (talk) 20:41, 2 April 2024 (UTC)

Any chance you could match IsThereAnyDeal identifiers with the Steam ID located in the entries`?  – The preceding unsigned comment was added by Trade (talk • contribs) at 14:07, 12 April 2024 (UTC).

I might have a go at some point, I'm not sure what their API is actually capable of since I haven't signed up for it yet. --Lewis Hulbert (talk) 14:29, 12 April 2024 (UTC)

Alright. If you ever get could you take a look at the Trustpilot API at some point? I was thinking of a Mix'n'Match catalog of entries with more than 1000 reviews but i dont know if the API is capable of that Trade (talk) 14:53, 13 April 2024 (UTC)