Importing another database into Zotero
I'm not quite sure where to post this, so let me try it here. For a research project, we are currently crawling various official government websites into a database format containing the following fields: the URL, the title, the source (e.g. Brazilian Ministry of Foreign Affairs, the raw text, and the date of publication. Could anybody please advise whether (and if so - how) we could get that data into Zotero? This would be great for our bibliography, as well as for the textmining we want to do with these sites (through Papermachines). So: which database format should we then use, how should we name the fields for them to be compatible with Zotero, how do we import them, etc. Thanks much!
This page offers reasonable advice regarding file formats in the unAPI section:
https://www.zotero.org/support/dev/exposing_metadata
If I understand that correctly, the easiest format to construct from an existing database is probably bibtex along the lines described here:
https://forums.zotero.org/discussion/25120/importing-from-excel-to-zotero/#Item_10 It's a flat format that's not very sensitive to linebreaks and the like.
To find out correct field names, just construct one entry as you want it in Zotero, export as bibtex and use that as a template.
It doesn't appear to be related to the specs of the pc. E.g. the pc from which I'm doing this runs on x64 Windows 8 on a recent AMD 8-core @ 3.5 GHz with 8 gig of RAM and on a fast SSD drive - and it does NOT extract. Whereas my notebook, which is a x64 Windows 7 machine with an Intel i7 CPU @ 2.67 GHGz with 6 gig of RAM and also a fast SSD drive.
So if you have any suggestions of what we could play with in order to fix this, we'd be very grateful