Laboratoire ICAR » Plateforme TXM

//

package org.txm.metadatas;

import java.io.BufferedWriter;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.OutputStreamWriter;

import javax.xml.xpath.XPathExpressionException;

import javax.xml.xpath.XPathFactory;

import org.txm.importer.AddAttributeInXml;

import org.txm.importer.PersonalNamespaceContext;

import org.txm.libs.msoffice.ReadExcel;

import org.w3c.dom.Element;

import org.w3c.dom.NodeList;

/**

 * The Class Metadatas.

 */

	File xmlfile;

	/** The metadatas. */

	ArrayList<Metadata> metadatas = new ArrayList<Metadata>();

	/** The headers list. */

	ArrayList<String> headersList = new ArrayList<String>();

	/** The isinialize. */

	boolean isInitialize = false;

	/**

	 * Checks if is initialized.

	 *

	 * @return true, if is initialized

	 */

		return isInitialize;

	}

	/** The ns context. */

	NamespaceContext nsContext = new PersonalNamespaceContext();

	/**

	 * Instantiates a new metadatas.

	 *

	 * @param xmlfile the xmlfile

	 */

		this.xmlfile = xmlfile;

	}

	/**

	 * Find a metadata file in a directory

	 * 

	 * @param directory

	 */

	public static File findMetadataFile(File directory) {

		File f = new File(directory, "metadata.ods");

		if (f.exists()) return f;

		f = new File(directory, "metadata.tsv");

		if (f.exists()) return f;

	}

	/**

	 * @param separator the separator

	 * @param nbheaderline the nbheaderline

	 */

		try {

			if (inputFile.getName().endsWith(".ods")) {

					this.xmlfile = xmlfile;

				}

					this.xmlfile = xmlfile;

				}

					this.xmlfile = xmlfile;

				}

					this.xmlfile = xmlfile;

				}

			}

			if (!initialize()) {

			}

			// TODO Auto-generated catch block

			org.txm.utils.logger.Log.printStackTrace(e);

			Log.severe(e.toString());

		}

	}

	private boolean convertXLSXToXml(File inputFile, File xmlFile) throws Exception {

		ArrayList<ArrayList<String>> data = ReadExcel.toTable(inputFile, "metadata");

		return data.size() > 0 && convertTableToXml(data, xmlFile);

	}

	private boolean convertTableToXml(ArrayList<ArrayList<String>> data, File xmlFile) throws Exception {

		XMLOutputFactory factory = XMLOutputFactory.newInstance();

		FileOutputStream output = new FileOutputStream(xmlFile);

		writer.writeStartDocument("UTF-8", "1.0");

		writer.writeCharacters("\n");

		writer.writeStartElement("enrichissement");

		writer.writeCharacters("\n");

		writer.writeStartElement("metadatas");

		writer.writeCharacters("\n");

		ArrayList<String> headers = data.get(0); // first line

			if (headers.get(i).length() == 0) {

				headers.set(i, "noname");

			}

			writer.writeStartElement("metadata");

			writer.writeAttribute("id", AsciiUtils.buildId(headers.get(i)));

			writer.writeAttribute("shortname", headers.get(i));

			writer.writeAttribute("selection", "true");

			writer.writeAttribute("partition", "true");

			writer.writeAttribute("display", "true");

			writer.writeEndElement();

			writer.writeCharacters("\n");

		}

		writer.writeCharacters("\n");

		writer.writeStartElement("texts");

		writer.writeCharacters("\n");

			ArrayList<String> dataline = data.get(i);

			writer.writeStartElement("text");

				if (headers.get(j).equals("id")) {

					writer.writeAttribute("id", dataline.get(j));

				}

			}

			// write the other attributes

				if (headers.get(j).equals("id")) {

					continue;

				}

				writer.writeStartElement("entry");

				writer.writeAttribute("id", headers.get(j));

				if (dataline.size() <= j) {

					writer.writeAttribute("value", "");

					writer.writeAttribute("value", dataline.get(j));

				}

				writer.writeEndElement();

			writer.writeEndElement();

			writer.writeCharacters("\n");

		}

		writer.writeCharacters("\n");

		writer.close();

		output.close();

		writer.close();

		return true;

	}

	private boolean convertODSToXml(File inputFile, File xmlFile) throws Exception {

		ArrayList<ArrayList<String>> data = ReadODS.toTable(inputFile, "metadata");

		return data.size() > 0 && convertTableToXml(data, xmlFile);

	}

	public File getXMLFile() {

		return xmlfile;

	}

	/** The sattr. */

	String sattr = "";

	/**

	 * Initialize.

	 *

	 * @return true, if successful

	 */

		Document doc;

		try {

			doc = DomUtils.load(xmlfile);

			org.txm.utils.logger.Log.printStackTrace(e1);

			Log.severe(e1.toString());

			return false;

		NodeList metadatasNodes = doc.getElementsByTagName("metadatas");

		NodeList metadataNodes = null;

		// get metadata nodes

			metadataNodes = metadatasNode.getElementsByTagName("metadata");

			break;

		}

			Metadata m = new Metadata(metadataNode);

			if (m.id == null) {

				System.out.println("The metadata file is missing attribute 'id'");

				return false;

			}

			this.metadatas.add(m);

			headersList.add(m.id);

		}

		// List<Node> Lmetadatas = doc.texts.text;

		// get metadata nodes

		NodeList textsNodes = doc.getElementsByTagName("texts");

		NodeList textNodes = null;

			textNodes = textsNode.getElementsByTagName("text");

			break;

		}

			TextInjection inj = new TextInjection(e);

			this.put(inj.id, inj);

		}

		isInitialize = true;

		return true;

	}

		HashMap<String, String> data = new HashMap<String, String>();

		String txtname = f.getName();

		int idx = txtname.lastIndexOf(".");

		TextInjection injection = this.get(txtname);

		if (injection == null) {

			return data;

		}

		for (org.txm.metadatas.Entry e : injection) {

			data.put(e.getId(), e.getValue());

		}

		return data;

	}

	/**

	 * Convert csv to xml.

	 *

	 * @param separator the separator

	 * @param nbheaderline the nbheaderline

	 * @return true, if successful

	 */

		if (separator == null || separator.length() == 0) {

			separator = "\t";

		}

			encoding = "UTF-8";

		}

		xmlFile.createNewFile();

			System.out.println("Error: CSV file does not exists");

			return false;

		}

		XMLOutputFactory factory = XMLOutputFactory.newInstance();

		FileOutputStream output = new FileOutputStream(xmlFile);

		CsvReader reader = new CsvReader(csvfile.getAbsolutePath(), separator.charAt(0), Charset.forName(encoding));

		if (txtseparator != null && txtseparator.length() > 0)

			reader.setTextQualifier(txtseparator.charAt(0));

		reader.readHeaders();

		String[] headers = reader.getHeaders();

			writer.close();

			output.close();

			return false;

		}

			writer.close();

			output.close();

			if (!separator.equals("\t")) {

				return convertCsvToXml(csvfile, xmlFile, encoding, "\t", "", nbheaderline);

			}

		}

		HashSet<String> testhash = new HashSet<String>();

		HashSet<String> doubles = new HashSet<String>();

			if (testhash.contains(str))

				doubles.add(str);

			testhash.add(str);

		}

			return false;

		}

		String[] longnames = new String[headers.length];

		String[] types = new String[headers.length];

			reader.readRecord();

				longnames[i] = reader.get(headers[i]);

			}

		}

				longnames[i] = headers[i];

			}

			reader.readRecord();

				types[i] = reader.get(headers[i]);

			}

		}

				types[i] = "String";

			}

		}

		writer.writeStartDocument("UTF-8", "1.0");

		writer.writeStartElement("enrichissement");

		writer.writeStartElement("metadatas");

		writer.writeCharacters("\n");

			if (headers[i].length() == 0) {

				headers[i] = "noname";

			}

			writer.writeStartElement("metadata");

			writer.writeAttribute("id", AsciiUtils.buildId(headers[i]));

			writer.writeAttribute("shortname", headers[i]);

			writer.writeAttribute("selection", "true");

			writer.writeAttribute("partition", "true");

			writer.writeAttribute("display", "true");

			writer.writeEndElement();

			writer.writeCharacters("\n");

		}

		writer.writeCharacters("\n");

		writer.writeStartElement("texts");

		writer.writeCharacters("\n");

			writer.writeStartElement("text");

					writer.writeAttribute("id", reader.get(headers[i]));

					writer.writeAttribute("xpath", reader.get(headers[i]));

				}

					writer.writeEmptyElement("entry");

					writer.writeAttribute("id", AsciiUtils.buildId(headers[i]));

					String value = reader.get(headers[i]);

						writer.writeAttribute("value", "N/A");

					else

						writer.writeAttribute("value", value);

				}

			writer.writeEndElement();

			writer.writeCharacters("\n");

		}

		writer.writeCharacters("\n");

		reader.close();

		writer.close();

		output.close();

		output = null;

		writer = null;

		return true;

	}

	/**

	 * Keep only metadatas.

	 *

	 * @param ids the ids

	 */

		List<String> Lids = Arrays.asList(ids);

		headersList.removeAll(Lids);

			Metadata m = metadatas.get(i);

				metadatas.remove(i);

				i--;

			}

		}

				org.txm.metadatas.Entry e = inj.get(i);

					inj.remove(i);

					i--;

				}

			}

		}

	}

	/**

	 * Inject metadatas in xml txm.

	 *

	 * @param infile the infile

	 * @param outfile the outfile

	 * @return true, if successful

	 */

	}

	/**

	 * Inject metadatas in xml.

	 *

	 * @param outfile the outfile

	 * @param tag the tag

	 * @return true, if successful

	 */

	}

	/**

	 * Inject metadatas in xml.

	 *

	 * @param tag the tag

	 * @param namespace the namespace

	 * @return true, if successful

	 */

		String key = infile.getName();

			key = key.substring(0, key.lastIndexOf("."));

		ArrayList<org.txm.metadatas.Entry> metas = get(key);

		if (metas == null) {

			System.out.println("Maybe the metadata file doesn't have the right format (comma separated values are needed)");

			return false;

		}

		AddAttributeInXml builder = new AddAttributeInXml(infile, tag, metas);

		builder.onlyOneElement();

		return builder.process(outfile);

	}

	/**

	 * Save.

	 *

	 * @param outfile the outfile

	 * @return true, if successful

	 */

		try {

			// Création de la source DOM

			Source source = new DOMSource(doc);

			// Création du fichier de sortie

			Result resultat = new StreamResult(writer);

			// Configuration du transformer

			TransformerFactory fabrique = new net.sf.saxon.TransformerFactoryImpl();

			Transformer transformer = fabrique.newTransformer();

			transformer.setOutputProperty(OutputKeys.INDENT, "yes");

			transformer.setOutputProperty(OutputKeys.METHOD, "xml");

			transformer.setOutputProperty(OutputKeys.ENCODING, "UTF-8");

			// Transformation

			transformer.transform(source, resultat);

			writer.close();

			doc = null;

			return true;

			org.txm.utils.logger.Log.printStackTrace(e);

			return false;

		}

	}

	/**

	 * Insert.

	 *

	 * @param xpath the xpath

	 * @param pairs the pairs

	 * @return true, if successful

	 */

		XPathFactory factory = XPathFactory.newInstance();

		XPath XpathObj = factory.newXPath();

		XpathObj.setNamespaceContext(nsContext);

		XPathExpression expr = XpathObj.compile(xpath);

		NodeList nodes = (NodeList) expr.evaluate(doc, XPathConstants.NODESET);

		int count = 0;

			org.w3c.dom.Node node = nodes.item(i);

				elem.setAttribute(p.getFirst(), p.getSecond());

			}

			count++;

		}

		factory = null;

		XpathObj = null;

		expr = null;

			return true;

			return false;

		}

	}

	/**

	 * Gets the property names.

	 *

	 * @return the property names

	 */

		return headersList;

	}

	/**

	 * Gets the sattributes.

	 *

	 * @return the sattributes

	 */

		String sattr = "";

		return sattr;

	}

	 * @see java.util.AbstractMap#toString()

	 */

	@Override

	public String toString() {

		StringBuffer str = new StringBuffer();

		str.append("Metadata: \n");

		for (Metadata data : metadatas) {

		}

		str.append("Injections: \n");

		}

		return str.toString();

	}

	/**

	 * The main method.

	 *

	 * @param args the arguments

	 */

	public static void main(String[] args) {

		String userhome = System.getProperty("user.home");

		File xmlfile = new File(userhome, "/xml/metadata.xml");

		File csvfile = new File(userhome, "/xml/metadata.csv");

		File odsfile = new File(userhome, "/xml/metadata.ods");

		File xlsxfile = new File(userhome, "/xml/metadata.xlsx");

		if (m.isInitialized()) {

			System.out.println(m.toString());

		}

	}

	public ArrayList<Metadata> getMetadatas() {

		return metadatas;

		return this.headersList;

	}

}

	public static String fminP0fmaxP1tP2vP3; 

	/**

	 * Binds the given message's substitution locations with the given string values.

	 * @param message

	 * @param bindings

	 * @return the given message's substitution locations with the given string values.