I've created a webservice that passes the received data from my api to a "Collection of Objects with attributes" parameter inside my business process.

I would like to know how can i convert that business process parameter to a JArray.



JArray jarray = Get("ProcessSchemaCadastros");

This is the line i have in my script task to get my data from business process parameter.

Like 0

Like

2 comments
Best reply

I found a way to pass my problem, instead of trying to convert into a JArray i used:

var entities = Get<ICompositeObjectList<ICompositeObject>>("WebService1.UsrWBCadastros_Out");

then i just worked with the data from 'entities'.

 

It's much easier to transfer a JSON from the web service to a text variable in a business process. Then parse the JSON in the business process.

I found a way to pass my problem, instead of trying to convert into a JArray i used:

var entities = Get<ICompositeObjectList<ICompositeObject>>("WebService1.UsrWBCadastros_Out");

then i just worked with the data from 'entities'.

 

Show all comments

I have this Script Task code for receiving file name from opportunity files record:

string RecordIdParam = Get("RecordID");

var result = "";

// Creating a query to the "OpportunityFile" schema, adding the "Name" column to the query.

var esqResult = new EntitySchemaQuery(UserConnection.EntitySchemaManager, "OpportunityFile");

var colName = esqResult.AddColumn("Name");

// Executing query to the database and receiving the object with the specified identifier.

var entity = esqResult.GetEntity(UserConnection, new Guid(RecordIdParam));

// Receiving value of the object column.

result += entity.GetColumnValue(colName.Name).ToString();

Set("fileName", result);

return true; 

 

I need to receive, in addition to the file name, the content of the blob to a binary variable for further use.

Can you please tell me what are the lines of code for this ?

Like 0

Like

4 comments

Hello Oren!



If you want to process the data on server side, than you can check how to read data column in FileLoader class. 

But I don`t recommend to work with files in such way. Much more convenient way is described here: https://community.bpmonline.com/questions/where-find-attachments-activity



Idea is not to process and convert the data into some object on server side, but read its value and insert in database where it is needed.



Perhaps, if you will check how system works with files on server side in oob functionality it will be helpful. Just search schemas in configuration with such filters http://prntscr.com/nocypn&nbsp;

Alex_Tim,

Thanks Alex for your answer.

It won't work for me because I need the file outside the DB, for example to deliver it to an FTP server.

SO do you know how to save it as a Binary variable ?

Or if you can tell me where to find this "FileLoader class"?

Oren Diga,

 

You can simply find it in configuration by entering it`s name.

Basically if you will search by such filters http://prntscr.com/nocypn  you will find many examples. 



Class that I have mentioned earlier ("FileLoader") lays in "FileLoader" schema in "Base" package. It is used for downloading the files. If I were you, I would give some thought to use it in my service or business process.



Regards,

Alex 

Thanks Alex!

This is very helpful.

Show all comments

Is it possible to roll up the monthly forecast to quarterly level easily? I have given forecasting at "customer need" dimension "Monthly". Once Apr, May & Jun Data is entered, can i give another "quarterly" forecasting view where the Q1 is populated based on the monthly forecast entered? Is there any quick provision for this? where are the forecast values stored in? which is the object name?

Like 0

Like

3 comments

Dear Krishna,

Hope you are doing well today.

Unfortunately, there are no any way to adjust different time periods other than that offered in the application. However we have in plans to implement the functionality for more flexible time adjustment. As for now you can only use months.  You can display the required months by adjusting the time periods http://prntscr.com/noitix  As for the forecasting values - they are stored in ContactForecast, AccountForecast and ForecastItemValue tables.

Best regards,

Dean

 

 

Dean Parrett,

Thanks Dean!! But I guess "ForecastItemValue" is made obselete from Ver 7.14. In that case in 7.14 which is the table which stores value? I tried to query "EntityInForecastCell" but got sql error "invalid object". 

Dear Krishna,

You need to use these titles - ContactForecast, AccountForecast and ForecastItemValue. These are correct names of the tables. Indeed, the query to EntityInForecastCell will error since there are no such table.

Best regards,

Dean

Show all comments

Hi,

Is it possible to add custom styles for forecast page ?

i followed 

https://community.bpmonline.com/articles/how-add-or-edit-css-style

I did the first step. But I dint find the replacing client module for forecast page, in order to embed the css file name . Please help.

 

Thank you in advance

 

Like 0

Like

1 comments

Hello,



To create replacing client module:

1. Add new replacing module http://prntscr.com/np9szt

2. Set desired page as parent for module that you created http://prntscr.com/np9thl

3. Add the code to the schema source code http://prntscr.com/np9u9m



Regards,

Alex

Show all comments



Hi,

 

Does anyone know if there's a way to unmerge the merged contacts?

 

Regards,

AK

Like 0

Like

2 comments

Hi,

Basically, merge deletes all duplicate records from DB, so after records are merged they cannot be restored. You can create a backup before merging records to use it later for restoring data. 

Best regards,

Angela

Ah Alright. No worries.

Thanks :)

Show all comments

Does the notification " Deduplication task completed" imply that there are no duplicates in the system?

 

When I run the duplicate search in the contacts section, I get this notification.

Like 0

Like

3 comments

Hello,

This notification indicates that the process of duplicates search is finished, but there are two possible results: duplicates are found or duplicates are not found. To find out if duplicates were found you can go to "Setup duplicates rules" section of system designer and in "Actions" drop-down choose "Show duplicate contacts/accounts". This action will open the list of duplicated contacts or accounts. Or you can click on "Actions" in accounts or contacts section and click on "Show duplicate accounts/contacts" and it should return the list of duplicates.

Best regards,

Oscar

Oscar Dylan,

Alright!

Also, what does this error imply?

I've been getting this error for last few hours when I run the duplicate search.

aaykay,

This error can be received if there are some issues with duplicates search functionality like incorrect procedure (or errors in it) that is executed when the search is started. It is difficult to say without access to the application in which the issue can be reproduced. Please email us at support@bpmonline.com and provide us with access to the application and we will check it.

Best regards,

Oscar

Show all comments

Hi all

Does someone have an example of taking attachment and saving it as a file on an FTP server ?

I want to create a process that when user attach a file, the file will be saved automatically on a local drive.

Thanks

Like 0

Like

1 comments

Dear Oren,

Unfortunately development of such functionality is difficult a little bit and may require a separate project. But you can try using this marketplace app https://marketplace.bpmonline.com/app/file-manager-bpmonline since it provides the possibility of working with FTP-storage systems. Also we already have a suggestion registered for our R&D team so to implement this possibility in out of the box version of the application, but unfortunately there is no ETA for it. We will also notify them about your request so to raise the priority of the problem. Thank you for helping us to make our application better!

Best regards,

Oscar

Show all comments

Hi community

I made a trigger on a lookup field using this attribute:

"UsrAmazonWarehouseAddress":{
    "dependencies": [
        {
            "columns": ["UsrAmazonWarehouseAddress"],
            "methodName": "onAmazonWharehouseChange"
        }
    ]
},

The thing is that this trigger is fired only if the user choose value by cliking it on the popup window. If the user uses only the keyboard without openning the lookup window, the trigger is not fired.

Any ideas on how to catch the evet of changing the lookup ?

Thanks

Like 0

Like

2 comments

I've just created the dependency specified below and it works no matter how it was triggered. Please test the code on your side and check the difference. 

define("AccountPageV2", [], function() {
	return {
		entitySchemaName: "Account",
		attributes: {
			"Owner": {
				"dependencies": [
					{
						"columns": ["Owner"],
						"methodName": "onOwnerChanged"
					}
				]
			}
		},
		modules: /**SCHEMA_MODULES*/{}/**SCHEMA_MODULES*/,
		details: /**SCHEMA_DETAILS*/{}/**SCHEMA_DETAILS*/,
		businessRules: /**SCHEMA_BUSINESS_RULES*/{}/**SCHEMA_BUSINESS_RULES*/,
		methods: {
			onOwnerChanged: function(){
				window.alert("onOwnerChanged");
			}
		},
		dataModels: /**SCHEMA_DATA_MODELS*/{}/**SCHEMA_DATA_MODELS*/,
		diff: /**SCHEMA_DIFF*/[]/**SCHEMA_DIFF*/
	};
});

 

Thanks Eugene

You are rihgt. I checked and the trigger is fired.

I checked and and found the problem:

This is how I got the recordId.

var recordId = this.get("UsrAllAddresses").Id;

When choosing with the popup window, recordId has the ID value

When choosing without the popup window, recordId is undefined.

The solution I found goes like this:

var record = this.get("UsrAllAddresses");

 var recordId=record.value;

Best regards,

Show all comments

Hello Community!

Some time ago I developed a functionality  on a custom package oriented to the version

bpmonline sales enterprise & marketing & service enterprise 7.11.0 being that the development was related to service entities, Marketing and Sales.

Currently I need to upload that development to an environment in bpmonline sales team 7.13.1, and when i try to install my package gives me an error that does not find certain dependent packages for example MarketingSoftkeyEnu.

What is the process that should be followed to implement it and obviously get out the functionality associated with entities of the marketing and service module?

By chance I have installed and unlocked the package in another environment bpmonline sales enterprise & marketing & service enterprise 7.12, where I have another development package. I made a copy of that environment and tried:

1. Set the imported package as a defect and its corresponding prefix

2. Remove items from the package associated with marketing and service

3. Remove fields from lookups in schemas that are related to those entities

4. Eliminate package dependencies: MarketingSoftkeyEnu & ServiceEnterpriseSoftkey

At this point:

* When I try to make changes to an entity and save the changes I get the following error:

Error while saving: Collection item with unique identifier "{AE0E45CA-C495-4FE7-A39D-3AB7278E1617}" not found.

When trying to generate code, compile, etc. I ended up giving the following error:

Unexpected character encountered while parsing value: =. Path '', line 0, position 0.

* Export the package and try to install the package into bpmonline sales team getting same error as the previous one.

Thank you!

Have a nice weekend

Regards

Like 0

Like

1 comments

Bpm'online allows transferring packages only between the same version. Additionally transferring is possible only between the same products or from less bundle to a greater one. 

In your case, you'll need to merge the package manually. Try to remove the dependencies from the SysPackageDependency table and then compile the assembly and debug the functionality. Find all errors and resolve them manually. 

 

Show all comments

Is there a way to set up certain column views for one unique folder and have them save to that folder? 

Like 0

Like

3 comments

Dear Heather,

The basic application tools do not allow to set up the views for folders, however we have the marketplace application that can satisfy your needs https://marketplace.bpmonline.com/app/list-setup-folder-bpmonline

The out-of-the-box feature that would allow to set up folder views will be available in the future application versions. As for now, please install this application. 

Best regards,

Dean

Dear Parrett,

Hi,

 

it seems the add-on is no longer available on Marketplace. Any hints how to define list view for a folder?

 

Best regards,

 

Michal

Hello Michał Krzycki,

 

Unfortunately, there is no basic way to set up different columns' views for different folders, but the corresponding project is already registered for our R&D team. The idea was accepted by them and will be released in further versions of Creatio system. 

 

Please let us know in case any additional information is required. 

 

Best regards, 

Olga. 

Show all comments