Export Extensions

Export Address data in the VCard format

In this article

    Export Address data in the VCard format

    Export Address data in the VCard format

    Export
    Universal

    This extension exports the address data from the Contacts table in a vCard (.vcf file) that can the be imported in Microsoft Outlook, Mac OS Contacts, Mozilla Thunderbird.

    Using the extension to export vCards

    This extension is compatible only with the following file types:

    • Address book
    • Library and collections
    • Estimates and Invoices

    To generate and export vCards, the extension uses data from the Contacts table in the file. Specifically, it reads the following columns:

    • First Name
    • Family Name
    • Street
    • Zip
    • Locality
    • Country Code
    • Country
    • Mobile Phone
    • Home Phone
    • Email Home

    Ensure that your file is of a supported type and that the required columns are filled in correctly to guarantee a successful export.

    Install the extension

    To install the extension:

    • Open Banana Accounting Plus.
    • Menu Extensions > Manage Extensions.
    • In the search field enter Export Address data in the VCard format.
    • From the extensions list select Export Address data in the VCard format.
    • Select the extension and click Install.
    • Click Close to close the window.

    Export address data in vCard format

    To export the vCard with the addresses data:

    1. Open the Banana file.
    2. From the Extensions menu select Export Address data in the VCard format.
    3. Enter the contact ID. You can export a vCard containing all contacts or just specific ones.
    4. Save the vCard.

    The generated .vcf file contains a structure like the following one:

    BEGIN:VCARD
    VERSION:3.0
    N:Pallino;Pinco
    FN:Pinco Pallino
    TEL;type=CELL:1234567890
    TEL;type=HOME:1234567890
    ADR;TYPE=HOME:;;Via Trevano 7a;Lugano;;6900;
    LABEL;TYPE=HOME:Via Trevano 7a Lugano,6900
    REV:2017-02-07T14:07:54.694Z
    END:VCARD

     

    Export vCard for unsupported file types

    If you're using a file type that is not supported by this extension (e.g., a double-entry accounting file, an income/expense accounting file, etc.), you can still export the data for members, customers and suppliers by following these steps:

    • Copy the contact information from your current accounting file.
    • Create a new file of type Address book and paste the copied data into the appropriate columns.
    • Run the extension to export the vCards in the new file.

     

    Journal Export (Banana 9)

    In this article

      Journal Export (Banana 9)

      Journal Export (Banana 9)

      Productivity
      Universal

      Export the Journal table of Banana and use it in Excel with the Pivot Tables to build your own reports.

      How to use it

      In order to use this app you have to:

      • Install the app
        • Menu Apps → Manage Apps...
        • Select Universal as country.
        • Select english as language.
        • Select Online → Productivity.
        • From the apps list select Journal Export.
        • Click Install to install the app.
        • Click Close to close the window.
      • Run the app
        • Menu Apps → Journal Export.
      • Export the content
        • From the top bar select Copy to Clipboard.
      • Copy into Excel
        • Open Excel and paste the copied content.

      journal export

      Journal Export (Banana+)

      In this article

        Journal Export (Banana+)

        Journal Export (Banana+)

        Productivity
        Universal

        The extensions creates a report with the Banana Accounting Journal table of current and budget transactions. Data of the journal can be copied and used in Excel with the Pivot Tables to build your own reports.

        Prerequisites

        To use this extension you must download and install Banana Accounting Plus.

        Install the extension

        To install the extension:

        • Open Banana Accounting Plus.
        • Menu Extensions > Manage Extensions
        • Select Universal as country.
        • Select english as language.
        • Select Online > Productivity.
        • From the extensions list select Journal Export (Banana+).
        • Click Install to install the extension.
        • Click Close to close the window.

        Create the journal report

        To creare and export the journal:

        1. Open an accounting file.
        2. From the Extensions menu select the Journal Export (Banana+).
        3. In Settings dialogue choose the journal columns you want to display, then click OK.
        4. From the Print Preview of the report select the Copy to Clipboard command in the top bar.
        5. Open Excel and paste the copied content. Columns headers and data will be copied in Excel. From there you can use it to create your own reports.

        Settings dialogue

        Run the extension from the menu Extensions > Journal Export (Banana+).

        The extension Settings dialogue will open. From here you can choose the journal columns you want to include in the report.

         

        You can find more information about the journal columns in the Journal’s API documentation.

        Print example

         

        Time Sheet Export

        In this article

          Time Sheet Export

          Time Sheet Export

          Productivity
          Universal

          This extension exports the Time Sheet table of Banana. Exported data can be used in Excel with the Pivot Tables to build your own reports.

          Prerequisites

          Install the extension

          To install the extension:

          • Open Banana Accounting Plus.
          • MenuExtensions > Manage Extensions.
          • Select Universal as country.
          • Select english as language.
          • Select Online > Productivity.
          • From the extensions list select Time Sheet Export.
          • Click Install.
          • Click Close to close the window.

          Export the time sheet columns

          To export the columns of the time sheet table:

          • Open a time sheet file type.
          • From the Extensions menu select the Time Sheet Export.
          • In Settings dialogue choose the time sheet columns you want to export, then click OK.
          • From the Print Preview of the generated report select the Copy to Clipboard command in the top bar.
          • Open Excel and paste the copied content. Columns headers and data will be copied in Excel. From there you can use it to create your own reports.

           

          timesheet export