Hi,

how can I change the code in client modules and add my own? I am still a beginner and it would be cool if someone could help me understand how to work with modules in Creatio. In general, I have a task: I need to figure out how to change the title on the "contacts" page. I need to understand how to change the name (here it is Aссom)

Hi Community,

In chart is is possible to add/remove series dynamically based on section filter 

Hi Team

I created a Node.js script to upload attachments using FileApiService.

Here is my script:

var axios = require('axios');

var fs = require('fs');

establish_connection();

async function establish_connection()

{

        axios.post('https://company_name.bpmonline.com/ServiceModel/AuthService.svc/Login',

        {

            "UserName":"xxxxxxx",

            "UserPassword":"xxxxxxxxxxx"

        }).then (function (response){

            console.log('Imported credentials cookie from BPM Online!')

            c=response.headers['set-cookie']

            var bpm_loader=c[0]

            bpm_loader = bpm_loader.replace('BPMLOADER=','')

            bpm_loader=bpm_loader.split(';')[0]

            var aspx_auth=c[1]

            aspx_auth = aspx_auth.replace('.ASPXAUTH=','')

            aspx_auth=aspx_auth.split(';')[0]

            var bpm_csrf=c[2]

            bpm_csrf = bpm_csrf.replace('BPMCSRF=','')

            bpm_csrf=bpm_csrf.split(';')[0]

            var user_name=c[3]

            user_name = user_name.replace('UserName=','')

            user_name=user_name.split(';')[0]

            var auth = 'BPMLOADER='+bpm_loader+'; .ASPXAUTH='+aspx_auth+'; BPMCSRF='+bpm_csrf+'; UserName='+user_name+';';

            console.log('Authentication Successful!')

            upload_attachments(auth,bpm_csrf)

        }).catch(error => {

            console.log(error)

        })

}

async function upload_attachments(auth,bpm_csrf) {

  let myPdf = fs.readFileSync("./file_name.pdf");

  let myData = myPdf.toString("base64");

  let myBody = {

    Name: "test.pdf",

    Data: myData,

    TypeId: '529bc2f8-0ee0-df11-971b-001d60e938c6',//This indicates that the type of the attachment is file

    Version: "1",

    Usr_reference_column_id: 'xxxxxguid_of_the_record_xxxxxxxx'

  };

  let options = {

    method: "POST",

    url: 'https://company_name.bpmonline.com/0/rest/FileApiService/Upload',

    headers: {

        "fileapi14998570381414":"",

      "cache-control": "no-cache",

      "Accept-Encoding": "gzip, deflate",

      "Cache-Control": "no-cache",

      Accept: "*/*",

      "Content-Type": "application/json;odata=verbose",

      Cookie:auth,

      BPMCSRF:bpm_csrf,

      "entitySchemaName":"Usr_id_of_the_file_section"

    },

    body: myBody,

    json: true

  };

  request(options, function(error, response, body) {

    if(!error)

    {

        console.log('Success!')

        console.log(response)

    }

    else

    {

        console.log('Failed!')

        console.log(error)

    }

  });

}

References: 

1. https://community.bpmonline.com/questions/sending-blob-file-node

2. https://community.bpmonline.com/questions/upload-files-case

3. https://community.bpmonline.com/questions/how-upload-attachments-odata

4. https://community.terrasoft.ru/questions/realizacia-peredaci-pdf-dokumenta-po-protokolu-odata-s-ispolzovaniem-http-zaprosov

5. https://community.terrasoft.ru/questions/fileapiservice-zagruzka-dokumenta-v-faily-i-primecania-crm-sistemy

I am able to establish connection (Authorization is successful) and getting SUCCESS for the attachment. But in the response, I am receiving 'Request Error'.

Questions:

1. Is my URL correct?

2. Is the way I specified file section name correct?

3. Do I need to add/delete/change my request body?

4. Do I need to create a MODULE in ADVANCED SETTINGS?

NOTE: I am using BPM'Online Studio.

Hi All

I am trying to insert attachments through OData. Here is my query:

URL: https://.bpmonline.com/0/ServiceModel/EntityDataService.svc/UsrCollecti…

HEADER:

'Content-Type': 'application/atom+xml;type=entry'

Cookie:

BPMCSRF:

'Accept':'application/atom+xml;type=entry'

XML BODY:

<?xml version="1.0" encoding="utf-8"?>

                    test_file.csv

                    3bd0cdb7-89f5-458f-b713-ad54ece97b4d

                    529bc2f8-0ee0-df11-971b-001d60e938c6

NOTE: Name, UsrAWPLogisticsPlanId and TypeId are the fields in my file section.

The above query successfully uploads a blank CSV.  Now here are my questions:

1. How can I read a local file and pass it though the XML body (the way I am passing Name, TypeId and UsrAWPLogisticsPlanId)? - So that I can upload real data instead of a blank file

2. Where is the attachment data stored? Whats the format?

NOTE: We use BPM'Online studio.

Hi Team, 

BPM is running in SQL server and we were planning to change the recovery model of the database to full recovery from simple recovery model for attaining the point in time recovery. As far as I knew it will not affect the BPM. Still wanted to confirm if there is any drawback in doing so. Thank you in advance. 

Gokul

Hello

I know that Bpmonline supports Gregorian Calendar, what about supporting other calenders like (Hijri Calendar)

Regards

Hi Community,

How we can do Multiple Selection on Mobile Section List?

How to add multiple new products on the product page. Is there way to create multiple new products?  

Hi.

Our intention is create a console app (C#) using EntitySchemaQuery  that query an entity (like Account or Contact) and gets its rows to populate a local table. 

We are trying to connect our bpmonline using this example:

source: https://www.bpmonline.cz/bpmonlinesdken/UsingEntitySchemaQuery.html

//////////
// Creating a query instance, adding columns and a data source in the query.
Select selectQuery = new Select(UserConnection)
                    .Column("Id")
                    .Column("Name")
                    .From("Contact");
// Executing a database query and getting the resulting dataset.
using (DBExecutor dbExecutor = UserConnection.EnsureDBConnection())
{
    using (IDataReader reader = selectQuery.ExecuteReader(dbExecutor))
    {
        while (reader.Read())
        {
            // Handling the query results.
        }
    }
} 

/////////////

The problem is we do not know how to create the connection string (UserConnection) to our cloud services, https://mycompany.bpmonline.com.

How to create this UserConnection? Someone has an example or may guide us?

Whether or not a System User is Active can be read from System administration object.  However, when the state of Active is changed in System Users, no Signal is caught using Record Modified if the Active flag was changed manually in System Users.  The Signal only triggers a process if the Active status is changed by another process.

How can a process be started when changing the Active status of a System User manually?