Hello Community,

 

I have a few questions about GUIDs:

 

Q1. Is it possible to create custom GUID series for different standard objects? 
 

For example, can I generate custom GUIDs where every customer record starts with `0000001`, contacts with `0000002`, and orders with `0000003`?
  - Example:
    1. Customers: `0000001-3cfa-4daf-a93c-632cb2420805`
    2. Contacts: `0000002-4akk-5fhg-d19c-42080asb2420`
    3. Orders: `0000003-4akk-5fhg-d19c-42080asb2420`

 

Q2. Can I identify the Object Name just by looking at the GUID of a record?

 

Regards, 

Ajay

 

Like 0

Like

1 comments

Greetings!
 

Unfortunately, we do not recommend creating custom GUIDs, as this may lead to issues with the application.


You can copy the GUID, paste it into the search field in 
Configuration, and select "filter by contains GUID" for further filtering.


Regards,
Orkhan 

Show all comments

Hello Community, 

 

I wanted to read a base 64 string of an image which is in android device. Also have creatio application installed in Android device. 

Now, I wanted to read an image as base 64 string format in android device from creatio, 

When I tried to read, it says undefined or null. 

 

Can someone help me to resolve this issue? 

Any suggestions are really helpful. 

 

Thanks

Gargeyi.G

Like 0

Like

1 comments

Hello,

You can use C# and try to build a conversion script from the information in these posts:

How do I decode a base64 encoded string?

How do I encode and decode a base64 string?
 

A very similar question on our Community here.

Also, when the task is to upload a file to Creatio, the OData service is used for that purpose, here is an example:  https://community.bpmonline.com/questions/how-upload-attachments-odata
 

Hope it helps!

Show all comments

When will the Copilot be available to users? https://www.youtube.com/watch?v=aHHODz6dv04

Like 0

Like

1 comments


Hello,
Unfortunately, we do not have an exact ETA for releasing CoPilot yet. However, the first versions are planned to be released within this year. 

Show all comments

Hi community,

This is an out of the box problem, because i tried it in a fresh Environment as well.

Here is the issue.

We have the Leads section in the Classic UI, meanwhile the Account section is in the FreedomUI

1-We click to the Account link from the Lead Section:

2- We expect that the Form Page will open since we are not adding a new Account. Instead of the Form Page the MiniPage of the Account opens

3- Status of the Pages established for the account

How can we fix this issue?

Sasor

Like 0

Like

2 comments

Hi Community,

Any update regarding this?

Hello,

 

Please make sure that the "Default page" setting is set to the "Form page" in the Accounts object located in a package that is at the end of the packages hierarchy (it might be in the Custom package). 

This issue might appear if in one of such objects the "Default page" setting is set to "Mini page", which overrides the base settings.

Show all comments

Hello

 

It is posible to save a file in creatio from a base64 string? I have a web service that allows me to request a document by an id to an external service and it responds with the document in a base64 string, so I would like to know if it is possible to convert that string into the file and save it in some record on the platform.

 

Thank you 

Like 0

Like

2 comments

Something like this should work:

var base64FileString = Get<string>("Base64File");
var accountId = Get<Guid>("AccountId");
 
var attachFileType = new Guid("529bc2f8-0ee0-df11-971b-001d60e938c6");
var fileName = "SomeFile.docx" // set proper file type in file name
 
var entity = UserConnection.EntitySchemaManager.GetInstanceByName("AccountFile");
var fileEntity = entity.CreateEntity(UserConnection);
fileEntity.SetDefColumnValues();
fileEntity.SetColumnValue("AccountId", accountId);
fileEntity.SetColumnValue("TypeId", attachFileType);
fileEntity.SetColumnValue("Name",fileName);
fileEntity.SetBytesValue("Data", Convert.FromBase64String(base64FileString));
fileEntity.Save();

Ryan

Ryan Farley,

Thank you very much 

Show all comments

Hello everyone,

I hope you're all well. I need your help.

I'm having a problem using CREATIO to create products that all end in :
insert or update on table ‘ProductPrice’ violates foreign key constraint ‘FK6ZjAW6Pzi2p2Jqy6BQy6n2r0xlY’
Even so, if I refresh the page, the product is created.

Once I get to the order and want to add one of these products, I get another integrity constraint.
Do you have an explanation, or do I have to go through support?
Thank you very much for your help.
Thierry

Like 0

Like

2 comments
Best reply

Hello!

The issue could be caused by a missing Default value within the Base Price List System Setting. Please check this. 

If this does not help, please contact support@creatio.com

Best regards,

Anton

Hello!

The issue could be caused by a missing Default value within the Base Price List System Setting. Please check this. 

If this does not help, please contact support@creatio.com

Best regards,

Anton

Thanks a lot. 

Show all comments

Hi colleagues,

 

Somebody know how can I made the default column "Name" of a detail (in Freedom) not clickable? 

 

Thanks in advance

 

Regards

Julio Falcón

Like 0

Like

2 comments
Best reply

I'm not aware of anything you can add in the column properties to make it not clickable, but it's possible that there's something available (hard to know and it's not mentioned in the List properties). 

Would it work to just expand the Lookup column to map the display value column directly to the list? Also, if you never want it a clickable link you can remove the default page for the object (if that is something that would work for your scenario - obviously won't work for OOTB entities)

I'm not aware of anything you can add in the column properties to make it not clickable, but it's possible that there's something available (hard to know and it's not mentioned in the List properties). 

Would it work to just expand the Lookup column to map the display value column directly to the list? Also, if you never want it a clickable link you can remove the default page for the object (if that is something that would work for your scenario - obviously won't work for OOTB entities)

Ryan Farley,

Thanks Ryan, I created another field and when create a new record using a process copy the Name column value to this column and in the detail show this another... is not the very best, but works :-)

 

Thanks

Julio

Show all comments

Hello. 

 

I'm doing an Web services to send a document to sign, the api request the Url of the document so I'm using the following link https:[creatio instance]/0/rest/FileService/GetFile/70ec5d9f-a55e-4f5c-8f59-30d2c5149c4a/ef68e95e-ef77-eddf-dfa8-685557ee4875

 

70ec5d9f-a55e-4f5c-8f59-30d2c5149c4a correspons to the  UId from the SysSchema table where the attachments are stored and the ef68e95e-ef77-eddf-dfa8-685557ee4875 is the Id of the attachment. This URL allows me to dowloand the document to my computer, so I know that is the right link but when I used it in the web service it says that there is no document. 

 

The json of the request is the following 

{
 
    "url_doc": {
 
        "url": "https://151929-crm-bundle.creatio.com/0/rest/FileService/GetFile/70ec5d9f-a55e-4f5c-8f59-30d2c5149c4a/ef68e95e-ef77-eddf-dfa8-685557ee4875",
 
        "name": "Contrato.pdf"
 
    },
 
    "stickers": [
 
        {
 
            "authority": "Vinculada a Correo Electronico por Liga",
 
            "stickerType": "line",
 
            "dataType": "email",
 
            "email":"laura@artica.digital",
 
            "data": "laura@artica.digital",
 
            "imageType": "stroke",
 
            "page": 0,
 
            "rect": {
 
                "lx":74.88173,
 
               "ly":312.32596,
 
               "tx":196.9875,
 
               "ty":373.37885
 
            }
 
        }
 
    ]
 
}

 

When I sent the request the response is 

 

{
    "error": "No document"
}

 

I had try this request with a Dropbox URL and works fine but I need to send the documents that are generated by the Word Reports. That why I'm trying to get the document from Creatio using the URL the API also gives me the option of sending the document using base64 but I dont know how to convert the file easly. 

 

Can you help me please to know what is happenig? 

Thank you

Like 0

Like

4 comments

The reason why this isn't working is because FileService/GetFile requires authentication to read. This is not an anonymous endpoint. The receiver of this, where ever you're sending this URL of the document to, is actually getting a 401 Unauthorized. 

You'd have to either go the route of sending the base64 of the file, or expose an anonymous service in Creatio to provide the file to the other service.

Ryan

Ryan Farley,

Thank you, can you explain me please how can I convert the file to base64 please, I had see some examples but I not sure if I can do it using a script task in a business process or a source code 

Laura Jurado,

The code would look something like this (not tested, but this should get you started). For this, I have two process params, one a uniqueidentifier AccountFileId (an Id of an account file) and second an unlimited text AccountFileBase64. The script task would look something like this:

var fileId = Get<Guid>("AccountFileId");
 
var entity = UserConnection.EntitySchemaManager.GetInstanceByName("AccountFile").CreateEntity(UserConnection);
if (entity.FetchFromDB(fileId))
{
    var base64FileData = Convert.ToBase64String(entity.GetBytesValue("Data"));
    Set("AccountFileBase64", base64FileData);
}

Ryan

Ryan Farley,

Thank you very much. It helped me a lot 

Show all comments

Hello,

 

is it possible to include Feed into global search results?

And/Or filter records by Feed in Section?

 

Thank you.

Vladimir

Like 1

Like

1 comments

Hello!

 

Regarding your first question, please note that at the moment, the feed is not indexed in the global search (the columns 'Message' of the 'CaseMessageHistory' object and the 'Message' of the 'SocialMessage' object). It is not possible to enable the feed in the global search in the current system configuration.

We have received similar inquiries in the past, and a development team has already registered a task to add this functionality. I have attached your request to the task to increase its priority. We will plan how to address this task and strive to develop a suitable mechanism, which will be presented in future Creatio releases.

Regarding your second question, unfortunately, it is impossible since we don't have direct connections between the record and Feed.


Best regards,

Mariia

Show all comments

Getting dateformat error during deserialization when calling a custom web service with the following JSON request:


{
  "ResultDate": "\"2000-01-01T00:00:00.000\""
}
The error message states:

The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter http://tempuri.org/:entity... "DateTime content '"2000-01-01T00:00:00.000"' does not start with '/Date(' and end with ')/' as required for JSON.' Please see InnerException for more details. See server logs for more details. The exception stack trace is: ...

Is there any way to pass a date in the "\"2000-01-01T00:00:00.000\"" format instead of using /Date(1511448000000)/

Like 0

Like

1 comments

Hello,

According to the given information, this article may be helpful:

https://stackoverflow.com/questions/44227653/content-date-does-not-start-with-date-and-end-with-as-requi

Also, you can write a DateTime to Unix timestamp converter and then extract the value:

public static DateTime UnixTimeStampToDateTime( double unixTimeStamp )
{
    DateTime dateTime = new DateTime(1970, 1, 1, 0, 0, 0, 0, DateTimeKind.Utc);
    dateTime = dateTime.AddSeconds( unixTimeStamp ).ToLocalTime();
    return dateTime;
}

Best regards,

Anhelina!

Show all comments