Page MenuHomePhabricator

JeanFred (Jean-Frédéric)
Volunteer

Projects (9)

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Oct 6 2014, 10:01 PM (469 w, 9 h)
Availability
Available
IRC Nick
JeanFred
LDAP User
Jean-Frédéric
MediaWiki User
Jean-Frédéric [ Global Accounts ]

Developer of Tool-inteGraality. Maintainer of Tool-wikiloves and Wiki-Loves-Monuments

Recent Activity

Yesterday

JeanFred closed T302314: Table not updating as Invalid.

Closing as invalid, as there is nothing much I can do there from the service side.

Mon, Oct 2, 6:02 PM · Tool-inteGraality
JeanFred moved T347897: integraality column for EntitySchema compliance? from Backlog to Enhancements on the Tool-inteGraality board.
Mon, Oct 2, 6:00 PM · Tool-inteGraality
JeanFred created T347897: integraality column for EntitySchema compliance?.
Mon, Oct 2, 5:53 PM · Tool-inteGraality
JeanFred committed R2566:3f9a3d5193c5: Do not crash on redirected items when formatting grouping links (authored by JeanFred).
Do not crash on redirected items when formatting grouping links
Mon, Oct 2, 9:29 AM

Wed, Sep 27

JeanFred committed R2566:07ef2b53c351: Do not add higher grouping empty column when there is no higher grouping (authored by JeanFred).
Do not add higher grouping empty column when there is no higher grouping
Wed, Sep 27, 7:29 AM

Tue, Sep 26

JeanFred committed R2566:ac64840b866c: Move SPARQL-formatting code from `get_query_for_items_for_property_negative` to… (authored by JeanFred).
Move SPARQL-formatting code from `get_query_for_items_for_property_negative` to…
Tue, Sep 26, 6:36 PM
JeanFred committed R2566:6178698830ca: Leverage GroupingConfiguration in Column.get_info_query (authored by JeanFred).
Leverage GroupingConfiguration in Column.get_info_query
Tue, Sep 26, 6:36 PM
JeanFred committed R2566:06cb52d776e9: Move SPARQL-formatting code from `get_query_for_items_for_property_positive` to… (authored by JeanFred).
Move SPARQL-formatting code from `get_query_for_items_for_property_positive` to…
Tue, Sep 26, 6:36 PM
JeanFred committed R2566:63ab29722796: Remove redundant attributes from PropertyStatistics (authored by JeanFred).
Remove redundant attributes from PropertyStatistics
Tue, Sep 26, 6:36 PM
JeanFred committed R2566:3e3f47fc9d08: Add GroupingConfiguration object as attribute to PropertyStatistics (authored by JeanFred).
Add GroupingConfiguration object as attribute to PropertyStatistics
Tue, Sep 26, 6:36 PM
JeanFred committed R2566:c88ad3537bc4: Move some SPARQL-related things to `sparql_utils.py` (authored by JeanFred).
Move some SPARQL-related things to `sparql_utils.py`
Tue, Sep 26, 6:36 PM
JeanFred committed R2566:e575508be446: Move `get_grouping_information` logic to GroupingConfiguration (authored by JeanFred).
Move `get_grouping_information` logic to GroupingConfiguration
Tue, Sep 26, 6:36 PM
JeanFred committed R2566:a8029ed6def8: Introduce GroupingConfiguration concept tree (authored by JeanFred).
Introduce GroupingConfiguration concept tree
Tue, Sep 26, 6:36 PM

Mon, Sep 18

JeanFred created T346681: Known fields for ua_uk.
Mon, Sep 18, 7:03 PM · Patch-For-Review, Wiki-Loves-Monuments-Database
JeanFred closed T231796: 502 Bad Gateway error in wikiloves images view when passing a user as Resolved.

Four years later, finally took the time to look into it properly :)

Mon, Sep 18, 4:12 PM · Tool-wikiloves
JeanFred merged T316917: 502 error on visiting the user subpage of a competition into T231796: 502 Bad Gateway error in wikiloves images view when passing a user.
Mon, Sep 18, 4:07 PM · Tool-wikiloves
JeanFred merged task T316917: 502 error on visiting the user subpage of a competition into T231796: 502 Bad Gateway error in wikiloves images view when passing a user.
Mon, Sep 18, 4:07 PM · Tool-wikiloves

Wed, Sep 6

JeanFred committed R2566:3caa9ed1f48d: Add tox target to reformat Python files using Black (authored by JeanFred).
Add tox target to reformat Python files using Black
Wed, Sep 6, 8:16 AM

Aug 29 2023

JeanFred created T345155: Pre-fill “Title language code” based on album statements (P407).
Aug 29 2023, 1:08 PM · Tool-multitrack-drafting

Aug 28 2023

JeanFred closed T338987: Multiple DB-related errors during harvesting as Resolved.

Harvesting has been stable for a few days now − closing as Resolved 🎉

Aug 28 2023, 9:12 AM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Should the "SET sql_mode =" patch also be applied to the other sql templates (classic_table.sql.template and wikidata_table.sql.template)?

Aug 28 2023, 9:11 AM · Data-Services, Wiki-Loves-Monuments-Database

Aug 27 2023

JeanFred added a comment to T249678: Add OAuth login to mailman for accessing list memberships/archive viewing.

The appstream patch was merged, will be presumably released with 0.45 (maybe some time around the end of the year, based on their average release frequency).

Aug 27 2023, 9:58 PM · Wikimedia-Hackathon-2021, Upstream, SRE, Wikimedia-Mailing-lists

Aug 25 2023

JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

@Lokal_Profil Thanks! I have the two STRICT_TRANS_TABLES open patches manually applied on the server, so I’ll only be able to deploy your changes once they are merged.

Aug 25 2023, 9:29 AM · Data-Services, Wiki-Loves-Monuments-Database

Aug 24 2023

JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Grepping through the logs for errors, only 2:

ERROR: Unknown error occurred when processing country de-he in lang de
(1048, "Column 'wd_item' cannot be null")
Aug 24 2023, 6:31 PM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Monuments Database is back to 1.7M monuments 🎉 https://commons.wikimedia.org/wiki/Commons:Monuments_database/Statistics

Aug 24 2023, 2:41 PM · Data-Services, Wiki-Loves-Monuments-Database

Aug 23 2023

JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Harvesting ran today without issue − until the very last step:

2023-08-23_18:22:51 Update monuments_all table...
ERROR 1292 (22007) at line 514: Truncated incorrect DECIMAL value: ''
Aug 23 2023, 6:32 PM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Edited the code in place on Toolforge to add a sql_mode argument to the pymysql connection object. If that works out, I’ll submit a Gerrit patch.

Aug 23 2023, 7:27 AM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Ah, so the SQL mode setting simply does not stick. Running again:

MariaDB [s51138__heritage_p]> SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE;
+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+
| @@SQL_MODE                                                                                | @@GLOBAL.SQL_MODE                                                                         |
+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+
| STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------+
Aug 23 2023, 7:18 AM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Hmmm, running SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE; again in s51138__heritage_p I’m getting

Aug 23 2023, 7:13 AM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Harvesting ran over night − still 84 errors :/

ERROR: Unknown error occurred when processing country ir in lang fa
(1406, "Data too long for column 'image' at row 1")
--
ERROR: Unknown error occurred when processing country se-arbetsl in lang sv
(1406, "Data too long for column 'id' at row 1")
--
ERROR: Unknown error occurred when processing country de-nrw-bm in lang de
(1406, "Data too long for column 'beschreibung' at row 1")
--
ERROR: Unknown error occurred when processing country es-ct in lang ca
(1265, "Data truncated for column 'prot' at row 1")
--
ERROR: Unknown error occurred when processing country ro in lang ro
(1406, "Data too long for column 'adresa' at row 1")
--
ERROR: Unknown error occurred when processing country be-vlg in lang fr
(1406, "Data too long for column 'classement' at row 1")
--
ERROR: Unknown error occurred when processing country ie in lang en
(1265, "Data truncated for column 'number' at row 1")
--
ERROR: Unknown error occurred when processing country hu in lang hu
(1265, "Data truncated for column 'site' at row 1")
--
ERROR: Unknown error occurred when processing country ch2 in lang de
(1406, "Data too long for column 'fotobeschreibung' at row 1")
--
ERROR: Unknown error occurred when processing country gb-eng in lang en
(1406, "Data too long for column 'name' at row 1")
--
ERROR: Unknown error occurred when processing country rs in lang sr
(1265, "Data truncated for column 'site' at row 1")
--
ERROR: Unknown error occurred when processing country be-wal in lang fr
(1406, "Data too long for column 'nom_objet' at row 1")
--
ERROR: Unknown error occurred when processing country uy in lang es
(1406, "Data too long for column 'monumento' at row 1")
--
ERROR: Unknown error occurred when processing country es in lang ca
(1265, "Data truncated for column 'prot' at row 1")
--
ERROR: Unknown error occurred when processing country gb-nir in lang en
(1406, "Data too long for column 'hb' at row 1")
--
ERROR: Unknown error occurred when processing country aq in lang en
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country ch-old in lang en
(1265, "Data truncated for column 'kgs_nr' at row 1")
--
ERROR: Unknown error occurred when processing country no in lang no
(1265, "Data truncated for column 'id' at row 1")
--
ERROR: Unknown error occurred when processing country us-ca in lang en
(1265, "Data truncated for column 'refnum' at row 1")
--
ERROR: Unknown error occurred when processing country fr in lang fr
(1406, "Data too long for column 'notice' at row 1")
--
ERROR: Unknown error occurred when processing country it-bz in lang de
(1406, "Data too long for column 'beschreibung' at row 1")
--
ERROR: Unknown error occurred when processing country ca-prov in lang en
(1366, "Incorrect integer value: '––' for column `s51138__heritage_p`.`monuments_ca-prov_(en)`.`idm` at row 1")
--
ERROR: Unknown error occurred when processing country th in lang th
(1265, "Data truncated for column 'site' at row 1")
--
ERROR: Unknown error occurred when processing country il in lang he
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country de-he in lang de
(1406, "Data too long for column 'beschreibung' at row 1")
--
ERROR: Unknown error occurred when processing country pt in lang pt
(1406, "Data too long for column 'designacoes' at row 1")
--
ERROR: Unknown error occurred when processing country fr-object in lang fr
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country mx in lang es
(1406, "Data too long for column 'id' at row 1")
--
ERROR: Unknown error occurred when processing country be-bru in lang nl
(1406, "Data too long for column 'bouwdoor' at row 1")
--
ERROR: Unknown error occurred when processing country au in lang en
(1366, "Incorrect double value: '' for column `s51138__heritage_p`.`monuments_au_(en)`.`lon` at row 35")
--
ERROR: Unknown error occurred when processing country be-wal in lang nl
(1406, "Data too long for column 'descr_nl' at row 1")
--
ERROR: Unknown error occurred when processing country gb-sct in lang en
(1265, "Data truncated for column 'hb' at row 1")
--
ERROR: Unknown error occurred when processing country es-vc in lang ca
(1265, "Data truncated for column 'prot' at row 1")
--
ERROR: Unknown error occurred when processing country hr in lang hr
(1406, "Data too long for column 'arhitekt' at row 1")
--
ERROR: Unknown error occurred when processing country jp-nhs in lang en
(1406, "Data too long for column 'comments' at row 1")
--
ERROR: Unknown error occurred when processing country za in lang en
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country pa in lang es
(1406, "Data too long for column 'descripcion' at row 1")
--
ERROR: Unknown error occurred when processing country ar in lang es
(1406, "Data too long for column 'direccion' at row 1")
--
ERROR: Unknown error occurred when processing country sr in lang commons
(1366, "Incorrect double value: '' for column `s51138__heritage_p`.`monuments_sr_(nl)`.`lon` at row 2")
--
ERROR: Unknown error occurred when processing country pl in lang pl
(1406, "Data too long for column 'nazwa' at row 1")
--
ERROR: Unknown error occurred when processing country in in lang en
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country es in lang es
(1406, "Data too long for column 'lugar' at row 1")
--
ERROR: Unknown error occurred when processing country wlpa-es-ct in lang ca
(1406, "Data too long for column 'descripcio' at row 1")
--
ERROR: Unknown error occurred when processing country be-wal in lang en
(1406, "Data too long for column 'descr_nl' at row 1")
--
ERROR: Unknown error occurred when processing country us in lang en
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country at in lang de
(1406, "Data too long for column 'beschreibung' at row 1")
--
ERROR: Unknown error occurred when processing country dk-bygning in lang da
(1265, "Data truncated for column 'systemnrbyg' at row 1")
--
ERROR: Unknown error occurred when processing country by in lang be-tarask
(1406, "Data too long for column 'name' at row 1")
--
ERROR: Unknown error occurred when processing country eg in lang ar
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country de-nrw-k in lang de
(1406, "Data too long for column 'beschreibung' at row 1")
--
ERROR: Unknown error occurred when processing country mt in lang de
(1406, "Data too long for column 'beschreibung' at row 1")
--
ERROR: Unknown error occurred when processing country ug in lang en
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country ca-fed in lang en
(1406, "Data too long for column 'address' at row 1")
--
ERROR: Unknown error occurred when processing country tn in lang fr
(1406, "Data too long for column 'monument' at row 1")
--
ERROR: Unknown error occurred when processing country il-npa in lang he
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country nl in lang nl
(1265, "Data truncated for column 'type_obj' at row 1")
--
ERROR: Unknown error occurred when processing country cn in lang en
(1406, "Data too long for column 'designation' at row 1")
--
ERROR: Unknown error occurred when processing country be-vlg in lang en
(1406, "Data too long for column 'address' at row 1")
--
ERROR: Unknown error occurred when processing country pe in lang es
(1406, "Data too long for column 'direccion' at row 1")
--
ERROR: Unknown error occurred when processing country ee in lang et
(1406, "Data too long for column 'aadress' at row 1")
--
ERROR: Unknown error occurred when processing country nl-gem in lang nl
(1406, "Data too long for column 'objnr' at row 1")
--
ERROR: Unknown error occurred when processing country ph in lang en
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country it in lang it
(1265, "Data truncated for column 'site' at row 1")
--
ERROR: Unknown error occurred when processing country gh in lang en
(1406, "Data too long for column 'id' at row 1")
--
ERROR: Unknown error occurred when processing country sk in lang de
(1406, "Data too long for column 'beschreibung-de' at row 1")
--
ERROR: Unknown error occurred when processing country be-vlg in lang nl
(1406, "Data too long for column 'adres' at row 1")
--
ERROR: Unknown error occurred when processing country de-by in lang de
(1406, "Data too long for column 'beschreibung' at row 1")
--
ERROR: Unknown error occurred when processing country iq in lang ar
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country es-gl in lang gl
(1406, "Data too long for column 'notas' at row 1")
--
ERROR: Unknown error occurred when processing country fr in lang ca
(1265, "Data truncated for column 'prot' at row 1")
--
ERROR: Unknown error occurred when processing country cz in lang cs
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country dk-fortids in lang da
(1265, "Data truncated for column 'fredningsnummer' at row 1")
--
ERROR: Unknown error occurred when processing country am in lang hy
(1406, "Data too long for column 'id' at row 1")
--
ERROR: Unknown error occurred when processing country gb-wls in lang en
(1406, "Data too long for column 'notes' at row 1")
--
ERROR: Unknown error occurred when processing country wlpa-at in lang de
(1406, "Data too long for column 'Beschreibung' at row 1")
--
ERROR: Unknown error occurred when processing country ru in lang ru
(1406, "Data too long for column 'description' at row 1")
--
ERROR: Unknown error occurred when processing country ua in lang uk
(1265, "Data truncated for column 'site' at row 1")
--
ERROR: Unknown error occurred when processing country cl in lang es
(1366, "Incorrect integer value: 'S/N' for column `s51138__heritage_p`.`monuments_cl_(es)`.`id` at row 1")
--
ERROR: Unknown error occurred when processing country ch in lang de
(1406, "Data too long for column 'anzeige-adresse' at row 1")
--
ERROR: Unknown error occurred when processing country pt-wd in lang pt
(1366, "Incorrect double value: '' for column `s51138__heritage_p`.`monuments_pt-wd_(pt)`.`lon` at row 3")
--
ERROR: Unknown error occurred when processing country co in lang es
(1406, "Data too long for column 'id' at row 1")
--
ERROR: Unknown error occurred when processing country ca-muni in lang en
(1366, "Incorrect integer value: '––' for column `s51138__heritage_p`.`monuments_ca-muni_(en)`.`idm` at row 1")
--
ERROR 1292 (22007) at line 514: Truncated incorrect DECIMAL value: ''
2023-08-23_04:30:04 Restart the categorization job...
--
ERROR: Unknown error occurred when processing country in-com in lang commons
Language 'commons' does not exist in family wikipedia
Aug 23 2023, 7:11 AM · Data-Services, Wiki-Loves-Monuments-Database

Aug 22 2023

JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Nice one! Can this task be resolved, or is there something else that you would like to fix?

Aug 22 2023, 7:28 PM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

(The annoying thing is that I don’t have yet support to test such things in my local docker-compose setup)

Why not? It should work if you use a similar MariaDB version.

Aug 22 2023, 12:42 PM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

(The annoying thing is that I don’t have yet support to test such things in my local docker-compose setup)

Aug 22 2023, 10:08 AM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

The problem could be that innodb_strict_mode changed from OFF to ON in MariaDB 10.2. Try set innodb_strict_mode = OFF; before issuing your query.

Aug 22 2023, 9:21 AM · Data-Services, Wiki-Loves-Monuments-Database

Aug 21 2023

JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.
Aug 21 2023, 7:36 PM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

It seems to me that "Data too long for column X" means bad data in the source tables. The harvesting used to ignore that, now it does not. The proper fix is to correct the source data, but we can’t do all that.

Aug 21 2023, 7:35 PM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

One example of

(1406, "Data too long for column 'image' at row 1")

Aug 21 2023, 7:28 PM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

One example of

(1366, "Incorrect double value: '' for column s51138__heritage_p.monuments_pk_(en).lon at row 1")

would be

REPLACE INTO monuments_pk_(en) (source, number, prov_iso, description, address, district, lon, monument_article, registrant_url) VALUES (//en.wikipedia.org/w/index.php?title=List_of_cultural_heritage_sites_in_Balochistan,_Pakistan&oldid=1139504719, BA-2, PK-BA, [[Nindo Damb]], Ornach Valley, Tehsil Wadh, [[Killa Abdullah District]], , Nindo_Damb, BA-2)

Aug 21 2023, 5:15 PM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred added a comment to T341773: Update queries based on templatelinks migration to use linktaget.

@JeanFred I see that there are some local changes on heritage (check_emailable_users.py and database_config.default.yml) unsure if they should be kept or not so not deploying this just yet.

Aug 21 2023, 3:38 PM · Wiki-Loves-Monuments-Database
JeanFred assigned T318644: Include Wiki Loves Food in the Wikiloves tool to Bodhisattwa.

@Bodhisattwa Could you take care of adding the necessary configuration for the remaining years ?

Aug 21 2023, 8:51 AM · Tool-wikiloves

Jul 4 2023

JeanFred added a comment to T332899: [EPIC] Migrate selected R-based Wikidata products [up to milestone 3].

Hey @AndrewTavis_WMDE & @Manuel , I only used the dashboard to get a nice visualization of the external ID galaxy − see this slide (the red bubble is the video-game related IDs)

ExternalIds.png (768×1 px, 753 KB)

Jul 4 2023, 5:31 PM · Wikidata Analytics, Epic, Wikidata

Jun 20 2023

JeanFred updated subscribers of T332899: [EPIC] Migrate selected R-based Wikidata products [up to milestone 3].

I was pointed to this ticket by @Lydia_Pintscher: I wanted to update a presentation slide that uses https://wikidata-analytics.wmcloud.org/app_direct/WD_ExternalIdentifiersDashboard (that’s the only dashboard I can remember using)

Jun 20 2023, 7:40 PM · Wikidata Analytics, Epic, Wikidata

Jun 14 2023

JeanFred added a comment to T338987: Multiple DB-related errors during harvesting.

Likely related to the MariaDB upgrade T301949

Jun 14 2023, 5:51 AM · Data-Services, Wiki-Loves-Monuments-Database

Jun 13 2023

JeanFred triaged T338987: Multiple DB-related errors during harvesting as High priority.

Looks like this is happening since April 7th

Jun 13 2023, 6:26 PM · Data-Services, Wiki-Loves-Monuments-Database
JeanFred created T338987: Multiple DB-related errors during harvesting.
Jun 13 2023, 6:19 PM · Data-Services, Wiki-Loves-Monuments-Database

Jun 11 2023

JeanFred committed R2566:9712666babc4: Guard against empty result in `populate_groupings` when getting the counts for… (authored by JeanFred).
Guard against empty result in `populate_groupings` when getting the counts for…
Jun 11 2023, 1:16 PM
JeanFred committed R2566:649259f45d16: Extract method `populate_groupings` from `retrieve_data` (authored by JeanFred).
Extract method `populate_groupings` from `retrieve_data`
Jun 11 2023, 1:16 PM
JeanFred committed R2566:5aecae8a131f: Include cells contents in Grouping equality operator (authored by JeanFred).
Include cells contents in Grouping equality operator
Jun 11 2023, 1:16 PM
JeanFred added a comment to T338684: Hard crash when configured with a column (property) that is never used on any items.

Confirmed that https://www.wikidata.org/w/index.php?title=User%3AAmadalvarez%2Fdashboard%2Fmotociclisme&diff=1912981582&oldid=1912428855 was updated correctly.

Jun 11 2023, 12:58 PM · Tool-inteGraality
JeanFred closed T338684: Hard crash when configured with a column (property) that is never used on any items as Resolved.

Thanks for the report. The issue was that the dashboard is configured with p710 as column, but that property is not used on any of the items in scope. Fixed with 9712666.

Jun 11 2023, 12:52 PM · Tool-inteGraality
JeanFred renamed T338684: Hard crash when configured with a column (property) that is never used on any items from Undefined bug in integraality to Hard crash when configured with a column (property) that is never used on any items.
Jun 11 2023, 12:51 PM · Tool-inteGraality

Jun 6 2023

JeanFred closed T336768: Wales knocked off the table as Resolved.
Jun 6 2023, 6:52 PM · Tool-wikiloves

May 28 2023

JeanFred committed R2566:c18611b63d29: Rename `PropertyGrouping` object to `ItemGrouping` and move `YearGrouping` (authored by JeanFred).
Rename `PropertyGrouping` object to `ItemGrouping` and move `YearGrouping`
May 28 2023, 11:09 AM
JeanFred committed R2566:88906cb10993: Update isort to latest version 5.11.2 and update configuration (authored by JeanFred).
Update isort to latest version 5.11.2 and update configuration
May 28 2023, 11:09 AM

May 27 2023

JeanFred added a watcher for WMSE-Content-partnerships-support-2021-Software-development: JeanFred.
May 27 2023, 10:31 AM
JeanFred closed T137881: Set-up Sentry for ErfgoedBot as Declined.

There is no Wikimedia-hosted Sentry anymore.

May 27 2023, 10:09 AM · Wiki-Loves-Monuments
JeanFred closed T137881: Set-up Sentry for ErfgoedBot, a subtask of T138633: improve logging, as Declined.
May 27 2023, 10:09 AM · Wiki-Loves-Monuments-Database

May 23 2023

JeanFred committed R2566:6407625c4e83: Add allowlist_externals to tox targets using Bash (authored by JeanFred).
Add allowlist_externals to tox targets using Bash
May 23 2023, 7:57 PM
JeanFred committed R2566:5fb06a92d575: Remove method get_percentage from property_statistics (authored by JeanFred).
Remove method get_percentage from property_statistics
May 23 2023, 7:57 PM
JeanFred closed T284684: Support for aliases as Declined.

I fail to see the use case here. On some items Aliases are crucial, on some others they do not make sense. It thus does not make sense from a completion point of view, which is integraality’s main value proposition.

May 23 2023, 8:42 AM · Tool-inteGraality

May 22 2023

JeanFred committed R2566:7b095a8a9938: Correctly handle of higher-grouping when there is no higher-grouping (authored by JeanFred).
Correctly handle of higher-grouping when there is no higher-grouping
May 22 2023, 8:04 PM
JeanFred committed R2566:66d9325827be: Use the YearGrouping object depending on the GroupingType (authored by JeanFred).
Use the YearGrouping object depending on the GroupingType
May 22 2023, 7:38 PM
JeanFred committed R2566:380c651e89e9: Add .git-blame-ignore-revs to ignore reformatting in blame view (authored by JeanFred).
Add .git-blame-ignore-revs to ignore reformatting in blame view
May 22 2023, 7:23 PM
JeanFred committed R2566:19a63b0399c0: Reformat HTML files using HTMLPrettify/js-beautify (authored by JeanFred).
Reformat HTML files using HTMLPrettify/js-beautify
May 22 2023, 7:23 PM
JeanFred committed R2566:de6335d4ab04: Reformat Shell scripts using shfmt (authored by JeanFred).
Reformat Shell scripts using shfmt
May 22 2023, 7:23 PM
JeanFred committed R2566:7df13146151e: Reformat the whole Python codebase using Black (authored by JeanFred).
Reformat the whole Python codebase using Black
May 22 2023, 7:23 PM
JeanFred committed R2566:eca852873c9d: Relax Flask app unit tests by ignoring whitespace (authored by JeanFred).
Relax Flask app unit tests by ignoring whitespace
May 22 2023, 7:23 PM

May 20 2023

JeanFred committed R2566:b3fccb02a315: Extract method `row_opener` from line formatter to Line object (authored by JeanFred).
Extract method `row_opener` from line formatter to Line object
May 20 2023, 7:27 PM
JeanFred committed R2566:bc6d06d22282: Extract method `format_count_cell` out of `format_stats_for_one_grouping` (authored by JeanFred).
Extract method `format_count_cell` out of `format_stats_for_one_grouping`
May 20 2023, 7:27 PM
JeanFred committed R2566:eec39012e516: Use `format_stats_for_one_grouping` for `make_stats_for_no_group` and… (authored by JeanFred).
Use `format_stats_for_one_grouping` for `make_stats_for_no_group` and…
May 20 2023, 7:27 PM
JeanFred committed R2566:b0f08192fc6b: Rename method `make_footer` to `make_totals` and rescope it (authored by JeanFred).
Rename method `make_footer` to `make_totals` and rescope it
May 20 2023, 7:27 PM
JeanFred committed R2566:8139308fb5e4: Harmonize make_stats_for_no_group and make_footer (authored by JeanFred).
Harmonize make_stats_for_no_group and make_footer
May 20 2023, 7:27 PM
JeanFred committed R2566:526d91c8c07e: Change slightly the footer formatting (in both code and tests) (authored by JeanFred).
Change slightly the footer formatting (in both code and tests)
May 20 2023, 7:27 PM
JeanFred committed R2566:a9277f6a5310: Handle totals use-case with a Line object (authored by JeanFred).
Handle totals use-case with a Line object
May 20 2023, 7:27 PM
JeanFred committed R2566:b9287f98d49f: Add more unit tests covering when grouping-link is set (authored by JeanFred).
Add more unit tests covering when grouping-link is set
May 20 2023, 7:27 PM
JeanFred committed R2566:d52875b76dc5: Add unit tests for year grouping formatting (authored by JeanFred).
Add unit tests for year grouping formatting
May 20 2023, 7:27 PM
JeanFred committed R2566:a1d06c153250: Rename method `make_stats_for_one_grouping` to `format_stats_for_one_grouping` (authored by JeanFred).
Rename method `make_stats_for_one_grouping` to `format_stats_for_one_grouping`
May 20 2023, 7:27 PM
JeanFred committed R2566:f7c9f06bcb5a: Move the `format_header_cell` logic out of `make_stats_for_one_grouping` into… (authored by JeanFred).
Move the `format_header_cell` logic out of `make_stats_for_one_grouping` into…
May 20 2023, 7:27 PM
JeanFred committed R2566:dfb7d83b076a: Handle no-group use-case with a Line object (authored by JeanFred).
Handle no-group use-case with a Line object
May 20 2023, 7:27 PM
JeanFred committed R2566:057bb8d23186: Add content of the cells attribute to the Line object repr method (authored by JeanFred).
Add content of the cells attribute to the Line object repr method
May 20 2023, 7:27 PM
JeanFred committed R2566:8073e4b228c0: Copy method get_percentage from property_statistics to AbstractLine (authored by JeanFred).
Copy method get_percentage from property_statistics to AbstractLine
May 20 2023, 7:27 PM
JeanFred committed R2566:e86024709d79: Move more of the `make_stats_for_one_grouping` logic to the line object (authored by JeanFred).
Move more of the `make_stats_for_one_grouping` logic to the line object
May 20 2023, 7:27 PM
JeanFred committed R2566:34ee30a2314d: Retire the `column_data` structure and move data to the grouping objects (authored by JeanFred).
Retire the `column_data` structure and move data to the grouping objects
May 20 2023, 7:27 PM
JeanFred committed R2566:32a1b4577dae: Move the heading formatting logic from `make_stats_for_one_grouping` to the… (authored by JeanFred).
Move the heading formatting logic from `make_stats_for_one_grouping` to the…
May 20 2023, 7:27 PM
JeanFred committed R2566:9c9c9ac14c8d: Pass grouping object to `make_stats_for_one_grouping` instead of its attributes (authored by JeanFred).
Pass grouping object to `make_stats_for_one_grouping` instead of its attributes
May 20 2023, 7:27 PM
JeanFred committed R2566:cdeef60eaa81: Convert grouping list to grouping dictionary (authored by JeanFred).
Convert grouping list to grouping dictionary
May 20 2023, 7:27 PM
JeanFred committed R2566:0d775cf23071: Introduce the Line object concept and use the Grouping (authored by JeanFred).
Introduce the Line object concept and use the Grouping
May 20 2023, 7:27 PM

May 19 2023

JeanFred committed R2566:21613be5046b: Add unit-test for retrieve_and_process_data (authored by JeanFred).
Add unit-test for retrieve_and_process_data
May 19 2023, 11:49 PM

May 16 2023

JeanFred added a comment to T336768: Wales knocked off the table.

For context, very little is manual in the wikiloves tool. It’s controlled by:

  1. The application code, mostly contributed by me, which is publicly accessible and can be freely audited at https://github.com/JeanFred/wikiloves/commits/master
  2. The configuration that lives on-wiki at https://commons.wikimedia.org/wiki/Module:WL_data
May 16 2023, 3:58 PM · Tool-wikiloves

May 7 2023

JeanFred created T336129: New mode: grouping by external identifier.
May 7 2023, 10:34 AM · Tool-inteGraality

May 3 2023

JeanFred claimed T320160: Migrate wikiloves from Toolforge GridEngine to Toolforge Kubernetes.
May 3 2023, 8:10 PM · Tool-wikiloves, Grid-Engine-to-K8s-Migration

Apr 18 2023

JeanFred updated the task description for T334932: Upgrade wikiloves to Python3.
Apr 18 2023, 11:37 AM · Tool-wikiloves
JeanFred created T334932: Upgrade wikiloves to Python3.
Apr 18 2023, 11:36 AM · Tool-wikiloves

Mar 9 2023

JeanFred added a watcher for Tool Maintainers: JeanFred.
Mar 9 2023, 5:29 PM
JeanFred added a comment to T313546: Identify metrics to measure the impact of a tool [Tech Engagement Experiment Week].

That second link is not public − it requires authentication, and if I am logged in with a google account it tells me I do not have access to view it.

Sorry about that – it should work now.

Mar 9 2023, 12:29 PM · User-Raymond_Ndibe, User-Slst2020, cloud-services-team (Kanban), Developer-Advocacy (Jul-Sep 2022)

Mar 8 2023

JeanFred added a comment to T313546: Identify metrics to measure the impact of a tool [Tech Engagement Experiment Week].
Mar 8 2023, 7:30 PM · User-Raymond_Ndibe, User-Slst2020, cloud-services-team (Kanban), Developer-Advocacy (Jul-Sep 2022)

Feb 11 2023

JeanFred added a comment to T328527: Brainstorm: Status update functionality.

Another kind of report is the one used for reporting on the Museum day competition: https://meta.wikimedia.org/wiki/International_Museum_Day_2021/Wikidata_Competition/Winners#Before_and_after

Feb 11 2023, 11:51 AM · Tool-inteGraality

Feb 10 2023

JeanFred added a comment to T313588: Add Wiki Loves Folklore Competition to wikiloves stats tool.

Before this the contest was called Wiki Loves Love, so we're taking 2021 to be the first proper year for Wiki Lovea Folklore at this point. We may revise this later if enough people express a concern about it.

Feb 10 2023, 9:38 AM · Tool-wikiloves

Feb 9 2023

JeanFred added a comment to T313588: Add Wiki Loves Folklore Competition to wikiloves stats tool.

Did a quick fix to the start/end timestamp and triggered two updates:

Saved folklore2021: 4sec, 20 countries, 5726 uploads
Saved folklore2022: 5sec, 23 countries, 6635 uploads
Saved folklore2023: 3sec, 20 countries, 3244 uploads
Feb 9 2023, 9:23 PM · Tool-wikiloves
JeanFred added a comment to T313588: Add Wiki Loves Folklore Competition to wikiloves stats tool.

@JeanFred All the relevant countries have now been added to the configuration at https://commons.wikimedia.org/wiki/Module:WL_data for all editions since 2021.

Feb 9 2023, 9:02 PM · Tool-wikiloves