sql server datamerge (7 emails, 6 files total)

[naglists]

1 of 7

Hi,
I hacked together a SQL Server datamerge and have now generalized it into a
sample like the Access and Excel ones that install with Editor. (Frankly,
it's better documented if I do say so myself.) I am going to send each of
the six files I've created one at a time as replies to this e-mail.
Eventually, I'll upload it to adepters.org. If you try it and it works (or
doesn't work), please let me know.

--
Paul Nagai

[naglists]

E-mail 2 of 7.

File 1 of 6. readme.txt:

This is a SQL Server datamerge setup for axdocbook.

Paul Nagai
paul@panaga.com
20110218

Datamerge demo files and directory structure:


sql_server_datamerge.zip Contains everything mentioned below.

readme.txt. this file.

sql_server_datamerge.pdf screen caps associated with the
sql_server_datamerge.doc steps documented in readme.txt.

docbook_sql_server_datamerge.xml This is an XML instance with
a resolved datamerge in it.

hardware_sql.sql Contains hardware_sql database creation
and data insertion query.

NOTES:
* This demo was developed against SQL Server 2005.
* I had admin access to the server hosting SQL Server.
* The .sql file could possibly be simplified but I
quit when it worked.


Custom Directory files (Arbortext install custom if you dare ... make
backups of any files you need to replace OR set APTCUSTOM to something
else, e.g. c:\datamerge):

datamerge directory
sql.dmf The datamerge configuration file which
defines a query using a SQL Server database:
Hardware Reqs in a freeform table (using xsl transformer)

sqlhardware.xsl freeform xsl that converts
datamerge namespace elements into
CALS / OASIS table elements.

doctype directory
axdocbook.dcf a modification of axdocbook dcf file


How to set up the demo:
1. Unzip datamerge_sql.zip to a directory (e.g. c:\datamerge)
2. Point APTCUSTOM to the directory where the demo file unzipped
(e.g. c:\datamerge)
3. Create a SQL Server database using hardware_sql.sql.
a. Start Microsoft SQL Server Management Studio.
b. Click New Query.
c. Open hardware_sql.sql in Notepad.
d. Copy and paste its contents into the new query.
e. Click Execute.
f. Select Databases in the left-hand pane of SQL Server Management
Studio.
g. Select View > Refresh.
h. Confirm hardware_sql has been created.
4. Setup System DSN for SQL Server.
a. Control Panel -> Administrative Tools-> Data Sources (ODBC)
b. Go to System DSN tab and click add
c. Select the SQL Server driver.
d. Set "Data Source Name" to "sql".
e. Set the Description to anything you like.
f. Set the server to the server where you created the database.
g. Click Next.
h. Accept the defaults on the next dialog by clicking Next.
i. Select the Change the default database to checkbox.
j. Select the hardware_sql database.
k. Click Next.
l. Accept the defaults on the next dialog by clicking Next.
m. Select Test Data Source to test the new data source.
n. Click OK several times to close out the ODBC Data Source
Administrator.
3. Setup xsl stylesheet path for
a. Open sql.dmf in a text editor (or Epic)
b. Near the bottom of the dmf file, you will see
<transformerref name="transformer" nameref="XSLTransformer">
<parameterref name="p_stylesheet" nameref="stylesheet">
<value>c:/mylocation/sqlhardware.xsl</value>
</parameterref>
</transformerref>
c. Change the value of stylesheet location to match where you put
sqlhardware.xsl
is. (e.g. c:/datamerge/sqlhardware.xsl)


How to run the demo
1. Open an axdocbook document
2. Place your cursor in a document location where table is valid.
3. Go to Insert->Markup
3. In the mode drop down list, select "Query" (it may take a few seconds
the
first time to start Java and load config files)
4. You should see the query Hardware Requirements in a freeform table
(Company, Platform) in the dialog.
5. Click Insert.
6. Click Next. (You can change the choices if you want.)
7. Clear the Auto Update on Open checkbox. (Or not. Your choice. It
bugged me.)
8. Click Insert.
9. Editor inserts the query (note the datamerge icon) and renders the
table.

[naglists]

E-mail 3 of 7.

File 2 of 6. axdocbook.dcf:



Configuration 2.0//EN"
"dcfdtd.dtd" [
Configuration 1.0//EN" ">
Configuration Translated Strings 1.0//EN" "../../lib/dcf_strings.ent">
%strings;
]>
<documenttypeconfiguration>
<options allowfosimod="yes" allowtouchup="yes" protected="no"/">
<newdialog>
<new description="Arbortext" xml=" docbook=" v4.0&quot;=" samplefile="demo.xml"&lt;br"/>templateFile="template.xml"/></newdialog>
<elementoptions>
<elementoption allowspellchecking="no" element="abbrev"/">
<elementoption category="division" element="abstract"/">
<elementoption allowspellchecking="no" element="accel"/">
<elementoption allowspellchecking="no" element="acronym"/">
<elementoption category="division" element="appendix"&lt;br"/>webComposePageBoundary="yes"/>
<elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="arg"/>
<elementoption category="division" element="article"/">
<elementoption allowspellchecking="no" element="artpagenums"/">
<elementoption allowspellchecking="no" element="authorinitials"/">
<elementoption category="division" element="bibliodiv"/">
<elementoption category="division" element="bibliography"/">
<elementoption category="division" element="blockquote"/">
<elementoption category="division" element="book"&lt;br"/>webComposePageBoundary="yes"/>
<elementoption element="bookinfo" webcomposepageboundary="yes"/">
<elementoption category="division" element="caution"/">
<elementoption category="division" element="chapter"&lt;br"/>webComposePageBoundary="yes"/>
<elementoption allowcharactersubstitution="no" element="cmdsynopsis"/">
<elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="command"/>
<elementoption allowspellchecking="no" element="computeroutput"/">
<elementoption allowspellchecking="no" element="contractnum"/">
<elementoption allowspellchecking="no" element="database"/">
<elementoption category="division" element="dedication"&lt;br"/>webComposePageBoundary="yes"/>
<elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="email"/>
<elementoption allowspellchecking="no" element="envar"/">
<elementoption allowspellchecking="no" category="division"&lt;br"/>element="equation"/>
<elementoption allowspellchecking="no" element="errorcode"/">
<elementoption category="division" element="example"/">
<elementoption category="division" element="figure"/">
<elementoption allowspellchecking="no" element="filename"/">
<elementoption element="footnote" spellcheckingnewword="yes"/">
<elementoption category="division" element="formalpara"/">
<elementoption allowspellchecking="no" element="funcdef"/">
<elementoption allowcharactersubstitution="no" element="funcsynopsisinfo"/">
<elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="function"/>
<elementoption category="division" element="glossary"&lt;br"/>webComposePageBoundary="yes"/>
<elementoption category="division" element="glossdiv"/">
<elementoption category="division" element="glossentry"/">
<elementoption element="holder" spellcheckingnewword="yes"/">
<elementoption category="division" element="important"/">
<elementoption category="division" element="index"&lt;br"/>webComposePageBoundary="yes"/>
<elementoption category="division" element="indexdiv"/">
<elementoption element="indexterm" spellcheckingnewword="yes"/">
<elementoption allowspellchecking="no" element="informalequation"/">
<elementoption allowspellchecking="no" element="inlinemediaobject"/">
<elementoption allowspellchecking="no" element="invpartnumber"/">
<elementoption allowspellchecking="no" element="isbn"/">
<elementoption allowspellchecking="no" element="issn"/">
<elementoption allowspellchecking="no" element="issuenum"/">
<elementoption element="itemizedlist" listtype="block"/">
<elementoption category="division" element="legalnotice"/">
<elementoption element="listitem" listtype="item"/">
<elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="literal"/>
<elementoption allowcharactersubstitution="no" element="literallayout"/">
<elementoption allowspellchecking="no" element="manvolnum"/">
<elementoption allowspellchecking="no" element="markup"/">
<elementoption element="member" listtype="item"/">
<elementoption category="division" element="note"/">
<elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="option"/>
<elementoption element="orderedlist" listtype="block"/">
<elementoption allowspellchecking="no" element="pagenums"/">
<elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="parameter"/>
<elementoption category="division" element="part"&lt;br"/>webComposePageBoundary="yes"/>
<elementoption category="division" element="partintro"/">
<elementoption allowspellchecking="no" element="pob"/">
<elementoption allowspellchecking="no" element="postcode"/">
<elementoption category="division" element="preface"&lt;br"/>webComposePageBoundary="yes"/>
<elementoption element="primary" spellcheckingnewword="yes"/">
<elementoption category="division" element="procedure" listtype="block"/">
<elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="programlisting"/>
<elementoption category="division" element="refentry"/">
<elementoption category="division" element="reference"/">
<elementoption category="title" element="refmeta"/">
<elementoption category="division" element="refsect1"/">
<elementoption category="division" element="refsect2"/">
<elementoption category="division" element="refsect3"/">
<elementoption category="division" element="refsynopsisdiv"/">
<elementoption allowcharactersubstitution="no" element="replaceable"/">
<elementoption allowcharactersubstitution="no" element="screen"/">
<elementoption element="secondary" spellcheckingnewword="yes"/">
<elementoption category="division" element="sect1"&lt;br"/>webComposePageBoundary="yes"/>
<elementoption category="division" element="sect2"/">
<elementoption category="division" element="sect3"/">
<elementoption category="division" element="sect4"/">
<elementoption category="division" element="sect5"/">
<elementoption category="division" element="section"/">
<elementoption category="division" element="simplesect"/">
<elementoption category="division" element="set"/">
<elementoption category="division" element="setindex"/">
<elementoption allowspellchecking="no" element="sgmltag"/">
<elementoption category="division" element="sidebar"/">
<elementoption element="simplelist" listtype="block"/">
<elementoption element="state" spellcheckingnewword="yes"/">
<elementoption element="step" listtype="item"/">
<elementoption element="substeps" listtype="block"/">
<elementoption allowcharactersubstitution="no" element="synopsis"/">
<elementoption allowcharactersubstitution="no" allowspellchecking="no"&lt;br"/>element="systemitem"/>
<elementoption category="division" element="table"/">
<elementoption category="division" element="tip"/">
<elementoption category="title" element="title"/">
<elementoption allowspellchecking="no" element="userinput"/">
<elementoption category="division" element="variablelist"/">
<elementoption category="division" element="varlistentry"/">
<elementoption allowspellchecking="no" element="varname"/">
<elementoption allowspellchecking="no" element="volumenum"/">
<elementoption category="division" element="warning"/"></elementoptions>
<attributeoptions>
<attributeoption attribute="security" profiling="yes"/">
<attributeoption attribute="os" profiling="yes"/">
<attributeoption attribute="userlevel" profiling="yes"/">
<attributeoption attribute="arch" profiling="yes"/"></attributeoptions>
<display>
<icon characternumber="16" characternumberlocal="15"&lt;br"/>characterSet="ati_tag" id="para"/>
<icon characternumber="18" characternumberlocal="17"&lt;br"/>characterSet="ati_tag" id="endpara"/>
<elementdisplay element="abstract" partialtagmodedisplay="full"/">
<elementdisplay element="anchor" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="appendix" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="area" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="article" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="authorgroup" partialtagmodedisplay="full"/">
<elementdisplay element="beginpage" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="bibliodiv" partialtagmodedisplay="full"/">
<elementdisplay element="bibliography" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="blockquote" partialtagmodedisplay="full"/">
<elementdisplay element="book" newline="yes" partialtagmodedisplay="full"/">
<elementdisplay element="bookinfo" partialtagmodedisplay="full"/">
<elementdisplay element="calloutlist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="caution" partialtagmodedisplay="full"/">
<elementdisplay element="chapter" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="cmdsynopsis" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="cmdsynopsis" newline="yes" pair="end"/">
<elementdisplay element="co" pair="start" partialtagmodedisplay="partial"/">
<elementdisplay element="colspec" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="dedication" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="equation" partialtagmodedisplay="full"/">
<elementdisplay element="example" partialtagmodedisplay="full"/">
<elementdisplay element="figure" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="footnoteref" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="funcsynopsis" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="funcsynopsis" newline="yes" pair="end"/">
<elementdisplay element="glossary" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="glossdiv" partialtagmodedisplay="full"/">
<elementdisplay element="glossentry" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="glosslist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="graphic" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="important" partialtagmodedisplay="full"/">
<elementdisplay element="index" newline="yes" notagmodeprompt="no"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="indexdiv" partialtagmodedisplay="full"/">
<elementdisplay element="inlinegraphic" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="itemizedlist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="legalnotice" partialtagmodedisplay="full"/">
<elementdisplay element="literallayout" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="literallayout" newline="yes" pair="end"/">
<elementdisplay element="msgentry" partialtagmodedisplay="full"/">
<elementdisplay element="msgset" partialtagmodedisplay="full"/">
<elementdisplay element="note" partialtagmodedisplay="full"/">
<elementdisplay element="orderedlist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="para" pair="start" partialtagmodeicon="para"/">
<elementdisplay element="para" pair="end" partialtagmodeicon="endpara"/">
<elementdisplay element="part" newline="yes" partialtagmodedisplay="full"/">
<elementdisplay element="partintro" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="preface" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="procedure" partialtagmodedisplay="full"/">
<elementdisplay element="programlisting" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="programlisting" newline="yes" pair="end"/">
<elementdisplay element="programlistingco" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="quote" partialtagmodedisplay="none"/">
<elementdisplay element="refentry" partialtagmodedisplay="full"/">
<elementdisplay element="reference" partialtagmodedisplay="full"/">
<elementdisplay element="refmeta" partialtagmodedisplay="full"/">
<elementdisplay element="refnamediv" partialtagmodedisplay="full"/">
<elementdisplay element="refsect1" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="refsect2" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="refsect3" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="refsynopsisdiv" partialtagmodedisplay="full"/">
<elementdisplay element="revhistory" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="sbr" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="screen" newline="yes" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="screen" newline="yes" pair="end"/">
<elementdisplay element="sect1" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="sect2" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="sect3" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="sect4" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="sect5" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="segmentedlist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="set" newline="yes" partialtagmodedisplay="full"/">
<elementdisplay element="setindex" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="sidebar" partialtagmodedisplay="full"/">
<elementdisplay element="simplelist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="spanspec" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="synopsis" newline="yes"/">
<elementdisplay element="table" newline="yes"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="tip" partialtagmodedisplay="full"/">
<elementdisplay element="toc" notagmodeprompt="no"/">
<elementdisplay element="varargs" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="variablelist" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="varlistentry" pair="start"&lt;br"/>partialTagModeDisplay="full"/>
<elementdisplay element="void" pair="start"&lt;br"/>partialTagModeDisplay="partial"/>
<elementdisplay element="warning" partialtagmodedisplay="full"/">
<elementdisplay element="xref" pair="start"&lt;br"/>partialTagModeDisplay="partial"/></display>
<specials>
<graphic element="inlinegraphic" entity="entityref" filename="fileref"&lt;br"/>horizScale="scale" inline="yes" reproDepth="depth" reproWidth="width"
scaleToFit="scalefit" vertScale="scale"/>
<graphic element="graphic" entity="entityref" filename="fileref"&lt;br"/>horizScale="scale" reproDepth="depth" reproWidth="width"
scaleToFit="scalefit" vertScale="scale"/>
<graphic element="imagedata" entity="entityref" filename="fileref"&lt;br"/>horizScale="scale" reproDepth="depth" reproWidth="width"
scaleToFit="scalefit" vertScale="scale"/>
<link element="ulink" uri="url"/">
<link element="link" idref="linkend"/">
<link element="glossterm" idref="linkend"/">
<target element="anchor"/">
<paragraph element="para"/">
<paragraph element="member"/">&activex;
</specials>
<contexttransformations>
<insertaroundtofix>
<elementlistitem element="para"/">
<elementlistitem element="member"/">
<elementlistitem element="term"/">
<elementlistitem element="equation"/">
<elementlistitem element="inlineequation"/"></insertaroundtofix>
<substitutions element="appendix">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="glossary"/">
<elementlistitem element="section"/"></substitutions>
<substitutions element="appendixinfo">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="glossaryinfo"/">
<elementlistitem element="sectioninfo"/"></substitutions>
<substitutions element="bridgehead">
<elementlistitem element="title"/"></substitutions>
<substitutions element="chapter">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="section"/">
<elementlistitem element="simplesect"/">
<elementlistitem element="appendix"/"></substitutions>
<substitutions element="chapterinfo">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="sectioninfo"/">
<elementlistitem element="appendixinfo"/"></substitutions>
<substitutions element="glossary">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="appendix"/">
<elementlistitem element="section"/"></substitutions>
<substitutions element="glossaryinfo">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="appendixinfo"/">
<elementlistitem element="sectioninfo"/"></substitutions>
<substitutions element="glossdef">
<elementlistitem element="listitem"/"></substitutions>
<substitutions element="glossterm">
<elementlistitem element="term"/"></substitutions>
<substitutions element="member">
<elementlistitem element="para"/">
<elementlistitem element="listitem"/"></substitutions>
<substitutions element="para">
<elementlistitem element="member"/"></substitutions>
<substitutions element="part">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="section"/">
<elementlistitem element="simplesect"/">
<elementlistitem element="appendix"/"></substitutions>
<substitutions element="partinfo">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="sectioninfo"/">
<elementlistitem element="appendixinfo"/"></substitutions>
<substitutions element="refsect1">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="appendix"/">
<elementlistitem element="glossary"/">
<elementlistitem element="section"/"></substitutions>
<substitutions element="refsect1info">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="appendixinfo"/">
<elementlistitem element="glossaryinfo"/">
<elementlistitem element="sectioninfo"/"></substitutions>
<substitutions element="refsect2">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="appendix"/">
<elementlistitem element="glossary"/">
<elementlistitem element="section"/"></substitutions>
<substitutions element="refsect2info">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="appendixinfo"/">
<elementlistitem element="glossaryinfo"/">
<elementlistitem element="sectioninfo"/"></substitutions>
<substitutions element="refsect3">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="appendix"/">
<elementlistitem element="glossary"/">
<elementlistitem element="section"/"></substitutions>
<substitutions element="refsect3info">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="appendixinfo"/">
<elementlistitem element="glossaryinfo"/">
<elementlistitem element="sectioninfo"/"></substitutions>
<substitutions element="sect1">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="section"/">
<elementlistitem element="simplesect"/">
<elementlistitem element="appendix"/"></substitutions>
<substitutions element="sect1info">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="sectioninfo"/">
<elementlistitem element="appendixinfo"/"></substitutions>
<substitutions element="sect2">
<elementlistitem element="sect1"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="section"/">
<elementlistitem element="simplesect"/">
<elementlistitem element="appendix"/"></substitutions>
<substitutions element="sect2info">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="sectioninfo"/">
<elementlistitem element="appendixinfo"/"></substitutions>
<substitutions element="sect3">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="section"/">
<elementlistitem element="simplesect"/">
<elementlistitem element="appendix"/"></substitutions>
<substitutions element="sect3info">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="sectioninfo"/">
<elementlistitem element="appendixinfo"/"></substitutions>
<substitutions element="sect4">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="section"/">
<elementlistitem element="simplesect"/">
<elementlistitem element="appendix"/"></substitutions>
<substitutions element="sect4info">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="sectioninfo"/">
<elementlistitem element="appendixinfo"/"></substitutions>
<substitutions element="sect5">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="section"/">
<elementlistitem element="simplesect"/">
<elementlistitem element="appendix"/"></substitutions>
<substitutions element="sect5info">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="sectioninfo"/">
<elementlistitem element="appendixinfo"/"></substitutions>
<substitutions element="section">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/">
<elementlistitem element="chapter"/">
<elementlistitem element="part"/">
<elementlistitem element="refsect1"/">
<elementlistitem element="refsect2"/">
<elementlistitem element="refsect3"/">
<elementlistitem element="appendix"/">
<elementlistitem element="simplesect"/"></substitutions>
<substitutions element="sectioninfo">
<elementlistitem element="sect1info"/">
<elementlistitem element="sect2info"/">
<elementlistitem element="sect3info"/">
<elementlistitem element="sect4info"/">
<elementlistitem element="sect5info"/">
<elementlistitem element="chapterinfo"/">
<elementlistitem element="partinfo"/">
<elementlistitem element="refsect1info"/">
<elementlistitem element="refsect2info"/">
<elementlistitem element="refsect3info"/">
<elementlistitem element="appendixinfo"/"></substitutions>
<substitutions element="simplesect">
<elementlistitem element="formalpara"/"></substitutions>
<substitutions element="term">
<elementlistitem element="glossterm"/"></substitutions>
<substitutions element="title">
<elementlistitem element="bridgehead"/"></substitutions>
<substitutions element="varlistentry">
<elementlistitem element="glossentry"/"></substitutions>
<insertautowithin element="glossary" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:title></axdocbook:title><insertautoselection/><insertautocaret<br/>/></insertautowithin>
<insertautowithin element="indexterm" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:primary><insertautoselection/><insertautocaret/></axdocbook:primary<br/>></insertautowithin>
<insertautowithin element="listitem" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:para><insertautoselection/><insertautocaret/></axdocbook:para<br/>></insertautowithin>
<insertautowithin element="refentry" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:refmeta><insertautoselection/><insertautocaret/></axdocbook:refmeta<br/>></insertautowithin>
<insertautowithin element="sidebar" xmlns:axdocbook="axdocbook.dtd"&lt;br"/>><axdocbook:title></axdocbook:title><insertautoselection/><insertautocaret<br/>/></insertautowithin>
<insertautowithin element="step"&lt;br"/>xmlns:axdocbook="axdocbook.dtd"><axdocbook:para<br/>><insertautoselection/><insertautocaret/></axdocbook:para></insertautowithin>
</contexttransformations>
<textstyles>
<bold attribute="role" attributevalue="bold" element="emphasis"/">
<underline attribute="role" attributevalue="underline" element="emphasis"/">
<italic attribute="role" attributevalue="italic" element="emphasis"/">
</textstyles>
<lists>
<bulleted>
<block element="itemizedlist"/">
<item element="listitem"/"></bulleted>
<numbered>
<block element="orderedlist"/">
<item element="listitem"/"></numbered>
</lists>
<smartinsert>
<category title="&amp;Admonition;">
<elementlistitem element="caution"/">
<elementlistitem element="important"/">
<elementlistitem element="note"/">
<elementlistitem element="tip"/">
<elementlistitem element="warning"/"></category>
<category title="&amp;Base;">
<elementlistitem element="anchor"/"></category>
<category title="&amp;Compound;">
<elementlistitem element="msgset"/">
<elementlistitem element="procedure"/">
<elementlistitem element="qandaset"/">
<elementlistitem element="sidebar"/"></category>
<category title="&amp;Description;">
<elementlistitem element="abstract"/">
<elementlistitem element="authorblurb"/">
<elementlistitem element="epigraph"/"></category>
<category title="&amp;Division;">
<elementlistitem element="appendix"/">
<elementlistitem element="chapter"/">
<elementlistitem element="glossary"/">
<elementlistitem element="preface"/">
<elementlistitem element="sect1"/">
<elementlistitem element="sect2"/">
<elementlistitem element="sect3"/">
<elementlistitem element="sect4"/">
<elementlistitem element="sect5"/"></category>
<category title="&amp;DocumentInformation;">
<elementlistitem element="author"/">
<elementlistitem element="authorinitials"/">
<elementlistitem element="corpauthor"/">
<elementlistitem element="modespec"/">
<elementlistitem element="othercredit"/">
<elementlistitem element="productname"/">
<elementlistitem element="productnumber"/">
<elementlistitem element="revhistory"/"></category>
<category title="&amp;Formal;">
<elementlistitem element="equation"/">
<elementlistitem element="example"/">
<elementlistitem element="figure"/">
<elementlistitem element="table"/"></category>
<category title="&amp;General;">
<elementlistitem element="abbrev"/">
<elementlistitem element="acronym"/">
<elementlistitem element="anchor"/">
<elementlistitem element="bridgehead"/">
<elementlistitem element="citation"/">
<elementlistitem element="citerefentry"/">
<elementlistitem element="citetitle"/">
<elementlistitem element="emphasis"/">
<elementlistitem element="firstterm"/">
<elementlistitem element="footnote"/">
<elementlistitem element="foreignphrase"/">
<elementlistitem element="glossterm"/">
<elementlistitem element="highlights"/">
<elementlistitem element="phrase"/">
<elementlistitem element="quote"/">
<elementlistitem element="remark"/">
<elementlistitem element="subscript"/">
<elementlistitem element="superscript"/">
<elementlistitem element="trademark"/">
<elementlistitem element="wordasword"/"></category>
<category title="&amp;Graphic;">
<elementlistitem element="graphic"/">
<elementlistitem element="inlinegraphic"/">
<elementlistitem element="imagedata"/"></category>
<category title="&amp;Index;">
<elementlistitem element="indexterm"/"></category>
<category title="&amp;Informal;">
<elementlistitem element="address"/">
<elementlistitem element="blockquote"/">
<elementlistitem element="graphic"/">
<elementlistitem element="graphicco"/">
<elementlistitem element="informalequation"/">
<elementlistitem element="informalexample"/">
<elementlistitem element="informalfigure"/">
<elementlistitem element="informaltable"/">
<elementlistitem element="mediaobject"/">
<elementlistitem element="mediaobjectco"/"></category>
<category title="&amp;Inline;">
<elementlistitem element="inlineequation"/">
<elementlistitem element="inlinegraphic"/"></category>
<category title="&amp;LineSpecific;">
<elementlistitem element="literallayout"/">
<elementlistitem element="programlisting"/">
<elementlistitem element="programlistingco"/">
<elementlistitem element="screen"/">
<elementlistitem element="screenco"/">
<elementlistitem element="screenshot"/"></category>
<category title="&amp;Link;">
<elementlistitem element="link"/">
<elementlistitem element="olink"/">
<elementlistitem element="ulink"/"></category>
<category title="&amp;Lists;">
<elementlistitem element="calloutlist"/">
<elementlistitem element="glosslist"/">
<elementlistitem element="itemizedlist"/">
<elementlistitem element="orderedlist"/">
<elementlistitem element="segmentedlist"/">
<elementlistitem element="simplelist"/">
<elementlistitem element="variablelist"/"></category>
<category title="&amp;Paragraph;">
<elementlistitem element="formalpara"/">
<elementlistitem element="para"/">
<elementlistitem element="simpara"/"></category>
<category title="&amp;Reference;">
<elementlistitem element="footnoteref"/">
<elementlistitem element="xref"/"></category>
<category title="&amp;Synopsis;">
<elementlistitem element="classsynopsis"/">
<elementlistitem element="cmdsynopsis"/">
<elementlistitem element="constructorsynopsis"/">
<elementlistitem element="destructorsynopsis"/">
<elementlistitem element="fieldsynopsis"/">
<elementlistitem element="funcsynopsis"/">
<elementlistitem element="methodsynopsis"/">
<elementlistitem element="synopsis"/"></category>
<category title="&amp;Technical;">
<elementlistitem element="accel"/">
<elementlistitem element="action"/">
<elementlistitem element="application"/">
<elementlistitem element="classname"/">
<elementlistitem element="command"/">
<elementlistitem element="computeroutput"/">
<elementlistitem element="database"/">
<elementlistitem element="email"/">
<elementlistitem element="envar"/">
<elementlistitem element="errorcode"/">
<elementlistitem element="errorname"/">
<elementlistitem element="errortype"/">
<elementlistitem element="exceptionname"/">
<elementlistitem element="filename"/">
<elementlistitem element="function"/">
<elementlistitem element="guibutton"/">
<elementlistitem element="guiicon"/">
<elementlistitem element="guilabel"/">
<elementlistitem element="guimenu"/">
<elementlistitem element="guimenuitem"/">
<elementlistitem element="guisubmenu"/">
<elementlistitem element="hardware"/">
<elementlistitem element="interface"/">
<elementlistitem element="interfacename"/">
<elementlistitem element="keycap"/">
<elementlistitem element="keycode"/">
<elementlistitem element="keycombo"/">
<elementlistitem element="keysym"/">
<elementlistitem element="literal"/">
<elementlistitem element="markup"/">
<elementlistitem element="medialabel"/">
<elementlistitem element="menuchoice"/">
<elementlistitem element="methodname"/">
<elementlistitem element="mousebutton"/">
<elementlistitem element="msgtext"/">
<elementlistitem element="ooclass"/">
<elementlistitem element="ooexception"/">
<elementlistitem element="oointerface"/">
<elementlistitem element="option"/">
<elementlistitem element="optional"/">
<elementlistitem element="parameter"/">
<elementlistitem element="prompt"/">
<elementlistitem element="property"/">
<elementlistitem element="replaceable"/">
<elementlistitem element="returnvalue"/">
<elementlistitem element="sgmltag"/">
<elementlistitem element="structfield"/">
<elementlistitem element="structname"/">
<elementlistitem element="symbol"/">
<elementlistitem element="systemitem"/">
<elementlistitem element="token"/">
<elementlistitem element="type"/">
<elementlistitem element="userinput"/"></category>
</smartinsert>
<profiling config="axdocbook.pcf"/">
<framesets>
<frameset description="default" location="default"/"></framesets>
<composition>
<compose type="htmlfile"></compose>
<compose type="htmlhelp"></compose>
<compose type="pdf"></compose>
<compose type="profile"></compose>
<compose type="web"></compose>
<compose type="xsl"></compose>
<compose type="xslfo"></compose>
</composition>
<datamerge><datasource enabled="yes" name="sql"/"></datamerge>
</documenttypeconfiguration>

[naglists]

E-mail 4 of 7.

File 3 of 6. docbook_sql_server_datamerge.xml:



"axdocbook.dtd">

<book>
<title></title>
<subtitle></subtitle>
<bookinfo>
<pubdate></pubdate>
<authorgroup>
<corpauthor></corpauthor>
</authorgroup>
<address><street></street><city></city><state></state><postcode></postcode<br/>><country></country><phone></phone></address>
</bookinfo>
<chapter>
<title></title>
<para>Here comes the datamerge output.</para>
<atidm:query fontcolor="gray5" backcolor="inherit"&lt;br"/>queryKey="sql:HardwareReqItems"
queryName="Hardware Requirements in a freeform Table(Company, Platform)"
queryType="freeform" timestamp="1298058096893" updateOnOpen="no"
updateOnCompose="yes" updateManually="yes" p01="ARBWRE" p02="Windows"
xmlns:atidm="
<title>Results</title>
<tgroup cols="4">
<colspec colname="col1" colwidth="*"/">
<colspec colname="col2" colwidth="*"/">
<colspec colname="col3" colwidth="*"/">
<colspec colname="col4" colwidth="*"/">
<thead>
<row><entry>processor</entry><entry>operating_system</entry><entry<br/>>memory</entry><entry>disk_space</entry></row>
</thead>
<tbody>
<row>
<entry>IBM-compatible PC with a Pentium IV processor</entry>
<entry>Vista</entry>
<entry>512 MB RAM</entry>
<entry>300 MB additional disk space</entry>
</row>
<row>
<entry>IBM-compatible PC with a Pentium IV processor</entry>
<entry>Win98</entry>
<entry>12</entry>
<entry>300 MB additional disk space</entry>
</row>
<row>
<entry>IBM-compatible PC with a Pentium IV processor</entry>
<entry>7 Ultimate</entry>
<entry>4 GB</entry>
<entry>600 MB additional disk space</entry>
</row>
<row>
<entry>IBM-compatible PC with a Pentium IV processor</entry>
<entry>7 Universe</entry>
<entry>1 <bold>TB</bold></entry>
<entry>600 MB additional disk space</entry>
</row>
</tbody>
</tgroup>
</table></atidm:query>
</chapter>
</book>

[naglists]

Adepters shut me down for sending too many things too fast. Resending.

[naglists]

On Fri, Feb 18, 2011 at 3:36 PM, Paul Nagai <-> wrote:

> E-mail 6 of 7.
>
> File 5 of 6. sql.dmf
>
>
>
> > "../doctypes/datamerge/datamerge.dtd" [
> > component list//EN" "component.ent">
> %component;
> ]>
> <datamerge>
> <resource>&domReader;
> &msAccessSource;
> &xslTransformer;
> &tableModelTransformer;
> </resource>
>
>
> <query name="HardwareReqItems" querytype="freeform" rootelement="table">
> <label>Hardware Requirements in a freeform Table</label>
> <interface>
> <label>Query Parameters</label>
> <queryfield name="p01" displaytype="combo" value="ARBWRE">
> <label>Company</label>
> <listitem>ARBWRE</listitem>
> <listitem>TRU</listitem>
> </queryfield>
> <queryfield name="p02" displaytype="combo" value="Windows">
> <label>Platform</label>
> <listitem>Windows</listitem>
> <listitem>Unix</listitem>
> </queryfield>
> </interface>
> <sourceref name="r1" nameref="MS_Access_Source">
>
> <parameterref name="p_statement" nameref="sqlStatement">
> <value>select processor, operating_system, memory, disk_space from
> hardware_tbl WHERE company=? AND platform=?</value>
> </parameterref>
>
> <parametergroupref name="queryParameters" nameref="sqlParameters">
> <parameterref name="Model" datatype="string">
> <queryfieldref nameref="p01"></queryfieldref>
> </parameterref>
> <parameterref name="Year" datatype="string">
> <queryfieldref nameref="p02"></queryfieldref>
> </parameterref>
> </parametergroupref>
>
> <parametergroupref name="p_connect" nameref="connectionProperties">
> <parameterref name="p_url" nameref="url">
> <value>jdbcdbc:sql</value>
> </parameterref>
> </parametergroupref>
> </sourceref>
>
> <transformerref name="transformer" nameref="XSLTransformer">
> <parameterref name="p_stylesheet" nameref="stylesheet">
> <value>C:/Program
> Files/Arbortext/Editor53/custom/datamerge/sqlhardware.xsl</value>
> </parameterref>
> </transformerref>
> </query>
> </datamerge>
>
>


--
Paul Nagai

[naglists]

On Fri, Feb 18, 2011 at 3:37 PM, Paul Nagai <-> wrote:

> E-mail 7 of 7.
>
> File 6 of 6. sqlhardware.xsl
>
>
>
>
>
> <xsl:stylesheet version="1.0"&lt;br"/>> xmlns:xsl="
>
> xmlns:atidm="
> >
>
> <xslutput indent="yes" method="xml" encoding="UTF-8"/">
>
> <xslaram name="output-encoding">UTF-8</xslaram>
>
> <xsl:template match="/">
> <xsl:apply-templates/>
> </xsl:template>
>
> <xsl:template match="atidm:ResultSet">
>
> <table>
> <title>Results</title>
> <tgroup cols="4">
> <colspec colname="col1" colwidth="*"/">
> <colspec colname="col2" colwidth="*"/">
> <colspec colname="col3" colwidth="*"/">
> <colspec colname="col4" colwidth="*"/">
> <thead>
> <row>
> <entry>processor</entry>
> <entry>operating_system</entry>
> <entry>memory</entry>
> <entry>disk_space</entry>
> </row>
> </thead>
> <tbody>
> <xsl:apply-templates/>
> </tbody>
> </tgroup>
> </table>
>
> </xsl:template>
>
> <xsl:template match="atidm:Row">
> <row>
> <xsl:apply-templates/>
> </row>
> </xsl:template>
>
> <xsl:template match="atidm:Header">
> </xsl:template>
>
> <xsl:template match="atidm:Value">
> <xsl:apply-templates/>
> </xsl:template>
>
> <xsl:template match="atidm:Column">
> <entry>
> <xsl:apply-templates/>
> </entry>
> </xsl:template>
>
>
> </xsl:stylesheet>
>
>
>


--
Paul Nagai

[naglists]

On Fri, Feb 18, 2011 at 3:38 PM, Paul Nagai <-> wrote:

> All done. I just remembered, though, I should mention that the readme.txt
> references a Word .doc and an Acrobat .pdf that I'm not going to send across
> the mailing list. They are duplicates of each other and only contain screen
> caps. The readme.txt is probably enough.
>



--
Paul Nagai

[steve.thompson4]

Paul,

Just FYI...

File 3 of 6 didn't make it. With this last email, there should have been 8, counting your introductory message. Double checked, twice. Not triple, double twice, which is what... fourple? 😄

Anyway, no File 3 of 6. Looks like the "shut me down... Resending" needed to include File 3.

Regards,
Steve Thompson
+1(316)977-0515

[bibach]

Perhaps that message got caught by a filter of some sort at your
location, Steve? I got a copy of it, and all of the messages are
intact in the archives on ptcuser.org.

-Brandon 🙂


On Sat, Feb 19, 2011 at 7:32 AM, EXT-Thompson, Steve
<steve.thompson2@boeing.com> wrote:
> Paul,
>
> Just FYI...
>
> File 3 of 6 didn't make it. With this lastemail, there should have been 8,
> counting your introductory message. Double checked, twice. Not triple,
> double twice, which is what... fourple? 😄
>
> Anyway, no File 3 of 6. Looks like the "shut me down... Resending" needed to
> include File 3.
>
> Regards,
> Steve Thompson
> +1(316)977-0515

[steve.thompson4]

Good news for everyone else. Unhappily, they don't dump the 'filtered' files into a folder for review. Just gone.

As long as it's on ptcuser.org, it will be 'findable'...

Thanks,
Steve Thompson
+1(316)977-0515

[naglists]

Here you go, Steve.

[naglists]

Doing his best Ron Popeil:

BUT WAIT! THAT'S NOT ALL! THREE THREE THREE BONUS FILES!

1) An "identity" XSL stylesheet used to return the raw datamerge markup.
2) An example of the raw datamerge markup created by #1.
3) An "enhanced" example of an XSL that names ALL elements in the datamerge
markup. Even if it doesn't do anything different from the XSL delivered in
the sample with the new elements. Plus this contains processing that will
return a "row" as an <h1> with nested <h2> / para children.

[GarethOakes]

Very cool Paul, thanks for sharing!!

[mjohn]

Hi Everyone,

I've been testing some files for an update from Editor 5.3 - 5.4M80
and encountered a problem with the graphic spacing. It seems that in
one of my file, the graphic was moved to another page because of an
increase in the spacing between graphic and generated caption. I have
nothing special in postspace setting just a zero space with
precedence=none.

I cant force it to use 0pt because it will re-flow the other pages.
What I find weird also is that when I force it to use 8pt, then that
graphic fit and look exactly as in 5.3, but decrease the space to 7pt,
and again was pushed to the next page.

I also tested this in 5.4 M60 and this is not a problem. Was looking
at the release notes of 5.4 M70 and 5.4M80 and didnt see anything with
regards to this.

Anyone knows any work around for this or am I missing something?

Thanks.

Milton