Jump to content

jack's Content

There have been 13 items by jack (Search limited from 01-April 19)

By content type

See this member's

Sort by                Order  

#16183 Country Pull-down

Posted by jack on 28 January 2020 - 09:18 AM in Community Support

Bigbankclub, here is an example entry for making a drop down with all the countries. You need to insert it into the dropdown table in your database to use it. Hope it helps.



     name: Countries
  options: {"":"","Albania":"Albania","Algeria":"Algeria","Andorra":"Andorra","Angola":"Angola","Anguilla":"Anguilla","Antigua and Barbuda":"Antigua and Barbuda","Argentina":"Argentina","Armenia":"Armenia","Aruba":"Aruba","Australia":"Australia","Austria":"Austria","Azerbaijan":"Azerbaijan","Bahamas":"Bahamas","Bahrain":"Bahrain","Bangladesh":"Bangladesh","Barbados":"Barbados","Belarus":"Belarus","Belgium":"Belgium","Belize":"Belize","Benin":"Benin","Bermuda":"Bermuda","Bhutan":"Bhutan","Bolivia":"Bolivia","Bosnia and Herzegovina":"Bosnia and Herzegovina","Botswana":"Botswana","Brazil":"Brazil","British Virgin Islands":"British Virgin Islands","Brunei":"Brunei","Bulgaria":"Bulgaria","Burkina Faso":"Burkina Faso","Burundi":"Burundi","Cabo Verde":"Cabo Verde","Cambodia":"Cambodia","Cameroon":"Cameroon","Canada":"Canada","Cape Verde":"Cape Verde","Caribbean Netherlands":"Caribbean Netherlands","Cayman Islands":"Cayman Islands","Central African Republic":"Central African Republic","Chad":"Chad","Channel Islands":"Channel Islands","Chile":"Chile","China":"China","Colombia":"Colombia","Comoros":"Comoros","Costa Rica":"Costa Rica","Cote d Ivoire":"Cote d Ivoire","Croatia":"Croatia","Cuba":"Cuba","Curacao":"Curacao","Cyprus":"Cyprus","Czech Republic":"Czech Republic","Democratic Republic of the Congo":"Democratic Republic of the Congo","Denmark":"Denmark","Djibouti":"Djibouti","Dominica":"Dominica","Dominican Republic":"Dominican Republic","Ecuador":"Ecuador","Egypt":"Egypt","El Salvador":"El Salvador","England":"England","Equatorial Guinea":"Equatorial Guinea","Eritrea":"Eritrea","Estonia":"Estonia","Ethiopia":"Ethiopia","Europe":"Europe","Fiji":"Fiji","Finland":"Finland","France":"France","Gabon":"Gabon","Gambia":"Gambia","Georgia":"Georgia","Germany":"Germany","Ghana":"Ghana","Great Britain":"Great Britain","Greece":"Greece","Grenada":"Grenada","Guadeloupe":"Guadeloupe","Guatemala":"Guatemala","Guinea":"Guinea","Guinea Bissau":"Guinea Bissau","Guyana":"Guyana","Haiti":"Haiti","Honduras":"Honduras","Hong Kong":"Hong Kong","Hungary":"Hungary","Iceland":"Iceland","India":"India","Indonesia":"Indonesia","Iran":"Iran","Iraq":"Iraq","Ireland":"Ireland","Israel":"Israel","Italy":"Italy","Ivory Coast":"Ivory Coast","Jamaica":"Jamaica","Japan":"Japan","Jordan":"Jordan","Kazakhstan":"Kazakhstan","Kenya":"Kenya","Kiribati":"Kiribati","Kosovo":"Kosovo","Kuwait":"Kuwait","Kyrgyzstan":"Kyrgyzstan","Laos":"Laos","Latvia":"Latvia","Lebanon":"Lebanon","Lesotho":"Lesotho","Liberia":"Liberia","Libya":"Libya","Liechtenstein":"Liechtenstein","Lithuania":"Lithuania","Luxembourg":"Luxembourg","Macedonia":"Macedonia","Madagascar":"Madagascar","Malawi":"Malawi","Malaysia":"Malaysia","Maldives":"Maldives","Mali":"Mali","Malta":"Malta","Marshall Islands":"Marshall Islands","Martinique":"Martinique","Mauritania":"Mauritania","Mauritius":"Mauritius","Mayotte":"Mayotte","Mexico":"Mexico","Micronesia":"Micronesia","Moldova":"Moldova","Monaco":"Monaco","Mongolia":"Mongolia","Montenegro":"Montenegro","Montserrat":"Montserrat","Morocco":"Morocco","Mozambique":"Mozambique","Myanmar":"Myanmar","Namibia":"Namibia","Nauru":"Nauru","Nepal":"Nepal","Netherlands":"Netherlands","Netherlands Antilles":"Netherlands Antilles","New Caledonia":"New Caledonia","New Zealand":"New Zealand","Nicaragua":"Nicaragua","Niger":"Niger","Nigeria":"Nigeria","North Korea":"North Korea","Northern Ireland":"Northern Ireland","Norway":"Norway","Oman":"Oman","Pakistan":"Pakistan","Palau":"Palau","Palestine":"Palestine","Panama":"Panama","Papua New Guinea":"Papua New Guinea","Paraguay":"Paraguay","Peru":"Peru","Philippines":"Philippines","Poland":"Poland","Portugal":"Portugal","Puerto Rico":"Puerto Rico","Qatar":"Qatar","Republic of the Congo":"Republic of the Congo","Reunion":"Reunion","Romania":"Romania","Russia":"Russia","Rwanda":"Rwanda","Saint Barthelemy":"Saint Barthelemy","Saint Helena":"Saint Helena","Saint Kitts and Nevis":"Saint Kitts and Nevis","Saint Lucia":"Saint Lucia","Saint Martin":"Saint Martin","Saint Vincent and the Grenadines":"Saint Vincent and the Grenadines","Samoa":"Samoa","San Marino":"San Marino","Sao Tome and Principe":"Sao Tome and Principe","Saudi Arabia":"Saudi Arabia","Scotland":"Scotland","Senegal":"Senegal","Serbia":"Serbia","Serbia and Montenegro":"Serbia and Montenegro","Seychelles":"Seychelles","Sierra Leone":"Sierra Leone","Singapore":"Singapore","Sint Maarten":"Sint Maarten","Slovakia":"Slovakia","Slovenia":"Slovenia","Solomon Islands":"Solomon Islands","Somalia":"Somalia","South Africa":"South Africa","South America":"South America","South Korea":"South Korea","South Sudan":"South Sudan","Spain":"Spain","Sri Lanka":"Sri Lanka","Sudan":"Sudan","Suriname":"Suriname","Swaziland":"Swaziland","Sweden":"Sweden","Switzerland":"Switzerland","Syria":"Syria","Taiwan":"Taiwan","Tajikistan":"Tajikistan","Tanzania":"Tanzania","Thailand":"Thailand","Timor Leste":"Timor Leste","Togo":"Togo","Tonga":"Tonga","Trinidad and Tobago":"Trinidad and Tobago","Tunisia":"Tunisia","Turkey":"Turkey","Turkmenistan":"Turkmenistan","Turks and Caicos Islands":"Turks and Caicos Islands","Tuvalu":"Tuvalu","Uganda":"Uganda","Ukraine":"Ukraine","United Arab Emirates":"United Arab Emirates","United Kingdom":"United Kingdom","United States Virgin Islands":"United States Virgin Islands","Uruguay":"Uruguay","Uzbekistan":"Uzbekistan","Vanuatu":"Vanuatu","Vatican City":"Vatican City","Venezuela":"Venezuela","Vietnam":"Vietnam","Wales":"Wales","Western Sahara":"Western Sahara","Yemen":"Yemen","Yoguslavia":"Yoguslavia","Zambia":"Zambia","Zimbabwe":"Zimbabwe","United States":"United States"}
    multi: 0
   parent: NULL
parentVal: NULL

#16181 Login issue

Posted by jack on 28 January 2020 - 09:04 AM in Community Support

Can you look at your error logs and post what they say? I would also recommend checking the free space on your server, a similar issue has come up when the area where logs are stored has no free space.


#16135 Contact Web activity trigger and unsubscribe form

Posted by jack on 17 December 2019 - 02:30 PM in Web Lead Capture


The form preview is showing our default of "You have been successfully unsubscribed." until you set up you own in the email settings under the admin options.

For the execute branch check, I would recommend just adding a constant value in the URL you can check for instead of the tracking key.


#16124 Contact Web activity trigger and unsubscribe form

Posted by jack on 10 December 2019 - 11:41 AM in Web Lead Capture

Hi Chris, 

For number one if you want to be able to use the tracking key for other purposes you have to make an entry for it in the (x2_fields) table. For number 2 if you are trying to set up an unsubscribe page you can do so from under email settings in the admin panel. If you are asking about why it does not look different for different users our current software does not check if you are already unsubscribed. It shows the same page no matter what email is passed in. For setting opt in you should add your own custom field for opt in and build a list off of that.

Hope this info helps.


#15888 Broken email templates

Posted by jack on 07 October 2019 - 08:23 AM in Community Support

Hi Dev, 

If you can generate the HTML your self you can place it in our editor using "Source" mode, or place it directly in to the database if you can log into the mySQL database you have.

#15784 Broken email templates

Posted by jack on 31 July 2019 - 03:31 PM in Community Support

Hi Dev,

We are looking into having other editors in the app, we don't have a definitive schedule but that is something we are working on. 


#15677 Constant Error 500

Posted by jack on 10 May 2019 - 03:41 PM in Bug Reports

Can you upload the rest of the stack trace?

Also that seems like a x2_sessions issue, I would delete the records on "x2_sessions" table and the "x2_sessions_token" table. And clear your X2 cookies for good measure. 

#15633 Fix for "Add to list" and "Remove from List"

Posted by jack on 16 April 2019 - 03:34 PM in Community Support

Here is code for a fix for the workflow actions, it will be included in next update.


in both X2FlowRecordListAdd.php and X2FlowRecordListRemove.php change 


'linkSource' => Yii::app()->controller->createUrl(
                           CActiveRecord::model('X2List')->autoCompleteSource, array(
'linkSource' => Yii::app()->controller->createUrl(
                       "/contacts/contacts/getAllLists", array(
and add to ContactsController.php
                'actions' => array('getItems', 'getLists', 'ignoreDuplicates', 'discardNew',
                'actions' => array('getItems', 'getLists', 'getAllLists', 'ignoreDuplicates', 'discardNew',


Also add this function 



     * Return a JSON encoded list of all the lists
    public function actionGetAllLists() {
        if (!Yii::app()->user->checkAccess('ContactsAdminAccess')) {
            $condition = ' AND (visibility="1" OR assignedTo="Anyone"  OR assignedTo="' . Yii::app()->user->getName() . '"';
            /* x2temp */
            $groupLinks = Yii::app()->db->createCommand()->select('groupId')->from('x2_group_to_user')->where('userId=' . Yii::app()->user->getId())->queryColumn();
            if (!empty($groupLinks)) {
                $condition .= ' OR assignedTo IN (' . implode(',', $groupLinks) . ')';
            $condition .= ' OR (visibility=2 AND assignedTo IN
                (SELECT username FROM x2_group_to_user WHERE groupId IN
                (SELECT groupId FROM x2_group_to_user WHERE userId=' . Yii::app()->user->getId() . '))))';
        } else {
            $condition = '';
        // Optional search parameter for autocomplete
        $qterm = isset($_GET['term']) ? $_GET['term'] . '%' : '';
        $static = isset($_GET['static']) && $_GET['static'];
        $weblist = isset($_GET['weblist']) && $_GET['weblist'];
        $result = Yii::app()->db->createCommand()
                ->select('id,name as value')
                        ($static ? 'type="static" AND ' : '') .
                        ($weblist ? 'type="weblist" AND ' : '') .
                    AND name LIKE :qterm' . $condition, array(':qterm' => $qterm))
                ->order('name ASC')
        echo CJSON::encode($result);




#15622 Rules not working when making dynamic contact lists

Posted by jack on 10 April 2019 - 03:49 PM in Community Support

Hi Pmc,

Sorry to hear about your issue, for moving more then 100 contacts at a time you on the main view for contacts you can click on the top check box and then the system will ask I you want to select all contacts on all pages. You can use this to deal with multiple pages of contacts. You could also use a workflow to add/remove contacts from list and put all the contacts through the workflow to manage your list. Now for your list issue directly can you share a picture of the rules you have set for your dynamic list so we can try to recreate your issue on our end.


#15621 I need to make a list using the data from a previous email campaign.

Posted by jack on 10 April 2019 - 11:58 AM in Community Support

Hi Attila,

Following up with "Add to  and Delete from list  does not work in 7.0 & 7.1 " I have fixed the auto fill for those workflow actions and will release it next update. Are you having any other issues with those workflow actions or was it just the auto fill that was broken?


#15592 Known Issues with ver 7 upgrade

Posted by jack on 27 March 2019 - 03:18 PM in Bug Reports

Thanks for the find Ylandsman, can you please also post your detailed fix here so we can be sure to added to our next update.



#15588 Email with Oauth2 support

Posted by jack on 22 March 2019 - 09:54 AM in Feature Requests

We have been working on it, but don't have a set date for when it will be released.

#15571 MySQL Query Performance Issue - x2crm 6.9

Posted by jack on 12 March 2019 - 12:52 PM in Community Support

Hi Alberto, 


Can I get some more info about your set up, is your database on the same server that you have you X2 instillation?