Adventure Creator Translation Problem
Hello everyone,
We are currently in the process of translating/localizing our game. We have already exported the dialogues, translated them into Spanish, and obtained a CSV file with the translations. However, we're facing an issue.
By default, Google Sheets translates texts that use commas (,) within quotations (""). To overcome this, we've written a script to delete these quotation marks. The problem is that the CSV format defines the comma (,) as the start/ending of a column, which causes our translated Spanish text to be truncated at the first comma.
Is there a step we might be missing or is there a workaround for this issue? We would greatly appreciate any help you can offer!
Images:
https://drive.google.com/drive/folders/1KUh-vm98yyc2lr-RqOPXR94WEtxoUnGe?usp=sharing
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Comments
Sorry, I'm not quite clear on the underlying issue.
The standard CSV format is to use quotations around lines that involve a comma. The quotations shouldn't be removed in that instance.
What are your AC/Unity versions, and what occurs when importing the updated CSV file?
The problem is that we dont want, the quotations to appear on the translated game texts, and we dont want the translated text to appear cut just where a comma appears, we are using unity version 2022.3.26f1 and AC 1.74.72
The quotation marks are necessary in the CSV file for it to be correctly formatted.
Are they appearing in-game after importing, i.e. as subtitle text? They should be removed when processed.
If you're just looking to remove them as part of the translation workflow, you'd need to have an additional script that re-adds the quotation marks before importing back into AC.
hi, I have a reverse problem: exporting csv from adventure creator outputs a csv file without quotes, while unity localization requires quotes, otherwise, when importing into unity localization, the key column will be displayed, but not the replica columns; what could be the reason?
What is the exact syntax you wish to export with? With quotes around all cells?
yes, like this
When exporting, the csv structure of adventure creator and unity localization differs: adventure creator does not have a Key column.
unity localization export:
Key,Id,Russian (Russia)(ru-RU),English (United States)(en-US)AC export:
ID, original, englishAC column structure differs from that of Localization because its ID value serves the purpose of Key as well.
I can potentially add an option to surround each cells with quotation marks, however.