|
Bonjour David,
Merci pour le fichier xslt, mais je dois dire que je ne comprends pas vraiment :
"Ceci peut te permettre d'insérer "statiquement" des données provenant de
ton fichier xml au bon endroit dans le fichier odt, sans même avoir à
ouvrir openoffice."
Comment dois-je faire ? Suis-je obligée de mettre une macro en parralèlle?
Pour le moment j'ai incorporé le fichier xslt dans 'paramètres du filtres xml"
Mais je ne sais pas comment relier le fichier identité.xml à mon formulaire PersonneMorale.ott
Te serait-il possible de me dire comment faire ?
Voici le contenu du fichier xslt que tu m'as recommandé : :)
/*
* ODTransform.java
* (c) 2003-2005 J. David Eisenberg
* Licensed under LGPL
*
* Program purpose: to perform an XSLT transformation
* on a member of an OpenDocument file, either
* after unzipping or while still in its zipped state.
* Output may go to a normal file or a zipped file.
*/
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.Transformer;
import javax.xml.transform.sax.SAXSource;
import javax.xml.transform.sax.SAXResult;
import javax.xml.transform.stream.StreamSource;
import javax.xml.transform.stream.StreamResult;
import javax.xml.transform.TransformerException;
import javax.xml.transform.TransformerConfigurationException;
import org.xml.sax.XMLReader;
import org.xml.sax.InputSource;
import org.xml.sax.ContentHandler;
import org.xml.sax.ext.LexicalHandler;
import org.xml.sax.SAXException;
import org.xml.sax.helpers.XMLReaderFactory;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Hashtable;
import java.util.jar.JarInputStream;
import java.util.jar.JarOutputStream;
import java.util.jar.JarEntry;
import java.util.Vector;
import java.util.zip.ZipException;
public class ODTransform
{
String inputFileName = null; // input file name, or member name...
String inputODName = null; // ...if given an OpenDocument input file
String outputFileName = null; // output file name, or member name...
String outputODName = null; // ...if given an OpenDocument output file
String xsltFileName = null; // XSLT file is always a regular file
Vector params = new Vector(); // parameters to be passed to transform
public void doTransform( )
throws TransformerException, TransformerConfigurationException,
SAXException, ZipException, IOException
{
/* Set up the XSLT transformation based on the XSLT file */
File xsltFile = new File( xsltFileName );
StreamSource streamSource = new StreamSource( xsltFile );
TransformerFactory tFactory = TransformerFactory.newInstance();
Transformer transformer = tFactory.newTransformer( streamSource );
/* Set up parameters for transform */
for (int i=0; i < params.size(); i += 2)
{
transformer.setParameter((String) params.elementAt(i),
(String) params.elementAt(i + 1));
}
/* Create an XML reader which will ignore any DTDs */
XMLReader reader = XMLReaderFactory.createXMLReader();
reader.setEntityResolver( new ResolveDTD() );
InputSource inputSource;
if (inputODName == null)
{
/* This is an unpacked file. */
inputSource =
new InputSource( new FileInputStream( inputFileName ) );
}
else
{
/* The input file should be a member of an OD file.
Check to see if the input file name really exists
within the JAR file */
JarInputStream jarStream =
new JarInputStream( new FileInputStream( inputODName ),
false );
JarEntry jarEntry;
while ( (jarEntry = jarStream.getNextJarEntry() ) != null &&
!(inputFileName.equals(jarEntry.getName()) ) )
// do nothing
;
inputSource = new InputSource( jarStream );
}
SAXSource saxSource = new SAXSource( reader, inputSource );
saxSource.setSystemId( inputFileName );
if (outputODName == null)
{
/* We want a regular file as output */
FileOutputStream outputStream =
new FileOutputStream( outputFileName );
transformer.transform( saxSource,
new StreamResult( outputStream ) );
outputStream.close();
}
else
{
/* The output file name is the name of a member of
a JAR file (which we will build without a manifest) */
JarOutputStream jarStream =
new JarOutputStream( new FileOutputStream( outputODName ) );
JarEntry jarEntry = new JarEntry( outputFileName );
jarStream.putNextEntry( jarEntry );
transformer.transform( saxSource,
new StreamResult( jarStream ) );
/* Close the member file and the JAR file
to complete the file */
jarStream.closeEntry();
createManifestFile( jarStream );
/* Close the JAR file to complete the file */
jarStream.close();
}
}
/* Check to see if the command line arguments make sense */
private void checkArgs( String[] args )
{
int i;
if (args.length == 0)
{
showUsage( );
System.exit( 1 );
}
i = 0;
while ( i < args.length )
{
if (args[i].equalsIgnoreCase("-in"))
{
if ( i+1 >= args.length)
{
badParam("-in");
}
inputFileName = args[i+1];
i += 2;
}
else if (args[i].equalsIgnoreCase("-out"))
{
if ( i+1 >= args.length)
{
badParam("-out");
}
outputFileName = args[i+1];
i += 2;
}
else if (args[i].equalsIgnoreCase("-xsl"))
{
if ( i+1 >= args.length)
{
badParam("-xsl");
}
xsltFileName = args[i+1];
i += 2;
}
else if (args[i].equalsIgnoreCase("-inod"))
{
if ( i+1 >= args.length)
{
badParam("-inOD");
}
inputODName = args[i+1];
i += 2;
}
else if (args[i].equalsIgnoreCase("-outod"))
{
if ( i+1 >= args.length)
{
badParam("-outOD");
}
outputODName = args[i+1];
i += 2;
}
else if (args[i].equalsIgnoreCase("-param"))
{
if ( i+2 >= args.length)
{
badParam("-param");
}
params.addElement( args[i+1] );
params.addElement( args[i+2] );
i += 3;
}
else
{
System.out.println( "Unknown argument " + args[i] );
System.exit( 1 );
}
}
if (inputFileName == null)
{
System.out.println("No input file name specified.");
System.exit( 1 );
}
if (outputFileName == null)
{
System.out.println("No output file name specified.");
System.exit( 1 );
}
if (xsltFileName == null)
{
System.out.println("No XSLT file name specified.");
System.exit( 1 );
}
}
/* If not enough arguments for a parameter, show error and exit */
private void badParam( String paramName )
{
System.out.println("Not enough parameters to " + paramName);
System.exit(1);
}
/*
Creates the manifest file for a compressed OpenDocument
file. The mType array contains pairs of filename
extensions and corresponding mimetypes. The comparison
to find the extension is done in a case-insensitive manner.
*/
private void createManifestFile( JarOutputStream jarStream )
{
String [] mType = {
"odt", "application/vnd.oasis.opendocument.text",
"ott", "application/vnd.oasis.opendocument.text-template",
"odg", "application/vnd.oasis.opendocument.graphics",
"otg",
"application/vnd.oasis.opendocument.graphics-template",
"odp", "application/vnd.oasis.opendocument.presentation",
"otp",
"application/vnd.oasis.opendocument.presentation-template",
"ods", "application/vnd.oasis.opendocument.spreadsheet",
"ots",
"application/vnd.oasis.opendocument.spreadsheet-template",
"odc", "application/vnd.oasis.opendocument.chart",
"otc", "application/vnd.oasis.opendocument.chart-template",
"odi", "application/vnd.oasis.opendocument.image",
"oti", "application/vnd.oasis.opendocument.image-template",
"odf", "application/vnd.oasis.opendocument.formula",
"otf", "application/vnd.oasis.opendocument.formula-template",
"odm", "application/vnd.oasis.opendocument.text-master",
"oth", "application/vnd.oasis.opendocument.text-web",
};
JarEntry jarEntry;
int dotPos;
String extension;
String mimeType = null;
String outputStr;
dotPos = outputODName.lastIndexOf(".");
extension = outputODName.substring( dotPos + 1 );
for (int i=0; i < mType.length && mimeType == null; i+=2)
{
if (extension.equalsIgnoreCase( mType[i] ))
{
mimeType = mType[i+1];
}
}
if (mimeType == null)
{
System.err.println("Cannot find mime type for extension "
+ extension );
mimeType = "UNKNOWN";
}
try
{
jarEntry = new JarEntry( "META-INF/manifest.xml");
jarStream.write( "<?xml version=\"1.0\" encoding=\"UTF-8\"?>"
.getBytes() );
jarStream.write( "<!DOCTYPE manifest:manifest PUBLIC \"-//OpenOffice.org//DTD Manifest 1.0//EN\" \"Manifest.dtd\">"
.getBytes() );
jarStream.write("<manifest:manifest xmlns:manifest=\"urn:oasis:names:tc:opendocument:xmlns:manifest:1.0\">"
.getBytes() );
outputStr = "<manifest:file-entry manifest:media-type=\"" +
mimeType + "\" manifest:full-path=\"/\"/>";
jarStream.write( outputStr.getBytes() );
outputStr = "<manifest:file-entry manifest:media-type=\"text/xml\" manifest:full-path=\"" + outputFileName + "\"/>";
jarStream.write( outputStr.getBytes() );
jarStream.write("</manifest:manifest>".getBytes() );
jarStream.closeEntry();
}
catch (IOException e)
{
System.err.println("Cannot write file:");
System.err.println( e.getMessage() );
}
}
/* If no arguments are provided, show this brief help section */
private void showUsage( )
{
System.out.println("Usage: ODTransform options");
System.out.println("Options:");
System.out.println(" -in inputFilename");
System.out.println(" -xsl transformFilename");
System.out.println(" -out outputFilename");
System.out.println("If the input filename is within an OpenDocument file, then:");
System.out.println(" -inOD inputOpenDocFileName");
System.out.println("If you wish to output an OpenDocument file, then:");
System.out.println(" -outOD outputOpenDocumentFileName");
System.out.println( );
System.out.println("Argument names are case-insensitive.");
}
public static void main(String[] args)
{
ODTransform transformApp = new ODTransform( );
transformApp.checkArgs( args );
try {
transformApp.doTransform( );
}
catch (Exception e)
{
System.out.println("Unable to transform");
System.out.println(e.getMessage());
}
}
}
Françoise
-------Message original-------
Date : 10/10/06 07:30:39
Sujet : Re: [dev-fr] Information (Important)
Bonjour,
Au lien suivant :
tu trouveras le code d'un programme qui permet d'appliquer un filtre
xslt au fichier content.xml d'une archive odt.
Ceci peut te permettre d'insérer "statiquement" des données provenant de
ton fichier xml au bon endroit dans le fichier odt, sans même avoir à
ouvrir openoffice.
Il y'a également la possibilité de parser ton fichier xml depuis une
macro et de modifier en conséquence les champs du formulaire. Il est
possible d'accéder aux données d'un fichier xml par DOM ou SAX depuis
une macro OOo.
Ce sont plus des pistes que des solutions, mais .... pour des exemples
plus concrets (en tout cas pour les macros), le forum OOoforum est d'une
aide précieuse ;)
David
Françoise a écrit :
> Bonjour,
>
>
> J'ai vraiment besoin d'aide.
> Quelqu'un pourrait-il me renseigner ?
>
> Est-il possible d'incorporer les données d'un fichier xml directement
> dans un formulaire (writer) d'OpenOfffice ? Comment le faire? ou
> suis-je obligée de réencoder tout?
>
> EX: Nom, prénom, date de naissance, lieu de naissance, rue, n°, code
> postal, commune, ville, pays, etc....
>
> Merci d'avance pour tous renseignements
>
> Françoise
>
>
>
>
> Des émoticônes GRATUITES pour votre messagerie électronique ? Cliquez
--
David Petter
Custom Department
SYMBIOS Orthopédie SA
Z.I. Petits-Champs 15
1400 Yverdon-les-Bains
Switzerland
Phone# : +41 (0)24 424 26 52
Fax# : +41 (0)24 424 26 45
| 
