2b:null 2c:["$","title",null,{"children":"[GameTools] Book of Hours Localization Guide and Tool | UnluckyNinja | Observable"}] 31:T57c,### 1-2. Find files to localize and have the game load them For every file under "`.../core`" other than "culture.json", their contents almost all have "label", "desc", "description" properties, which can be translated. (Devs may change these.) Some of them also have "startdescription", and nested "slot/slots" in which "label" and others can appear. You can search in-game text in the whole nested directory with editors like VSCode/EmEditor etc. Not all in-game texts are in these files though, some text may be hardcoded in program code. Like text in the locked path on the map. Then, if you have translated a file, it should be put under "`.../loc_`" - create a new folder right next to the "core" folder. (I suggest maintaining the same file structure as in "core", just like the first step.) The fold structure will look like this: ``` StreamingAssets |- bhcontent | |- core | |- loc_zh-hans <- new | |- edition |- further ... ``` **(Just a reminder, `culture.json` file only works in `core` folder. It won't work in `loc_*` folder.)** Lastly, go to `C:\Users\\AppData\LocalLow\Weather Factory\Book of Hours` and open file `config.ini`. Change the "en" in `Culture=en` to the id you wrote in the `culture.json` file (and the same as in "`.../loc_`"). Restart the game. If somthing went wrong, you will find the game changed the config back to "en".32:T49a,generated_json = { if(!target_file || !sheet_url) return '' const translatedJson = structuredClone(target_json) const dict = new Map(parsed_csv.map(it=>[`${it.id}|${it.key}`, it.value])) const old_en_dict = new Map(parsed_csv.map(it=>[`${it.id}|${it.key}`, it.old_en])) const out_list = [] traverse(Object.values(translatedJson)[0], '', (obj, parentID)=>{ const ID = utils.combineID(parentID, obj.id || obj.ID) ;['label', 'startdescription', 'description', 'desc'].forEach(it=>{ if(it in obj || it[0].toUpperCase() + it.substring(1) in obj){ const _key = it in obj ? it : it[0].toUpperCase() + it.substring(1) const translated = dict.get(`${ID}|${_key}`) const newEn = obj[_key] const oldEn = old_en_dict.get(`${ID}|${_key}`) if (obj[_key] !== utils.unescapeCSV(oldEn)) { out_list.push({ id: ID, key: _key, old_text: oldEn, new_text: newEn }) } if (translated) obj[_key] = utils.unescapeCSV(translated) } }) }) mutable outdated_list = out_list return { text: JSON.stringify(translatedJson, null, 2) } }33:T525,generated_csv = { if(!target_file || !sheet_url) return '' const clonedJson = structuredClone(target_json) const dict = new Map(parsed_csv.map(it=>[`${it.id}|${it.key}`, it.value])) const old_en_dict = new Map(parsed_csv.map(it=>[`${it.id}|${it.key}`, it.old_en])) const list = [] traverse(Object.values(clonedJson)[0], '', (obj, parentID)=>{ const ID = utils.combineID(parentID, obj.id || obj.ID) ;['label', 'startdescription', 'description', 'desc'].forEach(key=>{ if(key in obj || key[0].toUpperCase() + key.substring(1) in obj){ const _key = key in obj ? key : key[0].toUpperCase() + key.substring(1) const translated = utils.unescapeCSV(dict.get(`${ID}|${_key}`)) const old_en = utils.unescapeCSV(old_en_dict.get(`${ID}|${_key}`)) || '' const item = { id: ID, key: _key, value: translated || obj[_key], en: obj[_key], old_en, outdated: (obj[_key] !== old_en).toString() } list.push(item) } }) }) const keys = ['id', 'key', 'value', 'en', 'old_en','outdated'] const header = keys.join(',')+'\n' const lines = list.map(it=>{ return keys.map(key=>utils.escapeCSV(it[key] || '')).join(',') }) return { list, text: header + lines.join('\n') } }34:[{"id":"7548cd11ca28b2a3099f83cbeb9773e7622f1bca85f81931bdbed212ef3fb98f5a10420f9e22485667efdad48c6f71ebc7de44fde08bb5fe04ec1b33ba24200c","href":"https://static.observableusercontent.com/files/7548cd11ca28b2a3099f83cbeb9773e7622f1bca85f81931bdbed212ef3fb98f5a10420f9e22485667efdad48c6f71ebc7de44fde08bb5fe04ec1b33ba24200c","name":"loc_zh-hans.zip","type":"application/zip","lastModified":1693616351015.825,"size":30785}] 2f:{"id":"101e12dc5f4fbed3","slug":null,"title":"[GameTools] Book of Hours Localization Guide and Tool","thumbnail":"806e7a61b1fb456a1de57a5f77f031eba30b7709b2bfcab248b4a94ba471a30e","access_level":"public","create_time":"$D2023-08-25T19:00:37.393Z","update_time":"$D2024-10-02T09:20:50.592Z","view_time":null,"first_public_time":"$D2023-08-25T19:00:37.393Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ebb6118c9a990a2c","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":"starter_2024"},"version":735,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"4df1f6fd87aa7295","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":null}],"members":[{"type":"individual","id":"4df1f6fd87aa7295","login":"unluckyninja","name":"UnluckyNinja","avatar_url":"https://avatars-next.observableusercontent.com/95d8d23bafa30b0b30e2ead4a72666d02cc17899c3c958c22c65fc0fc09afe3d","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"6cb821d5a6280f87","slug":"games","title":"GameTools","owner":{"id":"ebb6118c9a990a2c","login":"unluckyninja","name":"UnluckyNinja"}},"type":"notebook","body":{"title":"[GameTools] Book of Hours Localization Guide and Tool","cells":[{"id":0,"value":"# [GameTools] *Book of Hours* Localization Guide and Tool","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"## 1. A guide to localize the game\nIt's good to know it shares a codebase with *Cultist Simulator*. You don't need to hack the code.\n\n### 1-1. Add a culture.json file:\n\nFirst of all, to add a new in-game language, there has to be a `.json` file under \"`bh_Data/StreamingAssets/bhcontent/core/`\" (short as \"`.../core`\" in following parts). \n\\- I'd recommend \"`.../core/cultures//culture.json`\". \nAnd its content's structure must be identical to `.../core/cultures/en/culture.json` file (a part of it with some notes of mine):","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":30,"value":"```jsonc\n{\n \"cultures\": [\n {\n \"id\": \"en\", // Your should change this, the ones in Cultist Simulator are 'zh-hans','de','jp','ru'\n \"endonym\": \"English\", // The language's name in local language\n \"exonym\": \"English\", // The language's name in English\n \"fontscript\": \"latin\", // Which font to use, can be 'cjk', 'jp', 'cyrillic', 'latin', 'latinplus'\n \"boldallowed\": true,\n \"released\": true,\n \"uilabels\": { // Some can be displayed correctly if translated, some don't, you should check it ingame.\n \"UI_PAUSE\": \"$Pause\\n[{SETTING:kbpause}]\", // Most Button's hovering text don't work.\n \"UI_UNPAUSE\": \"$Unpause\\n[{SETTING:kbpause}]\",\n ...\n \"UI_CAMERA_ARROW_SPEED\": \"% Camera Speed with Keys (experimental)\"\n }\n }\n ]\n} \n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":56,"value":"$31","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":99,"value":"### 1-3. Start translating\n1. **Translate in place.** \n Least effort, hardest navigating. Also hard to collaborate and adapt with game updates. You could use services like github.\n\n3. **Export text, translate and collab with google sheets.** \n Easy to seek for text. Easy to collaborate, but not that easy at start. You can continue reading.\n4. **Like the 2nd option, but with Weblate or similar tools.** \n Beyond my experiences, just pointing a way.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":562,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":124,"value":"## 2. Export text for easier translating and collaborating","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"(Except the `culture.json` file. Just translate it in place.)\n1. Use the first tool below to extract the text, just drag and drop the .json file onto the box.\n\n2. Download and import the .csv file into google sheets (Menu -> File -> Import). Once the file has uploaded, select \"insert new worksheet\", uncheck type conversion, confirm.\n\n3. Translate only the \"value\" column. (You can add stuff to empty cells on the right, just make sure the first row untouched.)\n\n4. When you are done, click \"Menu -> File -> Share -> Publish to the Web\". Select the worksheet you want to export. Select Comma Separated (.csv). Click Publish. Copy the URL.\n\n5. Paste the URL into the text input of the second tool. Drag and drop the original en .json file onto the box\n\n6. Download merged .json file and put it under `.../loc_/...`. (And overwrite the old file, if there is one.)\n\n7. Text of ongoing quest is stored in saves. You may have to start a new game to see the change.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":560,"value":"

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":228,"value":"## 3. Tools","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":230,"value":"### 3-1. Export from a language file","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":139,"value":"newDropArea(en_file, dnd.dropHandler((r)=>mutable en_file = r), dnd.dragover)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"{\n if(!en_file) return htl.html`Put file first`\n const content = en_csv.text\n // const content = await en_file.file.text()\n const textarea = htl.html``\n textarea.value = content\n textarea.style.width = width+'px'\n textarea.style.height = '200px'\n return htl.html`

Preview:

`\n return DOM.download(new Blob([en_csv.text], {type:'text/csv'}), en_file.name+'.csv','Download as CSV')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":286,"value":"#### ==== Developer Zone - You can ignore the following. ====","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":141,"value":"mutable en_file = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"en_json = {\n if (!en_file) return null\n if (!en_file.type.includes('json')) return null\n const content = await en_file.file.text()\n return JSON.parse(content)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"=== Intermediate data structure for further processing:\n```javascript\n{\n name: \"string\", // file name\n items: [\n {\n id: \"string\",\n key: \"string\",\n value: \"string\",\n en: \"string\",\n old_en: \"string\",\n outdated: \"string\", // true/false in string type for easier generating csv\n }\n ]\n}\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":588,"value":"function traverse(obj, parentID, callback) {\n if (!callback) return \n if (Array.isArray(obj)) {\n obj.forEach((item) => traverse(item, parentID, callback));\n return;\n }\n if (\"slot\" in obj) {\n traverse(obj.slot, utils.combineID(parentID, obj.id || obj.ID), callback);\n }\n if (\"slots\" in obj) {\n traverse(obj.slots, utils.combineID(parentID, obj.id || obj.ID), callback);\n }\n callback(obj, parentID);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"function parseEnJSON(json){\n if(!json) return []\n const name = Object.keys(json)[0]\n if(!name) throw 'there should be at least one entry in root object'\n if(!Array.isArray(json[name])) throw `the contens under ${name} is not an array`\n const list = []\n const checkAndPush = (obj, key, parentID = '' )=>{\n if(key in obj || key[0].toUpperCase() + key.substring(1) in obj){\n const _key = key in obj ? key : key[0].toUpperCase() + key.substring(1)\n list.push({\n id: utils.combineID(parentID, obj.id || obj.ID),\n key: _key,\n value: obj[_key],\n en: obj[_key],\n old_en: obj[_key],\n outdated: 'false',\n })\n }\n }\n const checkKeys = (obj, parentID)=>{\n ;['label', 'startdescription', 'description', 'desc'].forEach(key=>{\n checkAndPush(obj, key, parentID)\n })\n }\n traverse(json[name], '', (it,pID)=>{\n checkKeys(it, pID)\n })\n return list\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":608,"value":"en_parsed = parseEnJSON(en_json)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"=== CSV\n```csv\nid,key,value,en,old_en,outdated\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":220,"value":"en_csv = {\n if (en_parsed.length === 0) return ''\n const keys = ['id','key','value','en','old_en','outdated']\n const header = keys.join(',')+'\\n'\n const lines = en_parsed.map(it=>{\n return keys.map(key=>utils.escapeCSV(it[key])).join(',')\n })\n return {\n text: header + lines.join('\\n')\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":557,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":262,"value":"### 3-2. Merge Back","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":355,"value":"viewof sheet_url = Inputs.url({label: 'CSV URL', width: 500})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":453,"value":"viewof refresh = Inputs.button('Refetch URL')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":400,"value":"Drag and drop the en json file you want to overwrite. (the original file.)\n${newDropArea(target_file, dnd.dropHandler(r=>mutable target_file = r), dnd.dragover)}","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":367,"value":"{\n if(!sheet_url) return htl.html`Input URL & Drop target file first`\n const content = generated_json.text // output\n // const content = remote_csv.text // input\n const textarea = htl.html``\n textarea.value = content\n textarea.style.width = width+'px'\n textarea.style.height = '200px'\n return htl.html`

Preview:

No outdated text found.

`\n return htl.html`

There are some texts of which original string have changed. Check the array below and the 3rd tool.

`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":641,"value":"mutable outdated_list = []","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":441,"value":"{\n if (!sheet_url || !target_file) return htl.html`

`\n return DOM.download(new Blob([generated_json.text], {type:'text/plain'}), target_file.name, 'Download as JSON')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":426,"value":"#### ==== Developer Zone - You can ignore the following. ====","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":394,"value":"mutable target_file = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"target_json = {\n if (!target_file) return null\n if (!target_file.type.includes('json')) return null\n const content = await target_file.file.text()\n return JSON.parse(content)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":380,"value":"remote_csv = {\n refresh\n if(!sheet_url) return ''\n return {\n text: await (await fetch(sheet_url, {cache: \"no-cache\"})).text()\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"parsed_csv = {\n if(!sheet_url) return ''\n return d3.csvParse(remote_csv.text)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":554,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":544,"value":"### 3-3. Merge but export as csv & with original text for comparing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":546,"value":"Use the 2nd tool's input.\n\nBe careful though, if the corresponding entries of some translated texts, are **deleted** in new updates, those entries will **not** be re-exported in the csv.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":550,"value":"{\n if(!sheet_url) return htl.html`Input URL & Drop target file first`\n const content = generated_csv.text // output\n // const content = remote_csv.text // input\n const textarea = htl.html``\n textarea.value = content\n textarea.style.width = width+'px'\n textarea.style.height = '200px'\n return htl.html`

Preview:

${textarea}`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"There are ${diff.only_in_old.length} strings that are **deleted** in the update. \nThere are ${diff.only_in_new.length} strings that are **added** in the update. \nThere are ${diff.changed_in_new.length} strings that are **changed** in the update","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":693,"value":"diff = {\n return {\n only_in_old: _.differenceBy(old_vs_new.oldLines, old_vs_new.newLines, 'id'),\n only_in_new: _.differenceBy(old_vs_new.newLines, old_vs_new.oldLines, 'id'),\n changed_in_new: outdated_list.filter(it=>!!it.old_text),\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":634,"value":"{\n if (!sheet_url || !target_file) return htl.html`

`\n return DOM.download(new Blob([generated_csv.text], {type:'text/plain'}), target_file.name+'.csv', 'Download as JSON')\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":585,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":679,"value":"old_vs_new = {\n const oldLines = parsed_csv\n return {\n oldLines,\n newLines: generated_csv.list,\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":669,"value":"### 汉化注记\n- 按钮提示不能汉化，可能没有支持本地化的字体\n- 地图解锁相关文本不能直接汉化，没有搜索到对应文本\n- 部分浮窗提示不能汉化，也没找到对应文本，可能是hardcoded（例如点击文本复制的提示）","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":225,"value":"utils = {\n function escapeCSV(str){\n if (!str) return str\n // google sheets will hide leading single quote when publishing\n // a workaround is to double it\n let google_fix = ''\n if(str.startsWith(\"'\")) {\n google_fix = \"'\"\n }\n return '\"'+ google_fix + str.replaceAll(/\\r?\\n/g, '\\\\n').replaceAll(/(?