I need help importing xisbn worldcat xml data into filemaker.

Here is a sample of the xml returned from http://xisbn.worldcat.org/webservices/xid/isbn/9780230418899?method=getMetadata&format=xml&fl=*

<rsp xmlns="http://worldcat.org/xid/isbn/" stat="ok">

<isbn oclcnum="726087703 751704411" form="BC" lang="eng" title="Mastermind." author="Mickey Rogers, Steve Taylore-Knowles, Dorothy E. Zemach ; concept development: Mariela Gil Vierma." publisher="Macmillan" city="Oxford" url="http://www.worldcat.org/oclc/726087703?referer=xid">9780230418899</isbn>

</rsp>

I need to extract :

Title

Author

Publisher

ISBN

Year

I don't know XML or XSL.

Can anyone give me an insight or provide me with an example file so I can see how this is done. Any help would be greatly appreciated.

Thanks,

Stuart

Try importing from the URL, using the attached stylesheet.

xisbn.zip

Try importing from the URL, using the attached stylesheet.

Thanks a million. That worked a like a charm. Much appreciated.

A blessed day to you!!

Stuart

Try importing from the URL, using the attached stylesheet.

I tried extracting this folder but I am getting an invalid message, I am working from a Windows platform, does this make a difference?

Possibly:

http://fmforums.com/forum/topic/82675-problem-with-attachments/

darn I hoped and prayed that I wouldn't run into any problems with using Windows with FM (I used to work with FM on a mac) ggrrr. Ok I'll look into other ways to open the attachment -- this answer seems to be the closes I've found to trying to extract data from an internet based library catalog into FM

I tried opening this file on my Windows XP computer, it did not work on that computer either. I've tried unblocking the file, downloading it from IE and Firefox, and turning off my antivirus. None of these actions have worked. In the original file, or when creating the zip did you ever use/enter a password? Otherwise maybe you could elaborate on instructions on how to extract data like title, author, subject, etc from online library catalogs (like Worldcat or Library of Congress).

I have just now downloaded archive file and extracted the contents without a problem. I really don't know how I can overcome this issue. The archive contains only a XSLT stylesheet to be used when importing from the WorldCat XML source. I'll paste the contents of the file below, but the forum software is not very friendly to XML code.

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

xmlns:xid="http://worldcat.org/xid/isbn/"

exclude-result-prefixes="xid">

<xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/>

<xsl:template match="/">

<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">

<ERRORCODE>0</ERRORCODE>

<PRODUCT BUILD="" NAME="" VERSION=""/>

<DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/>

<METADATA>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Title" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Authors" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Publisher" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ISBN" TYPE="TEXT"/>

<FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Year" TYPE="NUMBER"/>

</METADATA>

<RESULTSET FOUND="">

<xsl:for-each select="xid:rsp/xid:isbn">

<ROW MODID="" RECORDID="">

<COL><DATA><xsl:value-of select="@title" /></DATA></COL>

<COL><DATA><xsl:value-of select="@author" /></DATA></COL>

<COL><DATA><xsl:value-of select="@publisher" /></DATA></COL>

<COL><DATA><xsl:value-of select="." /></DATA></COL>

<COL><DATA><xsl:value-of select="@year" /></DATA></COL>

</ROW>

</xsl:for-each>

</RESULTSET>

</FMPXMLRESULT>

</xsl:template>

</xsl:stylesheet>

Edited April 3, 201213 yr by comment

I tried opening this file on my Windows XP computer, it did not work on that computer either. I've tried unblocking the file, downloading it from IE and Firefox, and turning off my antivirus. None of these actions have worked. In the original file, or when creating the zip did you ever use/enter a password? Otherwise maybe you could elaborate on instructions on how to extract data like title, author, subject, etc from online library catalogs (like Worldcat or Library of Congress).

Download 7-Zip - Download.com for windows.

I had the same problems with a file Comment did for me an his Mac. The Windows unzipper just doesn't like them .....