Issue with " and , on Translation CSV

duckmadeofwood

Hi @ChrisIceBox.
I'm trying to import the Italian translation on my last game Day of The Jellyfish.

This is the CSV I'm using. I used Visual Code Studio to edit (never had issues before):

The English is working perfectly. However the speech of the italian translation appears surrounded by the " " when I put them in sentences with the comma , .
If I remove the " " the sentence will appear cut at the comma. Instead the Original Text column appear correctly without the " ".

The Languages settings:

Unity version: 2022.3.26f1
Adventure Creator v.1.81.2

Thanks

ChrisIceBox

The speech marks surrounding the import text is part of the CSV standard format, so as to create a disctinction between commas in the text, and commas that separate cells. They'll need to be left alone for the import process to work.

These marks should be removed automatically, however. Would it be possible to PM me your Speech Manager asset file, and the CSV file, so that I could test it on my end?

duckmadeofwood

So maybe something went wrong when I imported the CSV with the italian translation and I didn't get the " " automatically. Ok. I'm going to send you the files. Thanks for looking into this.

ChrisIceBox

The lines that have speech marks surround them need to do so without a leading space, i.e.:

135,Speech,"Cabot Cove. Home town of America’s favorite, Duka Nuka","Cabot Cove, la città natale della bevanda preferita dagli americani, la Duka Nuka."

Instead of:

135,Speech,"Cabot Cove. Home town of America’s favorite, Duka Nuka", "Cabot Cove, la città natale della bevanda preferita dagli americani, la Duka Nuka."

I'm not sure if this space was added as a part of the translation / editing process, however.

duckmadeofwood

Thank you @ChrisIceBox going to fix the spaces and try again.

duckmadeofwood

Hi! @ChrisIceBox. I'm testing the new version. It looks fine, except for this line:
162,Speech,"Dude, they should give you the golden key to the factory and all kinds of free swag!","Amico, dovrebbero regalarti la chiave dorata della fabbrica e tutta la roba a gratis!" The " " still appears on this one even with no space after the comma. Do you see any reason for that?

ChrisIceBox

The line ends with a hidden space ( ) character after the closing speech mark.

Rather than editing such files in a raw text editor, I recommend using a spreadsheet tool as it should help avoid such formatting issues. OpenOffice in particular is a good option, as it lets you dictate the exact text/cell delimiters (" and , respectively) when importing.

duckmadeofwood

Cool. I will switch tool. Thanks for the heads up, I know what to look for in order to fix the issues. Many thanks.

duckmadeofwood

Hi @ChrisIceBox. Do you mind sharing a screenshot of what import setting you are using with OpenOffice to edit the CSV? How do you make him to ignore the , if it is between " " ? Thanks.

duckmadeofwood

Oh, I managed the second time around.
If anyone else need it, it is:
Separate - Check Comma
Separator of text - Insert "