Rookie error... apologies ----- Original Message ----- From: "Jacques Le Roux" <[email protected]> To: [email protected] Sent: Tuesday, October 27, 2009 9:36:50 AM GMT -05:00 US/Canada Eastern Subject: Re: Entity Sync
Hi Marc, Did you follow recent threads on this subject ? Jacques From: "Marc Morin" <[email protected]> > We have a couple of use cases where we need to sync a subset of the > information in one database and mirror it into another. > > Been looking at the entity sync capability that is present in ofbiz. Very > good start, ability to build a sync set that is a > collection of entities to sync (pull or push) between delegators (or service). > > In my case, I need to create the nest of entities to consider for the sync, > but I need to restrict the rows from some starting > point. > > Use case 1: Want to import a collection of parties from one system along with > their relationships between the set of parties and > their contact info, notes, preferences, etc.... > > Use case 2: Create a product category, rollups, and then associate products > to that category. Want to publish this category, > products, and subset of pricing, product content, features, etc.... to other > instances. > > Looks like a modification to entity sync is required to do this? or am i > mistaken. > > Modification involves: > > - build set of entities in sync group > - add condition restrictions on possibly any number of entities for candidate > rows. (category_id = 'x') > - "soft" inclusion by foreign key reference from a row in the set to one that > is not explicit. > - alter row for foreign key references outside of entity set to null or to > rows that cannot be replicated. > > > I'm sure more precision is needed here and will to do the work. Just wanted > to see if others have similar use cases and if so, > what they have done. > > Marc Morin > Emforium Group Inc. > ALL-IN Software™ > 519-772-6824 ext 201 > [email protected] > > >
