Hi Marcin,



To set the model to learn prediction based on similar customers purchases you should add the following columns to the query:



Id (just an identifier)

user_id (a user)

item_id (something purchased by the user)

value (how much did the user purchase, but you can leave it 1 if it's important to see the fact of a purchase)



You should add those values to additional metadata as it is shown here:

https://academy.creatio.com/documents/technic-sdk/7-16/how-implement-custom-prediction-model

You can find more information regarding queries here:

https://academy.creatio.com/documents/technic-sdk/7-16/creating-data-queries-machine-learning-model?document=administration



Unfortunately, we don't have a separate article regarding this type of ML model (Recommendation).



Thank you.

Bohdan Zdor,

Thank You for explanation. To better understand this tool please clarify me some concerns:

Is this “advanced tools to add columns” overrides basic training data set resulting from “Recommendation dependency” query or this is additional data which are corellared with basic query ?

I mean .. “Query for selecting additional training data”, “Query metadata for selecting additional training data”.

I yes, then what is principle to building additional select ("new Select") to maintain relation between 2 queries (basic and advanced) ? Eg. that selected object should be the same (“Recommendation dependency” = "select .. From x"), what else ?

“Query metadata for selecting additional training data” – In posted documentation

https://academy.creatio.com/documents/technic-sdk/7-16/how-implement-custom-prediction-model?_ga=2.41994279.328510928.1596630980-1487324197.1596630446

additional columns are set:

{

    "inputs": [

        {

            Id

        },

        {

           attr1

        },

        {

           attr2

        }

    ],

    "output": {

        attr3

    }

}

In recommendation case in "inputs" tag i may add Id and eg. Account Country, Account Category ??

What I have to add then in "output" tag ?

In Your example I understood that as a input I have to add

Id -> Object Id

user_id -> Account Id

item_id -> Product Id

value  -> Quantity

when eg. Query data set is a “Product in Quote”, right ?

Regards,

Marcin

Marcin Kott,

Advanced parameters are merged with parameters that are formed by standard tools and as a result are formed one common set of parameters. Moreover, in the advanced settings, you can also specify additional filtering parameters.

For recommendation models, no "additional" parameters need to be passed, since the models are trained on transaction data, or any other interaction of the client with the product, for example, the product in the order. The model will not accept any other parameters.

Extended selection is needed for these models, for example, in order to combine data on purchases of goods and views of goods on the site. Then a selection is written that somehow aggregates this data, but as a result, it is necessary to still get a selection of the type - client, product, number.

In recommendation case in "inputs" tag i may add Id and eg. Account Country, Account Category ? - It is impossible to divide this way, since the selection should contain only Id (just an identifier)

user_id (a user)

item_id (something purchased by the user)

value

Finally, there are actually two options for recommendations – selection by standard tools or completely form it using a custom query.

Best regards,

Norton

Hi Ankit,

Pivot tables were developed using angular in our system and connected to the app as custom element and use shadow dom for styles encapsulation. And the screenshot cannot be done because of the shadow dom. Screenshot is performed using html2canvas library and it has an issue on GitHub https://github.com/niklasvh/html2canvas/issues/430. We tried updating the html2canvas library to the latest version but the error still reproduces and we are now working on developing our own rendering. So as for now there is no workaround for this problem, but using third-party screenshot tools.

Best regards,

Oscar

Hi Allen, 

In order to remove "Select multiple records", "Apply filter", "Sort by" you can do the following: 

1. Create a replacing client module schema for the detail schema. Here is the article on how you can do it:

https://academy.creatio.com/documents/technic-sdk/7-16/creating-custom-…

2. In a replaced client schema, please override method addGridOperationsMenuItems as in the example below:

define("UsrSchemac2207388Detail", [], function() {
  return {
    entitySchemaName: "UsrPets",
    details: /SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
    diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/,
    methods: {
      addGridOperationsMenuItems: function(toolsButtonMenu) {
        const switchGridModeMenuItem = this.getSwitchGridModeMenuItem();
        if (!switchGridModeMenuItem) {
          toolsButtonMenu.addItem(this.getButtonMenuSeparator());
          toolsButtonMenu.addItem(switchGridModeMenuItem);
        }
        const exportToExcelMenuItem = this.getExportToExcelFileMenuItem();
        if (exportToExcelMenuItem) {
          toolsButtonMenu.addItem(exportToExcelMenuItem);
        }
        const fileImportMenuItem = this.getDataImportMenuItem();
        if (fileImportMenuItem) {
          toolsButtonMenu.add("FileImportMenuItem", fileImportMenuItem);
        }
        Terrasoft.each([
          this.getGridSettingsMenuItem(),
          this.getRecordChangeLogMenuItem(),
          this.getObjectChangeLogSettingsMenuItem()
        ], function(buttonConfig) {
          if (buttonConfig) {
            toolsButtonMenu.addItem(this.getButtonMenuSeparator());
            toolsButtonMenu.addItem(buttonConfig);
          }
        }, this);
      },
    },
  };
});

If you want to do that in all details you can override BaseGridDetailV2 and override the method in the same way. 

Best regards, 

Anastasiia

Hello,

Such an option is not available for fault-tolerant installation. 

Fault-tolerant architecture implies that when one node fails, users will be able to work with the neighbouring one. If two neighbouring nodes are different, then this is no longer a fault-tolerant architecture, but two different applications.

Best regards,

Angela

Dear Adharsh,

All controls (including Terrasoft.IframeControl) inherit from the “Terrasoft.Component” class that is located in the “component.js” file. The “Terrasoft.Component” class is designed in such way that on “reRender” function it inserts html content of the control into DOM twice https://prnt.sc/tl2f68. The old “wrapEl” object is destroyed and replaced by the new one - https://prnt.sc/tl2tnu.

In order to fix this behavior, it is necessary to perform a very detailed analysis of how it can be done differently. Moreover, take into account the regression since this is the basic mechanism for all controls.

Please note that we notified the development team about your request.

Best regards,

Norton

Norton Lingard,

Thanks!

Dear Adharsh,

Most probably, the issue happened because you didn’t specify a body of the request. The body contains file data in binary format. You can see it in the “Request payload” section from the “Headers” tab:

As data is in the binary format, so it is impossible to call the “FileApiService” using Postman. Please debug the client code of the application in order to determine how this service is called in Creatio.

Best regards,

Norton

Norton Lingard,

I have specified the request body, to add the binary files in Postman by adding the binary file in the "Body" tab of the "binary" option. But still the same result.





Even I have added the actual file in the "form-data" option under the "Body" tab. But the same error persists. Let me check by debugging the client code.



Regards,

Adharsh S

Dear Adharsh,

Please debug the client code of the application in order to determine how this service is called In Creatio. Please take a look at the “upload” function that is located in the “ConfigurationFileApi” schema.

Best regards,

Norton

Dear Kevin,

You can use Auto-generated page and show lookup with templates so the user could select them, or forward the user to Templates lookup. Process "Send email to case group" is a great example of how to fill macro values in the template and then send it as an email automatically. Check "Handle template for email with macros" element for more details. 

Best regards,

Angela

Hi Kevin,



I am curious what did you do to solve your problem?

I am experiencing a weird bug now actually. Every time i visit my business process it clears the templateId i set on advance mode.

Can you enlighten me?



Best Regards,

Solem

Hey Mark , In the detail page of the details you want  , add the accounts lookup and associate it on accounts page using the account lookup and Id. 

Hi Shailey

Thanks for your reply, but I am not following sorry.

When editing the page and tab and adding a 'New Detail' I cannot get the Account option in those expected to allow the connection to these data fields to be available and display data:

Would you be so kind and expand on your guidance, so I can follow and apply to our installation please.

Many thanks

Mark

Hello Mark,

As was mentioned by Shailey, at first you need to add the detail and after that set the detail page up to have the connection/lookups between needed sections of the system (like Accounts and Orders). For that you need to open the Section wizard in the Account section and create the detail in the appropriate tab (or create new one):

After that you should open any record in Account section and go to the seetings of just created detail:

In the detail settings window you can open the Detail Page and add needed lookups:

After configuration is set, don't forget to save changes. Then you need to open Account record and set the needed columns for the detail (use Column setup):

Order, Order Date (Date), Qty Price (Product in order (by column Order) - Quantity), Sold (Total, base currency).

As far as there is no strict connection between Account and Products (any account can have any products and different types of product), there is no possibility to show the Product name in the new created detail. That's why we can suggest to open the order and check the connected products there.

 

Best regards, 

Roman

Dear Adharsh, 

You can build a project in any way needed, you can find the project following this path in installation files: 

Terrasoft.WebApp\Terrasoft.Configuration\Terrasoft.Configuration.Dev.csproj

You can try building this project in a needed way to use SonarQube. 

Unfortunately, there is no specific coded analyzing tool for Creatio.

Best regards, 

Dennis 

Dennis Hudson,

Thanks

Hello Mohamed,

Seems that your 8089 has no process that listens to this port so that's why you cannot forward the listener to this port. Try running this command:

netstat -abn | findstr "LISTENING" | findstr "your host IP-address" | findstr "8089"

and check if this command shows the result.

Then try running

kubectl -n default exec -it creatioexchangelistener curl -v host_IP_address:8089

and let's check the result then (we will need to run kubectl describe pods creatioexchangelistener)

Best regards,

Oscar

Hi Oscar

Can you please provide me a YAML file to deploy the pod (Redis + Exchange Listener + Expose Service Address)?

Thank you

Mohamed

Mohamed Ouederni,

Hello Mohamed,

We don't have a separate YAML file for this proposes and Redis should be installed separately. All available .yaml files can be found in the exchangelistener-0.6.9.tgz file that is downloaded via this link 

http://ftp.bpmonline.com/support/downloads/Exchangelistener/exchangelis…

Best regards,

Oscar