Endnote exporting and importing?
Endnote exporting and importing?
I love delicious library and its very tangible, tactile sort of interface. It's superb for researchers like me with a huge library. But most of us in research use professional bibliography and database search tools like Endnote, which lacks barcode or ISBN support, and does not link to amazon. Do you have plans to incorporate Endnote export/import support? This would be a godsend to get my whole library in one place and be able to pull out certain books for my research collection for further detailing, cataloguing, and bibliography export based on my templates. Also expanding your scope beyond Amazon to the library databases worldwide could be a tremendous improvement.
8 people have
this question +1
this question +1
Expanding beyond Amazon is definitely in the books, but won't be implemented until Version 3, which is realistically a year or two out.
As far as Endnote is concerned, it's something we'll consider, but it's going to have to take a back seat to the iPhone apps and some much-requested changes to DL2. After that, who knows what we might be able to do.
Does Endnote support CSV import/export?
Thanks Terry-- glad to know that you are building on the database importing options for DL. There's enormous potential for your product with people who need to plug in bibliographic data on the fly while also wanting to keep track of all their books in vast collections that might be spread between home and office, school and other places-- or also books that they "have" in their minds or their written work, but which really belong to the library, etc. Sure that may not be the need of the average consumer, but still it's useful to have as much cross-application compatibility as possible.
EndnoteX, the latest version I have, does not seem to support CSV exporting. However, it exports in either text or XML formats. In fact this is like iTunes, which uses XML. Can DL handle XML imports? If so, it could theoretically link with Endnote very easily. When I try to export just "text" from Endnote and then import it as "text" in DL, the information is neither comma nor period separated, the columns are all whacked out, and it ends up only importing one file with no information in it.
All it may require is a minor tweak, so hopefully you can implement this soon!
We support export to XML but not import from XML. Text is a little tricky if it isn't organized in some sort of standardized format. I'll look at it, but unformatted text and XML aren't a lot to build on.
You can already export to a Bibliography format in DL2. Just select the items or shelves you want bibliographies for, select File->Export->To another application. You'll get a new panel will all our export options, so select Bibliography and you'll have the option of choosing between MLA, Chicago, CBE, APA, AMA, and Turabian formats.
I'm not sure exactly how Endnote works, but this might get you by in the mean time.
It shouldn't be too hard to make an xslt file to export EndNote xml or something like RIS that EndNote imports. In the short term, you can export from DL as BibTex and then use this free web-based tool to convert to EndNote XML: http://dret.net/bibconvert/ . Or, if you use Zotero (www.zotero.com) it will import BibTex and export a couple of formats that EndNote can use. I use EndNote all the time, but find Zotero quite handy for quicker grabbing of citations off the web...
Ugly fix for those who have Microsoft Word and Excel. This cannot be the easiest way, but this is what I figured out. Though some of the above solutions may work for people, I didn't understand them (I don't know how XML works), so this may help others.
In delicious 2.0:
File > Export > Export to another application
There will five options on the top. Select "Excel"
(The five options are: XML, Bibliography, BibTex(Bookends), Delimited Text, and Excel. -- I don't know how to use XML. It is pretty easy to import files into Endnote using "Delimited Text". HOWEVER, I first export into "Excel" not "Delimited Text", because excel allows you get rid of some formatting issues. For example, it exporting immediately to delimited text puts quote marks around multiple authors, which is annoying. This can be easily dealt with if you export it to excel first, and then follow the instructions below.)
Under the excel menu in delicious library, on the left:
Choose what you want to export (Entire Library, or Selected Shelved, or Selected Items)
For "separate muliple values with" I just left it at "comma" (that was the default)
On the right side: "Export Fields"
Select all those you want to use:
I select: Creater, Edition, I.S.B.N., No. of Pages, Release Date, Publisher / Label, Title.
With those boxes selected, I click on the "export" button.
Save the file. Note where you saved it. The extension used by delicious is ".slk" (not sure why)
Now open that file in microsoft excel.
IN EXCEL: CHANGING FIELD HEADERS
Your data should appear in the microsoft excel document you saved when exported from delicious.
You will see that the first row consists of the export fields you selected.
Each additional row is a book you exported.
To ready this for endnote, you need to change the name of the field headings. Change the field headers in excel:
Creater => Author
Edition => [no change]
I.S.B.N. => ISBN
No. of Pages => Number of Pages
Release Date => Year
Publisher / Label => Publisher
Title => [no change]
(You just changed the headers so they match the template used by "Book" in endnote. If you export additional fields besides the ones I used, just use the name of the field as it appears in the "Book" citation format in endnote. There is no need to rearrange the headings so they are ordered in a certain way. Endnote will take care of the sequence.)
FIXING YEAR FORMAT IN EXCEL (optional)
OK, next you will notice that "Year" (formerly "Release Date") also includes the month and the date. In my year column I get something like "2005-03-02"
You just want the year for books, so here's my fix:
In excel, with your document open:
Edit Menu> Replace
In the "find what" box, put in:
The "Replace with" box should be empty-- that's the default, but if it is not empty, go to it and delete everything in it. (do not have any spaces in it)
I just go to "replace all"
(The asterisks are wildcards. This will eliminate all text that has a dash, followed by any two characters, followed by a dash, followed by another two characters. You can find and replace each one if you like. You may prefer to find and replace each one individually, if you think you have similar text strings not in the date column.)
You should now have just the years, without the months and days.
ADDING CITY WHERE PUBLISHED IN EXCEL (optional):
Unfortunately, I don't see how to export the CITY of publication from delicious. Delicious has the country, but not the CITY of publication (please let me know if I'm wrong!).
In the excel document, on the first row, in the first available column to the right, you should enter "City". For each book enter the city of publication.
You can always add the city manually later for each book in endnote. Alternatively, you may prefer to enter it here. That makes sense, given that Harvard University Press books are all published (I believe) in Cambridge, Mass.; Princeton University Press books are all published in Princeton.
COPYING TEXT FROM EXCEL INTO WORD (back to essentials)
Select all the rows and columns that actually have data in them. Be sure to select the text in the first row (which should be the endnote field headers). Copy the data (Edit > Copy)
Now go to Microsoft Word, open a new document.
Edit Menu > Paste Special > "Unformatted Text"
(The reason I Microsoft Word rather than other text editors is because I can use the "paste special" command in this way.)
At this point, your data should appear, with tabs between each data point. Sometimes it appears as if just a space is between each word. However, that is apparently just a short tab. Keep in mind there may be empty fields in some cases.
IMPORTANT: SETTING DEFAULT PUBLICATION:
Next, we need to make it so endnote will be able to tell the default type of citation we are dealing with.
At the top of the word document, before the first letter of text, type in "*Book" (without the quotes), and then press enter. So "*Book" should make up your entire first line of text, without any tabs or spacing afterward.
The above is an important step, and it should be done in word, not in excel (otherwise you get extra tabs when you copy from excel to word, and this screws things up.).
For an explanation of this step, see page 7 of:
Ok, now save the document as text only (.txt). [NOT as text only with line breaks, etc.)
IMPORTING INTO ENDNOTE:
Open the library you want to import into.
File Menu > Import > Tab Delimited [Under "import options"]
Select the ".txt" file you saved, and click ok.
Your references should appear!
If they do not a few things may be wrong:
First, make sure you saved the document as a text file (without line breaks).
Second, make sure you have the "*Book" (without quotes) as the only thing in the top line. There should not be any spaces or tabs after this.
Third, make sure each of the headers matches EXACTLY how they appears in the Book citation format in endnote.
Those were the most common mistakes I found.
Though iphone apps are clearly a priority delicious monster will be even more effective and a necessity if it can successfully export to endnote.
This would mean delicious monster software would become a standardised tool used by academics, researchers and every single college student on the planet if it enabled them to streamline the laborious task of inputting reams of book information into pages, word or endnote.
The other option would be for delicious software to support harvard referencing export into a pages/word file.
Either way this would mean every college student in the world would actively seek our delicious. Buy the software. Then buy the app. Seems quite good for a small idea that's currently on the backseat.
I have to agree with Tom here. Without knowing too much about the practicalities of software development, I do know that making the changes that would allow DL to be used as a proper bibliographic tool would immediately open up a quite large and continually self-repleneshing market in the academic world. This would require adding an export feature that will directly communicate with bibliographic tools such as Endnote, and also the addition of a city of publication field in the details section. In fact, not that I encourage plagiarism (though I don't know how it works in the software world) it might be worth canvassing a couple of these bibliographic programs to see what data fields they offer instead of relying on what fields Amazon gives you - wouldn't be too hard to add them I imagine, even if you can't get them to auto-fill from Amazon (I could live with adding in the city myself for the time being).
I've spoken with several other academics about this, and also a librarian (my sister), all are surprised that there is no city of publication data in DL, as it is such standard practice.
This reply was removed on 2010-07-09.
see the change log
Last comment on this was 9 months ago - has progress been made by Delicious Monster on this front? I live and breathe EndNote in my writing and research. I have Delicious Library, but am reluctant to recommend it to any of my associates because of the limitation re: export to EndNote and other essential bibliographic information.
I often teach a class to graduate students on research methods, and would love to be able to plug Delicious Library, but at this point I can't do so. Any progress on this front?
OK here is something...
In DL3 there is an export option:
Use to other application
in the drop down requester select BibTex (bookends)
It will automatically open Bookends and you will have your bibliography...
I am not sure if endnote will import BibTex, but Bookends works.
So you have to decide if the bibliographic needs must use endnote or if another
bibliographic software is useful..
To that end also must you use MS Word? if not there is a wonderful Word processor that works seamlessly with Bookends and it is called Mellel (also on the Mac App store). I used Mellel years ago, with Bookends. Now the one great thing about Mellel is the license is for life...