Quote:
Originally Posted by erymaxuk
pdf articles drag and drop into Zotero collection, will automaticaly update metadata from pdf files with bibliographic accuracy. Occasionaly some pdf fails, simple open it in Zotero and click on doi URL, this wil open the article in browser, click on Zotero importer and the correct metadata will be downaloded into the collection. In the Zotero folder - in translators folder find csv.js, open it in any notepad++ and you can change setting for example I changed exportNotes to true, to export abstracts.
After all set, export it as csv (not bib), import it into calibre with Zotero importer. After I select all and create covers and tags. Zotero importer is an excellet plug-in, respect for its creator.
In regard of books (pdf, epub ets) is a diferrent story. Import them directly into calibre. The ISBN of books is the important book ID, for articles is the DOI importat ID, which you get easily updated in Zotero wit DOI plugin.
For me the way after is export books or articles from calibre in csv file which I load in excel, make some fine tunes like column formats to change dates to datem numbers to number etc. There is one problem with the filename path for pdf in calibre. It comes in format like this PDF:c:\books\..., I remove the PDF: or EPUB: part in excel before saving the loaded csv as excel file.
In case of different categories of medical books I created a simple VB macro scipt in excel and run it as bat file. I use mostly batch files for calibre on command line; import books into calibre, export as catalog in csv etc.
Excel file can be easily then imorted in MSSQL database in Visual Studio.
|
In regard of collecting only the citations, as I mention above, I download the DTD JATS xml files from any source like NLM, HINDAWI od MDPI normaly from their FTP sites. Those xml file need to be transormed using xslt in Saxon or other processors. I use Saxon HE 12 with a powershell script to collect thousands of xml files to transform in bib files. You can also transform in html, csv files. I load the bib files in Mendeley, update metadata and export thousands of bib files in one bib file. Import the bib files into Zotero, update doi and export as csv -> excel - >sql databse
I posted before screenshots of my finished forms created in visual studio in which I access my database with books, articles and citations. Also full journal collections.