Page 1 of 1

(newbie) how to populate CALS tables with database data

Posted: Mon May 14, 2018 4:14 pm
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

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

Posted: Tue May 15, 2018 7:36 am
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