The new responsive, react and simple CRM for uContact user's :D
The available fields to load information from your parandval will be the following:
[
"txtName",
"txtDocument",
"txtAddress",
"txtEmail",
"txtCity",
"txtCountry",
"txtColony",
"txtField1",
"txtField2",
"txtField3",
"cmbField4",
"cmbField5",
"txtCp",
"txtPhone",
"txtState",
];Dialerbase example:
CRMLite_PREV->;22264614;txtName=Gaston Morales:txtEmail=gaston@gmail.com;;9999;4004This is a const variable with the simple features of CRMLite and you can personalizate by yourself.
You can find it at the first lines in the CRMlite.js or search it by name.
//CONFIGURATION CONST:
const config = {
defaultPreview: "CRMLite_Scheduler->", //for scheduled calls
fieldsCmb: {
cmb1: ["Production", "Test"], //free field 4
cmb2: ["Active", "Desactivated"], //free field 5
},
closeForm: {
//if you want to close automatly the form after XXXX ms
active: false, //active here de feature
timeInMs: 300000, // miliseconds
},
historyLimit: 5, //rows limit for history table at the bottom
saveWithoutDispo: true, // you can save without disposition, if you dont have an active interaction already
inpts: [
"txtName",
"txtDocument",
"txtAddress",
"txtEmail", //you can setup the inputs you want to allow in your parandvalues
"txtCity",
"txtCountry",
"txtColony",
"txtField1",
"txtField2", // to be loaded
"txtField3",
"cmbField4",
"cmbField5",
"txtCp",
"txtPhone",
"txtState",
],
};//here is the expressions or regexs.
const expresiones = {
texto: /^[a-zA-ZÀ-ÿ\s]{1,40}$/, // Letters and spaces.
correo: /^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+$/, // emails
telefono: /^\d{7,13}$/, // 7 to 13 digits
cp: /^\d{3,5}$/, // 3 to 5 digits.
alphanumeric: /^[a-zA-Z0-9_\s]*$/, //alfanumeric
};Customers information by agent
CREATE TABLE `CRMLite_customers` (
`id_customer` int(100) UNSIGNED NOT NULL AUTO_INCREMENT,
`document` varchar(60) DEFAULT NULL,
`name` varchar(200) DEFAULT NULL,
`phone` varchar(200) NOT NULL,
`email` varchar(100) NOT NULL,
`address` mediumtext DEFAULT NULL,
`colony` varchar(200) DEFAULT NULL,
`cp` varchar(10),
`city` varchar(100) DEFAULT NULL,
`state` varchar(100) DEFAULT NULL,
`country` varchar(200) DEFAULT NULL,
`field1` varchar(200) DEFAULT NULL,
`field2` varchar(200) DEFAULT NULL,
`field3` varchar(200) DEFAULT NULL,
`field4` varchar(200) DEFAULT NULL,
`field5` varchar(200) DEFAULT NULL,
`files` longtext DEFAULT NULL,
`active` int(1) DEFAULT 1,
`agent` varchar(100) DEFAULT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_customer`),
KEY `Index_doc` (`document`) USING BTREE,
KEY `Index_name` (`name`) USING BTREE,
KEY `Index_phone` (`phone`) USING BTREE,
KEY `Index_agent` (`agent`) USING BTREE,
KEY `active` (`active`)
) ENGINE=InnoDB AUTO_INCREMENT=4629 DEFAULT CHARSET=utf8;management for the customer did by agent (with or without active interaction).
CREATE TABLE `CRMLite_management` (
`id` int(100) UNSIGNED NOT NULL AUTO_INCREMENT,
`id_customer` int(100) UNSIGNED DEFAULT 0,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`agent` varchar(100) DEFAULT '',
`lvl1` varchar(100) DEFAULT '',
`lvl2` varchar(100) DEFAULT '',
`lvl3` varchar(100) DEFAULT '',
`note` varchar(800) DEFAULT '',
`queuename` varchar(100) DEFAULT NULL,
`channel` varchar(40) DEFAULT NULL,
`guid` varchar(100) DEFAULT NULL,
`callid` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `Index_channel` (`channel`),
KEY `Index_lvl1` (`lvl1`),
KEY `Index_lvl2` (`lvl2`),
KEY `Index_lvl3` (`lvl2`),
KEY `Index_results` (`lvl1`,`lvl2`,`lvl3`),
KEY `Index_queue` (`queuename`),
KEY `Index_guid` (`guid`),
KEY `Index_agent` (`agent`),
KEY `index_date` (`date`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8;INSERT INTO ccdata.reports (name, file, description, DSN, parameters, grouped, language, license, visible)
VALUES ('CRMLite - Management and Customer information detail', 'CRMLiteManagementCustomerDetail.jrxml', '', 'Repo', 'INITIAL_DATE:Timestamp;FINAL_DATE:Timestamp;QUEUE:Queue;', 'CRMLite', 'en', 'CCS', 1),
('CRMLite - Detalle de gestiones y clientes', 'CRMLiteManagementCustomerDetail.jrxml', 'Gestiones realizadas sobre CRMLite e informacion de los clientes respectivos', 'Repo', 'INITIAL_DATE:Timestamp;FINAL_DATE:Timestamp;QUEUE:Queue;', 'CRMLite', 'es', 'CCS', 1);Put the folder named "CRMLite" into this path:
/etc/IntegraServer/web/forms/The content of the folder "reports" into this another path:
/etc/IntegraServer/reports/If you are currenty working with the CRM and you want to use the new CRMLite, maybe you want to backup your old information.
Please, follow the order, step by step, to complete this transaction to your new CRMLite
INSERT INTO ccrepo.CRMLite_customers
(document, name, email, address, phone, agent, date, country, state, city, field1, field2, field3 )
SELECT documento, nombrecompleto, '', direccion, tel1, agente, fecha,
pais, estado, ciudad, campolibre1, campolibre2, campolibre3 FROM ccrepo.CRM_Clientes
WHERE tel1 NOT IN (SELECT phone FROM ccrepo.CRMLite_customers)
GROUP BY tel1;INSERT INTO ccrepo.CRMLite_management
(date, agent, lvl1, lvl2, lvl3, note, queuename, channel, guid, callid)
SELECT fecha, agente, res1, res2, res3, comentarios, campana, "telephony", guid, telMarcado
FROM ccrepo.CRM_Gestiones
WHERE telMarcado IN (SELECT phone FROM ccrepo.CRMLite_customers);UPDATE ccrepo.CRMLite_management crml1, ccrepo.CRMLite_customers crml2
SET crml1.id_customer = crml2.id_customer
WHERE crml1.callid = crml2.phone AND crml1.id_customer = 0;INSERT INTO ccdata.dispositions
(campaign, channel, value1, value2, value3, action, textcode, gamification_measure)
SELECT DISTINCT campana, "telephony", res1, res2, res3, action, '', '' FROM ccrepo.CRM_Result res
WHERE res.res1 NOT IN
(SELECT value1 FROM ccdata.dispositions WHERE value1 = res.res1
AND value2 = res.res2
AND value3 = res.res3
AND campaign = res.campana
AND channel = 'telephony')