xml:aid table to HTML

[[Jongware]]

I'm a bit stumped about this request on an Adobe forum. Apparently, exporting a
table from their flagship InDesign to XML produces the following output for a
table (only first 2 rows listed; after that it's more of the same):

<?xml version="1.0" encoding="UTF-8"?>
< Table xmlns:aid="http ://ns.adobe.com/AdobeInDesign/4.0/" aid:table="tabl e"
aid:trows="7" aid:tcols="3">
<Cell aid:table="cell " aid:crows="1" aid:ccols="2">
<CellHeading>Si tuacao do Beneficiario</CellHeading>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 98.934380799140 81">
<CellHeading>Ta xas de Bonificacao</CellHeading>
</Cell>

Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 78.091861114101 46">
<CellBodyCenter >
<CharBold>Idade </CharBold>
</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 78.091861114101 46">
<CellBodyCenter >
<CharBold>Carre ira Contributiva (em anos)</CharBold>
</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 98.934380799140 81">
<CellBodyCenter >
<CharBold>Mensa l</CharBold>
</CellBodyCenter>
</Cell>

-- and the request of the OP is, how to convert this to HTML. Sounds easy? Not 4
me. The first row features a colspan (aid:ccols="2") ; without this, I could --
and would -- cheat, but this colspan messes up the <Cellcount. You see the
problem. Thou Shalt Not Loop or Count in XSLT As There Are No Variables! Anyone
else see a solution?

[Jongware]

[Joe Kesselman]

[Jongware] wrote:

Thou Shalt Not Loop or Count in XSLT As There Are No Variables!

General observation: you can often use position(), or last() applied to
an expression that counts the preceeding instances, as a replacement for
a loop counter. Try those first -- preferably position(), since it will
be more efficient.

See examples in the XSLT FAQ. Research left as an exercise for the student.
(If all else fails, it is possible to use recursion in place of looping
-- but that really should be a last resort.)
--
() ASCII Ribbon Campaign | Joe Kesselman
/\ Stamp out HTML e-mail! | System architexture and kinetic poetry

[[Jongware]]

"Joe Kesselman" <ke************ @comcast.netwro te in message
news:RJ******** *************** *******@comcast .com...

General observation: you can often use position(), or last() applied to an
expression that counts the preceeding instances, as a replacement for a
loop counter. Try those first -- preferably position(), since it will be
more efficient.

That would have been my cheat if all to-be rows had the same number of
cells. A short synopsis of the (quite unreadable) XML:
(header)
<table col='3' row='5'>
(first row)
<cell span='2'><cell span='1'>
(the rest)
<cell span='1'><cell span='1'<cell span='1'>

-- which has to be output in HTML form, grouping cells per row. The first
row only has 2 cells, as their 'spans' added equals the number of columns,
while the other rows have 3 cells each.

(If all else fails, it is possible to use recursion in place of looping --
but that really should be a last resort.)

The last resort is (always) cheating, and write a custom XSL for this case.
And another one for different numbers of rows and columns. And yet another
if the spans are in other places...
I tried recursion (sort of), propagating a 'current column' semi-variable
through the Cell template, but that was a very bad idea (as in I couldn't
insert row starts and ends).

[Jw]

[[Jongware]]

"Pavel Lepin" <p.*****@ctncor p.comwrote in message
news:f6******** **@aioe.org...

>
[Jongware] <Id***********@ hotmail.comwrot e in
<4Pwki.3912$%q4 .1386@amstwist0 0>:

>I'm a bit stumped about this request on an Adobe forum.

Perhaps you should've sent the OP here instead of serving as
a middleman.

I'll mention this ng ;-)

Engaging my gray matter yielded the following in about ten
minutes:

[brilliant, working solution snipped]

Oof. Just 10 mins?? It'll take me a bit longer than that to understand it.

Dealing with rowspans is left as an exercise for the reader.
Sending polite hate-mail to Adobe asking them to remove
their neck-mounted brain casings from their own rear-end
orifices is advised as well.

Fully agree with that.

[Jw]

[minlaca]

Thank you Jongware, and
Pavel Lepin!

This is a great solution but now I get an XML with some tables and the
tables has rowspan and colspan too. Can you help me for the transform?
Or the method like as the previous method?

<Table xmlns:aid="http ://ns.adobe.com/AdobeInDesign/4.0/"
aid:table="tabl e" aid:trows="7" aid:tcols="3">
<Cell aid:table="cell " aid:crows="1" aid:ccols="3">
<CellHeading>Si tuação do Beneficiário/Taxas de Bonificação</
CellHeading>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 78.091861114101 46">
<CellBodyCenter >
<CharBold>Idade </CharBold>
</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 103.98750365826 466">
<CellBodyCenter >
<CharBold>Carre ira Contributiva (em anos)</CharBold>
</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 72.788738254977 62">
<CellBodyCenter >
<CharBold>Mensa l</CharBold>
</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 78.091861114101 46">
<CellBodyCenter >&lt; 65</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 103.98750365826 466">
<CellBodyCenter >Condições de Acesso à Pensão sem
Penalização</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 72.788738254977 62">
<CellBodyCenter >0,65%</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 78.091861114101 46"></Cell>
<Cell aid:table="cell " aid:crows="3" aid:ccols="1"
aid:ccolwidth=" 103.98750365826 466">
<CellBodyCenter >15 a 24 </CellBodyCenter>
<CellBodyCenter >25 a 34 </CellBodyCenter>
<CellBodyCenter >35 a 39</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 72.788738254977 62">
<CellBodyCenter >0.33%</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 78.091861114101 46">
<CellBodyCenter >&gt; 65</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 72.788738254977 62">
<CellBodyCenter >0.65%</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 78.091861114101 46"></Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 72.788738254977 62">
<CellBodyCenter >1.0%</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 78.091861114101 46">
<CellBodyCenter >&gt; 65</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 103.98750365826 466">
<CellBodyCenter >&gt; 40</CellBodyCenter>
</Cell>
<Cell aid:table="cell " aid:crows="1" aid:ccols="1"
aid:ccolwidth=" 72.788738254977 62">
<CellBodyCenter >0.5%</CellBodyCenter>
</Cell>
</Table>

Thank you!