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

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 1,950
» Latest member: amietS
» Forum threads: 1,567
» Forum posts: 7,984

Full Statistics

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

Latest Threads
The last modified user in...
Forum: coreBOS Development
Last Post: Guido1982
Yesterday, 08:37 AM
» Replies: 0
» Views: 12
MANEJO DE TAREAS
Forum: International
Last Post: joebordes
10-28-2020, 10:42 PM
» Replies: 5
» Views: 3,021
Can't get sending mails u...
Forum: coreBOS Development
Last Post: Guido1982
10-28-2020, 03:54 PM
» Replies: 0
» Views: 10
Timecontrol - How to gene...
Forum: Modules/Extension Support
Last Post: joebordes
10-28-2020, 12:56 AM
» Replies: 5
» Views: 75
CLIENTE Y PROVEEDOR
Forum: International
Last Post: aehm8111
10-26-2020, 02:06 AM
» Replies: 4
» Views: 2,634
Report: Transferred to us...
Forum: Administrator Support
Last Post: joebordes
10-25-2020, 06:10 PM
» Replies: 3
» Views: 368
Mail Converter
Forum: Open Discussions
Last Post: joebordes
10-24-2020, 09:05 AM
» Replies: 3
» Views: 3,415
Blank popup contacts
Forum: Modules/Extension Support
Last Post: Merchant
10-21-2020, 12:00 PM
» Replies: 2
» Views: 34
Increase the height of th...
Forum: Administrator Support
Last Post: addady2
10-21-2020, 05:35 AM
» Replies: 4
» Views: 1,067
Issue in Emails::createE...
Forum: coreBOS Mail
Last Post: joebordes
10-20-2020, 03:56 PM
» Replies: 5
» Views: 129

 
  Use 'onlyonmymodule' in manifest.xml?
Posted by: Guido1982 - 07-28-2020, 07:12 AM - Forum: coreBOS Development - Replies (5)

In the manifest file, we have the option to add customlinks (which will become business actions), but can we also specify the 'Only on my module' option? And if yes, how? Something like this?

PHP Code:
<customlink>
  <
linktype>DETAILVIEWWIDGET</linktype>
  <
linklabel>InventoryDetailsBlock</linklabel>
  <
linkurl><![CDATA[block://InventoryDetailsBlock:modules/WorkAssignment/InventoryDetailsBlock.php]]></linkurl>
  
<linkicon><![CDATA[]]></linkicon>
  <
sequence>0</sequence>
  <
handler_path><![CDATA[]]></handler_path>
  <
handler_class><![CDATA[]]></handler_class>
  <
handler><![CDATA[]]></handler>
  <
onlyonmymodule>1</onlyonmymodule>
</
customlink

Print this item

  Background of the financial fields
Posted by: Guido1982 - 07-26-2020, 12:38 PM - Forum: coreBOS Development - Replies (8)

Since I'm working on a module that will introduce a new inventorydetails block and will also implement the now 'standard' financial fields that live on the stock inventory modules. I will use the master-detail businessmap definition as described in the wiki, but to be able to do so I would like to know the purpose, unit (%, currency or just no.) and exact formula for each of the following fields:

  • pl_gross_total
  • pl_dto_line
  • pl_dto_global
  • pl_dto_total
  • pl_net_total
  • pl_sh_total
  • pl_sh_tax
  • pl_adjustment
  • pl_grand_total
  • sum_nettotal
I will later specify this in a readme that we could also feed back into the wiki

Print this item

  Basic validation on typeofdata questions
Posted by: Guido1982 - 07-26-2020, 09:39 AM - Forum: coreBOS Development - Replies (3)

We have some =typeofdata]documentation concerning the basic validation, but I don't fully understand it.

  • What is 'OTH' in the date examples?
  • In
    Code:
    D~O~OTH~GE~dateinservice~Date in Service
    , are the last two columnname and fieldlabel of the field we are comparing with?

Print this item

  notDuplicate validation not respected on lead conversion
Posted by: radu - 07-10-2020, 05:22 AM - Forum: Administrator Support - Replies (1)

I noticed if i have a validation rule with notDuplicate on the Accounts, it is not respected if the account is created during a Lead conversion. So if the accounts does not permit duplicates on phone field for example, it is not respected if i convert a lead that passes an existing phone number in the account and the new organization gets created with a phone that already exists.

Print this item

  -Solved- Workflow execution when saved by another workflow
Posted by: radu - 07-08-2020, 06:26 AM - Forum: User Support - Replies (4)

The workflows are triggered when a record is saved most of the time. However, if the triggered workflow modifies(and saves) a field on a related module and another workflow is supposed to execute when something is saved in that module, the second workflow is not triggered, because it was 'indirectly' saved i suppose.
Is there a method to trigger workflows when a previous workflow was the one that 'provoked' the triggers instead of the user? To obtain a sort of cascading effect.
I remember i saw something like that in documentation examples but i can't find anything.

Thanks

Print this item

  Mail Converter text encoding
Posted by: addady2 - 07-01-2020, 02:03 PM - Forum: Administrator Support - Replies (3)

Hi,

Some of the incoming emails are not encode well, The text appear as: ... ???????? ???????? ....
Those email are in windows-1255 encoding.

There is a sample of typical email header:

Code:
Subject: =?windows-1255?B?4/TpIPHs6ffk?=
Content-Type: text/plain; charset="windows-1255"

It seems that Corebos ignore this encoding.
How can I add it to the Mail coverter?

Thanks

Print this item

  Mail Converter hang on Running status
Posted by: addady2 - 07-01-2020, 07:45 AM - Forum: Administrator Support - No Replies

Hi,

From time to time Mail Converter hang on "Running" status (attach pic)

To reset it I need to go to the "Scheduler" set it "Inactive" save and tham make it "Active"

How to fix it?



Attached Files Thumbnail(s)
   
Print this item

Bug Workflow Save on deleting condition button bug
Posted by: radu - 06-28-2020, 12:05 PM - Forum: Administrator Support - No Replies

When on a workflow, if you remove elements from a existing workflow condition the green SAVE button does not function, workflow does not save. So you kinda have to redo the workflow without the conditions you wanted to remove.

Print this item

  Workflow function aggregation error
Posted by: radu - 06-26-2020, 07:11 AM - Forum: Administrator Support - No Replies

I noticed when i have a condition in the aggregation function the whole function fails. For example i have the following function:

Code:
aggregation('count','SalesOrder','pl_grand_total','[sostatus,e,Approved,or],[sostatus,e,Delivered,or]')
which should count the sales orders that have the status 'Approved' or 'Delivered'. If I remove the condition from the expression, the function retunrs the correct count number of existing SO's but if i put any condition it craps out and return empty. This exact expression is in use on a older install and it works fine.
The log inspection reveals some clues. Here is what the query and result looks like on a new install:


query select count(vtiger_salesorder.pl_grand_total) as aggop  from vtiger_salesorder    inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_salesorder.salesorderid    left outer join vtiger_quotes on vtiger_quotes.quoteid=vtiger_salesorder.quoteid    left outer join vtiger_account on vtiger_account.accountid=vtiger_salesorder.accountid    left outer join vtiger_potential on vtiger_potential.potentialid=vtiger_salesorder.potentialid    left join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid    left join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid     where vtiger_crmentity.deleted=0 and vtiger_potential.potentialid = 25326 ORDER BY vtiger_crmentity.createdtime DESC and (vtiger_crmentity.deleted=0 AND ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Approved') OR vtiger_salesorder.sostatus = 'Approved')  or ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Delivered') OR vtiger_salesorder.sostatus = 'Delivered')  AND vtiger_salesorder.salesorderid > 0)

and it fails with:

Code:
DB DB >ADODB error  Query Failed:select count(vtiger_salesorder.pl_grand_total) as aggop  from vtiger_salesorder    inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_salesorder.salesorderid    left outer join vtiger_quotes on vtiger_quotes.quoteid=vtiger_salesorder.quoteid    left outer join vtiger_account on vtiger_account.accountid=vtiger_salesorder.accountid    left outer join vtiger_potential on vtiger_potential.potentialid=vtiger_salesorder.potentialid    left join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid    left join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid     where vtiger_crmentity.deleted=0 and vtiger_potential.potentialid = 25326 ORDER BY vtiger_crmentity.createdtime DESC and (vtiger_crmentity.deleted=0 AND ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Approved') OR vtiger_salesorder.sostatus = 'Approved')  or ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Delivered') OR vtiger_salesorder.sostatus = 'Delivered')  AND vtiger_salesorder.salesorderid > 0)::->[1064]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and (vtiger_crmentity.deleted=0 AND ( vtiger_salesorder.sostatus IN (
se' at line 1

And this is how the query looks on the older system where is working ok:

Code:
select count(vtiger_salesorder.pl_grand_total) as aggop  from vtiger_salesorder    inner join vtiger_crmentity on vtiger_crmentity.crmid=vtiger_salesorder.salesorderid    left outer join vtiger_quotes on vtiger_quotes.quoteid=vtiger_salesorder.quoteid    left outer join vtiger_account on vtiger_account.accountid=vtiger_salesorder.accountid    left outer join vtiger_potential on vtiger_potential.potentialid=vtiger_salesorder.potentialid    left join vtiger_groups on vtiger_groups.groupid=vtiger_crmentity.smownerid    left join vtiger_users on vtiger_users.id=vtiger_crmentity.smownerid     where vtiger_crmentity.deleted=0 and vtiger_potential.potentialid = 519508 and (vtiger_crmentity.deleted=0 AND ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Approved') OR vtiger_salesorder.sostatus = 'Approved')  or ( vtiger_salesorder.sostatus IN (
select translation_key
from vtiger_cbtranslation
where locale="en_us" and forpicklist="SalesOrder::sostatus" and i18n = 'Delivered') OR vtiger_salesorder.sostatus = 'Delivered')  AND vtiger_salesorder.salesorderid > 0)

I have marked with red the difference between the two which is ORDER BY vtiger_crmentity.createdtime DESC and
.
The failed query gives syntax errors when launched in the sql engine. However if I remove the red part which does not used to be present before, the engine executes the query just fine. I am not well versed in sql but from my point of view, that select query has logic with or without the 'red addition'. The syntax itself, i tried to count the parentheses and other symbols to see if i can spot any obvious mistake(with my limited knowledge of the language), i could not find any but the engine will not execute if that 'sorting/order' is present. If i remove it and launch that query in the engine, it runs ok.
Maybe someone can get a clue about what is going on. Could be something with my own install.

Print this item

  Popup open hook
Posted by: radu - 06-22-2020, 08:41 AM - Forum: Administrator Support - Replies (1)

I tested the wiki example for using a popup hook to filter the popup list of Assets based on a given Product's name. This is about the behavior of that popup list and the fact that it works, but if the result is split in more pages, when you go to the next page it reverts to the original 'all' list.
So in more detail, i can't be sure if I'm doing it entirely right and that procedure might be deprecated now with the business actions but:
-i did saved the js file
-i did execute the php that contains the addlink instruction
-i did insert in Products.php the condition(before the existing one in that function)
The hook did not work until i defined a business action stating what was in the addlink php. But then it worked, at least for the first page. It shows the correct number of results and the button for 'show all' but if you move to another page it loses the whole list and reverts to the default all list.

Print this item