Studio Creatio | Community Creatio

datamigration

datamodels

Import

json

schema

database

Studio_Creatio

8.0

Import existing database schema or json into creatio datamodel

Pascal

18:12 Nov 17, 2022

Is it possible to export an existing database schema into a creatio datamodel? Or from an ERD Data export?

I use lucidchart to create a model of my database, it has export functions for MySQL, PostgreSQL, SQL Server, Oracle SQL and a similar platform as creatio, Quickbase.

Does creatio support such an import wizard?

1 comments

Gleb

13:13 Nov 18, 2022

Hello Pascal,

unfortunately this is not quite possible.

The thing is that you can export the DB in such way, but you will not have any objects in the system.

So we would recommend sticking to the standard way. Also, we will register this option as a wish for the dev team to implement it in the future.

Regards,

Gleb.

Show all comments

webservice

collection

save record

Loop

Studio_Creatio

8.0

Saving each record in webservice collection to a record in a table

Pascal

13:25 Nov 17, 2022

I am trying to save data from an API call, it returns a collection of records. I wish to save these into a table. I do not know how to loop through this collection and save each as a record. Please advise.

2 comments

Best reply

Bhoobalan Palanivelu

13:37 Nov 17, 2022

Hi Pascal,

This can be achieved via OOTB no-code tools of Business Processes.

The response collection of an API can be sent to a sub-process with parameter filled and it can be set to run sequentially so that all the response data will be successfully inserted into the table.

Here is the article, https://customerfx.com/article/working-with-collections-from-a-web-service-element-in-a-process-in-creatio/

BR,

Bhoobalan Palanivelu.

Bhoobalan Palanivelu

13:37 Nov 17, 2022

Hi Pascal,

BR,

Bhoobalan Palanivelu.

Harvey Adcock

23:25 May 08, 2024

The subprocess method is very poor performance for larger datasets though, and so when we had this problem we ended up having to write C# for it. These aspects need to be improved by Creatio if their desire is to continue to push their platform as being effective at scale with no code solutions.

Show all comments

Studio_Creatio

7.17

Email sending

Tomasz Branicki

12:35 Nov 17, 2022

Hi;

I try to redirect sendig eMails from Creatio from SMTP account to our custom api responsable for communication in company

Is this easy way to do this not changing Creatio process working on SendEmail element

Regards;

Tomek Branicki

2 comments

Gleb

15:56 Nov 17, 2022

Hello Tomasz,

unfortunately, it is not quite clear what exactly you want to achieve.

Creatio sends emails where you want it to, without redirects.

Kindly ask you to explain in details what is the goal of the operation.

Regards,

Gleb.

Tomasz Branicki

17:25 Nov 17, 2022

Hi,Gleb,

Thanks

Creatio use the ExchangeListnerApi which use the SMTP based Account for sending email

I try to redirect the request to Listner to our custom rest api creating for communication manegement

Show all comments

maps

Adding

install package

Studio_Creatio

8.0

Problems with Toolkit to setup map view

Anas Iyad Ahmad Ibrahim

12:43 Nov 16, 2022

Hi All,

I Installed the toolkit for map view(https://marketplace.creatio.com/app/toolkit-setup-map-view-creatio ) but when I tried to follow the guide I stuck in second step, I didn't find "BaseModulePageWithMap" in the card schema.

I created my section within a new package, also I added the dependencies to my package but I didn't find "BaseModulePageWithMap".

2 comments

Best reply

Eugene Vorobiov

12:24 Nov 30, 2022

Hi!

I have checked this add-on and was unable to reproduce the issue. The steps I took are as follows:

1. Install the add-on.

2. Create a package and set dependencies.

3. Create a custom section that includes a page.

4. Open the page source code in the configuration and change the parent object to "BaseModulePageWithMap."

Could you please tell us the steps you took?

Eugene Vorobiov

12:24 Nov 30, 2022

Hi!

I have checked this add-on and was unable to reproduce the issue. The steps I took are as follows:

1. Install the add-on.

2. Create a package and set dependencies.

3. Create a custom section that includes a page.

4. Open the page source code in the configuration and change the parent object to "BaseModulePageWithMap."

Could you please tell us the steps you took?

Anas Iyad Ahmad Ibrahim

14:34 Nov 30, 2022

Yevhen Vorobiov,

Thanks a lot, it works now

Show all comments

#SaaS

Studio_Creatio

8.0

Do you have detailed specifications for SaaS?

KEIGO SHIMIZU

02:04 Nov 16, 2022

hello!

Is there a document (PDF, URL) that describes the detailed specifications of SaaS?

For example, I'm looking for a document with the following description!

・ Basic configuration of SaaS license purchase (number of virtual cores, memory capacity, database storage capacity, outbound traffic limit, inbound traffic limit, etc., development, verification, existence of DB for each production environment, etc.)

・Is it possible to change the configuration of the SaaS server (addition of servers, DB integration, etc.)

・Addition of front-end server

・Addition of development environment

・Addition of verification server

・Add production environment

・Increase the CPU and memory of the front-end server

・Additional CPU and memory for development environment

・Additional CPU and memory for verification server

・Additional CPU and memory for the production environment

- Third-party products cannot be installed in the CreatioSaaS environment.

・Is it possible to directly connect to the Database Server?

・Is it possible to create Tables and Views on the Database Server?

・The timezone of all servers on PaaS is fixed to "UTC" and cannot be changed.

・Can you use the “Multiple Database Catalogs and Schemas” function?

Is it possible to use the Zones function that can specify the front-end server that operates for each application?

・You cannot use the authentication function by client certificate.

・Is it possible to consider Japan time for backup cycle and recovery operation?

・At the time of a major version upgrade of the product, will the customer environment be forced to undergo a major version upgrade by a certain period of time?

・The version upgrade schedule will be handled after adjusting the schedule in advance with the customer, but can you specify the postponement of the version upgrade beyond a certain period?

・Is it possible to access the DC and FE server by remote desktop?

・How to connect to CreatioSaaS if the customer has a separate contract with AWS

・Whether it is possible to take a backup of the DB in a DB that exists in a physically different location (for natural disaster countermeasure purposes)

1 comments

Mira Dmitruk

15:18 Nov 18, 2022

Hello,

Please note that having questions of this kind it is better to contact us at info@creatio.com to receive the needed information.

Show all comments

FileDataType

Studio_Creatio

7.16

How to work with the "File" data type in the lookup

Dmitrii

13:31 Nov 15, 2022

I want to store in lookup records .xls file for your c# code. In the code , I 'll just take .xlsx file and use it further. I can create a field with the "File" data type for lookup, but I can't display it in lookup. How to work with such a field in general?

File attachments

FileTemplate.png

1 comments

Dmytro Vovchenko

17:23 Nov 18, 2022

Hi,

I recommend you to take a look at the attachments detail. When you upload a file to it, in the column "Data" you can see the value that you can use in your code (note, this field would be empty if you store files not in the database). If it format doesn't satisfy you, then you can change it, for example cast('' as xml).value('xs:base64Binary(sql:column("ivf.Data"))', 'varchar(max)'. As far as I know, you cannot store File values in the lookup column, only if you create an object with File column inside and use this object.

Show all comments

lookup

Adding

Unique

Studio_Creatio

8.0

How to check if the entered value exist already in the lookup

Anas Iyad Ahmad Ibrahim

13:43 Nov 14, 2022

Hi All,

I've created a lookup, when I Click "New" I can Add a value to it.

My question is: How to add only unique values to the lookup and prevent user from entering repeated value.

Thank You.

2 comments

Bhoobalan Palanivelu

17:09 Nov 14, 2022

Hi Anas Iyad Ahmad Ibrahim,

For all the records that get inserted into the Creatio table (Objects: section, details, or Lookup) the inserted record is distinguished by the "Id" (GUID Type) column which is a unique identifier for the record.

If an additional column has to be considered into account before inserting a record, then a custom implementation has to be made to validate the additional field value.

Please click, view and select display columns and add Id, and Name. Then Id field will be displayed with a unique value for each record.

BR,

Bhoobalan Palanivelu.

Anas Iyad Ahmad Ibrahim

09:14 Nov 15, 2022

Bhoobalan Palanivelu,

Thanks a lot

Show all comments

lookup

Adding

Studio_Creatio

8.0

How To Add record to lookup from Lookup field in specific Section

Anas Iyad Ahmad Ibrahim

12:20 Nov 14, 2022

Hi All,

I want to add a record to my lookup but not from lookup page, I want to add it from my section Page, How Can I Do That?

1 comments

Best reply

Anas Iyad Ahmad Ibrahim

13:38 Nov 14, 2022

it's solved, for who facing same issue please find this link:

https://community.creatio.com/questions/new-button-lookup

Anas Iyad Ahmad Ibrahim

13:38 Nov 14, 2022

it's solved, for who facing same issue please find this link:

https://community.creatio.com/questions/new-button-lookup

Show all comments

Studio_Creatio

7.18

Hide "+" on Column Setup

Sourav Kumar Samal

14:23 Nov 11, 2022

Hi Community,

I want to hide the "+" button shown below, during column setup. The expectation is that the user should only select the current object's columns. This functionality is similar to Customer Portal users as it is not visible to them.

Is there a way to hide this for normal users also? Any suggestions will be appreciated.

Regards,

Sourav

1 comments

Dmytro Vovchenko

16:40 Nov 14, 2022

Hi,

The code for this button is:

{
						className: "Terrasoft.Button",
						visible: {
							bindTo: "ExpandVisible"
						},
						click: {
							bindTo: "expand"
						},
						markerValue: "addObject",
						imageConfig: resources.localizableImages.ExpandImage,
						style: Terrasoft.controls.ButtonEnums.style.TRANSPARENT
					}

It is defined in the schema StructureExplorerViewConfig. As you can see, the parameter "visible" is bonded to the attribute ExpandVisible.

This attribute is located in the schema StructureExplorerMainViewModel and you can override this schema and set any value you want to it based on the needed condition.

Show all comments

Freedom_UI

minipage

Studio_Creatio

8.0

Freedom UI support for mini pages

Jeremy Couzens

20:07 Nov 09, 2022

I'm just getting started working with the new Freedom UI. One thing I'm not able to find any information on is if the new Freedom UI supports mini page popups. If not, is there a something that has been deemed a suitable replacement for that? If not, any plans on the roadmap to add support for this?

Thanks!

Jeremy

5 comments

Ihor Skohariev

13:57 Nov 16, 2022

Hello Jeremy,

Unfortunately, the support for mini pages for Freedom UI is not released yet. I created an idea for our developers to adopt this functionality in the future.

Thank you,

Igor