Dear Glenn,

You can use Fiddler to catch requests that are being sent to and from the application and use it for debbuging. But you will be able to do it starting from 7.13.2 version of the applciaiton. Until that you can either create the functionality and then use it after the upgrade or create the request on c# via a script task element.

Best regards,

Oscar

Oscar Dylan,

Both bpm'online and the service are in cloud, so I cannot use fiddler.  What is the target release for 7.13.2?

Dear Glenn,

You will be able to use fiddler to catch requests even if the instance is located on-cloud. As for 7.13.2 version - please take a look at release notes here https://academy.bpmonline.com/documents/bpmonline-release-notes-7-13-2.

Best regards,

Oscar

I get this notification: Import complete. 1 of 1 records imported from the source file "AK_Relationships.xlsx".

Hello

The Relationship table has following columns: http://prntscr.com/mkwsvu

In order to import relations you need to populate the RelationTypeId, ReverseRelationTypeId, Active, AccountAId(ContactAId) and AccountBId(ContactBId) columns. Please note, that you need to fill in the columns with the precise names in order for these relations to be connected to the existing records. Else, the duplicates might be created.

Best regards,

Matt

Dear Fulgen,

You can do that in the following way:

1) Open the replacing object that is usually in the Custom package (in the configuration).

2) Open all settings of the object: http://prntscr.com/ioprlo

3) Then you can set the usage mode for the column is None.

Please note that if you set such usage mode for the column, you won't be able to filter the records by it but also you won't be able to add this field to be displayed in the tile or list view in the section. 

Best regards, 

Dennis

Dear Aaykay,

The system may request you to choose the object where you want to add the new detail. For instance, if you choose the Accounts from the list, the detail will be referring to the Accounts object http://prntscr.com/mjc55 Here is the article for more details 

https://academy.bpmonline.com/documents/technic-sdk/7-13/creating-detai…

If you need to add a new object here is another resource that will help you out:

https://academy.bpmonline.com/documents/technic-sdk/7-13/creating-entit…

Best regards,

Dean

Hello, 

You can see all tables with it's content in the Lookup section in system designer. For that you would need to create a lookup connected to the needed object. You can't use queries in the lookup, though. for this purposes The marketplace app SQL Executor can be used. https://marketplace.bpmonline.com/app/sql-executor-bpmonline

Best regards, 

Dennis

Hello,

Please submit a case to support@bpmonline.com. We will be glad to help you!

Best regards,

Angela

Not sure what's the point of having a "community" is then if you're gonna give solutions via emails.

But will do that.

Got it sorted by removing the columns from the Excel that would not match with the Columns in tables within Bpm Online and it worked fine.

Not sure how that worked out but was able to upload the contacts.

Angela Reyes writes:

Hello ayman,



To achieve it you should set instalation type = Update existing and check column [Forced update]

[Update existing] - when updating a package, only those object columns that are marked with [Required for update ([Forced update]) in the [Columns] group will be updated. This type of installation is used, for example, when delivering hotfix updates!



Best regards,

Alex

Alex_Tim,

I still get the warning when saving the data binding with [Update existing] installation method chosen, should this not be the case? I have forced update set on the system setting I'm updating as well. Presumably this warning can be ignored, since the data is bound in another (OOTB) package which won't be installed with my package, but it does seem odd that the warning is still shown.

Hello Harvey, 

Could you please specify why do you need to bind the data that is already in one of the base packages?

Thank you in advance for your reply!

Olga. 

Hi Olga, in this case it's because I'm binding the default maximum repetitions of Business Processes system setting to the package to a higher number, but in general just to be able to bind any pre-existing System Setting to the package.

Harvey Adcock,

Thank you for the clarification! This warning has no impact on data binding. 

Best regards,

Olga. 

Hello Sekhar,



If we speaking about converting base64 string to a file you can check the possible realisation of this case here: https://snipplr.com/view/6034/base64-encode-or-decode-a-file/



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



If you have any questions, please specify more precisely what exactly you are trying to achieve.



Best regards,

Alex

Thanks Alex.

You can set process parameter in the script:

Set("PipelineId", pipelineId);

That sets the parameter for the process that contains the script task, but not for a subprocess that is further down the line from the script task (see the first link I included), I thought? Or do processes and subprocesses share parameters?

Dear Jonas,

You can use this coder to pass the value:

UserConnection userConnection = Get<UserConnection>("UserConnection");

IProcessEngine processEngine = userConnection.ProcessEngine;

IProcessExecutor processExecutor = processEngine.ProcessExecutor;

var nameValues = new Dictionary<string, string>();

int parameter1Value = 100;

nameValues["parameter1"] = parameter1Value.ToString();

processExecutor.Execute("UsrProcessCustom", nameValues);

return true;

Best regards,

Dean

Thank you. I will start testing this today. 

Now I need to know how to get data back from that process. Is that possible?

Dear Jonas,

You can try to add another element in your subprocess and use the same script to pass the values back to the parent process. 

Dean

Hi, Julius!



As you have your own field in Opportunity (e.g. "UsrCode"), so you can use:



    onEntityInitialized: function() {

                 // onEntityInitialized method parent realization is called.

                this.callParent(arguments);

                // The code is generated only in case we create a new element or a copy of the existing element.

                if (this.isAddMode() || this.isCopyMode()) {

                    //  Call of the Terrasoft.BasePageV2.getIncrementCode base method, that generates the number 

                    // according to the previously set mask. 

                    this.getIncrementCode(function(response) {

                    // The generated number is stored in [Code] column.

                        this.set("UsrCode", response);

                    });

                }

            }

Dear Julius,

Since opportunity section does not have an existing Code column, you can create one using means of section wizard.

No special methods needed for new column, since we are calling parent realization in the onEntityinitialized method, which has the logic of working with auto incrementing. Just be sure to indicate your custom column in the this.set method by its name, but not title.

As for the back end realization of the auto incrementing, follow the instructions just the same, but indicate name of the custom column.

Regards,

Anastasia

Anastasia Botezat, Vladimir Sokolov,

I tried this again. But it's not working. No value gets set.

I have created the System Settings, the Property on Opportunity, And I have adjusted the JavaScript to have the correct string value, "UsrCode".

It's not working this time either. Is the on-client method unavaliable on the Opportunity object?

Maybe the Opportunity object does not know the Systems Settings i Created. The system settings code names are : OpportunityLastNumber and OpportunityCodeMask

UPDATE : It is working while using Copy. But no Code is set when adding an Opportunity with the Mini-Page. I am now working on this. Any advice appreciated.

UPDATE 2 : Creating and Copying works as long as I do not have a Mini-Page. I tried to add the same JavaScript in the MiniPage methods{}. But that's not working. Any tricks to use MiniPages?

Julius,

The auto increment logic is not a part of basic mini page logic. The 

getIncrementCode method is written on the BasePageV2. However, mini pages are inherited from BaseMiniPage, which does not have such method.

You can add the getIncrementCode method realization to the mini page, so that it will execute the logic. 

As for the back-end part, the changes are displayed on the client side only after record is saved. Therefore, it is impossible to view the code value on the opportunity page immediately. 

Regards,

Anastasia

Anastasia Botezat,

 I did not get this to work with Mini-Page. I have anyway decided to work without the mini-pages. When Creating a Opportunity I just get the regular edit page where the incremented numbers work fine. Thank you.

Anastasia Botezat,

Hi,

This dint worked  even to me. 

https://community.bpmonline.com/questions/auto-increment-issue

I have posted the issue in detail in the above link. Please help!!!!

regards,

Sriraksha