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

Username
  

Password
  





Search Forums

(Advanced Search)

Forum Statistics
» Members: 2,024
» Latest member: sobuj801
» Forum threads: 1,571
» Forum posts: 8,017

Full Statistics

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

Latest Threads
PHP 7.4 error
Forum: User Support
Last Post: mindkicker
11-19-2020, 09:45 PM
» Replies: 2
» Views: 146
Default quantity when add...
Forum: User Support
Last Post: radu
11-18-2020, 11:02 AM
» Replies: 4
» Views: 64
Report Module - Export To...
Forum: Modules/Extension Support
Last Post: global.da
11-18-2020, 02:02 AM
» Replies: 3
» Views: 108
Problema con flujos de tr...
Forum: Spanish
Last Post: garenas
11-17-2020, 04:33 AM
» Replies: 0
» Views: 96
Concatenate values from r...
Forum: User Support
Last Post: joebordes
11-12-2020, 11:14 AM
» Replies: 3
» Views: 183
Automatically filling rel...
Forum: Administrator Support
Last Post: gedas
11-12-2020, 08:49 AM
» Replies: 4
» Views: 1,648
Autocomplete product/serv...
Forum: Administrator Support
Last Post: joebordes
11-11-2020, 10:35 AM
» Replies: 6
» Views: 841
Workflow task to change f...
Forum: Administrator Support
Last Post: Guido1982
11-10-2020, 03:41 PM
» Replies: 2
» Views: 179
Can't get sending mails u...
Forum: coreBOS Development
Last Post: joebordes
11-10-2020, 11:27 AM
» Replies: 1
» Views: 415
ISSUE IN INSTALLING/UPDAT...
Forum: Administrator Support
Last Post: joebordes
11-10-2020, 09:20 AM
» Replies: 4
» Views: 318

 
  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

  Product compnents / Product bundle
Posted by: radu - 06-22-2020, 08:23 AM - Forum: Modules/Extension Support - No Replies

If i understand correctly, product  bundles permit to establish a relation between products. It is governed by some GV's and two of them refers to price roll-up and cost roll-up. I set price roll-up to 1, did not necessarily apply to Products module but to all of the modules just to be sure. I set it to default and mandatory.
It's either i don't understand it correctly or  something does not function properly. Here is what I noticed:
- I make 2 products kit1 and subkit1
- in product bundle related list of kit1 i select subkit1. A relation is established and a new element representing this relation is added in Product Components module. The 'subproduct'(not the relation) is showing in Product Bundles table of kit1. At this point I would expect the unit price of kit1 to be increased with the unit price of subkit1. It does not happen, price of kit1 remains the same.
- if i try to view/edit the subproduct from the related table I get an error saying Record you are trying to access is not found. When I try to delete the relation, table collapses and nothing else happens. Here is the details with that 'not found' error:
kit1 record number is 25435
subkit1 record number is 25444
product component relation record number is 25459
the record number shown in the 'not found' error is 25459: 'index.php?action=DetailView&module=Products&record=25459'
so things Are not working properly in my installation. Could be that it does refer to the relation's id instead of the 'subroduct' id. make sense not being able to display/edit a product id that is not in the products table. Also adding prices would not work if it refers to a Product Components element(if that in itself does not return some kind of value).
-if i view the relation from the 'subproduct's' point of view, in it's Parent Product related list I can see the correct relation and links point to the correct elements, i can delete the relation from there.
So it's either that i do something wrong or there's something else going on. In the end the price does not roll-up(and neither the cost if tested)
Of course i can update the unit price with an aggregation workflow, but that leads into some issues later on.
Hope I explained it right.

UPDATE
After doing some more tests i found out that roll-up functions work if you ADD the product instead of SELECT it on the Product Bundles related table. In that case, the new element that is presented is a product component relation where you can establish the details of the relation, that's where you are supposed to chose the bundled product. Unlike if you just press SELECT then a capture popup shows with the available products and you can chose one to relate but no relation in the product components is selected. In both cases, the product bundle related list shows the related elements from Products not from Product Components(the product parent table shows the product components not the product). So that's why you can't view/edit/delete the elements in the list i guess.
UPDATE2
And then i found that on Product's Layout editor you can add the correct Product Components table instead of the default Product Bundle there and then it relates as supposed. But the cost and unit price columns of the bundled are empty so roll-ups does not function in this way. This one got a bit messy to explain Wink

Print this item

  Timecontrol and Service Contracts with different rates
Posted by: gaardam - 06-22-2020, 12:31 AM - Forum: Modules/Extension Support - No Replies

Hi All,

I have employees with different charge out rates, as well as different loadings on those rates for outside of hours work.

For example :
Employee 1 has a charge out rate of $80 / hour
Employee 2 has a charge out rate of $100 / hour

Any work outside of business hours, for either employee is charged at 1.5 x their charge out rate.

We sell a fixed number of hours in blocks (at employee 1 rates), which fits well with the 'Service Contract' in coreBOS. Currently we have to do the calculation of deducted hours manually, depending which employee did the work, and if the work was done outside or hours.

So we sell a Service contract of 10 hours ($800)

If employee 1 creates a time control of 1 hour (for in business hours) - then the service contract is updated correctly - 1 hour is deducted
If employee 1 does 1 hour outside of of work, then 1.5 hours should be deducted
If employee 2 does 1 hour inside business hours, then 1.25 hours should be deducted
If employee 2 does 1 hour outside of business hours, then 1.875 hours should be deducted.

What's a good way to implement this in coreBOS?

Not just the calculation for the service contact, but also the fields to define chargeout and loading rates?

I could create a chargeout rate on Users table, then a loading drop down on the timecontrol?

Or I could just do a drop down on the timecontrol, with say
- lvl 1 - normal
- lvl 1 - 1.5
- lvl 2 - normal
- lvl 3 - 1.5

I would also like the option to use these values for invoicing time control, where the customer has not purchased a 'Service Contract'

Can someone point me in the right direction please?

Print this item

  Inventory Details sequence number -Solved-
Posted by: radu - 06-19-2020, 07:53 AM - Forum: Administrator Support - Replies (3)

I noticed that if you change line positions on a master-detail module, the order of associated inventory details does not change(although the sequence number it's correctly updated). I don't know how this can be achieved using the interface tools, i think if it is even possible it needs to be done in the internal logic when the relations are updated. Left as it is it creates a mess on a gendoc template given the fact that the 'for each inventorydetails' loop scans the inventory details in a linear mode and you can't scan that list sorted on sequence number for example. so in the end the list that you get from gendoc differs from what you see on the module in terms of line positions.

Print this item