Sitemap | EndNote
Showing results for 
Search instead for 
Do you mean 
Reply
Visitor
Posts: 1
Registered: ‎04-07-2018
0

need to export records from EndNote in a format that can be imported to SQL database

I have searchd the forums but cannot find an answer. I have an EndNote database with over 5000 records. I am looking to export those records into some format that can be easily imported into a MySQL database on my website. Then I would have my web development people create an interface using PHP scripting that would allow my database to be searched according to the various fields, and return a list of all references that match the search query. Does anyone have any thoughts about how I might go about this?

Thank you in advance.

Richard

Mentor
Posts: 2,087
Registered: ‎09-30-2009
0

Re: need to export records from EndNote in a format that can be imported to SQL database

Records from an Endnote library can be exported in a variety of file formats including: XML, and text based flat files such as tab delimited or other delimiter such as .csv (with some modification of the Endnote output style file). If I recall correctly, these file formats can be imported into MySQL. However, note that Endnote’s XML format is proprietary and might not be in a form that MySQL can successfully import. So you need to test the files.

 

Refer to the Help menu in the toolbar for information and instructions on exporting Endnote references in a variety of file formats. In the Search box type “import” in the search results click on “About Direct Export and Import Formats”.

Highlighted
New User
Posts: 1
Registered: ‎04-14-2018
0

Re: need to export records from EndNote in a format that can be imported to SQL database

This does seem to happen too often with Endnote in  authorityjob. Are Microsoft so unhelpful that they don't give addon providers any time to anticipate the changes? I don't seem to get this happening with other software, but this is my only outside add-on with Word.
https://community.endnote.com/t5/EndNote-How-To/need-to-export-records-from-EndNote-in-a-format-that-can-be/m-p/149452
community.endnote.com
crawl=CC-MAIN-2019-35
134961
application/http; msgtype=response
sha1:LM52S55LU4NDKBUX5BEPGOSQU6KAHTDH
<urn:uuid:a6c8ac12-a417-4801-ba3b-22fd8f8d434e>
2019-08-18T08:44:12Z
208.74.204.83
text/html
sha1:AUUC4T5BREQVEQ2NP2QC6GM7GCK7AUEO
<urn:uuid:6788d521-10fa-4616-90d9-1cb0359d2d67>
https://community.endnote.com/t5/EndNote-How-To/need-to-export-records-from-EndNote-in-a-format-that-can-be/m-p/149452
response
<urn:uuid:21d347a8-d347-4d05-b2eb-643bbad41bc4>
isPartOf: CC-MAIN-2019-35
publisher: Common Crawl
description: Wide crawl of the web for August 2019
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-32.ec2.internal
software: Apache Nutch 1.15 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.1-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/