English Column Disappearing Automatically

[Only4gamers]

Hello everyone,
My English translation in table collection is disappearing after some time. and there is a button appearing there of “Add English (en)”. when I am clicking this button all my English translations are disappearing.

Other then this problem I have some questions also.
By default my game is using English language and all text components are already have English texts are included. So, my questions are:

1. Does I still need to generate English from Locale Generator?
2. Does I need to Add English words in Table Collection?
3. Does I need to choose English in Specific Locale Selector?
4. Do I need to remove all Texts from text components?
   Please help me on this.

[karl_jones]

@Only4gamers

Hello everyone,
My English translation in table collection is disappearing after some time. and there is a button appearing there of “Add English (en)”. when I am clicking this button all my English translations are disappearing.

Are you modifying the Addressables?
Can you file a bug report for this?

@Only4gamers

Other then this problem I have some questions also.
By default my game is using English language and all text components are already have English texts are included. So, my questions are:

1. Does I still need to generate English from Locale Generator?
2. Does I need to Add English words in Table Collection?
3. Does I need to choose English in Specific Locale Selector?
4. Do I need to remove all Texts from text components?
   Please help me on this.

Whilst you could just keep all the defaults as English and not have an English table it would mean that if you changed language in a scene you would not be able to change back to English as the values would have been overwritten and are not stored anywhere else. You would need to reload the scene instead. It would also make it harder when working with translators if you need to send the English values as a reference.
We do have some features in development that would allow you to store a default language in the scene and still be able to switch back and forth so that you can work in a more natural way, more on this in the future.
For now, I would say that having an English table is recommended and will certainly be a benefit when you need to start getting translations.

[Only4gamers]

@karl_jones

Are you modifying the Addressables?
Can you file a bug report for this?

I am not modifying the Addressables. I am using Unity 2019.4.0f1 and Latest localization v0.7.1. My game is just a simple racing game. and there is not much texts. Just some UI related things need translation. Why this problem happening with me? What thing can cause this issue? Can updating Unity version help anything?

[karl_jones]

@Only4gamers

I am not modifying the Addressables. I am using Unity 2019.4.0f1 and Latest localization v0.7.1. My game is just a simple racing game. and there is not much texts. Just some UI related things need translation. Why this problem happening with me? What thing can cause this issue? Can updating Unity version help anything?

Does the table disappear whilst you are editing or when you open the window?
The table not being found would likely be an issue in Addressables or the Table collection. If you select the collection asset for the tables does it show the table in the list of tables?

[Only4gamers]

@karl_jones

Does the table disappear whilst you are editing or when you open the window?
The table not being found would likely be an issue in Addressables or the Table collection. If you select the collection asset for the tables does it show the table in the list of tables?

Table disappear when i open table collection window.

Yesterday this happens 2-3 times in 10-20 minutes. And I am not sure what causes this problem. Today I tried to reproduce this problem, but there is no problem today. If I found the actual reason behind this bug, I will inform you. or how to reproduce this bug. Thanks for your time and help.

[Only4gamers]

Recently this problem happening frequently so now I have more info for this bug.

1. All columns are disappearing but just first column is not affected. Maybe because when I created This Table Collection only Russian language is there at first. I added English and french later.
   
2. When clicking NewTable file there is message in inspector in Loose Tables “The following table do not belong to…”.
   
3. and in NewTable_en file there is a warning in inspector “The table does not belong to a Collection…”
   
4. when I am clicking “Add table to collection” in NewTable_en file it is restoring my translations in Table Collection Window. But it again disappearing after some time.

[karl_jones]

The collection contains an internal list of all the Tables. It looks like its losing them for some reason.
Can you change the Table Collection editor to debug and see whats in the list?
Like this:

[Only4gamers]

@karl_jones

The collection contains an internal list of all the Tables. It looks like its losing them for some reason.
Can you change the Table Collection editor to debug and see whats in the list?
Like this:

It’s only showing russian table. When I am clicking “Add table to collection” in NewTable_en file then english is also added there.

[karl_jones]

@Only4gamers

It’s only showing russian table. When I am clicking “Add table to collection” in NewTable_en file then english is also added there.

Can you then save the project and restart Unity and see if its still in the list?

[Only4gamers]

@karl_jones

Can you then save the project and restart Unity and see if its still in the list?

Columns disappear always whenever I restart Unity Editor. No matter what i tried.

[karl_jones]

After adding the table and saving the project can you try opening the collection asset file in a text editor?
You should see an entry that says m_Tables, under it there should be one for each table. Is it adding the table to the collection?
For example this one has 6 tables:

%YAML 1.1
%TAG !u! tag:unity3d.com,2011:
--- !u!114 &11400000
MonoBehaviour:
  m_ObjectHideFlags: 0
  m_CorrespondingSourceObject: {fileID: 0}
  m_PrefabInstance: {fileID: 0}
  m_PrefabAsset: {fileID: 0}
  m_GameObject: {fileID: 0}
  m_Enabled: 1
  m_EditorHideFlags: 0
  m_Script: {fileID: 11500000, guid: 5be51871efa6c3e4eae1703925c8f5ac, type: 3}
  m_Name: Preloading Test
  m_EditorClassIdentifier: 
  m_SharedTableData: {fileID: 11400000, guid: aa28bdbc6e58c384bbc1be5258967cf4, type: 2}
  m_Tables:
  - {fileID: 11400000, guid: a6a8f4a11044ac749ad94d144a756d7c, type: 2}
  - {fileID: 11400000, guid: 1938047633926c445be0bd5e363512f7, type: 2}
  - {fileID: 11400000, guid: 11ebb3e5cd0f8a44488744d95dcdf688, type: 2}
  - {fileID: 11400000, guid: b736a9cb1b91bf0469bbf7b90a6820fc, type: 2}
  - {fileID: 11400000, guid: 1ecf33514643aea4e86e333fb3254b96, type: 2}
  - {fileID: 11400000, guid: 79699ba4e2cdab841828d45ad96b58fb, type: 2}
  m_Extensions: []
  references:
    version: 1

[Only4gamers]

@karl_jones

After adding the table and saving the project can you try opening the collection asset file in a text editor?
You should see an entry that says m_Tables, under it there should be one for each table. Is it adding the table to the collection?
For example this one has 6 tables:

%YAML 1.1
%TAG !u! tag:unity3d.com,2011:
--- !u!114 &11400000
MonoBehaviour:
  m_ObjectHideFlags: 0
  m_CorrespondingSourceObject: {fileID: 0}
  m_PrefabInstance: {fileID: 0}
  m_PrefabAsset: {fileID: 0}
  m_GameObject: {fileID: 0}
  m_Enabled: 1
  m_EditorHideFlags: 0
  m_Script: {fileID: 11500000, guid: 5be51871efa6c3e4eae1703925c8f5ac, type: 3}
  m_Name: Preloading Test
  m_EditorClassIdentifier:
  m_SharedTableData: {fileID: 11400000, guid: aa28bdbc6e58c384bbc1be5258967cf4, type: 2}
  m_Tables:
  - {fileID: 11400000, guid: a6a8f4a11044ac749ad94d144a756d7c, type: 2}
  - {fileID: 11400000, guid: 1938047633926c445be0bd5e363512f7, type: 2}
  - {fileID: 11400000, guid: 11ebb3e5cd0f8a44488744d95dcdf688, type: 2}
  - {fileID: 11400000, guid: b736a9cb1b91bf0469bbf7b90a6820fc, type: 2}
  - {fileID: 11400000, guid: 1ecf33514643aea4e86e333fb3254b96, type: 2}
  - {fileID: 11400000, guid: 79699ba4e2cdab841828d45ad96b58fb, type: 2}
  m_Extensions: []
  references:
    version: 1

I need to open this file?

I opened this file after adding tables and saving. But there is no tables and i am having problems reading this file with my softwares. I attached this file, please check.

6101337–663537–NewTable.txt (4.16 KB)

[karl_jones]

Oh yes, it looks like its using binary serialization.
I was able to read the file though, it only has a single table in it. So for some reason, the changes are not being saved to disk which is why the data gets lost over time.
Ok, I see the problem. We are not setting the Collection dirty when adding or removing a table.
Ill get this fixed for the next version. For now you can work around this by forcing the collection to be dirty so that it saves the changes to disk.
One way to do this is

• Add the tables

• Click the Add(+) extension button and add a Google sheets extension.

• Remove the extension by selecting it and pressing the remove(-) button.

• Now save the project. It should have saved the tables to the file now.

• Restart Unity and see if it works

I created a bug for this Unity Issue Tracker - Collections are not set dirty when adding or removing tables

[Only4gamers]

@karl_jones

Oh yes, it looks like its using binary serialization.
I was able to read the file though, it only has a single table in it. So for some reason, the changes are not being saved to disk which is why the data gets lost over time.
Ok, I see the problem. We are not setting the Collection dirty when adding or removing a table.
Ill get this fixed for the next version. For now you can work around this by forcing the collection to be dirty so that it saves the changes to disk.
One way to do this is

• Add the tables

• Click the Add(+) extension button and add a Google sheets extension.

• Remove the extension by selecting it and pressing the remove(-) button.

• Now save the project. It should have saved the tables to the file now.

• Restart Unity and see if it works

I created a bug for this https://issuetracker.unity3d.com/product/unity/issues/guid/LOC-107

Ok, I tried your solution and it worked. I restarted and everything is there. Thank you so much for your support

[Houtamelo]

I had the same issue, it was fixed by adding the google sheets extension, though i didn’t remove it, just started using google sheets as well.

Edit: After restarting Unity one time the tables were still there. however after the second time they were not there anymore, so i had to add and remove the google sheets extension each time i restart unity.