Difficulty importing .csv files

Start
Prev
1
Next
End

1

JHoffstein
Topic Author
Offline
New Member

More

10 years 2 months ago - 10 years 2 months ago #273 by JHoffstein

Difficulty importing .csv files was created by JHoffstein

Hello - Ok, I took the plunge and got I2 localization! I'm stumbling a bit trying to get up and running though. I have a spreadsheet of all my localized terms and I exported that as a .csv file. When I try to import the file in the I2Langauges prefab I get this error:
"No terms where found during parsing"

Attachment LocError1.jpg not found

However, if I then click on the "Languages" tab it looks like every single cell in my spreadsheet has been imported as a language. This slows Unity down to a crawl and I have to revert or delete the prefab.

Attachment LocError2.jpg not found

I'm not sure what I'm doing wrong here?

Thanks,
Jenna

Last edit: 10 years 2 months ago by JHoffstein. Reason: Attachments didn't work

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

Frank
Offline
Administrator

More

10 years 2 months ago #274 by Frank

Replied by Frank on topic Difficulty importing .csv files

Hi,
It seems that your existing spreadsheet doesn't have the format that the I2 Loc needs and thats why its not detecting any term and its filling the languages section with terms instead of languages.

The format of the spreadsheet should be:

Key	Type	Desc	Language1	Language2	...
Term1	Text	Description	Translation1	Translation2	...
Term2	Text	Description	Translation1	Translation2	...

My advice is to delete all languages/terms from the language source.
Then go to the languages tab and add the languages you want.
Then go to the terms tab and add 1 term.
Export that source into a csv file

Open the CSV file in excel or whatever editor you are using and then copy into that spreadsheet your existing terms/translations but keep the format.

Thanks,
Frank

Are you