Welcome, Guest |
You have to register before you can post on our site.
|
Forum Statistics |
» Members: 539,603
» Latest member: playbar27
» 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, Facebook, Google
|
Latest Threads |
Finetuning the way you se...
Forum: coreBOS Development
Last Post: alexandy40d
12-06-2024, 07:38 AM
» Replies: 4
» Views: 8,141
|
MariaDB Version
Forum: Administrator Support
Last Post: joebordes
11-01-2024, 11:49 AM
» Replies: 1
» Views: 634
|
Product Catalog / parts c...
Forum: Modules/Extension Support
Last Post: joebordes
09-15-2024, 09:40 AM
» Replies: 1
» Views: 1,108
|
Challenges and Best Pract...
Forum: coreBOS Development
Last Post: wishforbes
08-30-2024, 04:21 PM
» Replies: 0
» Views: 721
|
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: jonathanmoore858
08-03-2024, 04:14 PM
» Replies: 4
» Views: 2,769
|
Zapier | Integration
Forum: Modules/Extension Support
Last Post: bernardgbailey
07-29-2024, 11:45 PM
» Replies: 7
» Views: 9,851
|
Versión PHP recomendada
Forum: International
Last Post: joebordes
07-04-2024, 05:42 PM
» Replies: 7
» Views: 3,334
|
Could Someone Give me Adv...
Forum: Open Discussions
Last Post: joebordes
06-27-2024, 08:32 AM
» Replies: 1
» Views: 1,707
|
RESTRICTED FILE
Forum: Administrator Support
Last Post: inspectorflint
06-22-2024, 08:08 AM
» Replies: 7
» Views: 5,665
|
GENDOC imágenes
Forum: Open Discussions
Last Post: joebordes
06-02-2024, 05:11 PM
» Replies: 4
» Views: 2,040
|
|
|
Report merges rows when displayed columns are equal |
Posted by: Guido1982 - 07-30-2018, 12:50 PM - Forum: coreBOS Development
- Replies (2)
|
|
We create a report for assets on a weekly basis. We actually create the report for accounts, and then show the related assets. We show a number of columns for assets, but I've noticed something I've never noticed before: if there are two assets for an account, and all the info in the columns that you choose to show on the report is the same only one asset shows up on the report. I solved this right now by adding the serial number to the report (which is always unique), but personally I believe the reporting system should not filter duplicates based on only the visible columns. Actually, it should not filter duplicates at all I think.
|
|
|
Shows correct registry in call incoming |
Posted by: rslemer - 07-28-2018, 07:23 PM - Forum: Administrator Support
- Replies (2)
|
|
At Brazil there many ways a Telephone company sent a caller id
For example, for number 1234-0000, could be
12340000
012340000
1112340000
551112340000
+55112340000
User can add non numerics characters too, for example (11) 1234-0000
But the last 8 numbers always, correct
Is possible, change de way system check this in database?
|
|
|
birthday (report or workflow ) |
Posted by: rslemer - 07-27-2018, 07:01 PM - Forum: Administrator Support
- Replies (3)
|
|
How I can created a workflow to send a scheduled report to a marketing departament to talk with my day birthday contacts?
Or in b2b company, send a workflow with each aniversary for my clients
Problem is, aniversary date in coreBOS in format yyyy-mm-aaaa .. ( with year ), and in report or workflows, fuction "today" .. will not working for that
|
|
|
Finetuning the way you send in data to a webservice call |
Posted by: Guido1982 - 07-27-2018, 10:44 AM - Forum: coreBOS Development
- Replies (4)
|
|
How to specify the format of you fields when sending in through webservice
In the default behaviour, a webservice call to either revise or update will demand you to make sure all fields are sent to coreBOS in the form of your current user. This applies in particular to number and currency fields, but also to date fields.
Let’s say you use user ‘John’ to login to coreBOS through a webservice in a remote application (maybe some customer portal). John has his preferences stored in the user settings page for his user. He likes his thousands separator to be a dot, his decimals separator to be a comma and he wants only two decimals. So his currency fields and numbers would be formatted like:
1.234,56
In the database however, the number would be stored like this:
1234.560000 if it’s a currency field, or
1234.56 if it was for instance a percentage.
When you send a record, or part of a record to either the revise or update webservice methods, you would be expected to send in the data in the format of the user that sends the data in. So for John, he would have to send in ‘1.234,56’ on a currency field to end up with ‘1234.560000’ in the database. When logged in to coreBOS, coreBOS would take care of the correct formatting when John views or edits a record.
But what if John sends in the value in database-format? What if he would send in ‘1234.560000’ for his currency field? Well, coreBOS wouldn’t understand that and try to convert it to the database format anyway. Since John uses the dot as his thousands separator, coreBOS would remove that from the value first, since databases don’t know this concept. Then coreBOS would apply decimals, if there weren’t any to start with. CoreBOS would expect those to be indicated with a comma, since it knows it’s John that sends in the data.
Now John would end up with the number ‘1234560000.000000’ in the database. In the application, he would see ‘1.234.560.000,00’, which is not what he wanted.
So John has to make sure he sends in all currency and number fields in the format he specified in his user preferences.
But, since 26-07-2018, he could also do something else. He could add a special flag (or multiple) to his data, that tells coreBOS what to expect. Say John is updating a Potential with this data:
PHP Code: $input_array = array ( 'amount' => '1234.56', 'probability' => '5.00', 'id' => '5x195784', );
$moduleName = 'Potentials';
$update = $cbconn->doRevise($moduleName, $input_array);
Normally, this would go horribly wrong. But if he were to update the input array with some special fields, it wouldn’t:
PHP Code: $input_array = array ( 'amount' => '1234.56', 'probability' => '5.00', 'id' => '5x195784', '__cbws_skipcurdbconvamount' => 1, '__cbws_skipcurdbconvprobability' => 1, );
If he were to add the two fields with the name-prefix ‘__cbws_skipcurdbconv’ followed by the fieldname that he wants to send in formatted as database-format, he would get the result he expected (1.234,56 and 5,00).
But, there’s more. He could also add a single, special flag called ‘__cbws_skipcurdbconvall’ (notice the ‘all’ at the end) to make sure coreBOS treats all his fields as database-formatted.
There is one drawback to using the ‘all’ special flag though, which is quite obvious: you really need to make sure to input all data in the database-format. This includes date fields. Basically, setting the ‘all’ flag forces you to format the record as if you were doing an INSERT or UPDATE query on the database.
What about inventory lines?
If you had tried the above examples on an inventory module, you would notice that would not work. This is because the inventorylines are not fields, and are not treated as such by coreBOS. To be able to send your inventorylines with currencies formatted in the database format, you need to add:
‘__cbws_skipcurdbconv_pdo’
to your record and set it to anything, like ‘1’ or ‘true’ .
This mechanism works completely separate from the ones mentioned before. If you want to send in your entire inventory record (for instance a salesorder including the inventorylines) in database-format, you would have to set both ‘__cbws_skipcurdbconv_pdo’ and ‘__cbws_skipcurdbconvall’ to your record.
A note: Do not mistake inventorylines with the InventoryDetails modules. InventoryDetails is a modern module that does treat all of its numbers as fields. Setting the ‘__cbws_skipcurdbconv_pdo’ flag there or on a salesorder (for instance) that does not use the ‘old’ inventorylines mechanism would not do anything.
|
|
|
Default filter |
Posted by: rslemer - 07-26-2018, 02:21 PM - Forum: Administrator Support
- No Replies
|
|
I wish setting a default filter for my users.
Today system exhibit filter "All" or in the better situation, if user has only one filter marked as Default.
Problem is, my default filter is setting in my admin user.
Better solution is setting a global variable, because in this way, I can standarized for a role or group.
|
|
|
How to carry an account to timecontrol from a projecttask |
Posted by: Guido1982 - 07-24-2018, 09:02 AM - Forum: Administrator Support
- No Replies
|
|
Lets say you use timecontrol to keep track of the time spent on projects. You create timecontrol records from the project tasks, but you also want to carry over the account on the project to the timecontrol record, even though the projecttask is not directly related to the account.
You'd need the following business map (adjust to fit you exact needs)
Code: <map>
<originmodule>
<originid>49</originid>
<originname>ProjectTask</originname>
</originmodule>
<targetmodule>
<targetid>56</targetid> <!-- Make sure this is correct or remove al together -->
<targetname>Timecontrol</targetname>
</targetmodule>
<fields>
<field>
<fieldname>cf_722</fieldname> <!-- The field on timecontrol you want to fill -->
<Orgfields>
<Orgfield>
<OrgfieldName>$(projectid : (Project) linktoaccountscontacts)</OrgfieldName>
<OrgfieldID>EXPRESSION</OrgfieldID>
</Orgfield>
</Orgfields>
</field>
</fields>
</map>
The magic is in the '$(projectid : (Project) linktoaccountscontacts)' part. It gets the 'projectid' field from the project task, searches in Projects, and returns the result from the field 'linktoaccountscontacts'. Be careful when you link a project to a contact and carry it over to a UI10 field that is only meant for accounts!
|
|
|
Error in scheduled reports cron |
Posted by: Guido1982 - 07-24-2018, 08:12 AM - Forum: coreBOS Development
- Replies (2)
|
|
My cron gives me the following result:
[ERROR]: ScheduleReports - cron task execution throwed exception.
DateTime::__construct(): Failed to parse time string (1970-01-01 25:43) at position 11 (2): Unexpected character
The time clearly seems off. Does anyone have any experience with this problem?
|
|
|
|