Install and Login to Integration App

1) Open the Integration App. You can download the Integration app from here -https://www.gorillaexpense.info/install/publish.htm

2) Pre-requisite to integration app is .NET framework and access database engine to import excel. It can be downloaded from here- https://www.gorillaexpense.info/install/accessdatabaseengine.exe

3) Login user name and password will be same as the one used to log into gorilla expense. Select any account system radio button (For example GP2013)

Login URL will be https://www.gorillaexpense.info/gorillapro/service

 


     

Import Customers

Check the customers excel template has all the required data in the right format. The template can be downloaded from Customer Data Import Template

      1) Once logged in, go to File - > Import  Master Data -> Import Customers

   


      2) Select settings menu and browse for the file to be imported from the local drive using the Browse option   

       

   

      3) Select Done when the file is selected

      4)  Select Reload :This should populate all the data from the provided excel sheet on the Gorilla Expense Integration App Grid (as shown below). The user can then select all the records to be imported by choosing the “Select All” option or can manually select the desired record(s) to be imported 

 

 

 

 

      5) After selecting the records to be imported User selects the “Import Customers” button on successful import, the records turn green. In case of unsuccessful import, the record turns red and on hovering the unsuccessful record the reason for failure is displayed. The reason for failure can also be found by choosing the  “View log “ option  

 

   

 

      6) After successfully importing Customers, user should login to Gorilla Expense Web Application as an Admin and Go to Project Masters -> Customers and check if the imported Customer is displayed