SuiteCRM BI-Directional link to Xero
Automated BI-DIRECTIONAL synch between SuiteCRM and Xero, synch most recent record. Accounts, Contacts, Invoice and Products, connect and forget. Synch based on your criteria. This module also gives you the ability to manually update Accounts/Contacts/Invoice records to/from Xero
#3409 - Installation Advise - SQL Import + internal SuiteCRM URL
Item 1 - Running repairSugarDB.sql in Mariadb
- Installed the Plugin & downloaded the "repairSugarDB.sql
- Connected to putty
mysql -u root -pXXXXXXXXX bitnami_suitecrm < repairSugarDB.sql
ERROR 1064 (42000) at line 7: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
<sp...' at line 1
This is using docker images:-
Sugar Version 6.5.25 (Build 344)
Server Version: 10.3.23-MariaDB
I have below attached the .sql file so you can review & advise changes so it is compatible with MariaDB.
Item 2 - SuiteCRM URL only available internally but has internet access**
To minimize hacking etc the SuiteCRM URL is only available internally but the server has full access to the internet is this going to cause an issue with the plugins functionality + the functionality that coudl be affected?
(If this is going to cause issues not having the SuiteCRM URL being available externally can you advise what Xero external IP's might need access so I can allow them access at the firewall level)
Other add-ons of interest
Glances - Integrate All Your Applications
Accomplish More Every Day. Spend your time on getting things done, not on finding information. Glances securely connects all of your apps and provides a simplified view of the data you need right when you need it, in real time.
Xero Accounting SuiteCRM Integration
The synergy of Xero and SuiteCRM is a double bonanza, as SuiteCRM Xero Accounting Integration by Fynsis brings a seamless flow of data of customers from inside your CRM to the actual billing and invoicing system in useful handshake so the bills can be generated within CRM.