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

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 439,685
» Latest member: merifibirc
» Forum threads: 1,741
» Forum posts: 9,026

Full Statistics

Online Users
There are currently 543 online users.
» 2 Member(s) | 541 Guest(s)

Latest Threads
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: Joana
03-26-2024, 03:48 PM
» Replies: 0
» Views: 19
[RESUELTO] - Tipo de impu...
Forum: Administrator Support
Last Post: inspectorflint
03-22-2024, 05:23 PM
» Replies: 10
» Views: 6,614
Attachment in e-mail not ...
Forum: User Support
Last Post: julikarole
03-13-2024, 05:59 AM
» Replies: 2
» Views: 798
Mail Manager - Options Se...
Forum: Administrator Support
Last Post: joebordes
03-06-2024, 11:52 PM
» Replies: 16
» Views: 17,596
Intermittent issues after...
Forum: User Support
Last Post: joebordes
03-06-2024, 11:44 PM
» Replies: 9
» Views: 1,017
Custom Columns in Mail Ma...
Forum: Modules/Extension Support
Last Post: joebordes
03-06-2024, 11:42 PM
» Replies: 1
» Views: 1,532
[Solved] Gendoc - Contact...
Forum: Administrator Support
Last Post: geraldbigot
02-10-2024, 08:32 AM
» Replies: 2
» Views: 616
Orden en Custom View Lead...
Forum: International
Last Post: juanmax
01-22-2024, 12:38 PM
» Replies: 7
» Views: 1,854
Email Woes: Images Not Lo...
Forum: User Support
Last Post: levis19
11-29-2023, 07:11 AM
» Replies: 0
» Views: 765
Workflow and field betwee...
Forum: Administrator Support
Last Post: joebordes
11-17-2023, 09:15 AM
» Replies: 3
» Views: 1,359

 
  Work on Schedular has begun
Posted by: Guido1982 - 07-12-2016, 02:15 PM - Forum: coreBOS Development - Replies (12)

I've begun working on the Schedular module. Currently I'm in the planning phase. So basically I'm setting up the file structure and most importantly the manifest file. The repo can ben found here. The manifest file is my main concern at this moment.

As you can see I'm creating three tables at the moment. One to keep track of resource groups that a user can create. Upon installation I will create one resource group by default ('users'). When this resource group is selected as the one to show, a settings-allowed user can select the system users that will be used as resources. As you can see there is no way of keeping track of the currently selected resource group right now. I think I will keep track of this in a new 'general settings' table.

Every resource group gets an ID that will be used in the second table. This second table keeps track of the individual resources and the group it belongs to.

The third table is used to keep track of which resource is assigned to which internal coreBOS activity. This is where it gets a little tricky. When an activity is saved in the Schedular, my plan is to create an event through the normal internal system. I am not familiar with this system (apart from just writing SQL directly), but I need some kind of feedback. Meaning: after the system is done creating the normal activity, I need to know the crmid of that newly created activity so I can save this. This way I can load activities from the vtiger_activity table and get the correct resource for each activity (if any). So I need a little help on this. Is there a 'vtlib' way to do this? And does it provide a callback after creating an activity?

Print this item

Thumbs Up [RESUELTO] - Logo de la empresa mas grande
Posted by: julioval - 07-12-2016, 10:07 AM - Forum: Administrator Support - Replies (4)

Buen día,
Qué puedo hacer para que el logo de la empresa ocupe toda la pantalla del login y no solo la pequeña esquina superior izquierda?
Si no fuera posible esto, cómo puedo hacer para que se vea mucho mas grande? de un 50% por ejemplo, qué extensión y dimensiones son las mejores para usar y conseguir esto que pido?
Saludos.

Print this item

  Idea for a module: Scheduler
Posted by: Guido1982 - 07-06-2016, 09:12 PM - Forum: coreBOS Development - Replies (2)

In my quest to get the installation I maintain under GIT control I've found something on the fullcalendar website. One of the reasons I can't just upgrade the install is I made some hacks into the calendar module. I've always wished the calendar was more resource-based (which is part of what the hacks are for) and it seems the author of fullcalendar has made just that: Scheduler. The best thing is: it's free under the GPL license, as long as it's used in an open-source project, which is what we are. So I'd like to start developing a second module for events based on this. Theoretically, it can co-exist with the calendar, where calendar would be used for an individual calendar, and schedular (which is my neat name for it) for a resource planner (meaning: a user that manages resources of a company like rooms or in my case: people).

There are two reasons I'm posting this thread:

  • I know the calendar uses fullcalendar.js right now, but is it loaded on every page? Meaning, besides calendar pages? This may cause conflicts so we need a plan for this.
  • I'd like some advice on the best approach:
    • Start from a normal 'skeleton module' or:
    • Fork the calendar4you module.
  • Just to seem cool (OK three reasons).

So please, let me know any thoughts.

Print this item

Thumbs Up [RESUELTO] Eventos en documento
Posted by: julioval - 07-06-2016, 10:42 AM - Forum: Administrator Support - Replies (7)

Buen día,
Quiero imprimir un documento con las visitas (eventos) a realizar una semana determinada.
El problema con el que me encuentro es que, si genero un informe y exporto ese en pdf, no me deja organizar la información que quiero usar y sale toda en lineas, que, para que quepan en la pagina del pdf, reduce la fuente.
Es posible, de esa u otra forma, sacar el informe de manera que este organizado visualmente?
He probado también a hacer un pdf, con el pdfmaker. Lo que ocurre es que solo puedo exportar la información de un evento y no los eventos a realizar esa semana, no hay un bloque de eventos como ocurre con los bloques de productos.
Me podéis ayudar?
Saludos.

Print this item

  Weird thing on 'getSalesEntityType'
Posted by: Guido1982 - 07-06-2016, 08:29 AM - Forum: coreBOS - Replies (6)

I'm creating a new custom workflow (working nicely through cbUpdater, had to learn it sometime). Now I took some of Joe's scripts as a starting point and noticed something weird:

PHP Code:
list($acc,$acc_id) = explode('x',$entity->data['id']);  // separate webservice ID
    
if (getSalesEntityType($acc_id)=='Accounts') {
        list(
$usr,$usr_id) = explode('x'$entity->data['assigned_user_id']);
        
$query 'update vtiger_crmentity set smownerid=? where crmid in (select contactid from vtiger_contactdetails where accountid=?)';
        
$params = array($usr_id$acc_id);
        
$adb->pquery($query$params);
    } 

The 'getSalesEntityType' is used to check if we are actually working with an account here, by checking against the string 'Accounts'. But when I look up function (https://github.com/vtiger-crm/vtigercrm/blob/master/include/utils/CommonUtils.php#L475-L485) if specifically says: 'returns the tabid, integer type'. So great that it works, but it shouldn't... In the meantime, I checked the setype column in the vtiger_crmentity table and yes, this is a string, not an integer. Just thought I'd point out the comment on the function is wrong.

UPDATE

Just saw I had asked this already in a different thread a couple of months ago....

Print this item

  Questions on Business Maps
Posted by: Guido1982 - 07-04-2016, 06:17 PM - Forum: coreBOS Development - Replies (1)

Since I think this module is going to play a big role I'd like to get a good understanding. Let me just fire some questions from reading the docs:

Code:
<map>
<sql>
SELECT accountid,accountname
FROM vtiger_account
INNER JOIN vtiger_crmentity ce ON ce.crmid=vtiger_account.accountid
WHERE ce.deleted=0 AND vtiger_account.accountid =?
</sql>
<return>accountname</return>    {count|recordset}
</map>

OK, this is a query sure enough. You create it as an entity since I think Business Maps follows the basic entity GUI model. I write the code into the entity and then... What's the event it responds to? What's done with the return value? Can this be used in a workflow for instance?

Next one: the field mapping.

I see:

Code:
<originmodule>
    <originid>22</originid>  {optional}
    <originname>SalesOrder</originname>
  </originmodule>

This is obvious enough. But the origin id, this is the module's ID right? What's called tabid in the database?

Then this part from fieldmapping:
Code:
<field>
      <fieldname>subject</fieldname>   {destination field on invoice}
      <fieldID>999</fieldID>  {optional}
      <Orgfields>  {if more than one is present they will be concatenated with the delimiter}
        <Orgfield>
          <OrgfieldName>subject</OrgfieldName>
          <OrgfieldID>634</OrgfieldID>
        </Orgfield>
        <Orgfield>
          <OrgfieldName>sostatus</OrgfieldName>
          <OrgfieldID>778</OrgfieldID>
        </Orgfield>
        <Orgfield>
          <OrgfieldName>_FromSO</OrgfieldName>  {this is a constant string}
          <OrgfieldID>CONST</OrgfieldID>
        </Orgfield>
        <delimiter>;</delimiter>
      </Orgfields>
    </field>

So the <fieldname> is the name of the field from the target module, then subsequent fields in this <field> set will be filled with the concatenated string using the delimiter. How de the constants work? Is this case only one. Are they PHP constants? Is there a list of these constances as a reference? Is the event automatically triggered by the name ({originalModule}2{TargetModule})?

Since I am also to investigate the GlobalVariable module some more (I just am too busy, still don't know what it does exactly, probably set global variables) I'd like to shine dome light on this:

PHP Code:
$cbMapid GlobalVariable::getVariable('BusinessMapping_SalesOrder2Invoice'cbMap::getMapIdByName('SalesOrder2Invoice'));
  if (
$cbMapid) {
    
$cbMap cbMap::getMapByID($cbMapid);
    
$focus->column_fields $cbMap->Mapping($so_focus->column_fields,$focus->column_fields);
  } else { 

So I create a global variable called BusinessMapping_{my_map_name} and paste in this code? I'm thinking a bit in loops here, probably my bad...

Print this item

  Creating a user select for backup folders
Posted by: Guido1982 - 07-04-2016, 04:18 PM - Forum: coreBOS Development - Replies (3)

I am maintaining an installation that has a lot of files in the storage folder. Since this is in active use, I create backups every night. Once every so often I delete old backups. Also, I altered the backup script so that the storage folder is not backupped, since this will cause massive server load and take up space. In stead, I manually backup the storage folder. In my effort to move to an installation that can be easily updated without loosing the functionality I need, I'd like to offer to create a branch where I extend the backup settings screen to choose the folders to backup, and maybe even auto remove backups that are older than X days. Now my question is, is there any desire to incorporate this into the core codebase? If there is, I can start making this. If there is not, I'll spare myself the effort.

Print this item

  Developing using cbUpdater
Posted by: Guido1982 - 07-03-2016, 02:57 PM - Forum: coreBOS - Replies (6)

So far I've done some hacks that I need for a custom installation. Which is not the most preferred way of course. I want to get some better insight in how to do this while being able to keep up with the master branch development and still use cbupdater for my custom adjustments. Let me clarify by uding an example:

I've modified the calendar module because some specific needs were there, that the calendar module did not provide. For instance, I created an autocomplete that links calendar events to sales orders. This requires some database changes as well as some file changes. The database changes are quite straightforward I think:

  • Create an XML file in the 'modules/cbupdater/cbupdates' folder that describes the update and the path to the update file.
  • Create custom folder in the 'build' folder that holds the specific script (the XML file should point here).
  • Following both steps would allow me to alter the database. But would it also allow me to alter files? Or maybe, rename an original file and replace it with one that being pulled in through an update server?

The problem with altering files apart from the master branch is that you cannot just update from the coreBOS master branch anymore. It will force you to fork the master branch. Then, you can merge the main upstream from coreBOS, and merge commits from your synced master branch into the altered branch (can you even do that)?

Print this item

  me han actualizado a php s 5.6.22-0+deb8u1
Posted by: jackdemolay - 07-03-2016, 06:15 AM - Forum: User Support - Replies (14)

Hola.
En mi servidor me han actualizado a php s 5.6.22-0+deb8u1, y no me funciona el COREBOS.
He leído que, instalando la última versión del COREBOS creo que solo funciona entre el 5.3 y el 5.5. ¿hay algo que se pueda hacer?

Print this item

Thumbs Up [RESUELTO] - Añadir fuente
Posted by: julioval - 07-01-2016, 08:31 AM - Forum: Administrator Support - Replies (5)

Buen día,
Cómo puedo añadir una fuente nueva al Core para poderla usar en el pdfmaker?
Saludos.

Print this item