Import Endnote XML into FM

[Hammerton]

I have an endnote library that I would like to convert into a fm database. The obvious endnote options for exporting, like tab delimited, don't work because the data columns are f** up due to variable numbers of author, keywords, etc. in each record. It looks like the only option is to export as xml and use a xslt file to make it filemaker-friendly. I have read stuff on xslt and looked at examples but I have no idea where to begin. Can someone give me some ideas about how to get started? Thanks.

Edited August 19, 2009 by Guest

[comment]

An example of the XML source would be useful - along with a mapping of what needs to go where.

Note:

Please attach a zipped XML file - the forum software often distorts XML code within posts.

[Hammerton]

Thank you. Among my frustrations is that teh endnote xml export file doesn't have line breaks and Textwrangler can't figure out the proper indent indenting scheme. If the xml file has to look that way to be processed by the xslt file I might as well type the stuff in by hand. There are approximately 100 records. I included only 1.

Thanks for having a go at this.

SelfSeminar.zip

[comment]

You didn't say what do you want to import, into what tables/fields. Hopefully, you realize that you will need a matching relational structure in your Filemaker file to accommodate multiple authors, keywords, etc.

[Hammerton]

Sorry about the omission. I simply want to create a plain old fm database with one table, and fields for the author(s), year of publication, article title, journal name, volume number, and page numbers. I don't mind making the fm database with those fields and then importing. I had been trying to use the open the xml file approach.

[comment]

Here's an example that you could use as your starting point. It will import the record number, the year of publication, and a return-separated list of keywords.

EndNoteFlat.xsl.zip

[Hammerton]

Thank you so much for this. This is exactly what I needed to see which parts of these files are general things and which are specific to the xml file I am trying to import.

This was extraordinarily generous of you. I promise to pay the favor forward.

[Hammerton]

The file "comment" sent worked like a charm. I am now modifying and expanding. I think I get the scheme. One last mystery, what purpose does this serve

select="'
'"

within the authors loop?

Edited August 20, 2009 by Guest

[comment]

It's a symbol for carriage return - see:

http://en.wikipedia.org/wiki/Numeric_character_reference