void ShowExportGUI()
{
if (GUILayout.Button("Export"))
{
string folderPath = EditorUtility.OpenFolderPanel("Select folder to save to.", "", "");
if (availableFileFormats[chosenFileFormat] == csvFileEnding)
{
string fullPath = folderPath + "/" + exportFileName + csvFileEnding;
CSVParser.Write(fullPath, CSVParser.GetDelimiter(delimiter),
new List <string>(LanguageHandlerEditor.LoadLanguageFile(null, true).Keys), LanguageHandlerEditor.LoadAllLanguageFiles());
Debug.Log("Exported CSV file to " + fullPath);
this.Close();
}
else if (availableFileFormats[chosenFileFormat] == xlsFileEnding)
{
string fullPath = folderPath + "/" + exportFileName + xlsFileEnding;
XLSExporter.Write(fullPath, "Languages",
new List <string>(LanguageHandlerEditor.LoadLanguageFile(null, true).Keys), LanguageHandlerEditor.LoadAllLanguageFiles());
Debug.Log("Exported XLS file to " + fullPath);
this.Close();
}
else
{
Debug.LogError("BulkUpdateWindow: Unsupported export format!");
}
}
}
void ExportToXLS(string chosenExportFolder)
{
string name = chosenCulture.englishName + " - " + chosenCulture.languageCode + xlsFileEnding;
XLSExporter.Write(chosenExportFolder + "/" + name, chosenCulture.englishName,
LanguageHandlerEditor.LoadLanguageFile(chosenCulture.languageCode, false));
}
public void CreateWorkbookFromMultipleDictsWithNullKeys_ExpectedException()
{
var dictionaries = new Dictionary <string, Dictionary <string, string> >();
dictionaries.Add("en", testData);
Assert.That(() => XLSExporter.CreateWorkbookFromMultipleDictionaries("MySheet", null, dictionaries), Throws.ArgumentNullException);
}
public void CreateWorkbookFromMultipleDictsWithNullKeys_ExpectedException()
{
var dictionaries = new Dictionary <string, Dictionary <string, string> >();
dictionaries.Add("en", testData);
XLSExporter.CreateWorkbookFromMultipleDictionaries("MySheet", null, dictionaries);
}
public void CreateWorkbookFromMultipleDictsWithNullSheetName_ExpectedException()
{
var dictionaries = new Dictionary <string, Dictionary <string, string> >();
dictionaries.Add("en", testData);
XLSExporter.CreateWorkbookFromMultipleDictionaries(null, new List <string>(), dictionaries);
}
void UpdateFromXLS(string chosenUpdateFile)
{
var values = XLSExporter.Read(chosenUpdateFile);
LanguageHandlerEditor.UpdateLanguageFile(chosenCulture.languageCode, values);
if (parentWindow.translateLanguageWindow != null)
{
parentWindow.translateLanguageWindow.ReloadLanguage();
}
}
public void CreateWorkbookFromDict()
{
var workbook = XLSExporter.CreateWorkbookFromDictionary("MySheet", testData);
Assert.AreEqual(1, workbook.NumberOfSheets);
var sheet = workbook.GetSheetAt(0);
Assert.AreEqual("MySheet", sheet.SheetName);
Assert.AreEqual("TestKey", sheet.GetRow(0).GetCell(0).StringCellValue);
Assert.AreEqual("TestValue", sheet.GetRow(0).GetCell(1).StringCellValue);
Assert.AreEqual("TestKey2", sheet.GetRow(1).GetCell(0).StringCellValue);
Assert.AreEqual("TestValue2", sheet.GetRow(1).GetCell(1).StringCellValue);
}
void UpdateFromXLS(string chosenUpdateFile)
{
var values = XLSExporter.Read(chosenUpdateFile);
UpdateLanguageFile(values);
/*
* if (parentWindow.translateLanguageWindow != null)
* {
* parentWindow.translateLanguageWindow.ReloadLanguage();
* }
*/
}
void ImportFromXLS(string chosenImportFile)
{
List <List <string> > values = XLSExporter.Read(chosenImportFile);
if (chosenCulture == null)
{
Debug.LogError("The language: " + chosenCulture.englishName + " could not be created");
this.Close();
return;
}
LanguageHandlerEditor.CreateNewLanguage(chosenCulture.languageCode, values);
if (creationDelegate != null)
{
creationDelegate();
creationDelegate = null;
}
}
void ShowImportGUI()
{
if (GUILayout.Button("Import"))
{
if (availableFileFormats[chosenFileFormat] == csvFileEnding)
{
string file = EditorUtility.OpenFilePanel("Select CSV file.", "", "");
if (file != null && file != "")
{
var values = CSVParser.Read(file, CSVParser.GetDelimiter(delimiter));
if (values.Count > 0)
{
LanguageHandlerEditor.BulkUpdateLanguageFiles(values);
}
}
this.Close();
}
else if (availableFileFormats[chosenFileFormat] == xlsFileEnding)
{
string file = EditorUtility.OpenFilePanel("Select XLS file.", "", "");
if (file != null && file != "")
{
var values = XLSExporter.Read(file);
if (values.Count > 0)
{
LanguageHandlerEditor.BulkUpdateLanguageFiles(values);
}
}
this.Close();
}
else
{
Debug.LogError("BulkUpdateWindow: Unsupported import format!");
}
if (parentWindow.translateLanguageWindow != null)
{
parentWindow.translateLanguageWindow.ReloadLanguage();
}
}
}
public void CreateWorkbookFromMultipleDicts()
{
var dictionaries = new Dictionary <string, Dictionary <string, string> >();
dictionaries.Add("en", testData);
dictionaries.Add("sv", testData);
var workbook = XLSExporter.CreateWorkbookFromMultipleDictionaries("MySheet", new List <string>(testData.Keys), dictionaries);
Assert.AreEqual(1, workbook.NumberOfSheets);
var sheet = workbook.GetSheetAt(0);
Assert.AreEqual("MySheet", sheet.SheetName);
Assert.AreEqual(string.Empty, sheet.GetRow(0).GetCell(0).StringCellValue);
Assert.AreEqual("en", sheet.GetRow(0).GetCell(1).StringCellValue);
Assert.AreEqual("sv", sheet.GetRow(0).GetCell(2).StringCellValue);
Assert.AreEqual("TestKey", sheet.GetRow(1).GetCell(0).StringCellValue);
Assert.AreEqual("TestKey2", sheet.GetRow(2).GetCell(0).StringCellValue);
Assert.AreEqual("TestValue", sheet.GetRow(1).GetCell(1).StringCellValue);
Assert.AreEqual("TestValue", sheet.GetRow(1).GetCell(2).StringCellValue);
Assert.AreEqual("TestValue2", sheet.GetRow(2).GetCell(1).StringCellValue);
Assert.AreEqual("TestValue2", sheet.GetRow(2).GetCell(2).StringCellValue);
}
public void CreateWorkbookFromDictWithNullSheetName_ExpectedException()
{
Assert.That(() => XLSExporter.CreateWorkbookFromDictionary(null, testData), Throws.ArgumentNullException);
}
public void CreateWorkbookFromMultipleDictsWithNullValues_ExpectedException()
{
Assert.That(() => XLSExporter.CreateWorkbookFromMultipleDictionaries("MySheet", new List <string>(), null), Throws.ArgumentNullException);
}
public void CreateWorkbookFromDictWithNullSheetName_ExpectedException()
{
XLSExporter.CreateWorkbookFromDictionary(null, testData);
}
public void CreateWorkbookFromDictWithNullData_ExpectedException()
{
XLSExporter.CreateWorkbookFromDictionary("MySheet", null);
}
public void CreateWorkbookFromDictWithNullData_ExpectedException()
{
Assert.That(() => XLSExporter.CreateWorkbookFromDictionary("MySheet", null), Throws.ArgumentNullException);
}
public void CreateWorkbookFromMultipleDictsWithNullValues_ExpectedException()
{
XLSExporter.CreateWorkbookFromMultipleDictionaries("MySheet", new List <string>(), null);
}
