Explore Public Snippets

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. ;)

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

<?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();

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;

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

********************
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 

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/*