大專案中網頁多語系的維護方式

也許在許多專案上我們所說的Multi Language僅有繁體中文、簡體中文和英文,但在比較大型且跨國的專案上,可能會涉及更多的語言,例如:日文、俄文、德文、法文、西班牙文…等等,通常這些軟體內容的翻譯,需要經過更專業的單位來進行,也許這個單位不僅僅需要具備有這些國家的語言能力,也要具備有相當的軟體知識,才能配合當地民情翻譯出正確的文字,這部分往往需要專業的翻譯單位來進行。

而專業的翻譯單位通常並不具有軟體的製作能力,所以在軟體上要如何快速地進行協同作業,就變成一項非常重要的工作,而在許多專案上,我們會讓翻譯單位透過Excel來提供各國語系的翻譯文字,我們則透過軟體進行轉換,將其轉換至軟體能快速讀取的格式,講白一點就是將Excel檔案轉換成XML格式,並提供其他軟體進行讀取。

整體流程會如上圖所示,在拿到一個翻譯社提供所有語系的Excel資料後,我們會進行轉換,將文字轉換成多個XML檔案,並打包成一個ZIP檔讓轉換者進行下載。

今天我們主要來分享上圖藍色部分的處理程序,也就是那一隻轉換程式的結構和做法,我們將轉換程式設計成網頁版本,藉此提升易用性,而轉換程式操作Flow大致如下:

  1. 使用者上傳檔案(限制僅能上傳Excel檔案)
  2. 給出ZIP下載連結(提供使用者下載所有語系的XML檔)

操作上非常簡單,僅有上述這兩個步驟,而程式設計上採用JSP架構其運作邏輯如下:

  1. 檢查上傳檔案的格式、容量及相關資訊
  2. 擷取Excel中第一張工作表(也可以依照工作表名稱擷取)
  3. 將Excel中第一列視為語系標題,並當作存檔名稱(例如:English.xml)
  4. 將剩下來的每一列轉換為該檔案的語系資料,並建立XML檔案
  5. 將所有建立好的XML檔案進行打包(ZIP)
  6. 更新頁面產生ZIP檔下載路徑

在該轉換程式中,另外有利用到下述的JAVA Library:

  1. Apache POI – 處理與解析Excel檔案
  2. DOM4J – 建立XML檔案
  3. Apache Commons – 處理檔案上傳

以下是轉換的程式碼:

<%@ page contentType="text/html; charset=UTF-8"%>

<%@ page import="java.io.File"%>
<%@ page import="java.text.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.util.Iterator"%>
<%@ page import="java.util.List"%>
<%@ page import="org.apache.commons.fileupload.*"%>
<%@ page import="org.apache.commons.io.FilenameUtils"%>

<%@ page import="java.util.zip.ZipEntry"%>
<%@ page import="java.util.zip.ZipOutputStream"%>

<%@ page import="java.io.FileInputStream"%>
<%@ page import="java.io.FileOutputStream"%>
<%@ page import="java.io.IOException"%>
<%@ page import="java.io.OutputStreamWriter"%>
<%@ page import="java.nio.charset.Charset"%>

<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>

<%@ page import="org.dom4j.io.OutputFormat"%>
<%@ page import="org.dom4j.io.XMLWriter"%>
<%@ page import="org.dom4j.Document"%>
<%@ page import="org.dom4j.DocumentHelper"%>
<%@ page import="org.dom4j.Element"%>


<%!
    //允許上傳的檔案
  String allowedFileTypes = ".xls";
  
  //建立目錄
    public void newFolder(String folderPath) {
        try {
            String filePath = folderPath;
            filePath = filePath.toString();
            java.io.File myFilePath = new java.io.File(filePath);
            if (!myFilePath.exists()) {
                myFilePath.mkdir();
            }
        }
        catch(Exception e) {
            System.out.println("建立目錄錯誤");
            //e.printStackTrace();
        }
    }
   
   // 轉換XLS為XML的主程式 ; 參數1.欲轉換的Excel工作表編號; 參數2.轉換的檔案路徑與檔名; 參數3.XML儲存的檔案路徑;
   public static String convertSheet(int sheetNumber, String conversionFile, String conversionXMLFilePath) {
     
     String convertStatus = "0"; // 輸出轉換狀態 ; 0 是失敗; 1是成功
     String conversionXMLFileName = null; // XML檔名
     String conversionXMLFile = null; // XML完整路徑與檔名
     
     // 產生儲存XML檔案的資料夾
     File file = new File(conversionXMLFilePath);
     if(!file.exists()){
         file.mkdirs();
     }
     
     // 開始讀取XLS檔案
     HSSFWorkbook book = null;
     try {
       book = new HSSFWorkbook(new FileInputStream(conversionFile));
     } catch (IOException e) {
       System.out.println("IOException : " + e);
     }
     
     HSSFSheet sheet = book.getSheetAt(sheetNumber); // 打開對應編號的工作表
     HSSFRow row = sheet.getRow(0);// 取得工作表的第一列資料
     String cell;
     int totalRows = sheet.getPhysicalNumberOfRows(); // 取得工作表中所有的列數
     int totalCol = row.getPhysicalNumberOfCells(); // 取的工作表中所有的欄數
     
     // 開始建立XML檔並將XLS內容建入
     for (int j = 1; j < totalCol; j++){
       Document document = DocumentHelper.createDocument();
       Element root = document.addElement("root");
       
       for (int i = 0; i < totalRows; i++){
         row = sheet.getRow(i);
         try {
           cell = row.getCell(j).toString();
           if(i==0) {
             conversionXMLFileName = cell;
             conversionXMLFile = conversionXMLFilePath + conversionXMLFileName + ".xml";
           }else {
             root.addElement("row_" + (i+1)).addCDATA(cell);
             /*
             if(sheetNumber == 0) {
               root.addElement("tag_" + (i-1), cell);
             }else {
               root.addElement(xmlKeyboardTitle[(i-1)], cell);
             }
             */
           }
         } catch (NullPointerException e) {
           break;
         }
       }
       
       File storedFile = new File(conversionXMLFile);
       
       if(storedFile.exists())
         storedFile.delete();

       FileOutputStream fos = null;
       OutputStreamWriter osw = null;
       XMLWriter writer = null;
       try {
         storedFile.createNewFile();
         OutputFormat format = OutputFormat.createPrettyPrint();  
               format.setEncoding("utf-8");
               fos = new FileOutputStream(storedFile);
               osw = new OutputStreamWriter(fos, Charset.forName("utf-8"));
               writer = new XMLWriter(osw, format);
               writer.write(document);
       } catch (IOException e) {
         System.out.println("IOException : " + e);
       } finally {
         try {
           if(writer != null) writer.close();
           if(osw != null) osw.close();
           if(fos != null) fos.close();
           convertStatus = "1";
         } catch (IOException e) {
           System.out.println("IOException : " + e);
         }
       }
     }
     return convertStatus; // 回覆轉換狀態
   }
   
   List<String> filesListInDir = new ArrayList<String>();
   
   public void zipDirectory(File dir, String zipDirName) {
     
     filesListInDir = new ArrayList<String>();
     
        try {
          
            populateFilesList(dir);
            //now zip files one by one
            //create ZipOutputStream to write to the zip file
            FileOutputStream fos = new FileOutputStream(zipDirName);
            ZipOutputStream zos = new ZipOutputStream(fos);
            for(String filePath : filesListInDir){
                System.out.println("Zipping "+filePath);
                //for ZipEntry we need to keep only relative file path, so we used substring on absolute path
                ZipEntry ze = new ZipEntry(filePath.substring(dir.getAbsolutePath().length()+1, filePath.length()));
                zos.putNextEntry(ze);
                //read the file and write to ZipOutputStream
                FileInputStream fis = new FileInputStream(filePath);
                byte[] buffer = new byte[1024];
                int len;
                while ((len = fis.read(buffer)) > 0) {
                    zos.write(buffer, 0, len);
                }
                zos.closeEntry();
                fis.close();
            }
            zos.close();
            fos.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
   
   private void populateFilesList(File dir) throws IOException {
        File[] files = dir.listFiles();
        for(File file : files){
            if(file.isFile()) filesListInDir.add(file.getAbsolutePath());
            else populateFilesList(file);
        }
    }
  
%>

<%

String messageReturn = "";
  
try{
  
    request.setCharacterEncoding("utf-8");
    DiskFileUpload fileUpload = new DiskFileUpload();
  List<FileItem> fileItems = fileUpload.parseRequest(request);
  FileItem fileItem = fileItems.get(0);
  
    //原始上傳檔案名稱
  String originalFileName = fileItem.getName();
    //out.print("originalFileName : " + originalFileName + "<br>");
    
  if (originalFileName != null && !"".equals(originalFileName)) {

        originalFileName = FilenameUtils.getName(originalFileName);
        String extension = FilenameUtils.getExtension(originalFileName);
        
    //判斷檔案格式是否允許
    //out.print("extension : " + extension + "<br>");
        if (allowedFileTypes.indexOf(extension.toLowerCase()) != -1) {
            String filePath = this.getServletContext().getRealPath(request.getRequestURI().substring(request.getContextPath().length()));
            String savePath = new File(filePath).getParent() + "/upload";
          //out.println("savePath = " + savePath + "<br>");
      newFolder(savePath);
      
          String savePathAndName = savePath + "/" + originalFileName;
            //out.print(savePathAndName);
      
          File f = new File(savePathAndName);
          if(!f.exists()){
            f.createNewFile();
          }
          fileItem.write(f);
            
            //messageReturn += "File path : " + savePath + "<br>";
            
             String xmlSavePath = savePath + "/xml/";
             //messageReturn += "xmlSavePath : " + xmlSavePath + "<br>";
            
            if("1".equals(convertSheet(0, savePathAndName , xmlSavePath))){
              messageReturn += "File converted successfully.<br>";
        }else{
          messageReturn += "File conversion failed.<br>";
        };
        
        /*
        xmlSavePath = savePath + "/xml/keyboard/";
        
        if("1".equals(convertSheet(1, savePathAndName , xmlSavePath))){
              messageReturn += "Keyboard sheet conversion succeeded.<br>";
        }else{
          messageReturn += "Keyboard sheet conversion fail.<br>";
        };
        */
      
        java.io.File myDelFile = new java.io.File(savePath + "/All.zip");
        myDelFile.delete();
        
        zipDirectory(new File(savePath + "/xml/"), savePath + "/All.zip");
        
        messageReturn += "<a href='upload/All.zip' target='_blank'>Download Link</a><br>";

        } else {
          messageReturn += "上傳錯誤 : 上傳的檔案不能是" + extension + ",僅允許xls格式<br>";
        }
    }
}catch(Exception e){
  //e.printStackTrace();
}

%>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>AIOT CC Multi-Language Convertion Tool</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
    <style>
        *{
            font-family: 微軟正黑體;
        }
        h2{
            text-align: center;
        }
        .marginBottom20{
            margin-bottom: 20px;
        }
        #uploadBtn{
            margin: auto;
            display: block;
        }
        #messageDiv{
          color: red;
          text-align:center;
        }
    </style>
</head>

<body>

    <div class="container">
        <h2 class="marginBottom20">AIOT CC Multi-Language Convertion Tool</h2>
        <div class="form-group text-center">
          <form name="upload" enctype="multipart/form-data" method="post" action="index.jsp" onsubmit="return check_select()">
            <input type="file" name="file" id="file" size="60" maxlength="20" placeholder="*.xls" class="marginBottom20">
            <input id="uploadBtn" type="submit" value="轉換" class="btn btn-primary">
        </form>
      </div>
      <div id="messageDiv"><% out.print(messageReturn); %></div>
    </div>
    
</body>

</html>
<script>
    function check_select(form) {
        if (file.value == "") {
            alert("請選擇檔案");
            return false;
        } else {
            // document.getElementById("uploadBtn").disabled = true;
            //document.getElementById("msgDiv").innerHTML = "檔案上傳中,請稍候";
            return true;
        }
    }
</script>

You may also like...

71,976 Responses

  1. WilliamSoorp表示:

    http://certifiedpharmacymexico.pro/# pharmacies in mexico that ship to usa

  2. WilliamPaw表示:

    http://medicinefromindia.store/# top 10 pharmacies in india

  3. WilliamSoorp表示:

    https://medicinefromindia.store/# indian pharmacy

  4. Eugenehaupe表示:

    mexican pharmaceuticals online mexican pharmacy best online pharmacies in mexico

  5. Very interesting details you have remarked, thanks for posting.

  6. BennyNib表示:

    cheapest online pharmacy india: indian pharmacy online – Online medicine order

  7. WilliamSoorp表示:

    http://edpill.cheap/# top erection pills

  8. WilliamSoorp表示:

    http://medicinefromindia.store/# best online pharmacy india

  9. BennyNib表示:

    purple pharmacy mexico price list: mexico pharmacies prescription drugs – mexican drugstore online

  10. BennyNib表示:

    prescription drugs canada buy online: www canadianonlinepharmacy – reputable canadian online pharmacies

  11. Eugenehaupe表示:

    buy prescription drugs online without generic cialis without a doctor prescription prescription drugs online

  12. WilliamSoorp表示:

    http://edpill.cheap/# best otc ed pills

  13. Eugenehaupe表示:

    safe canadian pharmacies canada cloud pharmacy online canadian pharmacy reviews

  14. Eugenehaupe表示:

    what are ed drugs best ed pills at gnc online ed medications

  15. WilliamSoorp表示:

    http://certifiedpharmacymexico.pro/# mexico pharmacies prescription drugs

  16. Eugenehaupe表示:

    ed drugs list ed remedies ed pills gnc

  17. BennyNib表示:

    online shopping pharmacy india: top 10 pharmacies in india – pharmacy website india

  18. Eugenehaupe表示:

    mens ed pills men’s ed pills best treatment for ed

  19. WilliamSoorp表示:

    http://edpill.cheap/# cheapest ed pills online

  20. Ded表示:

    There’s no better place to play casino games than right here at Bovada. With both live dealer and standard online casino games available, you can choose how you want to play your favorite casino games. The live dealer options have real people dealing the cards and spinning the wheels. Their game selection includes table game classics like roulette, blackjack, baccarat, and super 6. The dealer runs the game through a live video feed, and you’re connected through a chat. TUTORIALIn our interactive built-in Craps tutorial, you will get all the help that you need to learn how to play Craps and what the different bets do. People turn to craps online because your get to play your way. You control the game, the bets, and wagers. Its an unpredictable game that never ceases to impress even the savviest, most experienced players. Thanks to digital technology you can also play on your favorite device with your favorite music jamming in the background. What more could you want? Did we mention we can tell you where to find the best craps casinos online?
    http://aged-wiki.win/index.php?title=Casinos_com_paypal
    Perhaps one of the few downsides to the site is that they do not have an accompanying app for mobile users. You can still use the mobile app, but many people prefer the convenience of an app. The other downside to the site is the flat fee of €5.00 every time you make more than one withdrawal per week. Of course, users can just time their withdrawals to ensure that they only make one large withdrawal to avoid the fee, but it is still very inconvenient. EnergyCasino is an online casino that offers hundreds of games to choose from since 2013. It targets European players and is available for play in English, German, Polish, Swedish and many more. At EnergyCasino, players can enjoy slots, table games, video poker, or jackpot games. The casino offers a no-download process which allows users to begin playing instantly. Customers must be 18 or older to register.

  21. WilliamPaw表示:

    https://medicinefromindia.store/# indian pharmacy online

  22. WilliamPaw表示:

    https://medicinefromindia.store/# indian pharmacies safe

  23. WilliamSoorp表示:

    http://canadianinternationalpharmacy.pro/# escrow pharmacy canada

  24. Eugenehaupe表示:

    canadian king pharmacy canadian family pharmacy buying from canadian pharmacies

  25. Eugenehaupe表示:

    best online pharmacy india Online medicine home delivery п»їlegitimate online pharmacies india

  26. Eugenehaupe表示:

    online canadian drugstore reputable canadian pharmacy online canadian pharmacy

  27. WilliamSoorp表示:

    https://canadianinternationalpharmacy.pro/# canadian pharmacy com

  28. BennyNib表示:

    best online pharmacies in mexico: mexican rx online – mexico pharmacies prescription drugs

  29. Ded表示:

    Next up, the ‘Newly opened’ tab will give you the most recent Siru casinos added to our system, if that’s your kind of thing. The ‘All’ tab next to it will draw up the full list of Siru casinos on our system. When using Siru you are likely to benefit from an online casino bonus, just like you would with most other payment methods. Such bonuses can come in different kinds and types. The casinos simply want to attracts new customers through such welcome bonuses. You will then get additional bonuses for deciding to choose Siru as your preferred payment method for your gambling transactions. As a result, online payments in Siru Mobile casinos are made straightforwardly and do not require many endeavors on the player’s part. Unfortunately, while there are many online casinos that accept MuchBetter, Skrill, and other payment options, there aren’t as many of them that use Siru Mobile: this online payment method is accepted only in several European countries, including Finland, Norway, Sweden, and the United Kingdom. However, since the company has plans to expand its presence in other world countries, the chances are high that we will see more online casinos that accept this payment option.
    https://lnfc.med.ly/the-worlds-most-unusual-jelly-bean-review/
    As a way to attract new players, many online casinos give away what’s known as “free spins”. Players are granted free spins to be used in specific slots games with the chance of winning real money. It’s a great way of playing for free without putting your bankroll on stake plus, if you win, the prize is yours to keep. A similar type of bonus is a no-deposit bonus, where the player receives a bonus but without the need of making an initial deposit. The best no deposit bonus Michigan is certainly the BetMGM Casino. It is the oldest casino and the long standing offer surviving the test of time. It gives all new players who do not have a BetMGM casino or sportsbook account in any state in the US, a $25 bonus. The secret to WIN at Miami Club Casino is written in The Book of the Earth! Visit Miami Club Sign up for a new account for the house to award you with 45 FREE Spins on the WGS-powered slots game right away! Miami Club Casino 45 FREE Spins on The Book of the Earth Code: BEF7 Minimum Deposit: No deposit is required Maximum cashout: $150 WR: 40x Date: …

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。