//contentuidでソート old_ja.Contents.Sort((a,b) => a.ContentUID.CompareTo(b.ContentUID)); //テスト出力 System.Xml.Serialization.XmlSerializerNamespaces ns = new System.Xml.Serialization.XmlSerializerNamespaces(); ns.Add(String.Empty, String.Empty); System.IO.FileStream stream_test = new System.IO.FileStream(@"C:\Temp\dos2\diff\test_sort.xml", System.IO.FileMode.Create); System.IO.StreamWriter writer_test = new System.IO.StreamWriter(stream_test, System.Text.Encoding.UTF8); serializer.Serialize(writer_test, old_ja, ns); writer_test.Flush(); writer_test.Close(); writer_test = null;

//翻訳データを指定のフォルダにxmlファイルとして出力する // アプデ対応作業用に、進捗データを追加 function saveAsXML_Prog() { var fileName = "old_japanese_progress" fileName = fileName + ".xml"; var folderName = "1ajoWyT-YyBclhBmd83RmdoVObFhoGi3g"; var csvFile = convertRangeToCsvFile_Prog(fileName); var folder = DriveApp.getFolderById(folderName); var oldFiles = folder.getFiles(); var file = "" var idToDLET = "" while (oldFiles.hasNext()) { file = oldFiles.next(); idToDLET = file.getId(); file.setSharing(DriveApp.Access.PRIVATE, DriveApp.Permission.EDIT) Drive.Files.remove(idToDLET); } var newfile = folder.createFile(fileName, csvFile); newfile.setSharing(DriveApp.Access.ANYONE, DriveApp.Permission.VIEW) } //機械翻訳無し版のデータ変換 function convertRangeToCsvFile_Prog(csvFileName) { var spreadsheet_1 = SpreadsheetApp.openByUrl(url_1); var sheet_1 = spreadsheet_1.getSheetByName(sheetName_1); var spreadsheet_2 = SpreadsheetApp.openByUrl(url_2); var sheet_2 = spreadsheet_2.getSheetByName(sheetName_2); var spreadsheet_3 = SpreadsheetApp.openByUrl(url_3); var sheet_3 = spreadsheet_3.getSheetByName(sheetName_3); var maintext_1 = sheet_1.getRange(2,3,max_row_1,7); var maintext_2 = sheet_2.getRange(2,3,max_row_2,7); var maintext_3 = sheet_3.getRange(2,3,max_row_3,7); var data_1 = maintext_1.getValues(); var data_2 = maintext_2.getValues(); var data_3 = maintext_3.getValues(); var csvFile = undefined; var datastr; // 一行目、プロジェクトのURL var csv = "<!-- Divinity: Original Sin 2 日本語化プロジェクト：http://gtm.steamproxy.vip/groups/dos2_jp_mod -->\r\n"; // 二行目、生成日時 var temp_csv = "<!-- " + Utilities.formatDate(new Date(), 'JST', 'yyyy年MM月dd日HH時') + "に自動生成 -->\r\n<contentList>\r\n"; csv += temp_csv; // 第一翻訳室のデータを取得 var rowMax = data_1.length -1; for (var row = 0; row < rowMax; row++) { datastr = data_1[row][0].toString(); datastr = datastr.replace(/&/g, "&amp;") datastr = datastr.replace(/</g, "&lt;") datastr = datastr.replace(/>/g, "&gt;") datastr = datastr.replace(/'/g, "&apos;") csv += ' <content contentuid="' + data_1[row][4] + '" progress="' + data_1[row][1] + '">' + datastr + '</content>\r\n'; } csvFile = csv; // 第二翻訳室のデータを取得 csv = ""; rowMax = data_2.length -1; for (var row = 0; row < rowMax; row++) { datastr = data_2[row][0].toString(); datastr = datastr.replace(/&/g, "&amp;") datastr = datastr.replace(/</g, "&lt;") datastr = datastr.replace(/>/g, "&gt;") datastr = datastr.replace(/'/g, "&apos;") csv += ' <content contentuid="' + data_2[row][4] + '" progress="' + data_2[row][1] + '">' + datastr + '</content>\r\n'; } csvFile += csv; // 第三翻訳室のデータを取得 csv = ""; rowMax = data_3.length -1; for (var row = 0; row < rowMax; row++) { datastr = data_3[row][0].toString(); datastr = datastr.replace(/&/g, "&amp;") datastr = datastr.replace(/</g, "&lt;") datastr = datastr.replace(/>/g, "&gt;") datastr = datastr.replace(/'/g, "&apos;") csv += ' <content contentuid="' + data_3[row][4] + '" progress="' + data_3[row][1] + '">' + datastr + '</content>\r\n'; } csv += '</contentList>'; csvFile += csv; return csvFile; }