AnsweredAssumed Answered

Converting XML in FileMaker to Table Format

Question asked by BENTO-BOX on Mar 15, 2010
Latest reply on Mar 19, 2010 by comment_1

Title

Converting XML in FileMaker to Table Format

Post

Hi everyone,

 

I am new to the FileMaker forum, as well as a novice to some of the advanced functions of FileMaker, but could anyone help me out with this problem?  (Update: I am using FileMaker Pro 10.)

 

I have some XML within a FileMaker field, and would like to automatically convert it into a standard table format.

 

I understand that exporting the XML, converting it to Excel, and then re-importing it back will indeed make it that way, but I was looking for a more automatic process.  (Perhaps using the script functions within FileMaker to parse the XML?)

 

I also understand that, if the XML were outside the FileMaker database, then importing it would require the use of XSLT style sheets.  (However, in this case, the XML is within the FileMaker database.)

 

I'd appreciate your help.  Thanks!

 

*************************************************

 

Here is the XML I am working with.  (Unfortunately, I cannot post the entire XML for some reason.)


 <GetClientListResult>
 <Clients>
  <Client ClientID="2iQs24qt0fcI" ClientName="3UK" ClientShortName="3UK" ClientNumber="" />
  <Client ClientID="2dR2QecHL9og" ClientName="Acer" ClientShortName="ACER" ClientNumber="" />
  <Client ClientID="2COiSYfuAf00" ClientName="Aigo" ClientShortName="AIGO" ClientNumber="" />
  </Clients>
  </GetClientListResult>
  </GetClientListResponse>
  </soap:Body>
  </soap:Envelope>

Outcomes