You are here

故障排除

The first time the Banana Add-In for Excel connects to Banana Accounting it is necessary to accept the connections. Once it is accepted Excel can further retrieve data from Banana Accounting.

On Apple Mac, the system correctly accept the connection and the Add-in works just as expected.

On Windows the system does not always works as expected:

  1. Some time the dialogs to accept the connection are not displayed.
  2. The acceptance of the connection is not saved. 

We have reported the bug to Microsoft. We are waiting for feedbacks.

In the mean time we do publish here a possible temporary fix. It require some technical knowledge and administrative permission.
We hope that Microsoft will fix the problem so that the Banana Add-in will be able to works under Windows the same as under Mac.

Troubleshooting for Windows

  1. Download and install the latest version of Banana Accounting 9 for Windows (version 9.0.2 or more recent).
  2. Start Banana Accounting 9 web servers
    • Open Banana Accounting 9
    • Click on menu Tools -> Program Options
    • Select the tab Interface
    • Check the options Start Web Server and Start Web Server with ssl


       
  3. Install Banana.ch certificates:
    • Open the following Banana folder on your pc: C:\Program Files\Banana90\Ssl


       
    • Double click on the file "win_install_certificates"


       
    • Click Yes: this will install the Banana.ch certificates on your computer.


       
    • Press Windows key and type certificates in the search field


       
    • In the search results, select Manage user certificates


       
    • From the list on the left side, select the Trusted Root Certification Authorities
    • Right-click on the Certificates directory on the right side, then slelect All Tasks > Import…


       
    • Select Current user and click Next


       
    • Click Browse


       
    • Go to the C:\Program Files\Banana90\Ssl directory, select the banana.rootCA.pem file and click Open (if you don’t see anything, on the bottom right select “All Files”)


       
    • Click Next


       
    • Click Next


       
    • Click Finish


       
    • Click Yes on the security warning dialog window
    • Click Ok


       
  4. Edit the hosts file:
    • Press the Windows key and type Notepad in the search field


       
    • In the search results, right-click on Notepad and select Run as administrator


       
    • Click Yes


       
    • From Notepad, click on File > open


       
    • Select the hosts file located in C:\Windows\System32\drivers\etc\ (if you don’t see anything, on the bottom right select “All Files”)


       
    • Click on the Open button to open the file
    • At the end of the file insert the following two lines:


      127.0.0.1 banana.localhost
      ::1 banana.localhost

       

      Your file may be a little different. Do not delete rows, just add these two lines at the end.

    • Click File > Save to save your changes.
    • Close the file.
  5. Change the server URL on the Add-in settings
    • Start Excel and Banana Accounting Add-in.
    • Click on the settings tab of the Add-in.
    • Enter the following server URL: https://banana.localhost:8089


       
    • Click OK to confirm.
    • Go on the Setup tab of the add-in and refresh the files list.
Each time Excel Add-in is launched it is necessary to change the server url.

 

 

Troubleshooting for Mac

  1. Download and install the latest version of Banana Accounting 9 for Mac.
  2. Start Banana Accounting 9 web servers
    • Open Banana Accounting 9
    • Click on menu Tools -> Program Options
    • Select the tab Interface
    • Check the options Start Web Server and Start Web Server with ssl
  3. Open Safari and insert https://127.0.0.1:8089
  4. When the dialog appears, insert your system password and click on always button


     
  5. Start Excel 2016 and load the Add-in
  6. Click on the refresh file list button
  7. If a dialog window appears, click on always button on the left

 

 

 

Share this article: Twitter | Facebook | Email


请帮助我们改进在线文档。

我们欢迎关于如何改进此页面的反馈信息。
请告诉我们什么主题需要更好的解释或者如何更好的阐明主题。