Hi Bev,

I'm using FMP10a. I'm trying to get data from Snow Leopard Server's Workgroup Manager on users and groups. 

I export the data from Workgroup Manager and attempt to pull the data into an FMP database using the Import->XML Data Source, but I get an invalid document structure error. Going to have to talk with the Apple Enterprise people to see just what's going on from their perspective and how to overcome this malfunction. 

Regards,

Chuck

On Apr 21, 2010, at 8:20 AM, Beverly Voth wrote:

> On 4/21/10 10:03 AM, "Chuck Pelto" <[log in to unmask]> wrote in whole or in
> part:
> 
>> Is there a script that can translate XML to a FileMaker Pro database?
> 
> 
> Chuck, what version of FMP?
> There is an IMPORT grammar called FMPXMLRESULT. It's formatted *somewhat*
> like a spreadsheet, because it has a list of the "Fields/column headers" and
> then is followed by a series of ROWS with COLS/DATA elements.
> 
> There are many "flavors" of XML (often defined or validated by a DTD or XSD
> - schema). What XML are you trying to import?
> 
> An XSLT needs to be used to translate (transform) your source XML into the
> FMPXMLRESULT for import. There are some sample XSLT in your install of FMP.
> However, these may not be sufficient. Your database structure will determine
> the correct way to import. For example, if you have related data, then you
> likely will need multiple imports (one into each table/table occurrence)
> from the same XML source.
> 
> Beverly
> 
>