Quote:
Originally Posted by erymaxuk
If you are collecting academic articles, you should be aware of the new standard of publishing articles in xml formate. The NLM and PubMed has millions of articles in DTD JATS xml formate. They have to be transformed with xslt processor such as Saxon ( I use it). The xml file can be transformed in bib, html or other format. I have many articles and books using mssql database. Calibre is an excellent database for eboks, pdf and other formats but you cannot import JATS xml files into calibre. My process flow is following:
download DTD xml files from NLM ftp sites daily. Transform them with Saxon to bib files using jatstobib.xslt. Import all (ususaly 15000) into Mendeley which will update the metadata. Export them as one bib file which I import in Zotero. From there export as csv file and load in excel. The excel file can be easily imported into mssql database and process with Visual studio. (Window Forms in C#)
I also download books and articles as pdf. Import them into Zotero and update metadata, export as csv file, import with zotero importer plugin into calibre. Create in calibre searchable tags and covers. Creating catalog using the command line as csv and load it in excel (same way to mssql).
|
If you use Zotero and/or RIS files and/or (soon) BIB files, see the attached image.
DaltonST