portfolioBack to Portfolio

Lotus Notes CRM and ERP System

Lotus Notes CRM and ERP System
Goal

The client set us a task to support and develop the existing CRM and ERP system based on Lotus Notes and Domino Server.

The main features of the system:

  • The ability to add, edit and remove goods
  • Storing information about this product
  • Create orders and the ability to pay for them through Credit Card, Electronic Check.
  • Check the status of orders
  • Queue order management
  • Receiving orders from partners
  • Creating tasks for warehouses on the formation or sending of orders
  • Monitor the status of these tasks
  • Managing queues of warehouse tasks
  • Sending notifications about the orders to the customer (e-mail)
  • Creating reports
  • User management
Solution

The process of developing and maintaining the system is using the Agile approach.

The customer set us the task of creating a new system, based on existing functionality. MySQL was chosen as the main data storage, but later data were transferred to Percona Server. CodeIgniter PHP Framework has been selected for fast and easy development. The later part of the project, namely authorization was submitted for FuelPHP Framework. Feedback from Lotus Notes / Domino - client-server architecture is based on the SOAP services. Transfer of users from the address book Lotus Notes / Domino to the database.

In this project, we used the following technologies and services: SOAP, Java, LotusScript, LotusFormula, ADODB, EDI, AS2 Server, Commercehub.com, Cybersource.com, FedEx SOAP services, and PGP encryption.

Technologies

Ajax, CSS, Cybersource.com, HTML, Java, JavaScript, jQuery, Lotus Formula, Lotus Script, MS SQL Server, MySQL, PGP encryption, SOAP, ­AS2 Server, ­Commercehub.com, ­FedEx SOAP services

Team

- Distribution of tasks, as well as monitoring their implementation, communication with the customer - Project Manager

- Development - PHP / JS programmer

- Development of the functional part of Lotus Notes and administer Lotus Notes / Domino - Lotus Notes / Domino Specialist

Duration

The development of the project began in 2011. The customer didn’t provide final technical specifications. Each day, the project manager sets the tasks. Ranking and evaluation are discussed with the manager of the customer. Priorities may vary depending on incoming tasks.