Page 1 of 1

Replication of a record from one database to another

PostPosted: Wed Aug 19, 2015 2:41 pm
by Atronics
We have a custom program (.net 3.5 ) for one of our clients that replicates debtor records to their other databases. We have built a “Debtor.cs” class under “AtronicsClassLibrary”.

In Jiwa v6 we have the following breakout code, see the attached image ( Debtor Save Completed ) to create the object of this Debtor class and pass required parameters to the class and execute the method to replicate. This works fine in v6.

How can we achieve this in V7 plugging code at the Debtor Save completed event.

Re: Replication of a record from one database to another

PostPosted: Wed Aug 19, 2015 7:30 pm
by Mike.Sheen
I've done plugins in version 7 to do similar things - specifically create a Sales Order in another database when a PO is marked as sent in another, and another plugin to "mirror" inventory items between databases - when an inventory item is created or edited in database A, create or update it in database B - in fact I think we ship with a plugin that does exactly that - We don't ship with the said plugin (we probably should) - but it is published in the Samples and Examples thread.

Your requirement to do this with debtors is very similar to the Mirror Inventory plugin. You can examine that and refactor it to use debtors instead. If that is beyond your ability or you feel it would be more efficient for us to do it for you then you should contact [email protected] to put in a customisation request and we can do that (for a fee - our time is valuable, as is yours).

If I were to guess the time it would take for us to do this, I would say around 6 hours - depending on the specific logic you want - i.e.: what rules do you want for mapping debtor classifications, categories, GL accounts, et cetera. The more complexity, the more time it will take to develop and test.

You can also simply log this as an enhancement request (again with [email protected]), and we'll get to it at some point and publish it with the standard product - and then you can take that standard plugin we had produced and tweak it to suit your specific needs.

Mike

Re: Replication of a record from one database to another

PostPosted: Wed Aug 26, 2015 10:32 am
by Atronics
Mike,
How soon could you build this?

John

Re: Replication of a record from one database to another  Topic is solved

PostPosted: Wed Sep 02, 2015 3:40 pm
by Mike.Sheen
Atronics wrote:Mike,
How soon could you build this?

John


Hi John,

If your requirements are simple, then it would only take a few hours and it could be completed within a week or two from now.