Topic on User talk:Magnus Manske

Dear Magnus! I recently uploaded a csv file to Mix'n'match to create a new catalog. The data was in this format:

40,ANDRÁSSY Karolina csíkszentkirályi és krasznahorkai gr.,1865. IX. 18.,1937. IX. 10.
41,KEGLEVICH Imre gr.,1897. X. 27.,1964. VIII. 19.
42,PIRET DE BIHAIN Lajos Jenő br.,1862. I. 27.,1910. XII. 2.

However, after uploading, I noticed that birth-death data can not be found. Will you help me see what the error was and whether it can be fixed by re-uploading the repaired dump?

Thank you!

m:Mix'n'match/Import explains the date format.

Also, names (read labels) would ideally have the same format as on Wikidata. For Hungarian, there is the additional problem that the label is different from English.

Not sure if there is a way to upload both formats in one catalogue. Maybe you could upload the data twice: once in English (<given name> <surname>), once in Hungarian (<surname>, <given name>). If someone matches a name in either catalogue, eventually resync will match the second entry.

Hello Jura1! Thanks for the reply! The header originally looked like this:

id, Name, BirthDate, DeathDate

I need to fix this:

id, name, born, died

and the date format

1786. XI. 9 -> 1786-11-9? So it will be good? Shall I upload as a new catalog? (Don't sync old 4183)

Unfortunately, I can't correct the name, not only because of the East-West order of names, but because the noble first names are included, I can't take them out

I suppose you could update the catalogue per explanation at m:Mix'n'match/Import or create one (or two) new ones. If new ones are created, 4183 can be de-activated.

I don't quite understand why you don't want to change the names to Wikidata label format. This would simplify matching and avoid that items are created with problematic labels (requiring correction later). The second name format could still be used as alias or with a P1932 qualifier.

Hello! I uploaded again, but not good. What's wrong? I modified the format and header based on the description.

id,P97,name,desc,born,died

26591,,ABAFFY Ágost Sándor abafalvi és felsőlehotai ,,1830-09-12,1907-04-14

4261,Q165503,ABELE Albert Lajos József Mária lilienbergi br,,1857-03-1,

Thank you! Palotabarát (talk) 00:16, 19 February 2021 (UTC)

type is missing (Q5)

Given the format of the names, it seems unlikely that much will automatically in MxM, e.g. second record with Albert Abele von und zu Lilienberg (Q12784118).

You might want to go ahead and create items (with normally cased names: Abaffy, Abele) and then merge applicable ones that appear on Wikidata:Database_reports/identical_birth_and_death_dates/1

Dear Jura1! Unfortunately, I can't correct the names. There are several different data types in a cell, and I can’t fix them in 39,000 cells individually. That's how I got it ready. In the example:

ABELE Albert Lajos József Mária lilienbergi br

Abele = family name (P734) (really bad spelling, not ABELE, but Abele is correct)

Albert Lajos József Mária = given name (P735)

lilienbergi = noble forename (no Wikidata property)

br = noble title (P97) (abbreviated in Hungarian = báró baron (Q165503))

In this, for example, the German and Hungarian spellings are different, in the Hungarian the noble first name is written with lowercase letter, in German it's with capital letter.

You say if I put another column with type = Q5 (for each item), it recognizes the dates and P97?

Maybe Magnus has advice that suits you better