How to export from Zotero to Excel

Some days ago I needed to export a set of references from Zotero to a Microsoft Excel file. I tried to export and import them in Excel using different formats, but none of them was good enough. For example, a single article was imported into several rows, one per author, and that’s not the result that I wanted. Finally I found out the following mechanism although it requires several steps.

  1. Export the database from Zotero using the BibTeX format.Export Zotero
  2. Import it in JabRef as a new database. JabRef is another source bibliography reference manager that uses BibTeX as its native file format. You can download the .jar file from here, so you don’t need to install it.

    Import JabRef

  3. Export the database from JabRef using the OpenOffice Calc format. You can export it using the MS Office XML format, but as I mentioned before, each article will be in more than one row.

    Export JabRef

  4. Open the OpenOffice Calc file and save it as a Microsoft Excel file.


  5. Finally, we can open the Excel file and format the results as we like.

    Excel file

Read More

Test project setup in Android Studio

Android Studio supports testing for activities natively. Let’s see how you can set up your test environment:

  1. Open Android Studio and the Android project under test. You can create a blank project with a main activity and layout.
  2. Create the package where the tests will be saved. You can create the test package in the source folder: /src/main/java/<your_package>.tests.
  3. Create the running configuration for testing. Open the top menu Run and execute the Edit Configurations option. On the left side of the window, the list of running configurations is shown. You should at least have the running configuration for your Android Application. Click on the add button and select the Android Tests type:
    Android Tests Configuration
  4. Configure the package for testing. Select the recently created running configuration so you can edit it on the right side of the window. Do the following modifications:
    1. Write a name, for example My Tests.
    2. Select your app in the Module list.
    3. Check the All in package option to establish the whole package for testing.
    4. Select your test package in the Package input text.
    5. Check the Show chooser dialog option so later you can select the emulator or a real device connected via USB. If you prefer using always the USB device, change this option, as you like.
    6. Click on the OK button to save the changes and close the window.

    Test configuration

  5. Verify that the running configuration is available in the toolbar of Android Studio as is shown in the following screenshot.
    Configuration check

Read More