CSV Import Problem

1
2

wagenheimer
Topic Author
Offline
Junior Member

More

8 years 7 months ago #952 by wagenheimer

CSV Import Problem was created by wagenheimer

When importing from CSV, I2 is adding an \r\ at end of each of my terms.

Is this expected?

I made a workaround for it, but an official fix would be nice! =)

Thanks!

Game Developer on www.greensaucegames.com and www.sevensails.com.br

Please Log in or Create an account to join the conversation.

Frank
Offline
Administrator

More

8 years 7 months ago #963 by Frank

Replied by Frank on topic CSV Import Problem

Hi,
I'm trying to reproduce that issue but I'm not getting \r\ added to the terms.

I took the Source in the UnityStandard Localization example scene and export it to CSV. (that source has a couple terms with multi-line translations)

Then imported back by clicking (CSV->Import->Replace), That worked correctly.
Then I opened the CSV in excel, did some modifications and exported back to the csv.

Imported again into I2L and it worked fine.

Can you please let me know what steps you did to create the issue?
Are you on Mac or Windows?
In which program are you editing the CSV file?
Are you running I2L v2.5.0 or v2.6.0?

Sorry for the inconvenience and I will try to reproduce the error asap and add an official workaround.

Thanks,
Frank

Are you

Give I2L 5 stars!
Are you

Please lets us know how to improve it!

To get the betas as soon as they are ready, check this out

Please Log in or Create an account to join the conversation.

wagenheimer
Topic Author
Offline
Junior Member

More

8 years 7 months ago #964 by wagenheimer

Replied by wagenheimer on topic CSV Import Problem

I'm importing the CSV using this code on Application Start;
I'm using an UTF8 CSV file.

string CSVstring;
CSVstring = File.ReadAllText(Application.streamingAssetsPath + "/fr.csv");

LocalizationManager.Sources[0].Import_CSV(string.Empty, CSVstring, eSpreadsheetUpdateMode.Replace, ';');
LocalizationManager.CurrentLanguage = LocalizationManager.Sources[0].mLanguages[0].Name;
LocalizationManager.LocalizeAll();

The file is attached here.

I hope this help you find the problem! =)

Game Developer on www.greensaucegames.com and www.sevensails.com.br

Please Log in or Create an account to join the conversation.

Frank
Offline
Administrator

More

8 years 7 months ago #966 by Frank

Replied by Frank on topic CSV Import Problem

Hi,
Can you attach the csv file? It seems that the forum didn't upload it.

One thing I'm noticing is that you are setting the separator to be ';' instead of ','
Can I ask in which program/settings are you generating the csv file? Even on excel the default for csv is a comma, so, maybe one of the settings is off.

I tried exporting/importing with the plugin settings set to semicolon but it was behaving correctly. Hopefully, your csv file should be able to show me what could be the issue.

Thanks a lot,
Frank

Are you

Give I2L 5 stars!
Are you

Please lets us know how to improve it!

To get the betas as soon as they are ready, check this out

Please Log in or Create an account to join the conversation.

wagenheimer
Topic Author
Offline
Junior Member

More

8 years 7 months ago #968 by wagenheimer

Replied by wagenheimer on topic CSV Import Problem

Here is it!

File Attachment:

File Name: fr.csv
File Size:11 KB

Strange, my Excel only opens CSV files with a double click when the separator is ; instead of a comma.

But I hope the file helps you find the problem.

Please let me know if you need anything else.

Thanks

Game Developer on www.greensaucegames.com and www.sevensails.com.br

Please Log in or Create an account to join the conversation.