I have here 150 Patentreferences in an Endnote 7.3 DB with the Patentnumbers in the Patentnumber field. (is the isbn field in the refs db) I know it is Mysql compatible. But how can I now import the 150 PDFs-Patents automatically and linked to the references? Is there a good way? My PDF-Filenames are like the Patentnumbers. f.e US123456A1.pdf
Thanks for help
Walter
I tried following:
I updated the field reserved3 ( where corresponding key refs_id matches to the id in refs ) to my filename like
internal-pdf://3658655952/y1775.pdf
But that might be not enough. there is still a relationship in refs_ext with reserved2.
If no file is attached there is the value of 1430405627
If I attach a file the value change. WHat meaning has this value?
If I change that value at a reference to something else I get the error in the Deskop IDE of Endnote
The following file could not be opened. This may occur for a number of reasons including, but not limited to: the file is corrupt or the relative link was deleted.
File C:\Users\myuser\mYSQL\3Pat_aus_Scifinder-Saved.Data\PDF\3658655952\y1775.pdf
I have chatted with Endnote support, but they say “they do not support such internal things!”, Ugly!
Can anyone here help me with relevant infos and advices?
Thanks
Moreover I figured out that the NAME of the DIRECTORY in the PDF Folder, where the PDFs are stored must be not a random name of digits. which alorithm are behind to get the PDF-Folder name?
ANy idears?
thanks
I have found a soluion.
I write with gnostice tool PDFToolkit VLC with Delphi to each PDF a pseudo doi (it stands in the subject line) and in the refs mysql database also this pseudo doi by my delphi (MyDAC MYSQL connection) programm.
No I can import the hole folder with the Patents
(added with f.e doi:10.1186/s12986-015-0010-9-’+<patentnummer>;
in my unit.pas: gtPDFDocument1.DocInfo.subject := ‘2015, :. doi:10.1186/s12986-015-0010-9-’+<patentnummer>;
)
to the endnote database via the Endnote IDE in a normal way. It works fine.
TReuters should consider to import Patents in a more easier way. F.e by identifieing the filename als pat nummber. But as this is not done till now, my above advice could be useful.
1 Like