Dear Mitch,

You can use "SectionName attachment" objects to trigger such process, for example "Contact attachment" object. 

Best regards,

Angela

Hello,

All files are stored as binary data in the "data" column of the object. Each one is stored in their own column, for example 'ActivityFile'

Best regards,

Angela

Angela Reyes,

Is it possible to copy the attachments from one object to another by copying the binary data from "data" column of the object.

Regards

Sivanesan

Hi,

If the field "Data" contains a correct value and not something like "0x" then yes, you can take this data and add it to another object.

For example, you can do it inside a business process script task.

 

var fileName = file.GetTypedColumnValue<string>("Name");
            var fileType = file.GetTypedColumnValue<Guid>("TypeId");
            var fileData = file.GetBytesValue("Data");
            
            var fileEntity = new ActivityFile(userConnection);
            fileEntity.SetDefColumnValues();
            fileEntity.SetColumnValue("ActivityId", activity.Id);
            fileEntity.SetColumnValue("TypeId", fileType);
            fileEntity.SetColumnValue("Name", fileName);
            fileEntity.SetColumnValue("Data", fileData);
            fileEntity.Save();

Dmytro Vovchenko,

Thanks for the response Dmytro. I am trying to copy the attachments from section A to section B. I have used "Add Data" element inside a BP to copy the data from A to B. The BP runs without any issue but when I try to open the same attachment from section B its throwing below error.

When I queried the object the attachments(both the sections) , it just shows the data type(System.Byte[]).

Can you please show how exactly you copy data in your bp?

Dmytro Vovchenko,

PFB

It looks like you cannot use "Add record" and "Read record" in this case because they cannot work with the "Data" type. You really need to use a script-task to read and add file:

        var ESQ = new EntitySchemaQuery(manager, AccountFile);
	    ESQ .AddColumn("Name");
	    ESQ .AddColumn("Data");
	    ESQ .AddColumn("Type");

	    var dataQueryResult = ESQ.GetEntityCollection(userConnection);
	    foreach(Entity file in dataQueryResult) {
		    var fileName = file.GetTypedColumnValue<string>("Name");
		    var fileType = file.GetTypedColumnValue<Guid>("TypeId");
		    var fileData = file.GetBytesValue("Data");
			
			var fileEntity = new ContactFile(userConnection);
		    fileEntity.SetDefColumnValues();
		    fileEntity.SetColumnValue("CintactId", contact.Id);
		    fileEntity.SetColumnValue("TypeId", fileType);
		    fileEntity.SetColumnValue("Name", fileName);
		    fileEntity.SetColumnValue("Data", fileData);
		    fileEntity.Save();
	    }

Dmytro Vovchenko,

I was able achieve it using the "Add data" itself. I missed to update/add the attachment type. After I added it I am able to open the attachment. Thanks for your input.

Dear Janine,

Please change the type to "Link": [#Lookup.Attachment Type.Link#].

This will solve the issue.

Regards,

Anastasia

Hi Mariia,

Did you figure out on how to change this?

I am looking for the solution as well.

Thank you in advance!

Kind regards,

Yosef

Hello Yosef,

Yes, we have found a solution. It was simple for our case.

Firstly, you need to add the necessary column to the [Section]File object, where [Section] is the name of your section in which the detail files are placed (In my example the column with type lookup names "Nature").

Then you create a "Replacing Client Module" where the parent schema is LinkPageV2 ( UIv2 ).

And then you create your column in the diff part:

define("LinkPageV2", ["terrasoft", "BusinessRuleModule", "ext-base", "sandbox", "ConfigurationConstants"],
function(Terrasoft, BusinessRuleModule, Ext, sandbox, ConfigurationConstants) {
	return {
		methods: {},
		diff: /**SCHEMA_DIFF*/[
			{
				"operation": "insert",
				"parentName": "LinkPageGeneralBlock",
				"propertyName": "items",
				"name": "Nature",
				"values": {
					"bindTo": "Nature",
					"layout": {
						"column": 12,
						"row": 0,
						"colSpan": 12
					}
				}
			},
		]/**SCHEMA_DIFF*/
	};
});

That's it)

Best regards,

Mariia

Please make sure that the object was published. Additionally please make sure that there is a view in the database named http://prntscr.com/mydb2y

Javier,



you can see my sample, how we add email attachment to the lead attachment.

So, you can created process on 'case is created' and add attachements from received email to the Case

Thank you!

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

Dear Pablo,

Such task can only be achieved by the means of development in the system.

In the Configuration add a replacing schema of FileDetailV2.

In the schema, you need to:

1. Initialize check of the current user, whether he has system administrator role. This is an ESQ method called in init function.

2. Set the result of ESQ to an attribute, so to use it later in the method check.

3. Override basic addColumnLink method and add two checks: section check and system administrator check.

The example of replacing FileDetailV2 schema is displayed below:

define("FileDetailV2", ["ConfigurationConstants"], function(ConfigurationConstants) {
	return {

		attributes: {
			"isSysAdmin": {
				"type": Terrasoft.ViewModelColumnType.VIRTUAL_COLUMN,
				"dataValueType": Terrasoft.DataValueType.BOOLEAN,
				"value": false
			}
		},

		methods: {
			init: function() {
				this.getUserRights();
				this.callParent(arguments);
			},
			addColumnLink: function(item, column) {
				if (this.parentEntity.EntityName === "KnowledgeBase") {
					if (this.get("isSysAdmin")) {
						this.callParent(arguments);
					}
				} else {
					this.callParent(arguments);
				}
			},
			getUserRights: function() {
				var scope = this;

				var currentUser = Terrasoft.SysValue.CURRENT_USER.value;
				var sysAdmins = ConfigurationConstants.SysAdminUnit.Id.SysAdministrators;
				var esq = Ext.create("Terrasoft.EntitySchemaQuery", { rootSchemaName: "SysUserInRole" });
				esq.addColumn("SysRole");
				esq.addColumn("SysUser");
				esq.filters.add("SysUser", Terrasoft.createColumnFilterWithParameter(
					Terrasoft.ComparisonType.EQUAL, "SysUser", currentUser));
				esq.filters.add("SysRole", Terrasoft.createColumnFilterWithParameter(
					Terrasoft.ComparisonType.EQUAL, "SysRole", sysAdmins));
				esq.getEntityCollection(function(response) {
					if (response && response.success) {
						var result = response.collection;
						var isSysAdmin = (result.collection.length !== 0);
						scope.set("isSysAdmin", isSysAdmin);
					}
				}, this);
			}
		}
	};
});

Regards,

Anastasia

Dear Allen,

You can find the example of the implementation in the academy article below:

https://academy.bpmonline.com/documents/technic-sdk/7-11/displaying-additional-columns-attachments-tab

Warm regards,

Matt

Thanks Matt! The columns are available after the implementing the customization. However the columns are not sortable. Is there a way to make the column headers trigger the sort operation when they are clicked on?

Dear Allen,

The following detail cannot be sorted out of the box due to its nature, it is not meant to store a large number of files initially. We recommend you to inspect the details, where the sorting is present and recreate the behavior in your detail, if it is required. Also, you can check one of the many marketplace applications that allow you to work with files more efficiently.

Warm regards,

Matt