In T338987#9119989, @Lokal_Profil wrote:

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.

In T249678#7504117, @Tgr wrote:

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.

In T338987#9109162, @fnegri wrote:

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.

In T338987#9108831, @fnegri wrote:

(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.

In T338987#9107216, @fnegri wrote:

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.

In T341773#9026755, @Lokal_Profil wrote:

@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)

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:

The application code, mostly contributed by me, which is publicly accessible and can be freely audited at https://github.com/JeanFred/wikiloves/commits/master
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].

In T313546#8677721, @Slst2020 wrote:

In T313546#8677551, @JeanFred wrote:

In T313546#8274688, @Slst2020 wrote:

Presentation slides: https://docs.google.com/presentation/d/1rurAADP9ryrim9BACizj12M7_95bnKnotnitzf-gTe4/edit?usp=sharing

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].

In T313546#8274688, @Slst2020 wrote:

Presentation slides: https://docs.google.com/presentation/d/1rurAADP9ryrim9BACizj12M7_95bnKnotnitzf-gTe4/edit?usp=sharing

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.

In T313588#8602748, @ToniSant wrote:

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.

In T313588#8602748, @ToniSant wrote:

@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

JeanFred (Jean-Frédéric)Volunteer

Projects (9)View All

Calendar

Today

Tomorrow

Thursday

User Details

Recent ActivityView All

Yesterday

Wed, Sep 27

Tue, Sep 26

Mon, Sep 18

Wed, Sep 6

Aug 29 2023

Aug 28 2023

Aug 27 2023

Aug 25 2023

Aug 24 2023

Aug 23 2023

Aug 22 2023

Aug 21 2023

Jul 4 2023

Jun 20 2023

Jun 14 2023

Jun 13 2023

Jun 11 2023

Jun 6 2023

May 28 2023

May 27 2023

May 23 2023

May 22 2023

May 20 2023

May 19 2023

May 16 2023

May 7 2023

May 3 2023

Apr 18 2023

Mar 9 2023

Mar 8 2023

Feb 11 2023

Feb 10 2023

Feb 9 2023

JeanFred (Jean-Frédéric)
Volunteer

Projects (9)
View All

Recent Activity
View All