CSV Import Problem
- wagenheimer
- Topic Author
- Offline
- Junior Member
9 years 3 months ago #952
by wagenheimer
Game Developer on www.greensaucegames.com and www.sevensails.com.br
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!
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.
9 years 3 months ago #963
by Frank
Are you Give I2L 5 stars!
Are you Please lets us know how to improve it!
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
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
9 years 3 months ago #964
by wagenheimer
Game Developer on www.greensaucegames.com and www.sevensails.com.br
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.
The file is attached here.
I hope this help you find the problem! =)
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.
9 years 3 months ago #966
by Frank
Are you Give I2L 5 stars!
Are you Please lets us know how to improve it!
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
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
9 years 3 months ago #968
by wagenheimer
Game Developer on www.greensaucegames.com and www.sevensails.com.br
Replied by wagenheimer on topic CSV Import Problem
Here is it!
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
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.
- wagenheimer
- Topic Author
- Offline
- Junior Member
9 years 2 months ago #1051
by wagenheimer
Game Developer on www.greensaucegames.com and www.sevensails.com.br
Replied by wagenheimer on topic CSV Import Problem
Any news on this?
I still have to remember updating the CSV importer always I update do a new version of i2
I still have to remember updating the CSV importer always I update do a new version of i2
Game Developer on www.greensaucegames.com and www.sevensails.com.br
Please Log in or Create an account to join the conversation.
Time to create page: 0.165 seconds