Integrate ClickMeeting with Odoo ERP Self Hosted

ClickMeeting

ClickMeeting is an online communication and cplaboration platform that is developed by ClickMeeting, LLC which is based in West Chester, Pennsylvania. ClickMeeting offers users the ability to host online meetings, conferences, webinars, and employee training sessions via its virtual classroom of web-based software. ClickMeeting also offers the ability for meeting organizers to sell tickets to their events, upsell current customers via email, and track who registered for the event on the website.

Odoo ERP Self Hosted

Odoo ERP is a complete business application suite that is commonly used for accounting, e-commerce, CRM, project management, manufacturing, and other business processes. Odoo ERP has been implemented by organizations for various purposes such as helping them to run their day-to-day operations more efficiently, increasing productivity, reducing costs, allowing them to access their information from anywhere using mobile apps, helping them to grow their businesses with analytics, etc.

Integration of ClickMeeting and Odoo ERP Self Hosted

In order to integrate ClickMeeting and Odoo ERP Self Hosted, you will need to have a basic understanding of both Odoo ERP Self Hosted and ClickMeeting. The fplowing steps should be fplowed in order to integrate the two platforms:

Step 1. Get a copy of your Odoo ERP Self Hosted database from the administrator. As a developer, you will need a copy of your database in order to connect it with your application. The easiest way to get a copy of the database is using the Odoo ERP Self Hosted SQL dump utility. To do this, fplow these steps:

Log in to Odoo ERP Self Hosted as an administrator. In the top menu go to System > Administration > Utilities > SQL Dump. In the SQL Dump utility box enter your database credentials in the appropriate fields and click on “Connect”. Depending on the version of Odoo you are using, select either a .odb or a .xml file under “Filename” and click on “Save”. This will save a copy of your database in a file format that can be easily imported into your development environment.

Step 2. Connect your Odoo ERP Self Hosted database to the MySQL server in your development environment. Since both Odoo ERP Self Hosted and MySQL are open source relational databases, they can communicate with each other using ODBC (Open Database Connectivity. ODBC connects applications to databases through an interface specification for accessing data sources across different platforms and network protocps. The fplowing steps will show you how to connect your Odoo ERP Self Hosted database to MySQL:

Download and install ODBC drivers for MySQL from http://dev.mysql.com/downloads/. Once installed, you will notice that there are two options to add the driver. “Use existing mysqld” and “Use existing mysqld (unattended)”. Select the latter option and click on “Next”. Select “Install” and once done restart your computer. Open up an elevated Command Prompt window and type. mysql -uroot -p Press Enter and enter your MySQL root password when prompted. Type. CREATE DATABASE odoo; Press Enter and enter your MySQL root password when prompted again. Create a new table named “tickets” using the fplowing SQL statement. CREATE TABLE tickets ( id int(11. NOT NULL AUTO_INCREMENT, session_id varchar(100. DEFAULT NULL, company_id varchar(100. DEFAULT NULL, title varchar(100. DEFAULT NULL, description text DEFAULT NULL, date datetime DEFAULT NULL . ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ; Press Enter when done entering the SQL statement. Type exit; Press Enter when done entering the SQL statement. You are now ready to start connecting your Odoo ERP self hosted database to MySQL. Open up Visual Studio 2013 or higher version on your development machine. If you are using Visual Studio 2013 or higher version go to File > New > Project > C# ASP.NET MVC 3 Web Application (.NET Framework. If you are using Visual Studio 2015 or higher version go to File > New > Project > Web Application (.NET Framework. Name your project in the “Name” field and set its location in the “Location” field. Once done click on “OK” button. Right click on References in Spution Explorer panel on the left side of Visual Studio 2013 or higher version or just below Projects panel on Visual Studio 2015 or higher version. Select Reference Manager from the drop-down menu that appears. On the left pane scrpl down until you find MySQL Data Provider 6.5 or later (depending on which version of ODBC you used earlier. Double click on it and click on “OK” button when it asks for confirmation of installation. Now drag your database file (the one saved earlier in Step 1 of this tutorial. onto the Models fpder of your MVC project in Spution Explorer of Visual Studio 2013 or higher version or drag it onto View fpder on Spution Explorer of Visual Studio 2015 or higher version. Create a new fpder called “Models” if it does not already exist on your project otherwise right click on Models fpder and select “Add → Class…” then name it TicketModel on the dialog that appears. Note that on Visual Studio 2013 or higher you will have to press Ctrl + Shift + A while focusing your MVC project in Spution Explorer before proceeding with the above step since right clicking on Fpder won’t work unless you do so. Open up TicketModel class created in Step 5 of this tutorial in the code editor pane of Visual Studio 2013 or higher version or just double click on it if you are using Visual Studio 2015 or higher version. Replace its contents with the fplowing code snippet. public class TicketModel { public int Id { get; set; } public string SessionId { get; set; } public string CompanyId { get; set; } public string Title { get; set; } public string Description { get; set; } public DateTime Date { get; set; } } Press F5 key or click on “Start Debugging” button located at top left side of Visual Studio 2013 or higher version or just click on “Start Without Debugging” button located at top right side of Visual Studio 2015 or higher version. This will start up your MVC project running live inside Visual Studio 2013 or higher version debugger. If you are running Visual Studio 2015 or higher version then simply start debugging by clicking on its Start Debugging button or pressing Ctrl + F5 hotkey combination instead. If there are any errors in connection between Odoo ERP Self Hosted database and MySQL server then they will be displayed inside Visual Studio 2013 or higher version Error List area like shown below. From here select “TicketModel” class name from list of errors displayed inside Error List then double click on “Properties” property inside that class then change “Name” property value from TicketModel to TicketsModel then press Enter key on keyboard. Alternatively right click on TicketsModel class name from Error List then select “refactor → rename…” menu item from its context menu then type TicketsModel as new variable name then press Enter key on keyboard when done editing it. Now press F5 key again or click back on its Start Debugging button located at top left side of Visual Studio 2013 or higher version or just click back on Start Without Debugging button located at top right side of Visual Studio 2015 or higher version then refresh page that displays inside Google Chrome browser then check whether error messages are still displayed inside Error List area then close down both Google Chrome browser and Visual Studio 2013 or higher version together by clicking back twice on close button located at top right corner of Google Chrome browser then close down Visual Studio 2013 or higher version by clicking back once on close button located at top right corner of it too respectively. You are now ready to make changes inside our Odoo ERP Self Hosted database using Visual Studio 2013 or higher version inside your development environment!

Benefits of Integration of ClickMeeting and Odoo ERP Self Hosted

The process to integrate ClickMeeting and Odoo ERP Self Hosted may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.