Hi Michal,

we use NPOI library

Kind regards,
Vladimir

Basically, you'll query SysUserInRole where the current user = the SysUser value. The SysRole lookup column will provide you the roles linked to this user. 

See here: https://customerfx.com/article/determining-if-a-user-has-a-specific-role-in-bpmonline/

For a Freedom UI approach, see https://customerfx.com/article/showing-or-hiding-a-field-if-the-current-user-is-a-member-of-a-role-in-a-creatio-freedom-ui-page/

Ryan

Thanks Ryan.  Is there a way to use a webservice for this requirement? Are there any out-of-the-box Webservices that can be called to check if the current user belongs a particular Role using Freedom UI approach ?

If this will be consumed from within Creatio on a Freedom UI page, it's just as easy to do a model query from the Freedom UI page (as shown in the article) as it is to call a web service. Maybe I am missing what you're trying to do? Calling a web service wouldn't really be any different than doing what is suggested in the article using a model query. You could wrap that up as a server-side C# code and expose as a web service, but ultimately, the Freedom UI page is going to request something, whether the web service or the model query, so you could just skip the web service IMO and use the model query.

Thanks Ryan.  Yes I agree. Its just that I wanted to explore using webservices in Creatio and also resuse this webservice across projects and am in the process of creating a C# webservice to achieve this.

Can't really do it without a 3rd party DLL or service. Some of the newer marketplace addons use the Free Spire.Doc .NET library, which is pretty easy to work with and would be easy to implement. There is a paid version of Spire.Doc, but the free version would likely suffice for most purposes (and can be used for commercial purposes)

Ryan Farley,

thank you for your response and for the recommendation,

I actually downloaded the free version of Spire.Doc and started exploring it — it does look quite promising. However, since I’m working entirely within Creatio Cloud, I believe there might be a limitation when it comes to using third-party DLLs directly, though I’m not completely sure.

Do you think it would be viable to integrate Spire.Doc by hosting the functionality externally (for example, as a microservice or an Azure Function) and calling it from Creatio via a REST API? I’d love to hear your thoughts on whether that approach makes sense or if you’ve seen it work in similar cases.

Thanks again for your help and insights.

Paulo Chacoff Leiton,

As Ryan said, we use the paid version of Spire.Doc in our marketplace app: https://marketplace.creatio.com/app/experceo-word-pdf-converter-creatio

It allows you to generate an unlimited number of PDF documents with unlimited pages (the Free version is limited to 3 pages).

Thank you
Mohamed
 

Still amazes me how conversion to pdf is not an Out of the Box feature of Creatio

(actually was and disappeared a couple of years ago)

We have used aspose connector in the past but there are a lot of errors in communication and quality is not acceptable.
we are also considering using the Spire.Doc library for future developments

Ryan Farley,

Do you happen to have a reference of how to invoke functionality from external libraries or assembly reference? i´ve trying to use Spire.doc in a source code file and script task but i always get a "missing assembly reference"

Just to illustrate the attempt, here´s a basic example a tried to convert word document to PDF with source code file:

Any guidance on how to properly reference and use third party libraries like this in Creatio would be appreciated.

using Spire.Doc;
using Spire.Doc.Documents;
using System.IO;
 
namespace JJ
{
    public class DocService
    {
        public byte[] GenerateDocx() {
            var doc = new Document();
            doc.AddSection().AddParagraph().AppendText("Hola desde Creatio!");
            using (var ms = new MemoryStream()) {
                doc.SaveToStream(ms, FileFormat.Docx);
                return ms.ToArray();
            }
        }
        public byte[] ConvertToPdf(byte[] docxBytes) {
            var document = new Document();
            using (var ms = new MemoryStream(docxBytes)) {
                 document.LoadFromStream(ms, FileFormat.Docx);
            }
            using (var outMs = new MemoryStream()) {
                 document.SaveToStream(outMs, FileFormat.PDF);
                 return outMs.ToArray();
            }
        }
    }
}

You would implement the C# code and expose as a configuration service, see https://customerfx.com/article/creating-a-web-service-and-consuming-it-from-client-side-javascript-in-bpmonline/

Then to consume the service from the remote module, you'd use the devkit sdk as shown here: https://customerfx.com/article/calling-configuration-web-services-from-client-side-code-in-a-creatio-freedom-ui-page/

Ryan

Ryan Farley,

Thank you.. If I want to ship this source code along with my package.. I have to put it under Resources as shown in the below image?

Can you also tell me if it is possible to run/debug the remote module during the development?

If I run the remote module using ng serve I am getting below error.
 

core.mjs:6531 ERROR Error: Remote entry with name 'angproject' does not exist
   at AppModule.ngDoBootstrap (app.module.ts:28:23)

bootstrap.ts:7 Error: Remote entry with name 'angproject' does not exist
   at AppModule.ngDoBootstrap (app.module.ts:28:23)

Sagar Rodda writes:

Ryan Farley,

If I want to ship this source code along with my package

You could sync your workspace to Creatio, add it in the package there and then download the workspace back and you'll see it under the Schemas folder. Or you could add it under Files\cs

Got it.. thank you so much.. I'll try it and let you know here how it goes..

Any information about this question?

Greetings,

We have not encountered this specific issue before. It is possible that what you described is related to browser caching, although we cannot confirm this with certainty.

For a thorough investigation, we will need the site logs and the exact time the issue occurred so we can analyze the problem in detail.

Please create a support request by emailing us at support@creatio.com.

Regards, 
Orkhan

Hi Orkhan,

We initially suspected that the issue might be related to browser caching, but strangely, it occurs for all users.

We previously attempted to submit a support request, but because our customer support package ("Business support") does not include "Performance diagnostics," the Creatio support team was unable to provide a solution. That’s why I’m now reaching out to the community for help.