Hammerton Posted August 19, 2009 Share Posted August 19, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
comment Posted August 19, 2009 Share Posted August 19, 2009 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. Link to comment Share on other sites More sharing options...
Hammerton Posted August 19, 2009 Author Share Posted August 19, 2009 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 Link to comment Share on other sites More sharing options...
comment Posted August 19, 2009 Share Posted August 19, 2009 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. Link to comment Share on other sites More sharing options...
Hammerton Posted August 20, 2009 Author Share Posted August 20, 2009 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. Link to comment Share on other sites More sharing options...
comment Posted August 20, 2009 Share Posted August 20, 2009 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 Link to comment Share on other sites More sharing options...
Hammerton Posted August 20, 2009 Author Share Posted August 20, 2009 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. Link to comment Share on other sites More sharing options...
Hammerton Posted August 20, 2009 Author Share Posted August 20, 2009 (edited) 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 Link to comment Share on other sites More sharing options...
comment Posted August 20, 2009 Share Posted August 20, 2009 It's a symbol for carriage return - see: http://en.wikipedia.org/wiki/Numeric_character_reference Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5376 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now