XIP Datenbank Import Beispiel: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „<syntaxhighlight lang="xml"> <?xml version="1.0" encoding="UTF-8"?> <import id="databaseimport" name="Import from Database"> <logging> <appender name=…“) |
|||
(Eine dazwischenliegende Version desselben Benutzers wird nicht angezeigt) | |||
Zeile 1: | Zeile 1: | ||
+ | ===XML Konfiguration=== | ||
<syntaxhighlight lang="xml"> | <syntaxhighlight lang="xml"> | ||
<?xml version="1.0" encoding="UTF-8"?> | <?xml version="1.0" encoding="UTF-8"?> | ||
<import id="databaseimport" name="Import from Database"> | <import id="databaseimport" name="Import from Database"> | ||
− | + | <logging> | |
− | + | <Appenders> | |
− | + | <RollingFile | |
− | + | name="FILE" | |
− | </ | + | fileName="${sys:sitepark.home}/database-import.log" |
− | < | + | filePattern="${sys:sitepark.home}/ldap/database-import-%d{dd-MM-yyyy}-%i.log.gz" |
− | < | + | append="true"> |
− | < | + | <PatternLayout> |
− | + | <Pattern>%d %-5p %m%n</Pattern> | |
− | + | </PatternLayout> | |
− | < | + | <Policies> |
− | + | <TimeBasedTriggeringPolicy /> | |
− | + | <SizeBasedTriggeringPolicy size="10MB" /> | |
− | + | </Policies> | |
+ | <DefaultRolloverStrategy max="10" /> | ||
+ | </RollingFile> | ||
+ | </Appenders> | ||
+ | <Loggers> | ||
+ | <Logger name="com.sitepark.ies" level="trace" additivity="false"> | ||
+ | <AppenderRef ref="FILE" /> | ||
+ | </Logger> | ||
+ | </Loggers> | ||
+ | </logging> | ||
<ies-connection login="Wartung" password="secret" client="ies2work" module="LDAP Importer"/> | <ies-connection login="Wartung" password="secret" client="ies2work" module="LDAP Importer"/> | ||
<options> | <options> | ||
Zeile 33: | Zeile 43: | ||
</source> | </source> | ||
</import> | </import> | ||
+ | </syntaxhighlight> | ||
+ | |||
+ | ===XSLT=== | ||
+ | <syntaxhighlight lang="xml"> | ||
+ | <?xml version="1.0" encoding="UTF-8"?> | ||
+ | |||
+ | <xsl:stylesheet version="1.0" | ||
+ | xmlns:xsl="http://www.w3.org/1999/XSL/Transform" | ||
+ | xmlns:xip="http://ies.sitepark.com/xip" | ||
+ | extension-element-prefixes="xip"> | ||
+ | |||
+ | <xsl:output method="xml" encoding="UTF-8" indent="yes"/> | ||
+ | |||
+ | <xsl:template match="/"> | ||
+ | <xip> | ||
+ | <xsl:for-each select="/rowset/row"> | ||
+ | <article parent="database.import.root" anchor="database.import.{_login}" name="{_lastname}, {_firstname}" filename="{_login}" template="database.import.template"> | ||
+ | <text name="sp_title"><xsl:value-of select="_lastname"/>, <xsl:value-of select="_firstname"/></text> | ||
+ | </article> | ||
+ | </xsl:for-each> | ||
+ | </xip> | ||
+ | </xsl:template> | ||
+ | </xsl:stylesheet> | ||
</syntaxhighlight> | </syntaxhighlight> |
Aktuelle Version vom 22. September 2023, 12:31 Uhr
XML Konfiguration
<?xml version="1.0" encoding="UTF-8"?>
<import id="databaseimport" name="Import from Database">
<logging>
<Appenders>
<RollingFile
name="FILE"
fileName="${sys:sitepark.home}/database-import.log"
filePattern="${sys:sitepark.home}/ldap/database-import-%d{dd-MM-yyyy}-%i.log.gz"
append="true">
<PatternLayout>
<Pattern>%d %-5p %m%n</Pattern>
</PatternLayout>
<Policies>
<TimeBasedTriggeringPolicy />
<SizeBasedTriggeringPolicy size="10MB" />
</Policies>
<DefaultRolloverStrategy max="10" />
</RollingFile>
</Appenders>
<Loggers>
<Logger name="com.sitepark.ies" level="trace" additivity="false">
<AppenderRef ref="FILE" />
</Logger>
</Loggers>
</logging>
<ies-connection login="Wartung" password="secret" client="ies2work" module="LDAP Importer"/>
<options>
<createElements>true</createElements>
<deleteWorkDir>true</deleteWorkDir>
<createPools>true</createPools>
<updatePools>true</updatePools>
<updateElements>true</updateElements>
<deletePools>true</deletePools>
<deleteOnlyEmptyPools>true</deleteOnlyEmptyPools>
<deleteElements>true</deleteElements>
<xslt>database-import.xslt</xslt>
<syncFile>${sitepark.home}/conf/database-import.sync</syncFile>
</options>
<source type="database" id="1">
<sql>SELECT * FROM UserDefinition</sql>
</source>
</import>
XSLT
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xip="http://ies.sitepark.com/xip"
extension-element-prefixes="xip">
<xsl:output method="xml" encoding="UTF-8" indent="yes"/>
<xsl:template match="/">
<xip>
<xsl:for-each select="/rowset/row">
<article parent="database.import.root" anchor="database.import.{_login}" name="{_lastname}, {_firstname}" filename="{_login}" template="database.import.template">
<text name="sp_title"><xsl:value-of select="_lastname"/>, <xsl:value-of select="_firstname"/></text>
</article>
</xsl:for-each>
</xip>
</xsl:template>
</xsl:stylesheet>