我需要将Zotero数据库中的项目获取到FileMaker Pro中。最明显的方法是从Zotero导出到xml,将该xml转换为FMPXMLRESULT xml格式,然后导入到FileMaker Pro中。
我是一个处理xml格式翻译的新手。
有没有人有xslt可以做到这一点,或者为我提供一些针对这两种xml格式的建议(而不仅仅是一般的xslt/xml引用)?
Zotero xml输出采用美国国会图书馆MODS格式:http://www.loc.gov/standards/mods/.
FileMaker Pro FMPXMLRESULT xml格式如下所述:http://www.filemaker.com/help/html/import_export.16.30.html.
以下是Zotero MODS导出的示例。(很抱歉,在这篇文章中,复制文件以形成代码块时丢失了一些缩进。以下是实际文件的Dropbox链接:https://www.dropbox.com/s/otrwr7xk0uwmff7/From_Zotero_MODS.xml)
<?xml version="1.0"?>
<modsCollection xsi:schemaLocation="http://www.loc.gov/mods/v3
http://www.loc.gov/standards/mods/v3/mods-3-2.xsd" xmlns="http://www.loc.gov/mods/v3"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<mods>
<titleInfo>
<title>Roberto Giobbi's Card college. Volume 1</title>
</titleInfo>
<typeOfResource>text</typeOfResource>
<genre authority="local">book</genre>
<genre authority="marcgt">book</genre>
<name type="personal">
<namePart type="family">Giobbi</namePart>
<namePart type="given">Roberto</namePart>
<role>
<roleTerm type="code" authority="marcrelator">aut</roleTerm>
</role>
</name>
<originInfo>
<place>
<placeTerm type="text">Seattle, Wash.</placeTerm>
</place>
<publisher>Hermetic Press</publisher>
<copyrightDate>1996</copyrightDate>
<issuance>monographic</issuance>
</originInfo>
<identifier type="isbn">0945296185</identifier>
<subject>
<topic>Card tricks</topic>
</subject>
<note>External Resources: Cite This Item Search for versions with same title and author
| Advanced options ...
Uniform Title: Grosse kartenschule. Band 1. English
Edition: Rev. 2nd ed. ; English language ed.
Language: English
Note(s): Includes bibliographical references (p. [245]-247) and index.
Other Titles: Card college
Responsibility: illustrated by Barbara Giobbi-Ebnöther ; translated from the German by
Richard Hatch.
Vendor Info: Baker & Taylor YBP Library Services (BKTY YANK) 32.00 Status:
active Note: B&T Title: Card College
Entry: 19960709
Update: 20091103
Provider: OCLC</note>
</mods>
<mods>
<titleInfo>
<title>Book of magic.</title>
</titleInfo>
<typeOfResource>text</typeOfResource>
<genre authority="local">book</genre>
<genre authority="marcgt">book</genre>
<name type="personal">
<namePart type="family">Warlock</namePart>
<namePart type="given">Peter</namePart>
<role>
<roleTerm type="code" authority="marcrelator">aut</roleTerm>
</role>
</name>
<originInfo>
<publisher>London New York, Arco</publisher>
<copyrightDate>1956</copyrightDate>
<issuance>monographic</issuance>
</originInfo>
<subject>
<topic>Magic tricks</topic>
</subject>
<note>External Resources: Cite This Item Search for versions with same title and author
| Advanced options ...
Edition: [1st ed.]
Language: English
Class Descriptors: LC: GV1547; Dewey: 793.8
Entry: 19750729
Update: 20120116
Provider: OCLC</note>
</mods>
<mods>
<titleInfo>
<title>The amateur magician's handbook,</title>
</titleInfo>
<typeOfResource>text</typeOfResource>
<genre authority="local">book</genre>
<genre authority="marcgt">book</genre>
<name type="personal">
<namePart type="family">Hay, Henry</namePart>
<namePart type="given"/>
<role>
<roleTerm type="code" authority="marcrelator">aut</roleTerm>
</role>
</name>
<name type="personal">
<namePart type="family">Mussey</namePart>
<namePart type="given">June Barrows</namePart>
<role>
<roleTerm type="code" authority="marcrelator">aut</roleTerm>
</role>
</name>
<originInfo>
<publisher>New York, Crowell</publisher>
<copyrightDate>1972</copyrightDate>
<issuance>monographic</issuance>
</originInfo>
<identifier type="isbn">0690057113</identifier>
<subject>
<topic>Magic tricks</topic>
</subject>
<note>External Resources: Cite This Item Search for versions with same title and author
| Advanced options ...
Edition: 3d ed., rev. and expanded.
Language: English
Note(s): Bibliography: p. 365-373.
Class Descriptors: LC: GV1547; Dewey: 793.8
Responsibility: by Henry Hay. Photos. by Audrey Alley.
Vendor Info: Baker and Taylor (BTCP)
Entry: 19720814
Update: 20080829
Provider: OCLC</note>
</mods>
</modsCollection>
所以它就像一个参考书目。好吧,这取决于你想如何在FileMaker中拥有它。基本的FileMaker XSLT是这样的:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:mod="http://www.loc.gov/mods/v3"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
<ERRORCODE>0</ERRORCODE>
<PRODUCT NAME="N/A" BUILD="N/A" VERSION="N/A"/>
<DATABASE NAME="N/A" LAYOUT="N/A" RECORDS="1"
DATEFORMAT="M/d/yyyy" TIMEFORMAT="h:mm:ss a"/>
<METADATA>
<!-- 1 -->
<FIELD EMPTYOK="YES" MAXREPEAT="1" TYPE="NUMBER"
NAME="Title" />
<!-- More field definitions -->
</METADATA>
<RESULTSET>
<xsl:for-each select="mod:modsCollection/mod:mods">
<ROW MODID="1" RECORDID="1">
<!-- 1. Title -->
<COL>
<DATA>
<xsl:value-of select="mod:titleInfo/mod:title" />
</DATA>
</COL>
<!-- More COL's in the same order as the fields -->
</ROW>
</xsl:for-each>
</RESULTSET>
</FMPXMLRESULT>
</xsl:template>
</xsl:stylesheet>
这个应该导入标题。template match="/"
类似于C中的main()
,它是(典型的)入口点。一旦我们到达那里,我们就输出结果XML的骨架。
一旦我们到达行,我们就使用XSLT指令循环遍历要成为表中记录的元素;在我们的案例中,这些是mod:modsCollection/mod:mods
,即参考书目条目,但它们可以是任何内容;例如,我们可以遍历所有名称(//mod:name
)。mod:
前缀是Zotero命名空间(http://www.loc.gov/mods/v3
)的快捷方式;在原始XML中,它被指定为默认名称空间,因此使用时没有前缀,但在XSLT中,我使用FileMaker XML名称空间作为默认名称空间(请参阅我如何在FMPXMLRESULT
中指定它),并定义一个前缀来引用Zotero元素。
循环表达式是XPath表达式;在谷歌上查找完整的规范。在这里,我使用了一个简单的表达式来获取所有mods
元素。当我浏览它们时,我会输出更多的FileMaker信纸(ROW
),然后为每个字段输出COL
和DATA
。现在,对于第一个字段的DATA
,我需要读取标题数据。由于我在mods
元素中,所以数据的路径是titleInfo/title
;为了得到值,我使用CCD_ 15元素。
要导入更多字段,请添加更多字段定义和COL
s。要导入其他内容(例如,不是条目,而是所有人),请在xsl:for-each
中使用不同的表达式。这应该让你开始:)