xml and html automation

[jtcdesigns]

I'm the IT and web designer for a printing company. We just got Powerswitch which lets us automate workflows. After a job is looked through and any errors are generated they come out as XML. We want to then be able to take that xml file, format certain areas of it.. like errors in red.. titles in bold. and send it off as an html email to the client who submitted the job.

Now I know in indesign you can layout the tags and such then do import and I believe then export to an html file. I was wondering is there a way I can just make a html file and within some kind of code have it look for the location of the xml file and put the info into a form?

I basically just need to get an xml file, modify its looks, and send off as an html email... but all of it will be automated.

 

[Darth.Titan]

If I'm understanding you correctly, straight html can't do what you want. You'll need a server-side language like PHP to parse the xml file and reformat it.

PHP has some pretty good built in XML capabilities with DOM and SimpleXML.

 

[Cromulent]

XSLT is what you want.

http://en.wikipedia.org/wiki/XSLT

 

[DJBenE]

XSLT is what you want.

http://en.wikipedia.org/wiki/XSLT

Yes, XSLT is exactly what you need, and in all actuality is exactly why XSLT was invented in the first place. No need for using server-side scripts or anything.