Hello,

There is no place to see that in Creatio. But you can use SQL script that shows the size of all tables in the database, so you can see the size of AccoutnFile, ContactFile, OpportunityFile tables and so on.

 SELECT

  t.Name                                       AS TableName,

  s.Name                                       AS SchemaName,

  p.Rows                                       AS RowCounts,

  SUM(a.total_pages) * 8                       AS TotalSpaceKB,

  SUM(a.used_pages) * 8                        AS UsedSpaceKB,

  (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB

FROM

  sys.tables t

  INNER JOIN sys.indexes i ON t.object_id = i.object_id

  INNER JOIN sys.partitions p ON i.object_id = p.object_id AND i.index_id = p.index_id

  INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id

  LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id

WHERE

  t.Name NOT LIKE 'dt%'

  AND t.is_ms_shipped = 0

  AND i.object_id > 255

GROUP BY

  t.Name, s.Name, p.Rows

ORDER BY

  t.Name;

Regards,

Dean

Hi Gabriele,

We need more data to reproduce the issue:

1. Is this error specific to a single opportunity, or is it triggered for every opportunity?

2. Does your report have any text columns with HTML markup (for example, Notes or Feed messages)?

Hi Alexander Demidov,

1 - the error is triggered for every opportunity

2 - no

The problem seems to be in the "handling" of the excel file.

Here an example of a template:

https://www.dropbox.com/s/p8z7hpwh0evbx4t/PBU_1.xlsx?dl=0

In the previous version the problem was not there.

Best regards

Hi Gabriele,

You are correct. The most likely cause of the error is the Excel template itself. Please create a similar report without a template. Download the report and use the file as a basis for the template. Add one worksheet at a time to the file and test it.

Amritha ,

Any object created by the campaign (e.g. activity) is automatically connected to the contact entity via business logic of the campaign. There's no need to connect it manually. 



Best regards, 

Yurii. 

Hello,

The macros take the actual value in the database. If you have 10,000,000.00 on UI, in the db you will have 10000000.00. That's why macro value has no separators. Currently it is not possible to add comma separators in macros. We have active task in our backlog to implement this logic for macros as well, but it will be available in future application versions.

Regards,

Dean

dean parrett,

Has there been a release to fix this issue?

As far as I can see it has not changed.

Kieron Moran,

We have checked this and this functionality has not been implemented yet. 

Mira Dmitruk,

Do you know when it will be implemented? The original question was asked 2.5 years ago.

Kieron Moran,

Hello,

Unfortunately, we do not have an exact ETA at the moment.

Once it is implemented, it will be mentioned in the Release Notes at https://academy.creatio.com/docs/release

Best regards,

Yuliya

Hi Nagaraju,

To run this action once per month a business process with a timer can be created that will create a scheduler task. And then you can either add a script task to the process, or use read data and read a collection of records or implement any other logic required.

Best regards,

Oscar

Hi Akshit,

it is not possible out-of-the-box. However, there are some (paid) marketplace add-ons that enable you to do this.

Another way would be to programmatically add the functionality on your own, but you will need some SMS gateway to send the messages, which will usually cost something.

There is an example in the academy about how to add a custom marketing campaign element for sending SMS here: https://academy.creatio.com/docs/developer/elements_and_components/marketing_campaigns/marketing_campaigns#title-1457-3

BR,

Robert

It is possible to use Web service in your business process to send SMS via a lot of SMS providers

Hi Gokul, 

Here are some examples how you can implement it : 

1. By using direct SQL queries 

https://customerfx.com/article/executing-direct-sql-statements-in-a-pro…

2. By using "Select" class 

https://academy.creatio.com/documents/technic-sdk/7-15/retrieving-infor…

3. By using client side logic (but modifying this code according to your business logic) example below

var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "Activity" });

 

esq.addColumn("Account.UsrINN", "AccountINN");

var column = esq.addColumn("ModifiedOn");

column.orderDirection = Terrasoft.OrderDirection.ASC; 

 

esq.rowCount=1; 

 

esq.filters.addItem(esq.createColumnFilterWithParameter(3, "Account.UsrINN", "7730616959")); 

 

esq.getEntityCollection(function (result) {

    if (result.success && result.collection.getCount() > 0) {

        var item = result.collection.getByIndex(0);

        var INN = item.get("AccountINN");

        var modOn = item.get("ModifiedOn");

    }

}, this);

P.S. Please refer the post below about ESQ access rights, that could be also useful for you 

https://community.creatio.com/questions/access-issue-esq

Hi Nageswara, 

Firstly please check the "QueueItem" object and set up checkboxes according to your further events

If you activate this checkbox (on Updating as you need) you will see new field below which was generated automatically. The value of that generated field will be used as trigger for the object process. In your case the override method will be "IsInserted" , where your logic is implemented. 

Here is more information : 

https://academy.creatio.com/docs/developer/back-end_development/entity_…

Best Regards, 

Bogdan L

Bogdan Lesyk,

Thanks for the reply Bogdan,

We did the same thing here, but we are unable to debug the code in VS, We put a break point on method OnInserted() mode but it is not hitting the break point when a QueueItem record  is inserting, but somehow it is inserting in DB.

Can you pls help on this?

Best Regards,

Nageswar

Hello Shivani,

Add the following CSS for this:

#mainHeaderContainer.opened-right-panel #header-command-line-container {
    display: none;
}

When the right panel opens the command-line (what can I do for you?) will disappear. When it closes it will reappear. See https://share.customerfx.com/xQubRjWj

Ryan

Additionally, if you only wanted to do this when the screen resolution is less than 1440px you could add the following: 

@media only screen and (max-width: 1440px) {
    #mainHeaderContainer.opened-right-panel #header-command-line-container {
        display: none;
    }
}

Ryan

Thanks Ryan! This works!

Hello,

The lead management process is called upon clicking the "Qualify" button on the lead page:

The logic of the button is stored on the LeadPageV2 schema:

The onLeadManagementButtonClick method is a part of LeadManagementUtilities and you can also study the implementation of the process call there.

Best regards,

Oscar