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

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 378
» Latest member: to8kitd45ome824w
» Forum threads: 1,148
» Forum posts: 5,983

Full Statistics

Online Users
There are currently 19 online users.
» 0 Member(s) | 19 Guest(s)

Latest Threads
Question about documents
Forum: Administrator Support
Last Post: rslemer
3 hours ago
» Replies: 0
» Views: 3
Error on created a new us...
Forum: Administrator Support
Last Post: rslemer
4 hours ago
» Replies: 0
» Views: 4
[solved] How 2fa Activiat...
Forum: Administrator Support
Last Post: rslemer
Yesterday, 02:19 PM
» Replies: 4
» Views: 87
revised ṕt-lang translati...
Forum: Administrator Support
Last Post: joebordes
Yesterday, 02:19 PM
» Replies: 1
» Views: 29
My 2 cents from being a u...
Forum: coreBOS Development
Last Post: joebordes
Yesterday, 02:05 PM
» Replies: 11
» Views: 215
Doubt - default filter fo...
Forum: Administrator Support
Last Post: joebordes
10-19-2018, 10:23 PM
» Replies: 1
» Views: 41
Sharing access with a Gro...
Forum: Administrator Support
Last Post: joebordes
10-19-2018, 10:21 PM
» Replies: 3
» Views: 44
[solved] Error click in l...
Forum: Administrator Support
Last Post: joebordes
10-16-2018, 09:32 PM
» Replies: 5
» Views: 134
[solved] translation for ...
Forum: Administrator Support
Last Post: joebordes
10-16-2018, 08:56 PM
» Replies: 1
» Views: 46
[solved] translation for ...
Forum: Administrator Support
Last Post: joebordes
10-16-2018, 08:56 PM
» Replies: 1
» Views: 50

 
  MySQL >= 5.5.3 bug
Posted by: addady2 - 12-18-2015, 08:09 AM - Forum: coreBOS - Replies (3)

Hello

One of my customer face this issue:

https://discussions.vtiger.com/index.php?p=/discussion/comment/1198220


FYI: After check coreBOS code it look like the above vtiger issue also relevance to coreBOS.

Regards
Addady

Print this item

  How to "attach/relate" products and/or services to project?
Posted by: Peter A. Gebhardt - 12-17-2015, 02:36 PM - Forum: coreBOS - Replies (2)

I would like to attach "productized" (and sometimes bundled) steps of financial advice/analysis to projects related to contacts.

Bundled products fit the bill already - but how to make products/services to appear under "More Information" in project tasks (and likewise in the parent project)?

Might be interesting for all kinds of Consultants, Advisors and Lawyers.

If a code snippet is readily available that would help most - but a pointer to applicable documentation is also very supportive ;-)

Best regards

PS: There are other extensions which I will post in Feature Requests - like: Adding up Units (here: billable hours) or cloning "Master Projects"

Print this item

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