Jealmembacy
New Member
I use XML to feed data to an InDesign template, and am in the process of switching from an older, simpler setup (mapped cells in an Excel spreadsheet) to FileMaker Pro. FileMaker Pro exports the XML in a slightly different format than the already-established XML structure in the InDesign document. When exporting XML from FileMaker Pro, I have the option of using an XSL stylesheet, but I don't know how to create one (and tutorials I've found seem vague or assume I already know things that I don't). FileMaker Pro export looks like this: \[code\]<?xml version="1.0" encoding="UTF-8" ?><!-- This grammar has been deprecated - use FMPXMLRESULT instead --><FMPDSORESULT xmlns="http://www.filemaker.com/fmpdsoresult"><ERRORCODE>0</ERRORCODE><DATABASE>Projects.fmp12</DATABASE><LAYOUT></LAYOUT><ROW MODID="1" RECORDID="2"><Project_name></Project_name><City_1></City_1><Size></Size><Building></Building><City_2></City_2><Completion></Completion><Scope_of_work></Scope_of_work><Description></Description></ROW>\[/code\]I need to write a stylesheet so the exported XML matches this structure, for each record:\[code\]<project> <project_title> <name></name> <city_1></city_1> </project_title> <project_information> <size></size> <building></building> <city_2></city_2> <completion></completion> <scope_of_work></scope_of_work> </project_information> <description></description></project>\[/code\]Any advice would be greatly appreciated.