Dear,

I want to add a calculated fieldto my OpportunityProductInterest object.

i add it with the Usr prefix (UsrMarge) , but when i save the object, the system return me the following error:

Unable to save structure. Name: OpportunityProductInterest. 
Label: Product of the opportunity. 
Error: InvalidNameException. 
The "Min Quantity" code in the "From" column must start with the prefix "Usr". 
Contact the system administrator.

This is because the previous developper created fields without the prefix.

Can i change the system parameters to set the prefix not required ?

Thank you,

Nicolas

Like 0

Like

1 comments

Hello community,

 

Earlier, we would not be able to access the database directly on Creatio SaaS cloud installations and would have to reach out to Creatio support for any assistance. Does this still continue or is there a roadmap to enable direct database access even in the Creatio cloud offering?

 

If we still do not have access,

  1. How does one approach enterprise level heavy volume data migrations in the context of the Cloud? Typically these are done directly through the Database either via SQL scripts or via ETL tools. 
  2. We are aware of ETL plugins like Starfish ETL, we want to understand options besides that - where access & control at the database layer is required to execute these migrations. How have other customers handled this scenario?
Like 1

Like

4 comments

Dear Shrikanth,

 

Due to security reasons the direct access to the databases is not available. If there is a necessity to migrate some data from\to Creatio - the enterprise level customers use different integrations via webservices, OOTB API and Odata, DB server linking, ftp\sftp storages and different custom API integrations. SQL scripts can be also involved.  

The direct connection with our cloud and customer's storages is never set up due to the security policies. Usually there can be some shared storage where customers send their data and it is imported into our cloud.  As for Starfish ETL, it is also used but not frequently. Usually enterprises use their own integrations.

 

Regards,

Dean

Dean Parrett,

 

Could you elaborate on the "DB Server Linking" part here, Dean? Thanks

Dear Amanthena,

 

This is typical on-site\non-cloud integration. It's basically looks like this:

Creatio database<--->buffer database<--->customer's storage.

Typically the buffer database is kind of shared storage for customer and Creatio used to import and export data to both sides. It is typically used on regular basis rather than one time data migration.   It has some particular access rules assigned to the required tables. It is not usually used for migrating data into Cloud database due to some security limitations, however some enterprise customers have similar solutions where Web server is connected to similar storage and it pulls data into Creatio. Again, server linking is not really commonly used for cloud integration solutions, however, under some conditions, specific setup and prior negotiation with cloud team- it may be possible. If you are interested in it, I suggest you to discuss it with your account manager.

 

Regards,

Dean    

I have done data migrations directly to the database on several occasions with no issues. The most challenging part is the creation of the access rights records (well, not really challenging once you figure out the RightLevel 0=read/1=edit/3=delete, Position, SourceId=user/role values, but something to be aware of). Each table has a separate table that stores access rights for the records, for example for Contact it stores it's access rights records in SysContactRight. For objects with record level permissions, you need to create these records to give read/edit/delete permissions to the records. However, in recent versions of Creatio the object permissions propagate to records nicely, so I would likely turn off record access rights for the migration, then set afterwords and let Creatio do that work. 

In my scenario, I had a customer with multiple millions of records. They are cloud hosted, so I had support provide me with a database backup, I performed the migration, then provided the complete database loaded with data back to support as a backup and they put in place on the cloud again. This was significantly faster to load using SQL inserts from selects etc than loading record by record via the API. Keep in mind that if a customer is first a cloud customer, the backup you get from support is likely going to be a Postgresql database, not MSSQL. In another scenario, with Creatio on premise, creating views that combine data from other SQL databases and exposing as objects in Creatio was very straightforward as well.

Hope this helps.

Ryan

Show all comments

Hello Community,

 

Logging of incoming and outgoing API requests via Custom configuration services in Creatio is a very typical use case wherever system integration is in the picture. Logging the absolute URI, request/response body, response status code, any custom headers added to the request are standard in any enterprise system. 



I could not see any utilities or out of the box features to help log these requests. This is right now done by maintaining custom tables in the DB and logging any incoming or outgoing requests through custom logic.

 

The following features would help - 

  1. Logging inbuilt into the WebService element. It would help to have all outgoing requests using WebService elements be auto logged in the data base and be available for quick reference on the UI. An additional idea could be enabling a 'manual retry' option from the UI for use cases where an outgoing request failed  even after N number of configured retries.
  2. Utility or helper Classes on the server side which assist in tracking outgoing or incoming requests in the data base. A UI view of these logged requests could also help. Right now, we have to use 3rd party logging solutions like Loggly and write custom logic to maintain these logs.
2 comments

Hello!

 

Our R&D team has a problem registered on this topic on their side so to enable easy logging setup in the application UI for custom web-services and this problem is in the "Accepted" status so we can expect this logic implementation in one of the nearest releases. I will also let them know about this community idea so to speed up the problem solution.

 

Thank you for reporting this issue to us and helping us to make the application better!

 

Best regards,

Oscar

Oscar Dylan,

Thank you Oscar.

Show all comments

Dear,

I want to add the "UsrUniteDeVente" product field on my opportunity print.

But when i want to select the field, i can not select it, it is not in the list:

Is it possible to add this field on my printable ?

Thank you,

Nicolas

Like 0

Like

2 comments
Best reply

The issue is that the value has a 1:many relationship with the opportunity. The opportunity can have multiple products added, so which one would display? In this case, you should add this using "Set up report tables" which would result in a table or list of the products added to the opportunity.

Ryan

The issue is that the value has a 1:many relationship with the opportunity. The opportunity can have multiple products added, so which one would display? In this case, you should add this using "Set up report tables" which would result in a table or list of the products added to the opportunity.

Ryan

Thank you Ryan

it was exactly what i was looking for

Show all comments

Hello colleagues,

 

Can I start a conversation with a contact using Telegram from Creatio? how?

 

I didn't see the possibility to add Telegram as a "Communication option"

 

Thanks in advance

Like 0

Like

2 comments

Hello Julio, 

 

Unfortunately, there is no possibility to start the chat with existing contacts from the system. The chat feature enables you to receive requests from external users at the moment. We will raise the idea for R&D team to implement this feature for chats in further releases. 

 

You can find more detailed information about chats in the Communications - Work with chats Academy article. 

 

Best regards, 

Olga. 

Olga Avis,

Thanks Olga

Show all comments

Dear,

i would like to disallow town and state creation on my address page.

Why is not the section wizard reachable ?

So i can not add a business rules... :'(

 

Does anybody can help me ?

Thank you,

Nicolas

Like 0

Like

1 comments
Best reply

Sorry i ve got it

i needed to go into the detail parameters...

Thank you !

Sorry i ve got it

i needed to go into the detail parameters...

Thank you !

Show all comments

How to integrate Squarefour landing pages with Creatio Leads and/or Accounts  and/or Contacts

Like 0

Like

1 comments

Dear Guido, 

 

As far as I know there are no known examples of such integration with Creatio. 

However, you can check these academy articles which can be pretty useful in case if you want to configure landing pages or create any integrations with your Creatio system:

Here is the article with instructions on how to set-up your landing page to integrate with Creatio

And this article will be useful in case if you need to create an integration between your website and Creatio. 

 

Kind regards,

Roman

Show all comments

Hello Team,

 

I'm experiencing a problem in the installation process for "Data binding tool for Creatio" market place app, when the configuration dll's compilation starts the installation fails and returns this error:

 

Autogenerated\Src\GlbDataBindingHelper.GlbDataBinding.cs(323,47) errore CS0246: The type or namespace name 'EntityDataSource' could not be found (are you missing a using directive or an assembly reference?)

 

Like 0

Like

2 comments

Hello Stefano,

 

Thank you very much for your post.

 

The error has been fixed by the responsible team. Please install the updated package from Creatio Marketplace.

 

Have a good day!

thank you Svetlana!

Show all comments

Dear,

Does an add-on that would show customers on a map exist ?

For example, a saler wants to know all accounts near the place he is.

Like this:

Thank you

Nicolas

Like 1

Like

5 comments

Dear Nicolas,

 

The is such option by default nor similar addon on the marketplace. We've registered your idea in our R&D team backlog to consider such implementation in future application versions.

 

Regards,

Dean

Is it exists in newest version? 

Dear Dmytro,



This functionality wan not implemented in the new version. Our R&D team still working on that.



Best regards,

Bogdan

Hi Nicolas,

 

Creatio Marketplace has a mapping tool called Mapsly that can geocode your accounts based on coordinates/address and display them on the map.

i did it with Toolkit to setup map view for Creatio

and following this guide

thank !

Show all comments

Hello,

 

We need to evaluate how to build a report to send using bulk mails monthly to customers.

 

The complexity is the report must have different typo of data, from different sources including also some graphs as you can see on the attached image,

 

Can I did it using some marketplace Creatio addon?

Like 0

Like

3 comments

Hello, Julio!

 

There is no such option by default, but here are some marketplace apps that may cover some of your tasks:

https://marketplace.creatio.com/template/send-email-attachments

https://marketplace.creatio.com/template/send-monthly-sales-report

https://marketplace.creatio.com/app/printable-attachment-email-creatio

 

Regards,

Dean

Dean Parrett,

Thanks Dean, 

 

Even if I use FastReport? I understand if I use Fastreport, I can achive it or not?

Dear Julio,

 

No, the is no such mechanism that could take data from multiple places in the system, make a report out of it and send it, for example, in an email. There are only some partial workarounds that I've sent but they work separately.

 

Regards,

Dean

Show all comments