AnsweredAssumed Answered

XML/XSLT Import Problem

Question asked by mgarcia on Feb 18, 2010
Latest reply on Feb 18, 2010 by comment_1

Title

XML/XSLT Import Problem

Post

Hello everyone,

 

I'm fairly new to Filemaker and having trouble importing XML files. I'm trying to import XML generated from WinAudit, a free computer auditing software. I know that the file is not in the correct grammar for Filemaker so I've been trying to find an XSLT stylesheet that can allow me to easily import these files (as there are many computers that will need auditing).

 

Basically, the XML from Winaudit looks like this:

 

<?xml version="1.0" encoding="utf-8" standalone="yes"?>

<computeraudit>

<title>Computer Audit :: 2/15/2010 1:04:42 PM</title>

<category title="System Overview">

<subcategory title="">

<recordset title="">

<fieldname>Item</fieldname>

<fieldname>Value</fieldname>

<datarow>

<fieldvalue>Computer Name</fieldvalue>

<fieldvalue>INTERCAL</fieldvalue>

</datarow>

<datarow>

<fieldvalue>Domain Name</fieldvalue>

<fieldvalue>WORKGROUP</fieldvalue>

</datarow>

 

</recordset>

</subcategory>

</category>

<disclaimer>Names mentioned herein maybe trademarks or service marks of their respective holders. Errors and Omissions Excepted. Generated by WinAudit Freeware v2.28.2</disclaimer>

</computeraudit>


 

I tried to use a stylesheet provided by Filemaker: mdso_elem.xslt. But Filemaker doesn't like it. I also don't have much experience with XML or XSLT so any information would be greatly appreciated.

 

Also, I'm using Filemaker Pro 9 Advanced on Mac OSX.

 

Thanks for the help,

Mercedes 

Outcomes