Answered

Synchronization Two Table in two Bizagi Project

Hi ;

We have two Bizagi projects. In Two Projects we have two table Named 'BAFILEUPLOAD' that Created By Bizagi.

We have two Dataset and we want Sync two table.

We try use 'saveentityasstring' web service but it didn't work.

How can I sync two tables?

Thanks very much.

Comments (6)

photo
1

Dear Mahdi,

BAFILEUPLOAD table is a system table and cannot be synchronised using SOA Methods neither Replication/virtualization.

Currently our product does not include this feature. We invite you to use our feedback platform on the ideas space to post your request.

This platform will allow you to share your ideas so that the whole Bizagi BPM Suite community can vote and discuss them. We want to make sure we solve the needs of our clients, so that we can add the features you consider most important.

Regards

photo
1

Ok, Thanks your answer

Now I change my question, I have some records in Excel and I want to write this data to 'BAFILEUPLOAD' table. I know type of table is a system table. Is there any way to import data to this table ?

After If I inserted data with insert command in SQL in this table, I can't add record from BIZAGI form and send a message that duplicate key or over write in old records.

Best Regards

photo
1

Dear Mahdi,

There is not a way to do what you want to do. This table cannot be modified directly because it is a system table. You can use a SOA Method in order to insert values in this table. For further information: http://help.bizagi.com/bpm-suite/en/index.html?uploading_files_using_soa_laye.htm.

We would like to know why you want to access and modify this table. Explain us details of your idea in order to give you solutions.

We look forward to hearing from you

photo
1

Thank you very much. I solved my problem with your comment and a small .NET Program.

photo
1

Dear Mahdi,

I've got the same problem I see you have solved it using a small .net application. I have uploaded file by a .net application in the correct directory then I transformed it to an array of bytes and I want to pass it as an object to Bizagi expression in order to add the related records in "BAFILEUPLOAD" table through using this expression: however I have problem. I would appreciate it if you could share your experience here or you could contact me through my email a: simin.maleki@gmail.com

var FileToUpload = Me.addRelation("Request.HistoryFile");

FileToUpload.setXPath("FileName", "DisplayNameOfTheFile.txt");

FileToUpload.setXPath("Data", FileData)

photo
photo
1

Mahdi,

I'm not an administrator.

I do however understand the need to clearly delineate 'issues' within a forum.

Would it not be better to submit a new topic - so that a search would find this new issue (rather than it be hidden within you old issue, with a completely different title)?

ATB,

Darrylle