https://wiki.musicbrainz.org/api.php?action=feedcontributions&user=91.157.16.77&feedformat=atomMusicBrainz Wiki - User contributions [en]2024-03-29T05:34:12ZUser contributionsMediaWiki 1.39.4https://wiki.musicbrainz.org/index.php?title=User:Jokipii&diff=51393User:Jokipii2012-01-20T17:37:35Z<p>91.157.16.77: Bot tasks done</p>
<hr />
<div>== Who am I? ==<br />
MusicBrainz editor [http://musicbrainz.org/user/Jokipii Jokipii] and operator of [http://musicbrainz.org/user/Jokipii_bot Jokipii_bot].<br />
<br />
== Currently working with ==<br />
I have both MusicBrainz and Discogs databases installed on PostgreSQL. I am currently trying to improve linking between those.<br />
Bot code can be found at [https://github.com/Jokipii/musicbrainz-bot musicbrainz-bot] and code that produces Discogs database from monthly XML dumps found at [https://github.com/Jokipii/discogs-xml2db discogs-xml2db].<br />
<br />
== Userscripts ==<br />
[http://userscripts.org/scripts/show/121381 Here] is userscript that makes voting for Discogs links easier.<br />
<br />
== Bot queue ==<br />
* Release links identified by exact match on catalog number, release name, linked label, format and same number of tracks. See [http://test.musicbrainz.org/edit/16084766 example]<br />
** 36974<br />
<br />
== Possible future sets ==<br />
Set descriptions and number of links<br />
* Artist (type:group) name with exact (case insensitive) match, have members with Discogs links, all members found that way have been also market as members in Discogs entry.<br />
** 2083<br />
* Artist name with exact (case insensitive) match, is member of groups with Discogs links, all groups found that way have same Discogs artist as member.<br />
** 8692<br />
* Artist that have Discogs link, and not have type(person/group) set, and have multiple members in Discogs (indicating type:group)<br />
** 1309<br />
* Artist that have Discogs link, and not have type(person/group) set, and have Discogs realname without characters "&,/+" and word "and" (indicating type:person)<br />
** 1699<br />
<br />
== Bot tasks done ==<br />
* Artist Discogs links<br />
** Exact name match. Have release(s) with Discogs links. All releases found that way point on same artist at Discogs.<br />
<br />
== Bot programming tasks ==<br />
* Merge bot code to [https://github.com/lalinsky/musicbrainz-bot musicbrainz-bot]<br />
* Start using [https://github.com/philipmat/discogs-xml2db discogs-xml2db] to produce Discogs database<br />
<br />
== Some stats ==<br />
<br />
{|<br />
!<br />
! MusicBrainz Total <br />
! Discogs Total <br />
! Links (all these are not unique) <br />
! Percent done (compared to smaller total) <br />
! Sum of unique MusicBrainz releases connected to linked entities <br />
! Percent of all MusicBrainz releases<br />
! Sum of unique Discogs releases connected to linked entities <br />
! Percent of all Discogs releases<br />
|-<br />
! Releases: <br />
| 988301<br />
| 2720810<br />
| 171170<br />
| (17%)<br />
|<br />
|<br />
|<br />
|<br />
|<br />
|-<br />
! Release groups:<br />
| 822442<br />
| 365081<br />
| 47387<br />
| (13%)<br />
| 106445<br />
| (11%)<br />
| 277207<br />
| (10%)<br />
|-<br />
! Artist:<br />
| 626598<br />
| 2100250<br />
| 110825<br />
| (18%)<br />
| 606737<br />
| (61%)<br />
| 1738474<br />
| (64%)<br />
|-<br />
! Label:<br />
| 55844<br />
| 245988<br />
| 16004<br />
| (29%)<br />
| 414436<br />
| (42%) see note<br />
| 1542803<br />
| (57%)<br />
|}<br />
<br />
note: In MB only 567392 releases have label information, and 420909 don't have.</div>91.157.16.77