Wikipedia:Help desk/Archives/2022 January 8

Welcome to the Wikipedia Help Desk Archives
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current Help Desk pages.

January 8

Convert table to template with display parameters

Hello Help deskers! I would like to convert a wikitable to a template. See {{Municipalities of Alberta}} for a truncated table of municipalities in Alberta that I intend to evolve into a working template with display parameters. Of the eight rows, there are two instances of four different municipal status types. I would like parameters for each of the four municipal status types.

• {{Municipalities of Alberta|cities=yes}} displays rows for municipalities that have city status and the "Total cities" sortbottom row
• {{Municipalities of Alberta|towns=yes}} displays rows for municipalities that have town status and the "Total towns" sortbottom row
• {{Municipalities of Alberta|villages=yes}} displays rows for municipalities that have village status and the "Total villages" sortbottom row
• {{Municipalities of Alberta|summervillages=yes}} displays rows for municipalities that have summer village status and the "Total summer villages" sortbottom row

Can anyone coach me on how to do this please? I am a relatively quick learner in a lead by example situation. In other words, please edit {{Municipalities of Alberta}} and I will analyze and learn from the diffs. Cheers, Hwy43 (talk) 00:47, 8 January 2022 (UTC)

Hi Hwy43. I tried to mark off a single row of the table with an <onlyinclude> section, but it didn't work. I have done something similar, but not for individual rows in a table, which may need a different solution. If I get some time, I will take a copy of your template a do some fiddling, because I would like to see if a solution is possible. --Verbarson ^talk_edits 12:13, 8 January 2022 (UTC)

Hello Verbarson. Thanks for taking a stab. I look forward to any input in future. I will approach the Wikipedia:WikiProject Templates as well. Cheers, Hwy43 (talk) 02:02, 9 January 2022 (UTC)

@Hwy43:, partially converted; summary rows currently non-parametrized (all summaries always included). See example below.

Show {{Municipalities of Alberta|cities=yes|towns=yes}}

List of municipalities in Alberta Name Status Region CD Neighbouring municipality Incorporated (current status) Council size Muni. census pop. (year) 2016 Census of Population Pop. in 2016 Pop. in 2011 Change (%) Land area (km2) Pop. density (per km2) Airdrie City Calgary Metro 6 Rocky View County January 1, 1985 7 70,564 (2019) 61,581 43,271 +42.3% 84.57 728.2/km2 Beaumont City Edmonton Metro 11 Leduc County January 1, 2019 7 18,829 (2018) 17,396 13,284 +31.0% 10.47 1,661.5/km2 Athabasca Town Northern Alberta 13 Athabasca County September 19, 1911 7 2,965 2,990 −0.8% 17.65 168.0/km2 Banff Town Alberta's Rockies 15 Improvement District No. 9 January 1, 1990 7 8,875 (2017) 7,851 7,584 +3.5% 4.77 1,645.9/km2 Total cities — — — — — — — 2,837,511 2,488,211 +14.0% 2,465.94 1,150.7/km2 Total towns — — — — — — — 453,775 420,051 +8.0% 1,246.10 364.2/km2 Total villages — — — — — — — 35,878 35,268 +1.7% 152.54 235.2/km2 Total summer villages — — — — — — — 5,176 4,586 +12.9% 40.79 126.9/km2 Total urban municipalities — — — — — — — 3,332,340 2,948,566 +13.0% 3,905.37 853.3/km2 Province of Alberta — — — — — — — 4,067,175 3,645,257 +11.6% 640,330.46 6.4/km2

Is that pretty much it? There's an introduced bug that messed up the values in the change percentage column. Haven't looked at that, maybe you can spot the problem and fix it. Also, it would be beneficial to change the conditionals to use the template {{yesno}} which allows more values than just yes (including y, true, 1, etc.) and so is more forgiving. Hope this helps, Mathglot (talk) 08:51, 9 January 2022 (UTC)

Fixed the bug; summary rows still need parametrizing by the same method; try it! Mathglot (talk) 09:20, 9 January 2022 (UTC)

As a practical matter, it looks like your small table is just a tester, and you plan to make a complete, A-Z table with lots of cities, right? Since the syntax of each row is not complex but extremely tedious, copy/pasting or typing errors are highly likely, and one misplaced vertical bar and the whole table will come out junk, and be extremely hard to debug. Even if you get it right, finally, it will be unmaintainable as the values change over time, no one will dare touch it, so it will slowly go out of date and become useless. So instead, create a subtemplate that generates one row with the proper syntax, e.g., {{muni AL row|Airdrie|C|January 1, 1985|61581|43271|84.57}} to generate row #2 with the proper syntax, and then the main table is just a collection of dozens of these row templates, one per urbanization, with the proper parser conditional around it (or pass the params through to the row, and have it return empty when appropriate), and then the whole thing will be both easier to create, and far easier to maintain. Good luck! Mathglot (talk) 09:42, 9 January 2022 (UTC)

Hi Mathglot. Thanks for the help! Dropping an interim note for now to acknowledge and advise that I will be studying what was done. I will return to ask some questions and more fulsomely respond. One spoiler alert though. I will want to further evolve the template, with optional parameterized columns as well. Cheers, Hwy43 (talk) 20:20, 9 January 2022 (UTC)

Hwy43, you're welcome. The current version should be considered only a way station on the road to a parametrized row template, without which the table-level template is ultimately doomed. For how to approach parametrizable columns, see for example this table template and this row template, but I can't stress enough how important it is to deal with the rows, first. A good exercise for you would be to alter the Alberta template so that only the proper summary rows are visible, depending on the parameters.

Also, I'm thinking that the general-interest portion of this discussion at the Help desk has about run its course, and as this discussion gets more technical maybe we should carry on at Template talk:Municipalities of Alberta, where it's more likely to be found and get feedback from interested readers. If you have no objection, I'll initiate one there (or you can just respond to this there instead of here) and we can link the conversations with {{Moved discussion}} so one can follow from one page to the other. Are you okay with that? Mathglot (talk) 22:16, 9 January 2022 (UTC)

Mathglot, I'd be thrilled with that! I have created the talk page and will start a thread using {{Moved discussion}}. Cheers, Hwy43 (talk) 22:35, 9 January 2022 (UTC)

Moved to Template talk:Municipalities of Alberta#Convert table to template with display parameters

Wikidata problem

I recently translated fi:Jamie MacDonald as Jamie MacDonald (Finnish comedian). I first moved the draft to Jamie MacDonald (comedian) and linked that article to the Wikidata item. Then I found out that there is more than one comedian named Jamie MacDonald, so I moved the article to Jamie MacDonald (Finnish comedian) without leaving a redirect behind. The resulting article did not appear to be connected to a Wikidata item, so I tried to link it to Wikidata again, only to be told that the item was already linked from Jamie MacDonald (Finnish comedian), the exact same article. The link to the Wikidata item, or the link to the original Finnish article, were nowhere to be seen. And they still don't show up, as I am writing this. The link from the original Finnish article to the English Wikipedia works, but not the other way around. What has caused this to be so muddled up, and how can it be remedied? Will I just have to wait until the English Wikipedia catches up with Wikidata? JIP | Talk 02:45, 8 January 2022 (UTC)

Purging the page seems to have fixed it. * Pppery * _{it has begun...} 03:05, 8 January 2022 (UTC)

Help Removing Twinkle

How do i remove twinkle? — Preceding unsigned comment added by ChromiumOverload (talk • contribs) 04:41, 8 January 2022 (UTC)

Have you tried disabling it at Special:Preferences#mw-prefsection-gadgets? --David Biddulph (talk) 05:54, 8 January 2022 (UTC)

asking my user level

Hi I am kunal, My usename is @Kunal7781. I am a Wikipedia editor. My account is 6 to 7 months old and I have made 10 to 15 edits. I want to ask that am I an autoconfirmed user? — Preceding unsigned comment added by Kunal7781 (talk • contribs) 06:30, 8 January 2022 (UTC)

Yes, you are; see this page. --David Biddulph (talk) 06:35, 8 January 2022 (UTC)

Wikipedia doesn't load on Windows 10

I'm trying to browse Wikipedia on Windows 10 but it won't load whatsoever. I can visit the Chinese version of any Wikipedia articles but pictures won't load; and other language versions don't load at all (I usually browse English, Russian, Chinese).

The pages load on MacOS and iOS under the same network. So I figured it's my PC/Windows. I tried multiple resettings such as disabling ipv6 but didn't work. Also, I had VPN on when doing these things; and since I'm based in China, turning it off is not an option. — Preceding unsigned comment added by 209.142.68.21 (talk) 06:38, 8 January 2022 (UTC)

What URL are you using? What browser are you using? When Wikipedia doesn't load, what do you see? GoingBatty (talk) 00:21, 10 January 2022 (UTC)

No one can help on this?

FYI

 – Combined sections. GoingBatty (talk) 00:25, 10 January 2022 (UTC)

I'm trying to browse Wikipedia on Windows 10 but it won't load whatsoever. I can visit the Chinese version of any Wikipedia articles but pictures won't load; and other language versions don't load at all (I usually browse English, Russian, Chinese).

The pages load on MacOS and iOS under the same network. So I figured it's my PC/Windows. I tried multiple resettings such as disabling ipv6 but didn't work. Also, I had VPN on when doing these things; and since I'm based in China, turning it off is not an option. — Preceding unsigned comment added by 38.64.78.149 (talk) 04:58, 9 January 2022 (UTC)

Hello. The fact that nobody has responded to this or your previous question suggests that nobody else has the problem (I use Windows 10 and have had no problem). You haven't said which browser you are using. But in any case, WP:VPT is a better place to ask about technical issues than the Help Desk. --ColinFine (talk) 09:20, 9 January 2022 (UTC)

I don't think they're using a browser - I think they may be using a Wikipedia app. I haven't said anything because I don't use the app and therefore can't offer advice other than "Use a standard web browser". —A little blue Bori v^_^v ^{Jéské Couriano} 16:20, 9 January 2022 (UTC)

How can I disable the Wikipedia dropdown toolbar?

The Wikipedia main page does not have a dropdown toolbar when you scroll down from the top of the page. But most pages on Wikipedia do have it. For example:

Help:Contents.

Is there some preference, gadget, script, user CSS/JS setting, etc. that will eliminate that dropdown toolbar? It takes up too much usable space on my screen. Especially since I often have the font zoom bar setting on Firefox at around 150%, 170%, etc.. Which makes that toolbar even larger. --Timeshifter (talk) 09:49, 8 January 2022 (UTC)

@Timeshifter: I assume you talk about the sticky header in the new vector versions. If you're talking about a different Skin, please state which. Assuming this refers to vector, this CSS snippet should do the trick:

.vector-sticky-header{
  display: none !important;
}

Hope this helps, Victor Schmidt (talk) 10:22, 8 January 2022 (UTC)

Victor Schmidt. Thanks! See:

https://en.wikipedia.org/wiki/User:Timeshifter/vector.css

I wish it was a preference, or a gadget. Many people would benefit. It's an accessibility setting. --Timeshifter (talk) 11:33, 8 January 2022 (UTC)

Help

How to implement patrol admin to pages with high level IP vandalism? Requesting protection does not give me enough measures. The Supermind (talk) 09:50, 8 January 2022 (UTC)

The Supermind If current protection levels for an article are insufficient, the protection can be raised, please request it at WP:RFPP. 331dot (talk) 10:03, 8 January 2022 (UTC)

Newspapers.com subscription

I thought I had a subscription to this service, that I got a while back from Wikipedia library. Can someone check this out, as I am not able to get to newspapers when I search "Cordelia E. Cook". I notice also that many results come up as Publisher Extra Subscription needed. Could I get access to this also? Thanks for looking into this.--Doug Coldwell (talk) 12:15, 8 January 2022 (UTC)

The people at WP:TWL will known more. Best Wishes, Lee Vilenski ^{(talk • contribs)} 12:38, 8 January 2022 (UTC)

Subscriptions expire. I had to renew mine a while back. Clarityfiend (talk) 19:35, 8 January 2022 (UTC)

Hi Doug Coldwell I am a person who helps out with subscriptions over at The Wikipedia Library, though I don't handle Newspapers.com. Your subscription to Newspapers.com will expire and need to be renewed annually, but you can apply for renewal starting at this page. If you're logged in to your account, once it's renewed, you should also have access to Publishers Extra papers. I just did a search like the one you described, I have a Newspapers.com subscription via TWL, and was able to see content from these newspapers. Hope that is helpful. Jessamyn (talk) 20:25, 10 January 2022 (UTC)

@Jessamyn: Great, that was useful. My application now says "Date of application - Jan. 8, 2022." Do you have an idea about how long it takes then to actually get the subscription, once it's "pending"? I am using the historical Newspapers to upgrade my 500 Did you know articles I created. I now have 202 Good Articles that is represented by the green icons on top of my User Page.--Doug Coldwell (talk) 21:29, 10 January 2022 (UTC)

@Doug Coldwell: I know for the stuff I review it's usually within the work week, but I think mine can be updated directly and I'm not sure if Newspapers.com is one of those or one that requires communication with the partner. Best thing is to go to the Wikipedia Library talk page here if you haven't seen movement by the end of this week. Good luck with writing more good articles! Jessamyn (talk) 22:24, 10 January 2022 (UTC)

Citing Excel documents

I want to cite a cell in an xslx (Excel) document, but not sure how to go about it. I was able to find this via the archive, but don't think I can cite it in the same way, as I don't have a website to cite as the origin of the file.

Because I'm trying to do this on my phone (don't have a computer!), I also can't find a way to link to it, but it *should* be the first result if you Google (other search engines are available!) "FY18Q2-FY21Q1 NAICS SB Avg Awar - SECRETARY OF THE NAVY".

Cheers in advance, RadiculousJ (talk) 13:21, 8 January 2022 (UTC)

The document appears to be https://www.secnav.navy.mil/smallbusiness/Documents/NAICS%20Awarded.xlsx --David Biddulph (talk) 13:32, 8 January 2022 (UTC)

Cheers David Biddulph, genuinely not sure how I wasn't able to get a link to it working. I assume I can just use the Cite web template, and use the "|at=" parameter to identify the relevant cell? RadiculousJ (talk) 14:38, 8 January 2022 (UTC)

Victor escobar

Kind editors of wikipedia, yesterday 61 year old victor escobar from Cali Colombia became the first person in latin america to recieve euthanasia for a non terminal illness. Please help me honor him by listing him in the recent deaths — Preceding unsigned comment added by 172.58.172.61 (talk) 13:28, 8 January 2022 (UTC)

Unless there is enough information from reliable sources to justify creation of an article about him, and such an article is created, this is not going to happen. --Orange Mike | Talk 15:05, 8 January 2022 (UTC)

Wikipedia's purpose is not to honor people.73.127.147.187 (talk) 19:51, 8 January 2022 (UTC)

I have added a note in the Colombia section of the Voluntary euthanasia article. Skarmory (talk • contribs) 11:00, 10 January 2022 (UTC)

How can I use vectorize maps for country regions

To denote regions of country using vectorize map, how can I use map. Can you show me an index page? For example, I want to use for regions in "Ethiopia" article. The Supermind (talk) 15:33, 8 January 2022 (UTC)