working on it ...

Filters

Explore Public Snippets

Sort by

Found 14 snippets matching: vtiger

    public by p.kontalis  99040  2  5  0

    VTiger Extraction Customers' Data by City

    Extract from Vtiger Customers' List with address and to whom they have been assigned
    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;
                
    

    public by p.kontalis  1958  2  5  0

    Contacts Export from VTiger to Google Contacts

    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 error - cannot modify header information: 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.
    
    

    external by Bruno  528  0  3  0

    Ansible install Vtiger

    Ansible install Vtiger: install_vtiger.yml
    - 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

    Database script to fix {"success":false,"error":{"code":"result is not an object","message":"result is not an object"}} error on vTiger Crm: user_error_fix.php
    <?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

    Gerando hierarquina das organizações no vtiger: hierarquia
    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

    SaltStack SLS to install vTiger on Linux Debian Wheezy: wheezy_vtiger.sls
    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 Beginners Guide Pdf Download: gistfile1.txt
    
    ********************
    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

    Vtiger 6.5 mass edit limit change: List.js
    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;
    }
    
    
    

    external by Bruno  0  0  1  0

    Vtiger Dockerfile

    Vtiger Dockerfile: Dockerfile
    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/*
    
    
    • Public Snippets
    • Channels Snippets