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

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 539,593
» Latest member: lotioncoast6
» Forum threads: 1,745
» Forum posts: 9,084

Full Statistics

Online Users
There are currently 4 online users.
» 0 Member(s) | 1 Guest(s)
Bing, Google, Yandex

Latest Threads
Finetuning the way you se...
Forum: coreBOS Development
Last Post: alexandy40d
12-06-2024, 07:38 AM
» Replies: 4
» Views: 8,134
MariaDB Version
Forum: Administrator Support
Last Post: joebordes
11-01-2024, 11:49 AM
» Replies: 1
» Views: 613
Product Catalog / parts c...
Forum: Modules/Extension Support
Last Post: joebordes
09-15-2024, 09:40 AM
» Replies: 1
» Views: 1,106
Challenges and Best Pract...
Forum: coreBOS Development
Last Post: wishforbes
08-30-2024, 04:21 PM
» Replies: 0
» Views: 717
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: jonathanmoore858
08-03-2024, 04:14 PM
» Replies: 4
» Views: 2,755
Zapier | Integration
Forum: Modules/Extension Support
Last Post: bernardgbailey
07-29-2024, 11:45 PM
» Replies: 7
» Views: 9,841
Versión PHP recomendada
Forum: International
Last Post: joebordes
07-04-2024, 05:42 PM
» Replies: 7
» Views: 3,318
Could Someone Give me Adv...
Forum: Open Discussions
Last Post: joebordes
06-27-2024, 08:32 AM
» Replies: 1
» Views: 1,696
RESTRICTED FILE
Forum: Administrator Support
Last Post: inspectorflint
06-22-2024, 08:08 AM
» Replies: 7
» Views: 5,651
GENDOC imágenes
Forum: Open Discussions
Last Post: joebordes
06-02-2024, 05:11 PM
» Replies: 4
» Views: 2,018

 
  Extending the email wftask merge tags
Posted by: Guido1982 - 08-03-2020, 03:01 PM - Forum: coreBOS Development - Replies (3)

I want to create some functionality: when a comment is placed, we send e-mails to the person mentioned in the comment. In that e-mail, I'd like to show the rest of the conversation. To that end I'd like to extend the existing workflow merge tags to accomodate a new tag that gets and prints the conversation that preceeded this comment. How would I start extending this functionality?

Print this item

  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 - Replies (5)

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