I don’t know where the supplement files will be posted, possibly on the legacy site this month.
We’ll be checking them carefully to make sure they look right before we release them, including making sure they load into WinTD and SwissSys. (I know people who have tried to load the Golden Master file into Excel, it failed because Excel had a maximum of somewhere around 640,000 rows, and the Golden Master files have more like 1.2 million rows in them.)
FWIW, there have been several times in the last year when the supplement files weren’t posted until Friday or Saturday due to issues with their generation. That may be the case with the December 2025 files as well.
Not one I’ve used. I have several PHP programs I wrote that can extract data from DBF files, most using the PHP dBase tool kit which makes it easy to read individual records from the file and process or aggregate them. If I want to do serious fiddling with the data in a DBF files, I write a tool to extract the records, create a database table for them and generate SQL inserts to populate the table, then it is just another table in Postgres.
Years ago, when my younger son was taking his first data structures course, the instructor had them write SQL statements to pull a variety of data reports from a set of MySQL tables.
Some of them were kind of tricky, I think most of the class wound up generating some kind of temporary table to handle some of the data reports, but the more I looked at the list the more certain I was that with feature like subqueries and windowing functions, every one of them could be done in a single SQL statement.
It reminded me of my days at the computer center at Northwestern, when the head of technical services would create some data records and ask the staff as a training exercise (mostly grad students, I was the first undergrad hired to work there) to produce some output from those data records using a variety of language tools including FORTRAN, COBOL, ALGOL-60, BASIC, APL, LISP and SNOBOL. Some of those languages were better suited for the specific tasks than others but there was always a way to do it with each of the assigned tools. It was excellent training for figuring out how to use a tool for purposes for which it was not well-suited or designed. Sometimes you have to use the tools you have, not the tools you’d like to have, to get the job done.
What’s the timeline between updating affiliate expiration (and member expiration) and display in the new system? It appears that my affiliate (which I renewed last month) is not showing renewed in Leago? I’m thinking it might have gotten caught between systems? If mine got missed, I’m wondering if other affiliates / memberships also might be missed? I was under the impression that future state these would be almost instantaneous (it was like 15 mins historically, I think?).
I’ve noticed the new ‘Other’ section format that MUIR allows. Is there a mapping for that? like M for match S for Swiss. Is it just ‘O’ ? and does anyone know if the Leago team mapped it for the DBF files?
There’s been an ‘other’ format going back to 1991, for things like ladder events or scramble pairings. But only the R (round robin) and M (match) codes are really used for anything.
I think it goes in the section file in the S_TRN_TYPE field, though the documentation for that format is somewhat archaic (as is the DBF format itself, which is why we will probably implement a JSON format some time.)