Explore Public Snippets
Found 14 snippets matching: vtiger
public by p.kontalis 99040 2 5 0
VTiger Extraction Customers' Data by City
SET @city = '[CITY NAME]'; #Replace [CITY NAME] with your preferable city name SET @db_name='[DATABASE NAME]'; #Replace [DATABASE NAME] with your database name SET @myquery = CONCAT(' SELECT ', @db_name, '.vtiger_account.accountid AS \'Company Code\', ', @db_name, '.vtiger_account.accountname AS \'Company\', ', @db_name, '.vtiger_account.phone AS \'Phone 1\', ', @db_name, '.vtiger_account.otherphone AS \'Phone 2\', ', @db_name, '.vtiger_account.email1 AS \'Email 1\', ', @db_name, '.vtiger_account.email2 AS \'Email 2\', ', @db_name, '.vtiger_account.website AS \'Website\', ', @db_name, '.vtiger_account.fax AS \'Fax\', ', @db_name, '.vtiger_accountbillads.bill_city AS \'City\', ', @db_name, '.vtiger_accountbillads.bill_code AS \'TK\', ', @db_name, '.vtiger_accountbillads.bill_country AS \'Country\', ', @db_name, '.vtiger_accountbillads.bill_state AS \'State\', ', @db_name, '.vtiger_accountbillads.bill_street AS \'Street\', ', @db_name, '.vtiger_accountbillads.bill_pobox AS \'TK\', ', @db_name, '.vtiger_users.last_name AS \'Αssignment το\' FROM ', @db_name, '.vtiger_account INNER JOIN ', @db_name, '.vtiger_accountbillads ON ', @db_name, '.vtiger_account.accountid = ', @db_name, '.vtiger_accountbillads.accountaddressid INNER JOIN ', @db_name, '.vtiger_crmentity ON ', @db_name, '.vtiger_account.accountid = ', @db_name, '.vtiger_crmentity.crmid LEFT JOIN ', @db_name, '.vtiger_users ON ', @db_name, '.vtiger_crmentity.smownerid = ', @db_name, '.vtiger_users.id WHERE ', @db_name, '.vtiger_accountbillads.bill_city=@city AND ', @db_name, '.vtiger_crmentity.setype=\'Accounts\' '); PREPARE stmt FROM @myquery; EXECUTE stmt; DEALLOCATE PREPARE stmt;
SELECT REPLACE (REPLACE (accountname, '"', '_'), ',', '_') AS 'Name', REPLACE (REPLACE (accountname, '"', '_'), ',', '_') AS 'Given Name', '' AS 'Additional Name', '' AS 'Family Name', '' AS 'Yomi Name', '' AS 'Given Name Yomi', '' AS 'Additional Name Yomi', '' AS 'Family Name Yomi', '' AS 'Name Prefix', '' AS 'Name Suffix', '' AS 'Initials', '' AS 'Nickname', '' AS 'Short Name', '' AS 'Maiden Name', '' AS 'Birthday', '' AS 'Gender', '' AS 'Location', '' AS 'Billing Information', '' AS 'Directory Server', '' AS 'Mileage', '' AS 'Occupation', '' AS 'Hobby', '' AS 'Sensitivity', '' AS 'Priority', '' AS 'Subject', '' AS 'Notes', '* My Contacts' AS 'Group Membership', '* Work' AS 'E-mail 1 - Type', REPLACE (REPLACE (email1, '"', '_'), ',', '_') AS 'E-mail 1 - Value', 'Εργασία 2' AS 'E-mail 2 - Type', REPLACE (REPLACE (email2, '"', '_'), ',', '_') AS 'E-mail 2 - Value', 'Εργασία 2' AS 'Phone 1 - Type', REPLACE (REPLACE (phone, '"', '_'), ',', '_') AS 'Phone 1 - Value', 'Work' AS 'Phone 2 - Type', REPLACE (REPLACE (otherphone, '"', '_'), ',', '_') AS 'Phone 2 - Value', 'Fax' AS 'Phone3 - Type', REPLACE (REPLACE (fax, '"', '_'), ',', '_') AS 'Phone 3 - Value', 'Home' AS 'Address 1 - Type', CONCAT('"',bill_street,'\n',bill_city,bill_state,' ',bill_pobox,'\n',bill_country,'"') AS 'Address 1 - Formatted', REPLACE (REPLACE (bill_street, '"', '_'), ',', '_') AS 'Address 1 - Street', REPLACE (REPLACE (bill_city, '"', '_'), ',', '_') AS 'Address 1 - City', '' AS 'Address 1 - PO Box', REPLACE (REPLACE (bill_state, '"', '_'), ',', '_') AS 'Address 1 - Region', REPLACE (REPLACE (bill_pobox, '"', '_'), ',', '_') AS 'Address 1 - Postal Code', REPLACE (REPLACE (bill_country, '"', '_'), ',', '_') AS 'Address 1 - Country', '' AS 'Address 1 - Extended Address', 'Home Page' AS 'Website 1 - Type', REPLACE (REPLACE (website, '"', '_'), ',', '_') AS 'Website 1 - Value' FROM vtigercrm600.vtiger_account LEFT JOIN vtigercrm600.vtiger_accountbillads ON vtiger_account.accountid = vtiger_accountbillads.accountaddressid; # NOTE: - After the execution click on export button and save it as csv # NOTE: The " and , have been replaced by _ # NOTE: If you want to use this snippet, consider to change the "vtigercrm600" with your database name. ;)
external by hericles 68 0 1 0
vTiger error - cannot modify header information
vTiger will generate the following error: Warning: Cannot modify header information - headers already sent by (output started at <location of error generating code>) in <location of class that caught the error> If this error is preceded by another PHP error or warning it is this first error that you need to resolve. E.g. Warning: Creating default object from empty value in <location of error> Warning: Cannot modify header information - headers already sent by (output started at <location of error generating code>) in <location of class that caught the error> The 'cannot modify header' error is being generated because output has been output to the screen before a call to header() in the PHP code. Because the first error occurred, so does the header error. Resolve the first error, or prevent PHP from displaying warnings (in the php.ini) and the problem is resolved.
- name: vTiger Installation hosts: localhost vars_files: - ../var/settings.yml tasks: - name: General | Install Application packages apt: "name={{ item }} state=present" with_items: - git - curl - name: vTiger | Create vTiger database mysql_db: login_user: root login_password: "{{ mysql_root_password }}" db: "{{ vtiger_db_name }}" state: present - name: vTiger | Create vTiger database user mysql_user: name: "{{ vtiger_db_user }}" password: "{{ vtiger_db_password }}" priv: "{{ vtiger_db_name }}.*:ALL,GRANT" state: present login_user: root login_password: "{{ mysql_root_password }}" - name: vTiger | Download application from Github sudo: false git: > repo=https://github.com/maestrano/vtiger6.git dest={{ vtiger_root_path }} version=6.2.0-1 accept_hostkey=yes ssh_opts="-o StrictHostKeyChecking=no" update=yes force=yes - name: vTiger | Configure Apache virtual host template: src: ../templates/etc-apache22-confd-vtiger6-conf dest: /etc/apache2/sites-available/vtigercrm.conf owner: root mode: 755 - name: vTiger | Enable Apache virtual host file: src=/etc/apache2/sites-available/vtigercrm.conf dest=/etc/apache2/sites-enabled/vtigercrm.conf state=link - name: Apache | Restart the Apache service service: name: apache2 state: restarted
external by Keith Mifsud 177 1 2 0
Database script to fix {"success":false,"error":{"code":"result is not an object","message":"result is not an object"}} error on vTiger Crm
<?php /** * This file fixes an issue on vTiger. * * The issue relates to having a missing 'is_owner' * column in 'vtiger_users' database table. * */ # Fill in the database connection details $host = 'localhost'; $port = 33060; // Possibly 3306 on your server $username = 'homestead'; $password = 'secret'; $dbName = 'vtiger'; # Place this file in a (1) web accessible directory or the root of your (2) # vTiger Installation. ### Note ## The file needs to be on the same server as the vTiger database # or else change the $host setting above. Delete this file from all servers # once done. # (1) If you've placed this file in a web accessible web server than simply # point the browser to it and the fix is completed. # (2) If you've laced this in vTiger root directory, ssh into the directory # and type the the following command `php user_error_fix.php`. The terminal will let # inform you if the fix was applied. ###### The Code Below Can Be Ignored - This is used to run the fix ##### // Initiate a connection to the database $connection = new mysqli($host, $username, 'some', $dbName, $port); /** * @return int|mysqli */ $connect = function() use ($connection) { if ($connection->connect_error) { return print " Cannot connect to database. Please review your settings "; } return $connection; }; /** * @return bool */ $test = function() use ($connect) { $query = "SHOW COLUMNS FROM vtiger_users LIKE = 'is_owner'"; $result = mysqli_query($connect(), $query); if (!$result == false) { if (mysqli_num_rows($result) > 0) { return false; } } else { return true; } return true; }; /** * @return bool|mysqli_result */ $action = function() use ($connect) { $query = "ALTER TABLE vtiger_users ADD is_owner VARCHAR (10)"; return mysqli_query($connect(), $query); }; /** * @return int */ $runFix = function() use ($test, $action){ if($test()){ if ($action()) { return print " Good job :) :) "; } } return print " Column already exists "; }; /** * Run the fix. */ $runFix();
external by Roberto 277 0 3 0
Gerando hierarquina das organizações no vtiger
DROP PROCEDURE IF EXISTS vtigercrm540.hierarquia; CREATE PROCEDURE vtigercrm540.`hierarquia`() BEGIN DECLARE v_finished INTEGER DEFAULT 0; declare v_accountid int(19); declare v_org int(19); declare v_idorg varchar(19); DEClARE cur CURSOR FOR select accountid, SUBSTRING_INDEX(ots_party_number,'.',1) organ from vtigercrm540.vtiger_account where SUBSTRING_INDEX(ots_party_number,'.',-1) > 0 and accounttype = 'Mediador' ; DECLARE CONTINUE HANDLER FOR NOT FOUND SET v_finished = 1; OPEN cur; get_cur: LOOP FETCH cur INTO v_accountid, v_org; IF v_finished = 1 THEN LEAVE get_cur; END IF; select ifnull(accountid,9) into v_idorg from vtigercrm540.vtiger_account where ots_party_number = CONCAT(v_org, '.0'); update vtigercrm540.vtiger_account set parentid = v_idorg where accountid = v_accountid; END LOOP get_cur; CLOSE cur; END;
external by pled76 119 0 2 0
SaltStack SLS to install vTiger on Linux Debian Wheezy
vtiger_pkgs: pkg: - installed - names: - php5 - php5-imap - php5-curl - php5-mysql - apache2 - libapache2-mod-php5 vtiger_php5_ini: file: - managed - name: /etc/php5/apache2/php.ini - source: salt://base/opr/vm/vtiger_9005/php.ini - require: - pkg: vtiger_pkgs vtiger_apache2_ports: file: - managed - name: /etc/apache2/ports.conf - source: salt://base/opr/vm/vtiger_9005/ports.conf - require: - pkg: vtiger_pkgs vtiger_apache2_conf: file: - managed - name: /etc/apache2/sites-enabled/000-default - source: salt://base/opr/vm/vtiger_9005/000-default - require: - pkg: vtiger_pkgs apache2_www_root: file: - directory - name: /mnt/data/apache2_wwwroot - require: - mount: /mnt/data vtiger_files: archive: - extracted - name: /mnt/data/apache2_wwwroot - source: salt://base/opr/vm/vtiger_9005/vtigercrm6.1.0.tar.gz - archive_format: tar - archive_user: www-data - if_missing: /mnt/data/apache2_wwwroot/vtigercrm - require: - file: apache2_www_root - pkg: vtiger_pkgs vtiger_config_inc: # Fixing error: Illegal request # $site_URL = 'http://crm.opr.ramecvs.ru'; file: - managed - name: /mnt/data/apache2_wwwroot/vtigercrm/config.inc.php - source: salt://base/opr/vm/vtiger_9005/config.inc.php - user: www-data - group: www-data - require: - archive: vtiger_files vtiger_service: cmd: - wait - name: 'service apache2 stop; chown -R www-data: /mnt/data/apache2_wwwroot/vtigercrm; service apache2 restart' - watch: - file: vtiger_php5_ini - file: vtiger_apache2_ports - file: vtiger_apache2_conf - archive: vtiger_files - file: vtiger_config_inc
external by Github 14 1 1 0
Vtiger Crm Beginners Guide Pdf Download
******************** Vtiger Crm Beginner's Guide Pdf Download >>> ******************** http://shurll.com/co4hc (Copy & Paste link) ******************** Grow Your Business Now w/ Zoho CRM . Free for 10 Users.Get Started Now!. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE warman s barbie doll field guide vault guide to the top government and nonprofit legal .. vtiger CRM Beginner's Guide By Ian D. Rossi English / 2011 / 248 Pages / ISBN: PDF / 11 MB vtiger CRM is free, full-featured, 100% Open Source CRM the real problem is .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE user s guide for the information center on education new york state department of .. vTiger PDF Maker for vTiger 6.0. . Download & Install vTiger Customer Portal. . vTiger is a powerful solution for your customer relationship management, .. vtiger CRM Beginner's Guide eBook: Ian D. Rossi: Amazon.ca: . Download one of the Free Kindle apps to start reading Kindle books on your smartphone, .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE vaccine safety manual for concerned families and health practitioners unique manual .. PLANETAUTHORIZE PAYMENT GATEWAY vtiger CRM Payment Module User Guide . User Guide and Installation . .. Grow Your Business Now w/ Zoho CRM . Free for 10 Users.Get Started Now!. Vtiger Crm Beginner's Guide Pdf Download -> . Rossi Publisher: Packt Publishing . vtiger CRM .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE vcap5-dcd official cert guide us army awol defense a practice guide and formbook advance .. Download Ebook : vtiger crm user and administration manual for v6 3 0 in PDF Format. also . Download or read online books in PDF, . Vtiger Crm Beginner S Guide.. Manual vtiger pdf pdf download, manual vtiger pdf documentation vtiger crm, .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE Vtiger crm beginner s guide - vw golf and bora service and repair manualor too .. This Download vtiger CRM Beginner's Guide PDF book always gives new wings, takes us flying into the most endearing gardens of knowledge, .. I'm new on Vtiger CRM: I am looking for a book / user manual. Books for versions 5.x can serve this purpose? Anyone know if there is already a manual (beginner) to .. Grow Your Business Now w/ Zoho CRM . Free for 10 Users.Get Started Now!. This book covers the basics of installing and using a CRM system, explaining how to implement vtiger's powerful features for your business, adding extensions, plug .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE Vtiger crm beginner s guide - usa study job and immigration made easya practical .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE Vtiger crm beginner s guide - virtualization a beginner s guidealso vegetable production .. Preface The vtiger CRM manual is a comprehensive step-by-step guide to using this powerful CRM system, an Open Source Customer Relationship Management project.. Grow Your Business Now w/ Zoho CRM . Free for 10 Users.Get Started Now!. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE user s guide to coenzyme q10 user s manual for premining planning of eastern surface .. Explore And Find Crm Software Results On AllResultsWeb.com. "vtiger CRM Beginner's Guide" By Ian D. RossiPublisher: Pac.,.kt Publi.shing 2011 248 Pages ISBN: 1849511861 PDF+code 12 MB vtiger CRM is free, ful.. . small or medium business to new levels with this comprehensive guide to vtiger CRM. . Download this book in EPUB, PDF, . vtiger CRM Beginner's Guide .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE ultimate civilization ii designer s guide to building scenarios unemployment insurance .. Download pdf book by Ian D. Rossi - Free eBooks. . vtiger CRM Beginner's Guide will show you how to unlock the power of the Open Source vtiger CRM system, .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE Vtiger crm beginner s guide - vw golf and bora service and repair manualor too .. In Detailvtiger CRM is free, full-featured, 100% Open Source CRM software ideal for small and medium businesses, with low-cost product support available to production .. User guide vtiger crm, . Mccormick gm series tractor operation maintenance service manual download Chilled Water Pump Catalogue Pdf Topic 9 Laboratory Skills .. Vtiger CRM is online customer relationship management software that helps you track and nurture customers across marketing, sales, and customer service.. vtiger CRM Beginner's Guide. Home; . A step-by-step guide to using vtiger CRM to streamline your organizations customer relationship . Free eBooks Download.. Get this from a library! Vtiger CRM : beginner's guide. [Ian D Rossi] -- Annotation vtiger CRM is free, full-featured, 100% Open Source CRM software ideal for small .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE Vtiger crm beginner s guide - usb complete the developer s guide fifth editionor too .. vtiger CRM Beginner's Guide . Adobe PDF eBook 9.3 MB; . Ian is a co-founder of aimtheory CRM, a hosted vtiger CRM so .. Vtiger crm beginners guide pdf Download Vtiger crm beginners guide pdf .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE user s guide for the emissions modeling system for hazardous air pollutants emshap .. [download] ebooks vtiger crm beginner s guide pdf VTIGER CRM BEGINNER S GUIDE vauxhall opel vectra service and repair manual ultimate guide to u s army combat skills .. Buy the vtiger CRM Beginner's Guide ebook. This acclaimed book by Rossi Ian D. is available at eBookMall.com in several formats for your eReader. Search. 8b9facfde6
external by fedek6 8 0 1 0
Vtiger 6.5 mass edit limit change
var selectedCount = this.getSelectedRecordCount(); if(selectedCount > 2000) { var params = { title : app.vtranslate('JS_MESSAGE'), text: app.vtranslate('JS_MASS_EDIT_LIMIT'), animation: 'show', type: 'error' }; Vtiger_Helper_Js.showPnotify(params); return; }
FROM maestrano:lamp MAINTAINER Maestrano <it@maestrano.com> # Add ansible configuration ADD ansible/playbooks/ /etc/ansible/playbooks/ ADD ansible/templates/ /etc/ansible/templates/ ADD ansible/var/ /etc/ansible/var/ ADD ansible/var/settings.yml /etc/ansible/var/settings.yml ADD ansible/hosts /etc/ansible/hosts WORKDIR /etc/ansible # Install Ansible RUN apt-get -y update && \ ansible-playbook /etc/ansible/playbooks/install_vtiger6.yml -c local && \ apt-get clean purge --auto-remove -y python2.6 python2.6-minimal && \ rm -rf /var/lib/apt/lists/* /tmp/* /var/tmp/*