data binding
7.12
sales_enterprise

Hi,

I have on-premise installation of bpmonline by local vendor.

however when I do verify configuration check, it showing list of error on data binding.

 

how to fix this ?

I tried to delete it but it showing this message:

 

Thank you

Like 0

Like

1 comments

Dear Antonius, 

Please contact your vendor or our support regarding this issue. Our support email is support@bpmonline.com We will be happy to help you! 

Regards, 

Anastasia

Show all comments
7.12
sales_enterprise

Hello Community! 

Is posible increase the numbers of digits in a decimal type to 5 after comma?

Regards,

Like 0

Like

1 comments

There is no such option

You can try to create an integer type column and assume that it contains everything on a scale of 1 to 100,000

Show all comments
price list
pricing model
7.12
sales_enterprise

Background: We have term pricing for products and we've created a product for each term (12, 24, 36 and M2M), but this is a nightmare to manage for a few hundred products. We'd like to explore using price lists to better manage the pricing differences.

Questions: Are price lists the best way to manage the term pricing differences in products? If so, can someone point us towards documentation to help us properly configure it?

If price lists aren't the best way, we are open to suggestions as we'd like a better way to manage our product catalog.

Thanks in advance, -Toby

Like 0

Like

1 comments

Dear Toby,

In the "Products" section on the correspondent product's page you can find a tab called "Prices and availability" where you can find a correspondent detail called "Price" (see screenshot http://prntscr.com/l264sz). In this detail there is the lookup field called "Price list" where you can choose the term. You can specify terms in the correspondent lookup in the "Lookups" section. Once they will be registered you can apply them for each product and after that you can choose them. Here is the regarding academy article on this topic. Hope this helps.

Best regards,

Oscar

Show all comments
7.12
sales_enterprise

Hello Community! Is posible apply css style to a specifict column un a detail? Example change the border to red in the field cell.

 

Like 0

Like

4 comments

Hello Federico,

1. You need to create a new module. 

In my example, I named it as UsrAccountContactsDetailV2Css. Then you need to navigate to the LESS tab and write your custom styles. In my example it was:

div#grid-AccountContactsDetailV2DataGridGrid-wrap > div>div:nth-child(2){

    border-color: red;

    border-style: solid;

    border-width: 1px;



Leave the source code for the module empty. Please, see my screenshot - http://prntscr.com/l21yvf

2. Create a replacing module for your schema detail and add the created earlier module as a dependency.

Please, see my example - http://prntscr.com/l21zft

As a result,  AccountContactsDetailV2 detail looks in the following way - http://prntscr.com/l21zzx

Hello Tetiana, the screenshots in your reply are no longer visible. Would you please upload them again? Thank you very much!

Andrew Sheng,

 

Hello,

 

Sure, here they are:

 

1) Creating CSS in the Less tab of the module:

2) Connecting CSS to the detail schema:

Oleg Drobina,

Hello,

 

I tried to follow your example above but it's just didn't work on me. i don't know which part is wrong, can you help me to check it please

1. tried changing css in inspect browser and its work like what i want

 

2. create CSS in LESS tab module

 

3.Connecting CSS to the detail schema

 

but nothing changes happen to my form.

and if you don't mind, please check my question in here https://community.creatio.com/questions/custom-image-size for the subject.

Thank you

Show all comments
7.12
sales_enterprise

Hello Community! Is posible cast the field Currency to add the $ simbol before the number? I want make the same with the % simbol in the integer fields.

 

Regards,

 

Like 0

Like

3 comments

Hello.

You can add the following symbols to the field by simply adding a mask to the field like in the academy article below:

https://academy.bpmonline.com/documents/technic-sdk/7-12/how-add-field-…

However, that would be applicable only to the string fields and will render you unable to perform calculations and such.

Alternatively, I would recommend you to use multi-currency fields instead:

https://academy.bpmonline.com/documents/technic-sdk/7-12/how-add-multi-…

Best regards,

Matt

How can we do this in FreedomUI pages?

Hello,

 

Our R&D team has a task to implement a multicurrency field in Freedom UI in the 8.2 application version.

 

Unfortunately, there are no examples in the documentation or application of implementing it in the current application versions. So please wait until 8.2 when this column will be available out-of-the-box and could be used on the pages.

Show all comments
7.12
sales_enterprise

Hello Community!

I have a query with aggregation SUM in products. But need SUMa field depend of the category.

How can make a subquery to sum based a condition 

Regards,

 

				esq.addAggregationSchemaColumn("[Product:OrderProduct:Order].UsrCost",
						this.Terrasoft.AggregationType.SUM, "ProductCost");
				esq.addAggregationSchemaColumn("[Product:OrderProduct:Order].UsrProfit",
						this.Terrasoft.AggregationType.SUM, "ProductProfit");

//Only if category of product is xxxxx sum the price
				esq.addAggregationSchemaColumn("[Product:OrderProduct:Order].UsrPrice",
						this.Terrasoft.AggregationType.SUM, "ProductProfit");

 

Like 0

Like

1 comments

Hello Federico,

Unfortunately, there is no way to create a complex query with subqueries via client ESQ.

You can create a business-process that will perform the request to the database, fetch all needed data, process it and display on the page.

Show all comments
7.12
sales_enterprise

Hello Community! I want to export only the data into a pachage like a file to another site. Is that posible?

Like 0

Like

1 comments

Could you clarify your business case (what you are trying to do) or give an example/more information on the end result?

If you mean just the values in a lookup: 

I know you can export data that is bound to a lookup within a package. I do not think you can create a different package and then recreate an object within that package to transfer the data connected to said package. You would have to use the same package.

If you mean data from a section (records), excel my friend. Use the excel exporter tool in the Action drop-down.

Hopefully with more information I can help further! 

Show all comments
integration
postman
DataServices
REST
7.12
sales_enterprise

Hi Everyone,



I have a case about data integration using DataService (JSON).

I have read documentation but I can't cleary understand cause example use C# languange, I'm not comfortable with that.



I have try using postman to integration DataService, but I have a trouble,

Below screenshot setting in my postman:



1. I access the login for get the cookies for Auth, I dont have any problem in Auth login.

2. I access url DataService, but I got a problem, I can't access the page what I want, the response is 403. I'm sure when I access the url I have put the cookies from auth login.

What's wrong in my method ?

Anyone have a same case or can give me some example to use DataService beside using C# language ?

Or any advise / suggest ??

 

Thanks.



FYI: I try in local BPM



SOLVED:

Check again header cookies, csrf, and format data JSON will sent to web service bpm'online.

And you can implement data service using any language along support JSON and http request.

Like 0

Like

3 comments

Hi Romadan, 

Have you tired the business process web call element? You could even try the script element.

I had the same issue and it looked to me that you have to use the C# language. 

 

Dear Romadan,

Firstly, based on the error, it is most likely, that authorization hasn't passed well. Please make sure, that you have done all the steps described in the article as an example, particularly adding needed namespaces for the DataService to work, as well as, adding methods to authenticate and create records.

https://academy.bpmonline.com/documents/technic-sdk/7-12/dataservice-adding-records 

Also, yes, as Philip already mentioned, you have to use C# language. Moreover, you can see the example of the working InsertQuery by opening web debugger application like Telerik Fiddler and tracing the insert action made within the bpm'online system. You will find all needed information on what InsertQuery is made of, as insert, update, delete queries in the system are executed by the means of DataService.

To sum up with, if you are not comfortable to use C# language I would recommend to use OData protocol instead. Please see the implementation of OData requests with its examples in the system:

https://academy.bpmonline.com/documents/technic-sdk/7-12/possibilities-bpmonline-integration-over-odata-protocol

Finally, here is a documentation on how to call configuration services using Postman:

https://academy.bpmonline.com/documents/technic-sdk/7-12/how-call-configuration-services-using-postman

Hope you find it helpful!

Regards,

Anastasia

Thanks Anastasia Botezat for your feedback.

I have solved this problem.

The problem is like you say. I dont complete passed auth in header, and have miss passed data json to web service bpm'online.



Philip Wierciszewski, I success implement data service using another language beside use c#.

Show all comments
7.12
sales_enterprise

Hello, 

Is there a way to produce printables and save their file name according to fields in the system?

Eg. Printable name to be saved in a users PC as "ClientCode_OpportunityName_ClientAmount$"

 

Thank you,

Much appreciated 

 

 

Like 0

Like

2 comments

Dear Thanos,

You need to create a replacing schema for PrintReportUtilities and overwrite the current logic. This is the out of the box logic used for naming the file:

    getCaption: function() {

            var baseCaption = this.get("Caption") || this.get("NonLocalizedCaption");

            return baseCaption + ((this.get("ConvertInPDF") || this.isDevExpressReport()) ? ".pdf" : ".docx");

        },

Feel free to develop your own logic overwriting it according to your needs.

 

With best regards,

Oleh

Oleh Chudiiovych,

Hello Oleh,

Thank you for your response. Thats perfect, however, how difficult would it be to amend that code and name the file according to those two field "UsrClientCode_UsrOpportunityName"? What would that look like (I dont have much experience with coding)

Thank you

Show all comments

Hello, 

 

I am wondering if a business process is started by a trigger, could that trigger also happen on the database side? (Example SQL script adjusting value in db so that a business process should be triggered).

 

This is the process in question:

 One the boolean flag is "1" process is suppose to run. 

 

If this is not how business processes are meant to run, how else could we trigger this business process via a database value changing? Would we have to use the DBExecutor, or other c# code on the section itself?

 

Thank you. 

Like 0

Like

1 comments

Dear Philip,

The business process won't be triggered on update/insert made directly into the database either from script task or directly via database system query.

The best option would be updating/inserting via script task within another business process where you should write the query that alters the field value with the help of EntitySchemaQuery (the manual is available in the Academy)

Oleh

Show all comments