Is there a way to prevent incoming and outgoing emails from generating all of the tiny image file attachments in the linked records attachments tab?  For example, I receive and mark as processed an email from a vendor.  That email has a dozen image files attached to it for all of their social media links, website links, photos etc.  It also has one actual word file that I need but I don't even see that file in the attachments tab unless I keep scrolling down past the other 12 image files.

Is there a filter or business rule that would allow me to stop certain file extensions or file types or set a minimum file size from becoming bpm attachments to stop all of the attachment clutter?

Like 0

Like

1 comments

Hello Scott,



If I understood you right, the you need to achieve is to create size limit for files that you can attach to entity. One of the ways to do it to create event subprocess on "inserting" where the size should be checked:

 

int size = Entity.GetTypedColumnValue<int>("Size");

if (size > 1048576)

    throw new Exception("Размер вложенного файла превышает 1 Мб");

return true;



Also, Size can be limited by web server itself.

In the application configuration file

Terrasoft.WebApp \ Web.config

see the <requestLimits maxAllowedContentLength = "104857600" />

This is the limit for the any data downloaded to the server in bytes.



Best regards, 

Alex

 

Show all comments

Hi,

I'm trying to get a list of OpportunityFile associated with an OpportunityId and it's seems it's not possible using ODATA.

1. If I'm using this Url https://server.bpmonline.com/0/ServiceModel/EntityDataService.svc/Oppor… I'm getting a "Not Implemented" exception

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<script/>
<code>4

Not Implemented

Not Implemented
System.Data.Services.DataServiceException

at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)
at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService, IODataResponseMessage responseMessage)
at System.Data.Services.DataService`1.HandleRequest()

Method 'SelectMany' not supported
System.NotSupportedException

at Terrasoft.Core.Entities.EntityQueryProvider.VisitMethodCall(MethodCallExpression node)
at Terrasoft.Core.Entities.EntityQueryProvider.Build(Expression expression)
at Terrasoft.Core.Entities.EntityQueryProvider.LoadEntityCollection(Expression expression)
at Terrasoft.Core.Entities.EntityQueryProvider.ExecuteEnumerable(Type elementType, Expression expression)
at Terrasoft.Core.Entities.EntityQuery`1.GetEnumerator()
at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)

2. If I'm using this Url https://server.bpmonline.com/0/ServiceModel/EntityDataService.svc/Oppor… eq guid'e14b9eb7-99ff-43a6-bf26-a60b23b3ec12') I'm getting the following exception:

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<script/>
<code>1

Collection item with name OpportunityId not found.

Collection item with name OpportunityId not found.
Terrasoft.Common.ItemNotFoundException

at Terrasoft.Core.Entities.EntitySchema.GetSchemaColumnByPath(String columnPath)
at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.CreateExpression(Expression node)
at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.CreateSimpleFilter(BinaryExpression binary)
at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.CreateFilter(Expression node)
at Terrasoft.Core.Entities.EntityQueryWhereBlockBuilder.BuildBlock(MethodCallExpression node)
at Terrasoft.Core.Entities.EntityQueryProvider.VisitMethodCall(MethodCallExpression node)
at Terrasoft.Core.Entities.EntityQueryProvider.Build(Expression expression)
at Terrasoft.Core.Entities.EntityQueryProvider.LoadEntityCollection(Expression expression)
at Terrasoft.Core.Entities.EntityQueryProvider.ExecuteEnumerable(Type elementType, Expression expression)
at Terrasoft.Core.Entities.EntityQuery`1.GetEnumerator()
at System.Data.Services.WebUtil.GetRequestEnumerator(IEnumerable enumerable)
at System.Data.Services.DataService`1.SerializeResponseBody(RequestDescription description, IDataService dataService, IODataResponseMessage responseMessage)
at System.Data.Services.DataService`1.HandleRequest()

3. Also, if I'm using this Url https://server.bpmonline.com/0/ServiceModel/EntityDataService.svc/Oppor… eq guid'b3427cc4-3b20-4c16-8d2a-058ada7e7631') I'm getting a different error.

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<script/>
<code>4

Syntax error at position 1.

Syntax error at position 1.
System.Data.Services.DataServiceException

at System.Data.Services.Parsing.ExpressionLexer.ValidateToken(TokenId t)
at System.Data.Services.Parsing.ExpressionLexer.ReadDottedIdentifier(Boolean allowEndWithDotStar)
at System.Data.Services.RequestQueryProcessor.ReadExpandOrSelect(String value, Boolean select, IDataService dataService)
at System.Data.Services.RequestQueryProcessor.ProcessSelect()
at System.Data.Services.RequestQueryProcessor.ProcessQuery()
at System.Data.Services.RequestQueryProcessor.ProcessQuery(IDataService service, RequestDescription description)
at System.Data.Services.RequestUriProcessor.ProcessRequestUri(Uri absoluteRequestUri, IDataService service, Boolean internalQuery)
at System.Data.Services.DataService`1.HandleRequest()

It seems the filtering is not working on associated collection entities. Do you have any ideas?

Regards,

Radu

Like 0

Like

1 comments

Dear Radu,

Please see the example below. Draw your attention to the column OpportunityId syntax - Opportunity/Id

 

http://localhost:8006/0/ServiceModel/EntityDataService.svc/OpportunityF… = Opportunity/Id eq guid'410006e1-ca4e-4502-a9ec-e54d922d2c00'

 

Regards, 

Anastasia

Show all comments

I've been trying to find some authoritative documentation on the best way to do this but alas, can't seem to find what I'm looking for.  We work with a lot of professional organizations (law firms, accounting firms, etc.) that have multiple offices in geographical locations.  They're all part of the same company, but have somewhat separate identities because of their location.

Ideally we would like to have one Account record for the overall company, with each separate location tracked AND all of the contacts at that particular office associated with that office so we can easily see who is at each location.  We would like to be able to get statistics (i.e. opportunities, projects, etc.) at both levels -- meaning the ability to see how many projects we've worked with at Accounting Firm A AND we'd like to be able to get these same stats for each location for the company.   E.g. Accounting Firm A - Location 1, Accounting Firm A - Location 2, etc.

I assumed we would use the Structure and Contacts Detail section, but I'm not seeing how to associate an individual contact with a particular location, etc. 

Is this the best approach?  Any instructions on associating a contact with one of these offices?

Like 0

Like

4 comments

Dear Damon,

You can either use functionality of Field Sales to create tasks/visits for each contact based on their location or add new address detail in the Account section with Office field which would determine the name of the office. When building statistics for any section you may use office to determine for which department is this statistics built. 

Dear Damon,

You might also create different Accounts with type "Our company" and set different addresses for each account. Each employee will be bonded to its own account, general statistics can be viewed via Dashboards section and each every dashboard can be set up for a certain office. 

Angela, thanks for the comments.  Perhaps I wasn't as clear as I needed to be.  This is NOT for OUR company, it is the manner in which we would structure all accounts.  Again, the majority of our clients are law firms and accounting firms; many of which have multiple offices.  The most important aspects for this are:

a) our ability to see ALL of the contacts associated with that Account, but also know which office they belong to (as some of these offices are widely dispersed geographically); 

b) ability to see all Opportunities and Projects under the firm so that we can get a good handle on where to spend our marketing & sales efforts.

 

I believe there are two routes I could go:

1) setting up each office as it's own account and linking them via Connected To

2) creating a separate object, say "Office".  Adding a detail at the Account level and adding each office via this mechanism.

I'm leaning towards #2, but trying to understand the advantages/disadvantages of both routes -- as I don't want to "undo" built-in functionality that might actually help in us seeing a clear picture on this.  So far though, I'm not really seeing a clear path forward on route #1 -- disadvantages seem to outweigh the advantages of #2...especially as it relates to assigning individuals to each office but having visibility at the "parent company" Account.

 

Damon Hacker,

Thank you for specifying your task. You may use "departments" lookup - add departments for each account and bind employees for certain department. To specify the address you might use my 1st comment. If a certain Account has 6 offices it will have 6 addresses, each one with "department" name field. Then you may add additional field to projects and opportunities that will be required and name it "Department" - thus there will be no need for creating a separate object. Is this a suitable solution for you? 

Show all comments

Hi community,

our client is asking for a way to filter a second detail when selecting one of the records on a first detail list. In screenshot below, they want to list on the Benefit Stream list only the Benefits from the Claimant Test selected on the first detail.

Appreciate any assistance.

 

 

Like 0

Like

5 comments

Hello Danilo,

This article outlines how to do this: https://community.bpmonline.com/articles/filtering-detail-records-based…

Ryan

Hi Danilo, 

Do you have  solved your problem ?

Ryan Farley,

Thanks, Ryan!... I will try that.

Hi Aymen,

We are finishing a web service integration and will get back to this after. That´s why I didn´t update yet.

Thanks

Danilo Lage,

Thanks, Danilo

Show all comments

Hello Community!

I need convert a decimal and show it in percentage format in the word file. How can do it?

Like 0

Like

1 comments

How are multiple tasks in a step ordered from left to right? And how do I change this order?

They are created by Business Process in this case.

 

4 comments

Dear Julius,

Hope you are doing great today.

Unfortunately, there are no any basic tools in the system to change the order of the statuses or the tasks. Only development process can help you to change it. As a solution, you can try to change the localization to Arabic or Hebrew. The order of the statuses and the tasks are reversed there. Apart from that, here is the guide on how to reverse the order using the development tools -

https://academy.bpmonline.com/documents/technic-sdk/7-13/development-re…

Hope this solution will help you out.

Best regards,

Dean Parrett

Thanks, Dean. We need an option to sort the tasks in a stage propperly in bpm'online.

I have also tried to have them arranged by changing StartTime and EndTime. This does not work. We need a SortingOrder or SortingIndex -parameter on Tasks in bpm'online

Hello Julius,



The tasks are arranged in the order they were added.(Last added => last in list). So, the way how to change is to add them in appropriate way. I recommend to modify business process so that tasks were added in sorted way. 



Best regards, 

Alex

Alex_Tim, I solved it by adding some Read elements as fillers. It's not pretty, but it works! Thank you Alex.

 

We sould have a index parameter for elements for sorting Tasks when they are on the current stage at the same time on the Edit page.

Show all comments

Hello community,

my client is aiming to change the default document storage for attachments on every objects (Accounts, Contacts, Leads, Opportunities, Products, and Invoices) to Azure environment. 

They already have SSO for that Azure environment.

How could we handle this?

Thanks,

Like 0

Like

1 comments

Dear Danilo,

As for now there is no such functionality, unfortunately. As a workaround you may use the following application: https://marketplace.bpmonline.com/app/external-file-storage-bpmonline

Show all comments

Hi,

I want to set the default search for custom section

 

Regards,

Sunitha

Like 0

Like

1 comments

Dear Sunitha,

Can you please specify which button do you mean? The one that creates new record? 

Show all comments

Hi community, good morning.

I am looking for a way to bulk upload files and attach them to specific Products. I know we are not supposed to do so using the out-of-box data import.

Is there any option for it?

What would be the best practices?

Thanks

Like 0

Like

2 comments

Dear Danilo,

As for now there is no such functionality, but I'll inform our R&D team about this issue and suggest them to implement it. As a workaround you can use OData to import attachments: https://community.bpmonline.com/questions/how-upload-attachments-odata

Angela Reyes,

Thanks, Angela. We will appreciate if we could have such functionality.

Regards,

Show all comments

Hi. I'd like to have a Dashboard with additional Quick filters. The standard Pipeline Dashboard comes with a date-picker Quick-filter.

I'd like the standard Dashboard, with a By Owner, Quick filter.

In the chapter about the Sales Pipeline Dashboard in the Academy, there is a note about Quick filters at the very bottom of the article. But I can't figure out how to add quick filters to the Pipeline Dashboard.

https://academy.bpmonline.com/documents/base/7-13/sales-pipeline-dashbo…

https://academy.bpmonline.com/documents/base/7-13/quick-filter

Like 0

Like

1 comments

Dear Julius,

You can add quick filter block using the following article: https://academy.bpmonline.com/documents/technic-sdk/7-13/adding-quick-f…

You may also inspect already existing filter in the Pipelines to understand how it should look like for "Owner" or inspect Activity section since it has the same quick filter. 

Show all comments