Question How can I do column mapping for GoogleSheet in Localization?

Hello. I'm using Unity Localization and I have such situation: I have about 30 StringTableCollection-s which I should translate to over 10 languages. Translations I get from a GoogleSheet via GoogleSheetExtension in Unity. So, in this extencion I have to map "locale" to "column" in google sheet. As you can see, I have to map 10 locales in 30 table collections manually. And in inspector I cannot copy-paste 'component' GoogleSheetExtension. Is there any way to automate this tedious process? Can I someway copy columns mapping and paste it to another extension?

 

First advice is OK, but I only have "Add default column" and don't have "Extract Column..." option



Did I understand correctly, that using this script I can change data in google sheet extension in editor? Or it's suitable for runtime setup?

 

Thanks, that's clear.
And can you prompt, how can I use this script to access the GoogleSheetProvider and map columns to locales?

P.S. Yeap, I'm using API key for google sheets

 

Oh, thank you very much, that's exactly what I needed! I also modified your code and I get copy-paste functionality for this extension

Code (CSharp):

1. using System.Collections.Generic;
2. using System.Linq;
3. using UnityEditor;
4. using UnityEditor.Localization;
5. using UnityEditor.Localization.Plugins.Google;
6. using UnityEditor.Localization.Plugins.Google.Columns;
7.  
8. public static class TableCollectionFuncExtension {
9.  
10.     private static List<SheetColumn> BUFFER;
11.     private static string SPREADSHEET_ID;
12.  
13.     [MenuItem("CONTEXT/StringTableCollection/Copy GoogleSheetExtension data")]
14.     public static void CopyData(MenuCommand command) {
15.         var collection = command.context as StringTableCollection;
16.      
17.         var googleExtension = collection.Extensions.FirstOrDefault(e => e is GoogleSheetsExtension) as GoogleSheetsExtension;
18.         if (googleExtension != null) {
19.             BUFFER = new List<SheetColumn>();
20.             foreach (var column in googleExtension.Columns) {
21.                 if (column is KeyColumn keyColumn) {
22.                     BUFFER.Add(new KeyColumn {Column = keyColumn.Column});
23.                 } else if (column is LocaleColumn locColumn) {
24.                     BUFFER.Add(new LocaleColumn {Column = locColumn.Column, LocaleIdentifier = locColumn.LocaleIdentifier});
25.                 }
26.             }
27.  
28.             SPREADSHEET_ID = googleExtension.SpreadsheetId;
29.  
30.         }
31.     }
32.  
33.     [MenuItem("CONTEXT/StringTableCollection/Paste GoogleSheetExtension data")]
34.     public static void PasteData(MenuCommand command) {
35.         var collection = command.context as StringTableCollection;
36.      
37.         var googleExtension = collection.Extensions.FirstOrDefault(e => e is GoogleSheetsExtension) as GoogleSheetsExtension;
38.         if (googleExtension == null) {
39.             googleExtension = new GoogleSheetsExtension();
40.             collection.AddExtension(googleExtension);
41.         }
42.  
43.         var columnsList = new List<SheetColumn>();
44.         foreach (var column in BUFFER) {
45.             if (column is KeyColumn keyColumn) {
46.                 columnsList.Add(new KeyColumn {Column = keyColumn.Column});
47.             } else if (column is LocaleColumn locColumn) {
48.                 columnsList.Add(new LocaleColumn {Column = locColumn.Column, LocaleIdentifier = locColumn.LocaleIdentifier});
49.             }
50.         }
51.      
52.      
53.         //paste values to the extension
54.         const string pathToYourAsset = "Assets/Localization/Tables/Google Sheet Extension.asset"; //The path to your SheetsServiceProvider asset. See docs for further info.
55.         var sheetsServiceProvider = AssetDatabase.LoadAssetAtPath<SheetsServiceProvider>(pathToYourAsset);
56.         googleExtension.SheetsServiceProvider = sheetsServiceProvider;
57.      
58.         googleExtension.SpreadsheetId = SPREADSHEET_ID;
59.         googleExtension.Columns.AddRange(columnsList);
60.      
61.         EditorUtility.SetDirty(collection);
62.     }
63. }

 

Can you answer one more question? When should I use this code??

Code (CSharp):

1. LocalizationSettings.InitializationOperation

I'm passing localized string keys to prefabs and scriptable objects, and I don't know at which point should I initialize localization.
Now I don't call 'LocalizationSettings.InitializationOperation' and everything works fine.