How can i access table collections at runtime?

Unity Engine
, ,
1

I have this code to import csv files to tables but i need to do it at runtime. Is it possible?

            var stringTableCollections = LocalizationEditorSettings.GetStringTableCollections();
          
            //var path = EditorUtility.SaveFolderPanel("Export All String Table Collections - CSV", "", "");
            if (string.IsNullOrEmpty(path))
                return;

            foreach (var collection in stringTableCollections)
            {
                var file = Path.Combine(path, collection.TableCollectionName + ".csv");
                using (var stream = new StreamReader(file))
                {
                    Csv.ImportInto(stream, collection, false, null, false);
                }
            }

I am trying this but i get a list of StringTables and not StringTableCollections

        private static IEnumerator ImportCsvFiles()
        {
            var tables = LocalizationSettings.StringDatabase.GetAllTables();
            yield return tables;
            //var path = EditorUtility.SaveFolderPanel("Export All String Table Collections - CSV", "", "");
            if (!string.IsNullOrEmpty(path))
            {
                foreach (var table in tables.Result)
                {
                    var file = Path.Combine(path, table.TableCollectionName + ".csv");
                    using (var stream = new StreamReader(file))
                    {
                        Csv.ImportInto(stream, table as StringTableCollection, false, null, false);
                    }
                }
            }
        }
2

Yes we support this
https://docs.unity3d.com/Packages/com.unity.localization@1.4/manual/Scripting.html
See Applying changes to a table after the game is built.
We don’t support importing csv in the player though, you would need to parse the file yourself.

3

When i use getentry gives me just the value of one of the languages, how can i get and set for all languages?

4

In the player, you would not want to do it for every language but just for the language that is currently in use, we don’t load the other languages (unless they are fallback - see preload behavior)
The changes you make in the player are not saved, they are only for that run so you need to do this every time the player starts, so it’s not ideal to update every language since you will usually only need 1.
You could filter the csv when you load it to extract what you need or have a csv per language and just load the one you need.

5

There is any way to import csv or json to the tables at runtime? i can do it in editor but not in runtime. I don’t see a way to do it with the link you provided previously as i just get one of the languages so i can’t save for all languages. If i filter what i need from the csv wouldn’t change anything cause i just can save changes for one language.
I have the csv in StreamingAssets so that the person who is going to run the build can change the csv or json and i need to load the tables from the csv or json

6

i see getalltables have a parameter of locale so i can choose the language

7

No, we don’t provide any runtime parsers but it’s quite simple to do, especially with json.

Example pseudo-code

[Serializable]
public class CustomTablePatcher : ITablePostprocessor
{
    public void PostprocessTable(LocalizationTable table)
    {
        if (table is StringTable stringTable)
        {
            var file = Path.Combine(path, $"{stringTable.TableCollectionName}_{table.LocaleIdentifier.Code}.json");

            // TODO: Parse the CSV/Json file and extract the column for table "table.LocaleIdentifier.Code"

            foreach (var row in csvFile)
            {
                // Update an old value
                var entry = stringTable.GetEntry(row.Id);
                if (entry != null)
                {
                    entry.Value = row.Value;
                }
                else
                {
                    // Add a new value
                    stringTable.AddEntry(row.Id, row.Value);
                }
            }
        }
    }
}

Create a file format to store the data and parse using JsonUtility.

Something simple would be:

[Serializable]
class LocalizationEntry
{
    public string key;
    public string value;
}

[Serializable]
class LocalizationData
{
    public List<LocalizationEntry> entries;
}

You could create some editor scripts to generate the json files in the Editor, like you do above, get the collections but convert them into the json and save them as .json files in StreamingAssets.

Ill create a task for us to put together a package sample to show how to do all of this in the future.

8

I got it working in editor but in build doesn’t work, entry.Value = row.Value; doesn’t update the value

9

How do you know its not working, how are you checking the value?
Does a new value get applied in PostprocessTable?
These changes wont be saved to the table in Editor, it will be a play mode only feature.

10

I know cause the UI text is not updated. But i am doing something wrong cause it just updates in one language but not in the other. I use LocalizationSettings.StringDatabase.GetAllTables twice, one for each language. Then i get the right entry value from the json but when i assign this value to entry.Value just update in one of the languages. I tried to change locale with LocalizationSettings.SelectedLocale = LocalizationSettings.AvailableLocales.Locales[localeId]; before getalltables but doesn’t work

11

You are calling getalltables and then updating the values? That wont work, the values will be updated after the table has loaded but before you have applied the changes, you need to use a ITablePostprocessor to make the changes before the table is used.

12

I got to solve the issue, i was trying to load both languages one after the other, but i have to choose one language and make the changes just for that one

13

It works, but not when i tried to change both tables one after the other

14

It’s probably unloading the old language and losing the changes when you switch active locale.