Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 439,885
» Latest member: iernengwhs
» Forum threads: 1,742
» Forum posts: 9,027

Full Statistics

Online Users
There are currently 692 online users.
» 5 Member(s) | 687 Guest(s)

Latest Threads
https://slimxmed-erfahrun...
Forum: Open Discussions
Last Post: williamgueroa
19 minutes ago
» Replies: 0
» Views: 1
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: Joana
03-26-2024, 03:48 PM
» Replies: 0
» Views: 31
[RESUELTO] - Tipo de impu...
Forum: Administrator Support
Last Post: inspectorflint
03-22-2024, 05:23 PM
» Replies: 10
» Views: 6,627
Attachment in e-mail not ...
Forum: User Support
Last Post: julikarole
03-13-2024, 05:59 AM
» Replies: 2
» Views: 803
Mail Manager - Options Se...
Forum: Administrator Support
Last Post: joebordes
03-06-2024, 11:52 PM
» Replies: 16
» Views: 17,604
Intermittent issues after...
Forum: User Support
Last Post: joebordes
03-06-2024, 11:44 PM
» Replies: 9
» Views: 1,019
Custom Columns in Mail Ma...
Forum: Modules/Extension Support
Last Post: joebordes
03-06-2024, 11:42 PM
» Replies: 1
» Views: 1,541
[Solved] Gendoc - Contact...
Forum: Administrator Support
Last Post: geraldbigot
02-10-2024, 08:32 AM
» Replies: 2
» Views: 618
Orden en Custom View Lead...
Forum: International
Last Post: juanmax
01-22-2024, 12:38 PM
» Replies: 7
» Views: 1,863
Email Woes: Images Not Lo...
Forum: User Support
Last Post: levis19
11-29-2023, 07:11 AM
» Replies: 0
» Views: 767

 
Question Usage on ZYXEL NAS: INNODB mandatory?
Posted by: Peter A. Gebhardt - 12-16-2015, 11:44 AM - Forum: Administrator Support - Replies (3)

Just tried this, because using ENGINE=INNODB throws 'Can't create' error:

Code:
CREATE TABLE IF NOT EXISTS `vtiger_cbupdater` (
 `cbupdaterid` int(11) NOT NULL DEFAULT '0',
 `cbupd_no` varchar(26) DEFAULT NULL,
 `author` varchar(83) DEFAULT NULL,
 `filename` varchar(218) DEFAULT NULL,
 `pathfilename` varchar(218) DEFAULT NULL,
 `classname` varchar(183) DEFAULT NULL,
 `execstate` varchar(56) DEFAULT NULL,
 `systemupdate` varchar(3) DEFAULT NULL,
 `blocked` varchar(3) DEFAULT NULL,
 `perspective` varchar(3) DEFAULT NULL,
 `execdate` date DEFAULT NULL,
 `execorder` int(11) DEFAULT NULL,
 PRIMARY KEY (`cbupdaterid`),
 UNIQUE KEY `findupdate` (`filename`,`classname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Bummer too. Error: 1071 SQLSTATE: 42000 (ER_TOO_LONG_KEY)

(Problem: ZYXEL doesn't support INNODB in it's mySQL packages yet)

Any idea?

Best regards

Print this item

Information "Uninstall" Free Module PDFMaker
Posted by: Peter A. Gebhardt - 12-16-2015, 01:18 AM - Forum: Administrator Support - Replies (1)

I've just tried out PDFMaker Free for vtiger 5.40 via "Install Custom Module".

But there is NO "Uninstall". Only a checkmark to disable it!

One way to get rid of it (if you don't like to use the module):

1. Rename/Delete ... corebos/modules/PDFMaker
2. Rename/Delete ... corebos/Smarty/templates/modules/PDFMaker

AND

3. Delete any instance of PDFMaker in 'vtiger_links' in your CoreBOS database.

Only then you get rid of the annoying message "PDFMaker is not installed" when you view or create eg. an invoice etc.

Best regards

Print this item

Information [TIP] Calendar4You - Module not installed?
Posted by: Peter A. Gebhardt - 12-15-2015, 07:29 PM - Forum: User Support - No Replies

The default GIT clone of CB comes with "CRON Module" disabled.

Pls. enable CRON in "Other Modules" - and you can use the calendar.  Idea

Best regards

Print this item

  UI Mods: How to migrate from vtiger 5.2.1 to CoreBOS 5.5?
Posted by: Peter A. Gebhardt - 12-15-2015, 05:23 PM - Forum: coreBOS - Replies (1)

In the course of my participation in the vtiger forum (until their switch to v6.x). I did some UI changes, I like to have available again under CB.

   

Although simple exchange of core files like ... Smarty/templates/Detail... looked promising first, once I wanted to add my "Show Contacts Hierarchy" module to it, I ran into problems. Mainly because I've patched code directly.

Apparently there is to much difference now between these two code-bases ('Meld'ed some files and was distracted).

Any ideas how to change UI Elements in a "proper way" under CB?

Best regards

Print this item

  Natural Sort
Posted by: Peter A. Gebhardt - 12-15-2015, 04:44 PM - Forum: coreBOS - Replies (1)

Just saw:

http://corebos.org/documentation/doku.php?id=en:adminmanual:faq#automatic_number_fields_are_no

I'm using e.g.:

Code:
SELECT * FROM vtiger_accounts ORDER BY LENGTH(account_no), account_no;

found here:

http://stackoverflow.com/questions/153633/natural-sort-in-mysql/12257917#12257917

Best regards

Print this item

  Creating a module record from a workflow via webservice
Posted by: Guido1982 - 12-15-2015, 01:50 PM - Forum: Modules/Extension Support - Replies (15)

Okay, I took a look at the following files:

https://github.com/tsolucio/corebos/blob/master/modules/com_vtiger_workflow/tasks/VTCreateEventTask.inc

and

https://github.com/tsolucio/corebos/blob/master/build/HelperScripts/importcsv.php

My goal is to make my module (that basically relies on the use of workflows) create a record for each workflow execution to show the result. The result will be a server answer, since it is connecting to a foreign application. Since I know very little about the vTiger/coreBOS webservice, I thought I'd start a topic here that will maybe help others as well.

My starting point is a line in the file in the second link:

PHP Code:
$row vtws_create('Accounts'$row$current_user); 

This is from this line. I presume this is a function from 'include/Webservices/Create.php' that handles the actual creation of a record. I will need to take a look at that function to find out more.

I also studied the class definition in the include file that creates an event, I know the 'doTask' method is the one that is actually executed when the workflow condition is met. I now have very simple custom functions in a single file that handle the API calls to the foreign server, and I'd basically like to expand them with a method from an existing class (the 'vtws_create' command?) that creates a record with the return from the foreign server. I can only get the answer from the server from the same function as I use to send data, so whatever I use, it can't be a separate workflow.

The above may be a little confusing, since I studied a lot of files but don't really get the context yet. In the end, I just want to create a new row in the main table of my module, but do it in a system-accepted way, so all other related actions are also taken (like updating the crmentity table). So can I use the 'vtws_create' function? Will it take care of all other system-updates for me? Does it expect any special parameters? Do I need to include special files (other that the 'include/Webservices/Create.php')?

Print this item

  Comportamiento errático
Posted by: unaitwo - 12-11-2015, 09:52 AM - Forum: Spanish - Replies (2)

Ayer el crm empezó a hacer cosas raras, muy raras, también es verdad que todo pasó después de que el servicio de hosting donde lo tengo alojado fallase, todo empezó mostrando a un usuario el siguiente mensaje:

Migration Incompleted.
Please contact your system administrator.

Me lo comunicó y a mi al probar, me funcionaba correctamente, pero la navegación era muy lenta, y no siempre cargaba las páginas a la primera, pensé que sería problema del cache del chrome del ordenador del usuario que me comunicó la incidencia, le sugerí que usar el firefox, y funcionaba.

Pero el problema ha llegado hoy, que sigue saliendo el mismo mensaje en ambos navegadores, incluso limpando la caché, a mi me funciona una vez si y 20 no, en el firefox no sale el mensaje, directamente no carga nada.

Alguna experiencia parecida, mil gracias

Print this item

  [Calendar4You] Hide module list
Posted by: Shao - 12-09-2015, 02:49 PM - Forum: Modules/Extension Support - Replies (4)

I cannot find a module list code, where i can put visibility:hidden or comment out (Calendar4You)?

Print this item

  Just a little explanation on 'getTranslatedString'
Posted by: Guido1982 - 12-08-2015, 11:11 AM - Forum: Modules/Extension Support - No Replies

One of those things where, when you see it, it's so simple:

When you use getTranslatedString in for instance your Settings.php page:

PHP Code:
$menu_array['SetCredentials']['location'] = 'index.php?module=ExactOnline&action=SetCredentials';
$menu_array['SetCredentials']['image_src'] = 'modules/ExactOnline/images/setexactcredIcon.png';
$menu_array['SetCredentials']['desc'] = getTranslatedString('SetCredentials','ExactOnline');
$menu_array['SetCredentials']['label'] = getTranslatedString('SetCredentialsTitle','ExactOnline'); 

The first argument is the label in the language array, the second one is the module you want the system to look into for this language file.

Print this item

  Creating a dropdown from vtlib
Posted by: Guido1982 - 12-02-2015, 12:53 PM - Forum: Modules/Extension Support - Replies (4)

For my ExactOnline module, I'm in the process of syncing the general ledgers to coreBOS from Exact. I created a dropdown in products like this:

PHP Code:
$Vtiger_Utils_Log true;
 include_once(
'vtlib/Vtiger/Menu.php');
 include_once(
'vtlib/Vtiger/Module.php');
 
$module Vtiger_Module::getInstance('Products');
 
$infoBlock Vtiger_Block::getInstance('LBL_PRODUCT_INFORMATION'$module);
 
$glaccountsField Vtiger_Field::getInstance('generalledgers'$module);
 if (!
$glaccountsField) {
 
$glaccountsField = new Vtiger_Field();
 
$glaccountsField->name 'generalledgers';
 
$glaccountsField->label 'General Ledger Accounts';
 
$glaccountsField->column 'generalledgers';
 
$glaccountsField->columntype 'VARCHAR(255)';
 
$glaccountsField->uitype 16;
 
$glaccountsField->typeofdata 'V~M';
 
$glaccountsField->setPicklistValues($GLAccountValues);
 
$infoBlock->addField($glaccountsField);
 } 

This works, but does produce errors, what am I doing wrong? Here are the errors:


PHP Code:
Strict StandardsOnly variables should be assigned by reference in /PATH/crmdevelop/include/database/PearDatabase.php on line 225
Creating table vtiger_generalledgers 
... DONE

Strict Standards
Only variables should be assigned by reference in /PATH/crmdevelop/include/database/PearDatabase.php on line 225

Strict Standards
Only variables should be assigned by reference in /PATH/crmdevelop/include/database/PearDatabase.php on line 225

Strict Standards
Only variables should be assigned by reference in /PATH/crmdevelop/include/database/PearDatabase.php on line 225
Creating Field generalledgers 
... DONE
Module language mapping 
for General Ledger Accounts ... CHECK

Catchable fatal error
Object of class Vtiger_Module could not be converted to string in /PATH/index.php on line 687 

Print this item