[Bug 59346] DBQ-94 Find all SVG Images on commons

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346

Bugzilla Bug Importer (valhallasw)  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #7 from Bugzilla Bug Importer (valhallasw) 
 ---

This bug was imported as RESOLVED. The original assignee has therefore not been
set, and the original reporters/responders have not been added as CC, to
prevent bugspam.

If you re-open this bug, please consider adding these people to the CC list:
Original assignee: guanda...@nurfuerspam.de
CC list: guanda...@nurfuerspam.de, wikimedia-bugzi...@dabpunkt.eu

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59346] DBQ-94 Find all SVG Images on commons

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: Guandalug 
Date: Fri, 25 Jun 2010 23:36:30
---

Compressed XML result file of the forementioned query

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59346] DBQ-94 Find all SVG Images on commons

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346

--- Comment #3 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: Guandalug 
Date: Fri, 25 Jun 2010 23:37:33
---

Query done

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59346] DBQ-94 Find all SVG Images on commons

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346

--- Comment #5 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: DaB. 
Date: Sat, 26 Jun 2010 12:00:14
---

@Guadalug "--default-character-set=UTF8" is wrong, the data is stored as latin1
(but it is in reality utf8). Remove that and check the charset of your
terminal, if you get garbish.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59346] DBQ-94 Find all SVG Images on commons

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: Guandalug 
Date: Fri, 25 Jun 2010 23:35:39
---

Run query:

mysql -X -h commonswiki-p.db.toolserver.org -D commonswiki_p
--default-character-set=UTF8 -n --delimiter=';' -e "select
img_name,img_minor_mime from image where lower(img_name) like '%.svg';" | tee
SVGList.xml

There's most likely a better way doing it, but this ought to work.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59346] DBQ-94 Find all SVG Images on commons

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346

--- Comment #4 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: Leo k 
Date: Sat, 26 Jun 2010 11:38:45
---

Did you maybe double-encode the data? I tried opening as UTF8, UTF16, Latin1
and a few others & I always get the nonstandard chars garbled

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 59346] DBQ-94 Find all SVG Images on commons

2014-01-03 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=59346

--- Comment #6 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: Guandalug 
Date: Sat, 26 Jun 2010 13:52:00
---

New attempt. CSV this time, Characters seem to be intact as far as my
UTF8-capable editor can be trusted.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l