大專案中網頁多語系的維護方式
也許在許多專案上我們所說的Multi Language僅有繁體中文、簡體中文和英文,但在比較大型且跨國的專案上,可能會涉及更多的語言,例如:日文、俄文、德文、法文、西班牙文…等等,通常這些軟體內容的翻譯,需要經過更專業的單位來進行,也許這個單位不僅僅需要具備有這些國家的語言能力,也要具備有相當的軟體知識,才能配合當地民情翻譯出正確的文字,這部分往往需要專業的翻譯單位來進行。
而專業的翻譯單位通常並不具有軟體的製作能力,所以在軟體上要如何快速地進行協同作業,就變成一項非常重要的工作,而在許多專案上,我們會讓翻譯單位透過Excel來提供各國語系的翻譯文字,我們則透過軟體進行轉換,將其轉換至軟體能快速讀取的格式,講白一點就是將Excel檔案轉換成XML格式,並提供其他軟體進行讀取。
整體流程會如上圖所示,在拿到一個翻譯社提供所有語系的Excel資料後,我們會進行轉換,將文字轉換成多個XML檔案,並打包成一個ZIP檔讓轉換者進行下載。
今天我們主要來分享上圖藍色部分的處理程序,也就是那一隻轉換程式的結構和做法,我們將轉換程式設計成網頁版本,藉此提升易用性,而轉換程式操作Flow大致如下:
- 使用者上傳檔案(限制僅能上傳Excel檔案)
- 給出ZIP下載連結(提供使用者下載所有語系的XML檔)
操作上非常簡單,僅有上述這兩個步驟,而程式設計上採用JSP架構其運作邏輯如下:
- 檢查上傳檔案的格式、容量及相關資訊
- 擷取Excel中第一張工作表(也可以依照工作表名稱擷取)
- 將Excel中第一列視為語系標題,並當作存檔名稱(例如:English.xml)
- 將剩下來的每一列轉換為該檔案的語系資料,並建立XML檔案
- 將所有建立好的XML檔案進行打包(ZIP)
- 更新頁面產生ZIP檔下載路徑
在該轉換程式中,另外有利用到下述的JAVA Library:
- Apache POI – 處理與解析Excel檔案
- DOM4J – 建立XML檔案
- 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>
рейтинг процессоров intel http://www.topcpu.ru .
какой процессор лучше https://topcpu.ru/ .
Do you have a spam problem on this blog; I also am a blogger, and I was curious about your situation; we have developed some nice practices and we are looking to swap techniques with other folks, please shoot me an email if interested.
http://eximp.com.ua/bi-led-linzy-dlya-avto-yak-prodovzhyty-termin-yikh-sluzhby
What’s up to every single one, it’s truly a pleasant for me to pay a visit this site, it consists of precious Information.
https://atelierdesdelices.com.ua/bi-led-linzy-dlya-avto-tehnologiya-yaka-zminyuye-pravyla-hry
yat?r?ms?z deneme bonusu veren siteler: deneme bonusu veren yeni siteler – deneme bonusu veren siteler yeni
Optimize Your Crypto Trading with TraderJoeXyz
In the dynamic world of cryptocurrency, having the right tools at your disposal can make all the difference. Enter TraderJoeXyz, a cutting-edge platform designed to maximize your trading potential. By leveraging TraderJoeXyz, traders gain access to a multitude of features that cater to both beginners and seasoned professionals. Let’s explore how TraderJoeXyz can enhance your crypto trading journey.
traderjoexyz
Features of TraderJoeXyz
The TraderJoeXyz platform is packed with robust features aimed at simplifying and optimizing cryptocurrency trading:
Advanced Trading Interface: The user-friendly interface is equipped with powerful tools to execute trades efficiently.
Comprehensive Analytics: Gain insights with detailed analytics and customizable charts for better decision-making.
Secure Wallet Integration: Seamlessly manage your crypto assets with integrated security measures.
Automated Trading Bots: Use AI-driven bots to enhance your trading strategy with automated buy and sell actions.
Benefits of Using TraderJoeXyz
Here are some of the benefits you can expect when using TraderJoeXyz:
Increased Efficiency: With streamlined processes and intuitive design, traders can execute trades faster than ever.
Greater Profit Potential: Advanced tools and analytics help you identify profitable trading opportunities.
Reduced Risk: Implementing secure wallet integrations and automated bots can help mitigate risks associated with trading.
Enhanced Trading Experience: A seamless interface paired with powerful tools ensures an exceptional trading journey.
Join the TraderJoeXyz Community
TraderJoeXyz is more than just a platform; it’s a community of crypto enthusiasts and experts. Joining this community provides access to shared knowledge, support, and collaboration opportunities. To become part of this thriving ecosystem, simply and start exploring the world of crypto trading today.
By choosing TraderJoeXyz, you’re not just trading—you’re transforming your crypto experience. Get started and make the most of your cryptocurrency assets.
капельница от запоя на дому нижний новгород капельница от запоя на дому нижний новгород .
denemebonusuverensiteler25: deneme bonusu veren siteler yeni – yeni deneme bonusu veren siteler
вывод из запоя на дому нижний новгород вывод из запоя на дому нижний новгород .
капельница наркология 24 https://vyvod-iz-zapoya-nizhnij-novgorod13.ru/ .
сравнение производительности процессоров topcpu.ru .
Introducing Velodrome Finance: Maximize Your Crypto Yields
In the rapidly evolving world of decentralized finance (DeFi), Velodrome Finance emerges as a robust platform for enthusiasts looking to enhance their crypto yield returns. This guide will walk you through the essentials of Velodrome Finance and how you can benefit from its features.
velodrome exchange
Why Choose Velodrome Finance?
Velodrome Finance stands out as a comprehensive DeFi protocol designed specifically for liquidity providers. Its innovative approach focuses on maximizing rewards while maintaining efficient and secure trading mechanisms. Here’s why it’s capturing the attention of the DeFi community:
Efficient Token Swaps: Velodrome offers seamless and cost-effective token swapping capabilities.
Liquidity Pools: Participants can provide liquidity to various pools, optimizing their earning potential.
Yield Optimization: With advanced strategies, Velodrome helps users achieve superior returns on their investments.
Secure Protocol: Security is a top priority, and Velodrome utilizes cutting-edge technology to protect user assets.
Getting Started with Velodrome
Embarking on your journey with Velodrome Finance is straightforward. Here’s a step-by-step guide to help you dive into the platform:
Create a Wallet: To engage with Velodrome, you first need a compatible crypto wallet.
Connect Your Wallet: Visit and securely link your crypto wallet.
Explore Liquidity Pools: Browse through available pools and decide where to allocate your assets for optimal returns.
Stake and Earn: Once you’ve funded a pool, begin staking and watch your earnings grow as you benefit from trading fees and incentives.
Community and Support
Velodrome Finance boasts a vibrant community ready to assist users at any step. Whether you’re a seasoned DeFi user or a newcomer, you can find guidance and support from community forums and dedicated customer service.
Conclusion
With its focus on maximizing crypto yield, Velodrome Finance is a compelling choice for anyone looking to delve deeper into the DeFi space. From efficient token swaps to robust security measures, it offers a complete ecosystem for those eager to optimize their returns. Visit the official site and start your journey towards enhanced financial growth.
капельница от запоя вызов http://www.vyvod-iz-zapoya-nizhnij-novgorod12.ru/ .
What is Uniswap?
Uniswap is a decentralized exchange (DEX) protocol built on the Ethereum blockchain. It enables direct peer-to-peer cryptocurrency transactions, allowing users to trade coins without intermediaries. This makes it a cornerstone of the Decentralized Finance (DeFi) ecosystem.
uniswap protocol
Benefits of Using Uniswap
Uniswap offers several advantages over traditional, centralized exchanges:
Decentralization: Users maintain control of their funds, minimizing the risk of hacking or fraud associated with central exchanges.
Liquidity Pools: Uniswap uses automated liquidity pools instead of traditional order books, enabling seamless and efficient trading.
Open Access: Anyone with an Ethereum wallet can trade on Uniswap, facilitating financial inclusivity.
No Registration: Trade instantly without creating an account or passing through identity verification processes.
How to Use Uniswap
Getting started with Uniswap is simple and intuitive. Follow these steps:
Create and fund an Ethereum wallet if you don’t have one. Some popular options include MetaMask, Trust Wallet, and Coinbase Wallet.
Connect your wallet to the Uniswap platform by navigating to their website and initiating the connection process.
Choose the tokens you wish to trade. Always ensure you are aware of the gas fees involved in the transaction.
Initiate the swap and confirm the transaction in your wallet. Your new tokens will be available once the transaction is confirmed on the blockchain.
Security Tips
While Uniswap is a secure platform, it’s crucial to follow best practices to ensure your funds remain safe:
Always ensure you are accessing the legitimate Uniswap website by verifying the URL.
Keep your wallet’s private keys secure and never share them with anyone.
Regularly update your cryptocurrency wallet and browser to prevent vulnerabilities.
Conclusion
Uniswap has revolutionized the way cryptocurrency trading operates by providing a secure, user-friendly, and inclusive platform. Whether you are a seasoned trader or a newcomer to the crypto world, Uniswap offers a powerful tool for navigating the DeFi landscape.
Whoa! This blog looks exactly like my old one! It’s on a entirely different subject but it has pretty much the same layout and design. Great choice of colors!
The Little-Known Benefits Online Mystery Box best mystery boxes
капельница от похмелья на дому капельница от похмелья на дому .
sweet bonanza kazanma saatleri sweet bonanza guncel sweet bonanza slot
SportyBet promotions SportyBet promotions .
Welcome to PancakeSwap: A Beginner’s Guide
PancakeSwap is a decentralized exchange platform on the Binance Smart Chain, designed for swapping BEP-20 tokens. With its vibrant ecosystem, ease of use, and low transaction fees, it’s become a popular choice among crypto enthusiasts.
Pancakeswap exchange
What is PancakeSwap?
PancakeSwap is an automated market maker (AMM) that allows users to trade directly from their crypto wallets. There’s no order book involved; instead, trades are made against a liquidity pool. Here’s how you can get started:
How to Use PancakeSwap?
Set Up Your Wallet
First, you need a crypto wallet like MetaMask or Trust Wallet. Ensure your wallet supports BEP-20 tokens.
Connect to Binance Smart Chain
Configure your wallet to connect to the Binance Smart Chain network. Detailed guides are available in your wallet settings.
Purchase BNB
You’ll need BNB (Binance Coin) to cover transaction fees. Buy BNB from a reputable exchange and transfer it to your wallet.
Access PancakeSwap
Visit the official PancakeSwap website and connect your wallet by clicking on the ‘Connect Wallet’ button.
Start Trading
Once connected, you can begin swapping BEP-20 tokens. Choose the tokens you wish to trade and confirm your transactions.
Benefits of PancakeSwap
Lower Fees: Operating on Binance Smart Chain, the fees are more affordable than Ethereum-based exchanges.
Fast Transactions: Experience quick transaction speeds due to the efficiency of BSC.
Yield Farming: Earn rewards by providing liquidity or participating in various farming pools.
Conclusion
PancakeSwap offers a user-friendly approach to trading cryptocurrencies, engaging users with its gamified elements like lotteries and collectibles. Whether you’re a beginner or an experienced trader, PancakeSwap provides an efficient and exciting way to dive into the world of decentralized finance. Always ensure to perform your due diligence before engaging in trading activities.
For more detailed guides and support, visit the .
http://casinositeleri25.com/# casino bahis siteleri
вывод. из. запоя. на. дому. http://www.vyvod-iz-zapoya-nizhnij-novgorod12.ru .
врач на дом капельница от запоя врач на дом капельница от запоя .
подробнее https://forum.hpc.name/thread/2/65815/paranoidalnoe-udalenie-faylov.html
перенаправляется сюда https://forum.hpc.name/thread/45547/samopechatnyy-tekst.html
Discover Stargate Finance: Your Gateway to DeFi
In the rapidly evolving world of decentralized finance (DeFi), Stargate Finance stands out as a reliable platform for decentralized transactions and yield optimization. Let’s explore how Stargate Finance can enhance your financial strategies.
stargate fi
Why Choose Stargate Finance?
Stargate Finance offers a comprehensive suite of tools designed to facilitate seamless and secure transactions. Here’s why you should consider integrating Stargate Finance into your DeFi experience:
Seamless Cross-Chain Transactions: Facilitate instant and smooth transactions across multiple blockchain networks without the hassle of traditional exchanges.
High-Performance Liquidity Pools: Access a wide range of liquidity pools to optimize your yield farming strategies and maximize returns.
Secure Protocols: Enjoy peace of mind with top-tier security measures designed to protect your assets and data.
Features that Enhance Your DeFi Experience
Stargate Finance uniquely positions itself by offering features that cater to both novice and veteran DeFi users:
Intuitive User Interface: Navigate effortlessly through the platform with a user-friendly interface that simplifies complex DeFi operations.
24/7 Customer Support: Get assistance anytime with a dedicated support team available to resolve queries and help optimize your DeFi strategies.
Comprehensive Analytics: Leverage data-driven insights to make informed decisions, tailor your yield farming, and monitor performance.
Getting Started with Stargate Finance
Ready to dive into the world of DeFi with Stargate Finance? Here’s a quick guide to get you started:
Visit the and create your account.
Connect your crypto wallet to begin accessing the features.
Explore liquidity pools and start yield farming to optimize your returns.
With these resources, you can securely and efficiently manage your decentralized financial strategies.
Conclusion
Stargate Finance empowers you to confidently participate in the DeFi landscape, offering secure, efficient, and user-friendly solutions for the modern investor. Discover what it means to have a true gateway to financial freedom and innovation with Stargate Finance.
For more information and to get started today, .
Understanding Stargate Finance Token
The Stargate Finance Token is an integral part of the blockchain ecosystem, especially for those involved in decentralized finance (DeFi). As a bridge to seamless blockchain transactions, it plays a crucial role in enhancing interoperability across different networks.
Key Features of Stargate Finance Token
Stargate Finance Token stands out in the DeFi space for several reasons. Here are its key features:
Interoperability: Facilitates cross-blockchain transactions with ease.
Scalability: Designed to handle a large volume of transactions.
Security: Incorporates advanced security protocols for secure transfers.
Liquidity Pools: Offers attractive opportunities for liquidity providers.
Benefits of Using Stargate Finance Token
Using the Stargate Finance Token provides several benefits to investors and users:
Cost Efficiency: Reduces transaction fees compared to traditional methods.
Speed: Transfers are quick, minimizing waiting times.
Investment Potential: Opportunity for profitable returns through staking and liquidity.
Innovation: Continuously updates to incorporate the latest in blockchain technology.
How to Get Started with Stargate Finance Token
Getting started with Stargate Finance Token is straightforward:
Visit a reputable that lists Stargate tokens.
Create an account and complete any necessary verification.
Deposit funds into your account via fiat or cryptocurrency transfer.
Purchase Stargate Finance Tokens from the exchange market.
Consider joining liquidity pools or staking to maximize your returns.
https://denemebonusuverensiteler25.com/# deneme bonusu veren siteler
опубликовано здесь https://forum.hpc.name/thread/6373/knigi.html
isotretinoin order – buy isotretinoin zyvox usa
sweet bonanza slot: sweet bonanza giris – sweet bonanza yorumlar