Format phone number to international
sql,phpmyadmin,format,substring,vtiger
I'm guessing that you are using MySQL. The way to concatenate strings is concat(): UPDATE vtiger_contactdetails SET phone = CONCAT('+49', ' ', SUBSTRING(phone, 2, 2 ), ' ', SUBSTRING(phone, 4, 3)); EDIT: To get all the characters, just use two arguments to SUBSTRING(): UPDATE vtiger_contactdetails SET phone = CONCAT('+49', '...
Get plain text from ckeditor
It's possible, and given that you're using PHP a decent-ish solution would be HTML Purifier. Assuming you can install it via PEAR (which is the most straightforward way to do it), your example would look like: require_once 'HTMLPurifier.auto.php'; $config = HTMLPurifier_Config::createDefault(); $config->set('HTML', 'Allowed', ''); // Allow Nothing $purifier = new...
VTiger - Custom field with a DB value
There are two possibilities. First: Create the customfield with vTiger and update your database query Second: Create the field in Database. Alter the Tyble vtiger_contacts with your custom field. Add a entry in vtiger_fields and link it with the new column in vtiger_contacts. in the field table you can set...
How make mandatory field inactive in vTiger?
You shouldn't change the presence column, because you need those fields to write times into the database (needed for history for example, because if you change it, you will always get 'created 44 years ago', because no 'Created Time' would be written into the database). Instead, change the displaytype column...
Adding/uploading a file via vtiger 5.4 webservice
you did not specify which language you are using, so I will paste here a simple curl request that you can try out yourself and figure out how to replicate it in the language of your choice. Basically, what you need to do is to "attach" the file as "multipart/form-data"...
Vtiger 6.2 shows blank page after login
The issue was because the mysqli extension is not loaded in the shared hosting. A quick googling tells me that installing mysqli on a shared hosting is not easy. So I changed the changed the db_type ($dbconfig['db_type']) from mysqli to mysql in the config file config.inc.php in the root director...
Vtiger6 how to integrate with existing website
It depends by what version of vtiger do you use, and what kind of website model/infrastructure do you using. For 100% website custom code you have 2 quickly ways: - Talend ETL https://www.talend.com/ suggested for complex data mapping - Mysql Triggers, (something like this http://blog.scarletkangaroo.com/2012/12/opencart-vtiger-syncmyshop-parte-1.html) Good Luck! ;-)...
What is jQuery.Class?
The vtiger CRM uses the jQuery.Class plugin, available here. You can see it in the repository in the libraries folder....
vTiger Customer Portal and Server Admin on different Subdomain / Customer Portal Email not being sent
To make workflow/scheduler work you need to set up your cron configuration. The way I did this was as follows. Start Cron First, i check if cron is running by going to http://example.com/vtigercron.php After browsers says Access Denied!, I did the following process Open vtigercron.php in CRM folder Look for...
vTiger back to install page
Answer: set the default config.inc.php file and delete config.csrf-secret.php Recommended server settings: memory_limit = 512m max_execution_time = 6000 max_input_time = 6000 ...
create custom module in vtiger 6
Thank you so much for your answers. It is very helpful. I found some interesting tutorial in making entity module this is the link. http://community.vtiger.com/help/vtigercrm/developers/extensions/examples/entity-module.html and it is working. Thank you so much.
Not unique table/alias in mysql while joining from different database
Last join and update reference the same table. Use JOIN table AS other_name to avoid this problem. Here is the corrected query. Plus I think you meant vtiger_new on the last join and not vtigerdb as you wrote. UPDATE vtigerdb.vtiger_leadscf JOIN vtiger_new.vtiger_leaddetails ON vtiger_new.vtiger_leadscf.leadid = vtiger_new.vtiger_leaddetails.leadid JOIN vtiger_new.vtiger_leadaddress ON vtiger_new.vtiger_leadaddress.leadaddressid...