Empty quote string "" import problem

More
4 years 8 months ago #617 by zpr
Hello.

I'm having a problem with empty quote strings "" when I am importing to i2L. Here's a example:

Importing the following csv to i2L:


I will get a Quote " in every 'Description' field:


Exporting back to CSV from i2L I get the following output:



I'm using i2L v2.4.5 f3 and Unity3d v4.6.4 f1

Thanks.

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

More
4 years 8 months ago - 4 years 8 months ago #621 by Frank
Hi,
I'm going to double check in excel to see if there has been any change in the csv format.
However, what you are seeing is kind of expected behavior.

When you export a csv from excel the empty columns are not exported as:
Key,"",Desc
instead, they are exported as:
Key,,Desc

When parsing the csv file, ("") and most (""") are interpreted as one quote (").

Is the csv file you show in the picture exported by a spreadsheet software or by an in-house tool? If its by a known software, please let me know so I can check how it outputs and adapt the code to handle that as well.

Nonetheless, I will double check in excel and google spreadsheet to verify thats the expected behavior.

However, a quick fix to make those csv work fine, is to replace (,"",) by (,,).

Hope that helps,
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
Last edit: 4 years 8 months ago by Frank.

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

More
4 years 8 months ago #622 by zpr
I'm not using excel or google spreadsheet. I'm using crowdin crowdin.com (a well known software). Before translators started doing the translations I imported the export CSV (keys & default language) from i2L to crowdin. The export from crowdin comes with double quotes in everything.

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

Time to create page: 0.165 seconds
Template by JoomlaShine