(newbie) how to populate CALS tables with database data

Post here questions and problems related to editing and publishing DITA content.
2level
Posts: 1
Joined: Mon May 14, 2018 3:47 pm

(newbie) how to populate CALS tables with database data

Post by 2level »

Hello!
I want to create product catalogs with photos, descriptions and CALS tables with technical data stored in a database (MS SQL in my case).
Do you know how to populate the rows of the CALS tables with database data?

Best Regards
Radu
Posts: 9445
Joined: Fri Jul 09, 2004 5:18 pm

Re: (newbie) how to populate CALS tables with database data

Post by Radu »

Hi,

You probably need to export the database data to some XML-like format. For example create a PHP script on the server side which could use SQL to interrogate the database and create a corresponding XML structure from it. Then apply an XSLT stylesheet on the XML to convert it to a CALS table model.

Regards,
Radu
Radu Coravu
<oXygen/> XML Editor
http://www.oxygenxml.com
Post Reply