Importing Data in existing references

NoemiV
Hello !
I am quite new to Zotero, and have to link an existing library with entries in a FileMaker Database.
I prepared a concordance table on Excel with the Zotero Keys and the FileMaker Keys and I can easily import it into Filemaker but I would like the concordance to be also present in Zotero. I thought I would use the field "extra" to store the FileMaker Key in the Zotero references, but I don't know how I can import it into the existing references. There are 1600 references in the library, so copy paste them is not really an option ...

Thanks in advance !
  • bwiernik
    Zotero can import a variety of structured metadata formats, so if you can export from your FileMaker Database in one of those formats, Zotero could import it: https://www.zotero.org/support/kb/importing_standardized_formats

    Otherwise, if all of your items have DOIs, you could add them to Zotero using the Add By Identifier (Magic Wand) tool.
  • NoemiV
    Hey ! Thanks for your answers. The thing is, I don't want to create new entries in my Zotero Library. What I did is export the Data from Zotero to match them with data from FileMaker and I would like to import just the Filemaker Key into the existing Zotero entries, so that the Zotero Key stays the same ...

  • dstillman
    edited June 9, 2020
    You'd need to export a text file with the Zotero key and the FileMaker key pairs and write a script to process it and update items, either from Tools → Developer → Run JavaScript (Zotero.File.getContents(path)) or using the web API (e.g., with pyzotero).
  • NoemiV
    Thank you very much !
    I have since tried to create a small script, but I am not familiar with javascript and therefore I am a little bit stuck ...

    I succeeded with getting my .txt file into the "Run Java script". Now, what I need to do is the following :
    I have in the first column the Zotero key, in the second the ID from FileMaker and in the third the title abbreviation that I also need to import. The two selected fields are Extra for the ID and Rights for the abbreviation. The columns in the .txt data have already that name.
    This is where I am stuck ... How can I call the content of the .txt data and copy it into each entry of the library ?

    It would help me a lot ... :)

This is an old discussion that has not been active in a long time. Before commenting here, you should strongly consider starting a new discussion instead. If you think the content of this discussion is still relevant, you can link to it from your new discussion.

Sign In or Register to comment.