public string Import_CSV(string Category, string CSVstring, eSpreadsheetUpdateMode UpdateMode = eSpreadsheetUpdateMode.Replace, char Separator = ',')
{
List <string[]> CSV = LocalizationReader.ReadCSV(CSVstring, Separator);
return(Import_CSV(Category, CSV, UpdateMode));
}
public string Import_CSV(string Category, string CSVstring, eSpreadsheetUpdateMode UpdateMode = eSpreadsheetUpdateMode.Replace, char Separator = ',')
{
List <string[]> CSV = LocalizationReader.ReadCSV(CSVstring, Separator);
//--[ Languages ]--------------
string[] Tokens = CSV[0];
int LanguagesStartIdx = 1;
int TypeColumnIdx = -1;
int DescColumnIdx = -1;
var ValidColumnName_Key = new string[] { "Key" };
var ValidColumnName_Type = new string[] { "Type" };
var ValidColumnName_Desc = new string[] { "Desc", "Description" };
if (Tokens.Length > 1 && ArrayContains(Tokens[0], ValidColumnName_Key))
{
if (UpdateMode == eSpreadsheetUpdateMode.Replace)
{
ClearAllData();
}
if (Tokens.Length > 2)
{
if (ArrayContains(Tokens[1], ValidColumnName_Type))
{
TypeColumnIdx = 1;
LanguagesStartIdx = 2;
}
if (ArrayContains(Tokens[1], ValidColumnName_Desc))
{
DescColumnIdx = 1;
LanguagesStartIdx = 2;
}
}
if (Tokens.Length > 3)
{
if (ArrayContains(Tokens[2], ValidColumnName_Type))
{
TypeColumnIdx = 2;
LanguagesStartIdx = 3;
}
if (ArrayContains(Tokens[2], ValidColumnName_Desc))
{
DescColumnIdx = 2;
LanguagesStartIdx = 3;
}
}
}
else
{
return("Bad Spreadsheet Format.\nFirst columns should be 'Key', 'Type' and 'Desc'");
}
int nLanguages = Mathf.Max(Tokens.Length - LanguagesStartIdx, 0);
int[] LanIndices = new int[nLanguages];
for (int i = 0; i < nLanguages; ++i)
{
string LanName, LanCode;
GoogleLanguages.UnPackCodeFromLanguageName(Tokens[i + LanguagesStartIdx], out LanName, out LanCode);
int LanIdx = -1;
if (!string.IsNullOrEmpty(LanCode))
{
LanIdx = GetLanguageIndexFromCode(LanCode);
}
else
{
LanIdx = GetLanguageIndex(LanName);
}
if (LanIdx < 0)
{
LanguageData lanData = new LanguageData();
lanData.Name = LanName;
lanData.Code = LanCode;
mLanguages.Add(lanData);
LanIdx = mLanguages.Count - 1;
}
LanIndices[i] = LanIdx;
}
//--[ Update the Languages array in the existing terms]-----
nLanguages = mLanguages.Count;
for (int i = 0, imax = mTerms.Count; i < imax; ++i)
{
TermData termData = mTerms[i];
if (termData.Languages.Length < nLanguages)
{
Array.Resize(ref termData.Languages, nLanguages);
Array.Resize(ref termData.Languages_Touch, nLanguages);
Array.Resize(ref termData.Flags, nLanguages);
}
}
//--[ Keys ]--------------
for (int i = 1, imax = CSV.Count; i < imax; ++i)
{
Tokens = CSV[i];
string sKey = string.IsNullOrEmpty(Category) ? Tokens[0] : string.Concat(Category, "/", Tokens[0]);
bool isTouch = false;
if (sKey.EndsWith("[touch]"))
{
sKey = sKey.Remove(sKey.Length - "[touch]".Length);
isTouch = true;
}
LanguageSource.ValidateFullTerm(ref sKey);
if (string.IsNullOrEmpty(sKey))
{
continue;
}
TermData termData = GetTermData(sKey);
// Check to see if its a new term
if (termData == null)
{
termData = new TermData();
termData.Term = sKey;
termData.Languages = new string[mLanguages.Count];
termData.Languages_Touch = new string[mLanguages.Count];
termData.Flags = new byte[mLanguages.Count];
for (int j = 0; j < mLanguages.Count; ++j)
{
termData.Languages[j] = termData.Languages_Touch[j] = string.Empty;
}
mTerms.Add(termData);
mDictionary.Add(sKey, termData);
}
else
// This term already exist
if (UpdateMode == eSpreadsheetUpdateMode.AddNewTerms)
{
continue;
}
if (TypeColumnIdx > 0)
{
termData.TermType = GetTermType(Tokens[TypeColumnIdx]);
}
if (DescColumnIdx > 0)
{
termData.Description = Tokens[DescColumnIdx];
}
for (int j = 0; j < LanIndices.Length && j < Tokens.Length - LanguagesStartIdx; ++j)
{
if (!string.IsNullOrEmpty(Tokens[j + LanguagesStartIdx])) // Only change the translation if there is a new value
{
var value = Tokens[j + LanguagesStartIdx];
var isAuto = value.StartsWith("[i2auto]");
if (isAuto)
{
value = value.Substring("[isauto]".Length);
if (value.StartsWith("\"") && value.EndsWith("\""))
{
value = value.Substring(1, value.Length - 2);
}
}
//if (value=="-")
// value = string.Empty;
var lanIdx = LanIndices[j];
if (isTouch)
{
termData.Languages_Touch[lanIdx] = value;
if (isAuto)
{
termData.Flags[lanIdx] |= (byte)TranslationFlag.AutoTranslated_Touch;
}
else
{
termData.Flags[lanIdx] &= byte.MaxValue ^ ((byte)TranslationFlag.AutoTranslated_Touch);
}
}
else
{
termData.Languages[lanIdx] = value;
if (isAuto)
{
termData.Flags[lanIdx] |= (byte)TranslationFlag.AutoTranslated_Normal;
}
else
{
termData.Flags[lanIdx] &= byte.MaxValue ^ ((byte)TranslationFlag.AutoTranslated_Normal);
}
}
}
}
}
return(string.Empty);
}