Laboratoire ICAR » Plateforme TXM

package org.txm.rcp.translate.devtools;

import java.io.BufferedReader;

import java.io.File;

import java.io.PrintWriter;

import java.util.Properties;

import org.odftoolkit.simple.TextDocument;

import org.odftoolkit.simple.table.Cell;

import org.odftoolkit.simple.table.Row;

import org.odftoolkit.simple.table.Table;

import org.txm.utils.io.IOUtils;

public class TableToProperties {

	File tableFile;

	String lang;

	public TableToProperties(File tableFile, String lang) {

		this.tableFile = tableFile;

		this.lang = lang;

	}

	public Properties convert() throws Exception {

		Properties slave = new Properties();

		TextDocument doc = TextDocument.loadDocument(tableFile);

		Table table = doc.getTableList().get(0);

		Row headerRow = table.getRowList().get(0);

		int ncol = headerRow.getCellCount();

		int keyIndex = -1;

		int langIndex = -1;

		int defaultIndex = -1;

		for (int c = 0; c < ncol; c++) {

			Cell cell = headerRow.getCellByIndex(c);

			if ("KEY".equals(cell.getDisplayText())) {

				keyIndex = c;

			}

			else if (lang.equals(cell.getDisplayText().toLowerCase())) {

				langIndex = c;

			}

			else if ("DEFAULT".equals(cell.getDisplayText())) {

				defaultIndex = c;

			}

		}

		if (keyIndex == -1) {

			System.out.println("KEY columns not found in " + headerRow);

			return null;

		}

		if (langIndex == -1) {

			System.out.println(lang + " columns not found in " + headerRow);

			return null;

		}

		if (defaultIndex == -1) {

			System.out.println("DEFAULT columns not found in " + headerRow);

			return null;

		}

		for (Row h : table.getRowList()) {

			String key = h.getCellByIndex(keyIndex).getDisplayText();

			if (key != null) {

				String value = h.getCellByIndex(langIndex).getDisplayText();

				if (value != null) {

					slave.setProperty(key, value);

				}

			}

		}

		return slave;

	}

	public static void main(String args[]) throws Exception {

//		Properties b = new TableToProperties(new File("/home/mdecorde/workspace047/org.txm.translate.rcp/bundles_fr.odt"), "fr").convert();

//		

//		System.out.println("RESULT: "+b);

//		

//		Properties b2 = new TableToProperties(new File("/home/mdecorde/workspace047/org.txm.translate.rcp/bundle_fr.odt"), "fr").convert();

//		

//		System.out.println("RESULT: "+b2);

//		

//		Properties newProperties = new Properties();

//		

//		for (Object k : b.keySet()) {

//			if (!(b.get(k).equals(b2.get(k)))) {

//				newProperties.setProperty(k.toString(), b2.get(k).toString());

//			}

//		}

//		

//		System.out.println("NEWPROPERTIES: "+newProperties);

//		PrintWriter writer = IOUtils.getWriter(new File("/home/mdecorde/TEMP/newvalues.properties"), "iso-8859-1");

//		newProperties.store(writer, "");

//		writer.close();

		Properties previousOKProperties = new TableToProperties(new File("/home/mdecorde/TEMP/messagespaskc.odt"), "fr").convert();

		File newValuesPropertiesFile = new File("/home/mdecorde/TEMP/newvalues.properties");

		BufferedReader reader = IOUtils.getReader(newValuesPropertiesFile, "iso-8859-1");

		Properties newProperties2 = new Properties();

		newProperties2.load(reader);

		reader.close();

		for (Object k : newProperties2.keySet()) {

			previousOKProperties.setProperty(k.toString(), newProperties2.getProperty(k.toString()));

		}

		PrintWriter writer = IOUtils.getWriter(new File("/home/mdecorde/TEMP/messagespaskc.properties"), "iso-8859-1");

		previousOKProperties.store(writer, "");

		writer.close();

	}

}

package org.txm.rcp.translate.devtools;

import java.io.File;

import java.io.PrintWriter;

import java.util.Properties;

import org.txm.utils.io.IOUtils;

public class TableFileToPropertiesFile {

	File tableFile;

	File propertiesFile;

	String lang;

	public TableFileToPropertiesFile(File tableFile, File propertiesFile, String lang) {

		this.tableFile = tableFile;

		this.propertiesFile = propertiesFile;

		this.lang = lang;

	}

	public boolean convert() throws Exception {

		Properties slave = new TableToProperties(tableFile, lang).convert();

		PrintWriter writer = IOUtils.getWriter(propertiesFile, "iso-8859-1");

		slave.store(writer, "");

		writer.close();

		return true;

	}

	public static void main(String args[]) throws Exception {

		boolean b = new TableFileToPropertiesFile(new File("/home/mdecorde/workspace047/org.txm.translate.rcp/bundles_fr.odt"), new File("/home/mdecorde/TEMP/orig.properties"), "fr").convert();

		System.out.println("RESULT: "+b);

		boolean b2 = new TableFileToPropertiesFile(new File("/home/mdecorde/workspace047/org.txm.translate.rcp/bundle_fr.odt"), new File("/home/mdecorde/TEMP/slh.properties"), "fr").convert();

		System.out.println("RESULT: "+b2);

	}

}

		String prefix = "bundle"; // messages

		System.out.println(new ImportMessagesTable(new File("/home/mdecorde/TEMP"), "fr").run(prefix, new File(prefix + "_fr.odt")));