Allods Text to Excel

[al5yal511]

This tool will allow you to extract all txt files inside a directory to an excel file with the contents of all txt files as rows, and paths

• You need Python 3.12

1-You can check your version by searching cmd or command prompt in your windows search bar
2- You can run these commands to see if it's installed.
3- if you run with an error or you don't have python ,

You do not have permission to view link Log in or register now.

python
python --version

• Your Python needs to have openpyxl module

1- this is necessary step and the tool won't work if you have python without openpyxl.
2- you can check if you have the module openpyxl by running this code in cmd or windows powershell.

pip show openpyxl

• You need an unpacked texts.pak -> Pac.loc -> Extracted folder. because it can only grab texts from folders, not from .loc or .pak.

1- to get the tool please refer to this link

• Next is running the tool.

1-Your folder should look like this
2- Press Shift + Right click on the side of the explorer.
3- Select Open PowerShell Window here.
4- before running the tool, check if the module openpyxl is found by running the command, "pip show openpyxl"
5- Edit the tool with your Notepad++

edit these 2 lines to your desired folder, in this case I'm trying to get all the txt files inside Client to an excel sheet called Client.xlsx.
6- You don't need to create the excel file, the tool will do it for you if it doesn't exist.
7-In the Powershell run this command

python grab.py

in 1-2 minutes you will have an excel file that looks like this.


Finally, we've extracted Every single txt file inside Client folder, to 1 excel sheet, with their paths.

This tool was written by me from scratch, for the purpose of adding it as a terminology file to my project of translating allods from English -> Arabic.
If this can help you achieve something similar good luck and don't forget to Thumbs Up

 

[al5yal511]

Here's an example of translating, we have a source and a target text, it appears we have a translation match, which means the text we're trying to translate has a matching translation in the "translation memory".

so since allods has stopped translating some language at about version 4.0 or 7.0. you can use the older versions to compare translations.

for example you can import a 13.0 or whatever last version allods reached so far, and add your previous version that stopped translating maybe 4.0.
you will be able to translate all previous texts in the 13.0 from the past 4.0. and you could clearly see which files still hasn't been translated.





Here's a progress view



2 files were translated "confirmed" , the rest are still at default.
at some point you can run a command or a replace from your "translation memory".
the issue was, you can't import txts, only excel sheets. so that's why I made this tool. to add them as "translation memory", and all that's left is translating whatever new files or expansions are.

this technique would allow you to translate over many versions of the game, without losing progress.
being able to maintain a high quality translation.