Studio Creatio enterprise edition

studio

OData - Attachments Upload

Nikhil Mogare

22:00 Oct 24, 2019

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.

1 comments

Norton Lingard

13:21 Oct 25, 2019

Dear Nikhil,

Unfortunately, there is no possibility to upload files via Odata protocol on current system version. Please feel free to use FileApiService for uploading a file. Please find an example of how to call the service in the “ConfigurationFileApi” module while adding the file on “Attachments and notes” detail.

Please note that all files are saved in the database in the appropriate table. For example, files from the “Attachments and notes” tab from the Contact section are saved in the “ContactFile” table and have the object name “Contact attachment”. Please note that the column with data of the file has name “Data” and type “varbinary(max)”.

For more detailed assistance, please contact technical support.

Best regards,

Norton

Show all comments

database

studio

7.11

backup

BPM Database recovery model

Gokul Krishnan

08:53 Oct 24, 2019

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

2 comments

Dean Parrett

17:52 Oct 30, 2019

Dear Gokul,

You will not have any difficulties with the application after changing the recovery model. The only difference that is in the database size. Since it will be bigger, you would need to have more free disc space not to affect system performance.

Best regards,

Dean

Gokul Krishnan

00:50 Oct 31, 2019

Thank you Dean :)

Show all comments

dates

calendar

hijri date

studio

Does Bpmonline spports Hijri Calender

sdeen@isb-me.com

14:37 Oct 23, 2019

Hello

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

Regards

1 comments

Dean Parrett

13:44 Oct 28, 2019

Hello,

Unfortunately, by default there are no any other calendars or Hijri Calendar time format. If you need to set up the new calendar, for example for case resolution time calculation, feel free to refer to the following article and create your custom calendar (calendar setup paragraph) https://academy.bpmonline.com/documents/service-enterprise/7-15/how-setup-response-and-resolution-time-calculation

Other than that, unfortunately, it is not possible to set up the time and date format according to Hijri calendar. We will register the idea of adding more calendars in our R&D team backlog for implementation in the future application releases.

Best regards,

Dean

Show all comments

mobile

7.14_()

studio

Multiple Selection on Mobile Section List

Fulgen Ninofranco

16:12 Oct 21, 2019

Hi Community,

How we can do Multiple Selection on Mobile Section List?

1 comments

Oleg Drobina

18:54 Oct 21, 2019

Hello Fulgen,

In the current out-of-the-box functionality there is no way to select multiple records in the section list using mobile application and problem regarding this topic is already present in a backlog of our R&D team. You can create your own logic of selection of several records in the list via development (try using multiSelect option in Terrasoft.controls.Select class), but we cannot guide you here since there was no practical implementation of this logic. I will also inform our R&D team about your question on the community so to raise the priority of the problem.

Regards,

Oscar

Show all comments

7.11

studio

How to add multiple new products in the product page

Gokul Krishnan

03:14 Oct 17, 2019

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

1 comments

Angela Reyes

00:42 Oct 21, 2019

Hi,

You can import functionality to add multiple product to the system. You can find more about import here: https://academy.bpmonline.com/documents/base/7-15/excel-data-import

Best regards,

Angela

Show all comments

userconnection

ConnectionString

EntitySchemaQuery

7.15_()

studio

How to create ConnectionString for EntitySchemaQuery

Jose Ramon Lopez

01:24 Oct 17, 2019

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?

3 comments

Eugene Podkovka

14:56 Oct 17, 2019

Theoretically, it's possible to use bpm'online local .dll-s and create the connection. However, it's very hard and usually pointless. If you need to get data from bpm'online, please create a web service in bpm'online. The service should get the needed data and give it to the requested.

This is how to create a service.

https://academy.bpmonline.com/documents/technic-sdk/7-14/creating-configuration-service

This is how to log in and call it

https://academy.bpmonline.com/documents/technic-sdk/7-14/executing-odata-queries-using-fiddler

Mohamed Ouederni

14:22 Nov 18, 2019

Eugene Podkovka writes:

However, it's very hard and usually pointless.

I don't think it's useless.

I'm trying to achieve the same goal to increase our developers' productivity.

We usually use task script in the process designer to manipulate data using EntitySchemaQuery.

Each time, we have to update the process, run it and check the log or attach visual studio debugger (which is painful) to verify our code.

Imagine if we are able to get a UserConnection instance directly into a standalone app. we can test our functions faster and increase the overall productivity.

@Eugene Podkovka: can you please help us!

Thank you

Mohamed

Mohamed Ouederni

19:09 Nov 18, 2019

We can use this approach!

https://academy.creatio.com/documents/technic-sdk/7-15/developing-configuration-server-code-user-project

Thank you

Mohamed

Show all comments

studio

Active

Signal

system users

Record Modified

System administration object

7.15_()

How to Know When a System User's Active Property Is Changed Manually?

Janine White

22:51 Oct 11, 2019

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?

1 comments

Alina Kazmirchuk

13:17 Oct 14, 2019

In order to create the functionality please use object "Users/roles (view)" instead of "System administration object" (https://prnt.sc/pj03qp).

Show all comments

7.14_()

studio

How to find Employee Manager by Process

sdeen@isb-me.com

11:44 Oct 10, 2019

Hello

How to find Employee Manager by Process.

Regards

3 comments

Angela Reyes

05:45 Oct 12, 2019

Hi!

You can use read element to find employee record and ther read manager value from it: http://prntscr.com/pi74m7. Then you can use second read data element to find contact of this manager.

Best regards,

Angela

sdeen@isb-me.com

15:52 Oct 12, 2019

Hi Angela

Thanks for your reply.

I did read manager of the employee succesfully, as shown below:

https://drive.google.com/open?id=11oYSOU6VcYFTfe93iUZVA2FYV3XX-Ih7

Regarding second read data to find the contact of this manager, I am doing as below, but it does not return manager contact, what should be the correct filter here.

https://drive.google.com/open?id=14aK6QaF4K1eK7ZPKPoXb2cPTCzVw_Ldp

Best Regards

Saif

Angela Reyes

09:36 Oct 14, 2019

sdeen@isb-me.com,

Use Employee object for second read data (http://prntscr.com/pix585) and then you can take needed contact from it (http://prntscr.com/pix5r3). Since manager is also part of Employee object it cannot find such contact.

Show all comments

details

7.12_()

studio

Editable details records based on condition

Marek

12:08 Oct 09, 2019

Can I make details records editable based on conditions? For example, records with colA=1 can be modified, but records with colA<>1 cannot.

2 comments

Eugene Podkovka

21:02 Oct 16, 2019

Try to add async validators into the edit page linked to the detail.

Please investigate the asyncValidate in the BaseEntityPage and the asyncValidate method in the AccountPageV2.

Eugene Podkovka

21:03 Oct 16, 2019

You'll probably need "messages" to get information from the detail main page.

https://academy.bpmonline.com/documents/technic-sdk/7-14/messages-messages-property

Show all comments

7.14_()

studio

attachments

links

7.14_()

How to include attachment link in email without converting to an attachment?

Janine White

00:03 Oct 08, 2019

I figured out how to get the link for an attachment, but when I include it in a Send email system action, the link is automatically converted to an attachment, which is undesirable because the attachment is too large. How do I include a link to an attachment in an email and have it remain text or a hyperlink?

2 comments

S.Kobizka

16:06 Oct 08, 2019

Dear Janine,

According to the [Send email] element logic, your hyperlinks to bpm'online attachments will be automatically converted to actual attached files in the email, there is no way you can leave them as text links.

Regards,

Svetlana

Janine White

18:51 Oct 08, 2019

S.Kobizka,

The really annoying part is even if I remove https:// it still converts. I'll have to put in more space to make it unrecognizable.

Show all comments

Subscribe to Studio Creatio enterprise edition