CSV Import Problem

More
3 years 11 months ago #952 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!

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

More
3 years 11 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.

More
3 years 11 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! =)

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

More
3 years 11 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.

More
3 years 11 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
Attachments:

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

More
3 years 10 months ago #1051 by wagenheimer
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

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

Time to create page: 0.160 seconds
Template by JoomlaShine