Dear Sarauzo,

Indeed, it might happen if your lead record has multiple connections with the other entities in the system. You would need to delete them prior deleting this record. You would need to modify your process to delete the connected records as well. The easiest way to know what are those records is to try to delete the record manually from the section. The system will show you the list of associated records. 

Best regards,

Dean

Thanks a lot Dean!

Dear Julius,

You can add a business process that will be triggered on creating new activity and make it connect this activity to the records needed.

Best regards,

Angela

Angela Reyes,Great! Thanks!

Dear Cristian,

Our system uses the external resource OpenStreetMaps for showing on the map specified addresses. You can check whether the address (or GPS) you specified is on the map at https://www.openstreetmap.org/. If it needed - you can add the address to this resource so that added address will be displayed correctly in OpenStreetMaps and bpm'online.

Best regards,

Anastasia

Anastasia Polo,

Thank you Anastasia for you answer.

So the account address will be shown correctly on mobile application if the OpenStreetMaps is also installed on that mobile device, right? And also if the GPS coordinates are filled for that address the pin on the map will appear?

Dear Cristian Galatan,

It isn't necessary to keep the OpenStreetMaps application installed all the time. Please check whether the address (or GPS) you specified exists and correctly is displayed on the map at https://www.openstreetmap.org/. If there is absent such address - add it. The main idea is - if it is correctly displayed on this map, it will be correctly displayed in the BPMonline.

Best wishes,

Anastasia

Anastasia Polo,

Maybe I didn't asked the right questions. I can see the address correctly on the web application. The pin is also displayed correctly.

The problem is with the mobile application. When I want to see the location on the mobile application, the mobile application ask me what map application I want to use to show me that address. I can choose (google map, waze or any other map application I have installed on that mobile device).

It doesn't open a screen (that maybe is using OpenStreetMaps) to show me the address, like it does on the web application. So is the mobile application not working as intended or do I need to configure the mobile application to do that?

Thank you.

Cristian Galatan,

Sorry for the misunderstanding. To investigate this issue we need more specific information so please submit a case to support@bpmonline.com. Also, specify please the OS version and name of your instance.

Thank you!

Anastasia

How can I map custom City column to be mapped correctly in the Map? I have a requirement to replace the city column with a standard text field as the users are complaining about the finicky data entry of creating lookup values. When creating a city field the MAP API is not working with new field and I would like to know how to fix that.

7.14.3.1686

Unfortunately, there are no such filters on the client end. However, you can create a view that will represent the needed data, then create an object in the bpm'online configuration that will represent the view. Then create a lookup in the "Lookups" section that will show data from the object. 

This is how to create an object based on a view. 

https://community.bpmonline.com/questions/how-create-view-object-bpm-on…

This is how to create a view that will display the needed data

create view VwContactPropDupl
as
with 
ContAddr (ContactId, AddressCount)
as
(
	select ContactId, COUNT([Address])
	from ContactAddress ca
	group by ContactId, [Address]
),
ContComm (ContactId, CommCount)
as
(
	select ContactId, COUNT(Number)
	from ContactCommunication
	group by ContactId, Number
)
select 
	c.Id [ContactId], 
	COUNT(c.Id) [DuplicatesCount]
from Contact c
left outer join ContAddr ca on ca.ContactId = c.Id
left outer join ContComm cc on cc.ContactId = c.Id
where ca.AddressCount > 1
or cc.CommCount > 1
group by c.Id

Create a method and then use it in a script task. 

http://prntscr.com/noyshq

You'll be able to override the method in child objects. 

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 

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.

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

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

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

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,