Export Extensions

Export Address data in the VCard format

Export Address data in the VCard format

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.

 

ivan
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/General/master/SampleApps/Utilities/Library/vcard.js
URL Development
https://github.com/BananaAccounting/General/tree/master/SampleApps/Utilities/Library
Short Description
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.
Country
Universal
Publisher
Banana.ch
Extension type
Export
Help ID
ch.banana.app.vcardfromaddress
Release Date Stable

Journal Export (Banana 9)

Journal Export (Banana 9)

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

ivan
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/General/master/SampleApps/ch.banana.uni.app.journalexport.js
Short Description
Export the Journal table of Banana and use it in Excel with the Pivot Tables to build your own reports.
Country
Universal
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.uni.app.journalexport.js

Journal Export (Banana+)

Journal Export (Banana+)

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

 

ivan
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/General/master/SampleApps/journalexportplus/ch.banana.uni.app.journalexportplus.js
URL Development
https://github.com/BananaAccounting/General/tree/master/SampleApps/journalexportplus
Short Description
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.
Country
Universal
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.uni.app.journalexportplus
Release Date Stable

Time Sheet Export

Time Sheet Export

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

ivan
URL Stable release
https://raw.githubusercontent.com/BananaAccounting/General/master/SampleApps/ch.banana.uni.app.timesheetexport.js
URL Development
https://github.com/BananaAccounting/General/tree/master/SampleApps
Short Description
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.
Country
Universal
Publisher
Banana.ch
Extension type
Productivity
Help ID
ch.banana.uni.app.timesheetexport
Title for application - displayed in "manage apps"
Time Sheet Export