Script that moves content from an Excel file (source) to a XLIFF file (target).
- The Excel file needs to be in the same structure as the example provided here (Title, Body, Body_2, Link).
- The XLIFF file (when downloaded from pendo.io) holds the original source-text in it, which normally is "en-US" (English).
- Open your Terminal, "cd" to the folder where the .py Script is located and write "python Excel2Xliff.py" or "python3 Excel2Xliff.py" to start the script. This will open a new window. You might have to set permissions to the script so it can access your files and your desktop, where it will save the new XLIFF files with the translations inside.
- Insert the pathname of the Excel file and the XLIFF file, select the language you wish to translate, and click the button "Convert Files".
- Your new files will be saved on your Desktop.
- Review your new files to see if it worked – hope so.
On a Mac you can get the pathname of a file with right-click on a file, then maintain the keyboard “option”-button pressed, and click on the “Copy FILENAME as Pathname” option in the menu.
- macOS Catalina
- Python 3.8.1
- pandas 1.0.1
- tkinter 8.6
- ttkthemes 3.0.0
- xlrd 1.2.0
- Overally improve and clean the Python code structure.
- More/Custom languages. Currently only "es" (Spanish) and "pt-BR" (Portuguese) work, but feel free to change them in the code itself.
- Add drag&drop functionality instead of adding the pathname of the files.
- Redesign the window to be more pleasant to the eye and user-friendly.
- ...
- Feel free to contact me and send me constructive feedback :)
Recently started learning about Python – this is a personal side-project which I am working on for a friend.