Do you mean it was a simple error on your side (sorry I did not take the time
to read all yet ;o) ?
Jacques
From: "Marc Morin" <[email protected]>
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]
