Skip to content

Instantly share code, notes, and snippets.

@mofukuma
Created April 11, 2013 13:32
Show Gist options
  • Save mofukuma/5363392 to your computer and use it in GitHub Desktop.
Save mofukuma/5363392 to your computer and use it in GitHub Desktop.
Indie game developers - common words translation sheet by www.bladko.comをスクレイピングする。 依存:jquery、jquery.csv.js
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8"/>
<title>transdb JSON</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script src="jquery.csv.js"></script>
<script>
var csv_urls =
[
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=0&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=7&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=3&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=10&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=5&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=6&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=13&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=9&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=14&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=8&output=csv",
"https://docs.google.com/spreadsheet/pub?key=0AgPcSiCUAktOdElmU0lfeTZIdy1NUHowaG9VWV9zLXc&single=true&gid=15&output=csv"
];
var langdb = {};
$(function(){
for( var i in csv_urls ){
//オフラインマスタ読み込み
$.get(csv_urls[i], function(data){
var csv = $.csv(",", "'\"")(data);
console.log(csv);
var i;
var START_X = 1;
var START_Y = 1;
var h = csv.length;
if(h < 2){
return;//error
}
var w = csv[START_Y].length;
for( x=START_X; x<w; x++){
var k = '';
for( y=START_Y; y<h; y++){
//if(csv[y][x] == "") break;
if(y==START_Y){// label
k = csv[y][x];//言語キー。ENまたはENGLISHなどで取得
if(k == "")
k = csv[0][x];//なんか無いときあり
if(!(k in langdb))
langdb[k] = {};
}else{// キー:英語文 バリュー:各国語文
if(x == START_X){ //key (ENGLISH)
langdb[k][csv[y][x]] = csv[y][x];
}else{ //key value
langdb[k][csv[y][START_X]] = csv[y][x];
}
}
}
}
});
}
setTimeout(function(){
console.log(langdb);
$("#out").text( JSON.stringify(langdb) ); //JSON吐く
}, 5000);//5秒後に出力。(手抜き)
});
</script>
</head>
<body>
<textarea id=out></textarea>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment