Found another pattern "]], [[", they still just a few. -- Nuno Tavares DRI, Consultoria Informática Telef: +351 936 184 086
Nuno Tavares escreveu: > Dear Vicenç [I believe all others should ignore this message], > > > Yes, I've just noticed, e.g., "[[Ogassa]] i [[Ribes de Freser]]". My > (professional) opinion is that this is a huge mistake, since that field > represents 2 values, which is a clear violation of standard database > rules. Having this in mind, I'd suggest splitting the object in two. > > I found a pattern for "multiple municipalities in the same object", > which seems to be "]] i [[", and there seems to be only 6 of them. You > can just wipe out one of them from the field, or manually duplicate the > record them for splitting - the latter being more complex, think of a > good ID disambiguation though. Regarding link disambiguations, you can > just add a column for that - in a "working table", as they are of no use > for a listing like this (alas, that kind of data is only relevant if you > plan to regenerate the lists). > > > We had similar problems - we even had descriptions names in wiki syntax > already, our lists date back to 2006. As I wanted to preserve the links > and original "names" (designations), I've done some transformations on > the data before it gets on the list - this kind of approach was actually > the reason to have our tools/plist [1] - notice multiple links near the > end of each description, and notice that, if you export to wiki format, > you'll find municipalities disambiguated as well. > > [1] http://www.wikilovesmonuments.org.pt/tools/plist/?region=Braga > > That's why you currently can "regenerate" the lists with their original > descriptions and links. > > This is, however, a more complex approach which I won't have time to > assist you, but I may point you directions if you know ETL. > > _______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu
