Re: How to clean up external db entities with names matching OFBiz internal entities?

I finally got the second delegator to work. The external db delegator throws errors initially because it cannot find OFBiz tables but works as needed the warnings are thrown. Most of the instructions to get to this point was provided in https://cwiki.apache.org/confluence/display/OFBIZ/Handli

Re: How to clean up external db entities with names matching OFBiz internal entities?

I plan on using mini-lang simple-methods to implement the import scripts and noticed that the tag has a delegator-name attribute. I'm not sure if this means it is required to create a separate delegator when connecting to external dbs with entities names matching those of OFBiz. I'll probably

Re: How to clean up external db entities with names matching OFBiz internal entities?

Seems like the relevant information to resolve this issue has been removed from https://cwiki.apache.org/OFBIZ/ofbiz-tutorial-a-beginners-development-guide.html. On 01/16/2014 10:53 AM, Christian Carlow wrote: I'm working on importing data into OFBiz and have encountered a stoppage issue relat

Re: JOINs across different DBs

Sorry, it's *NOT a viable migration method in my case On 01/16/2014 11:42 AM, Christian Carlow wrote: Hey Jad, Concerning view-entities, I mean that in my case I would need the ability to join the Product.internalName to externalDbProduct.internalName (just for example). I don't thing the

Re: JOINs across different DBs

Hey Jad, Concerning view-entities, I mean that in my case I would need the ability to join the Product.internalName to externalDbProduct.internalName (just for example). I don't thing the entity engine allows this period so it defeats the purpose of attempting to join the external entity in

Re: JOINs across different DBs

Hi Christian, As you are saying, there's no real open source equivalent to UnityJDBC. Although it would have been nice to have one, in order to integrate it maybe with Ofbiz in the future. Concerning view-entities, to be honest, I don't really know why they can't be used on different DBs. BTW, s

How to clean up external db entities with names matching OFBiz internal entities?

I'm working on importing data into OFBiz and have encountered a stoppage issue related to external db entity names matching those of OFBiz. I added a element to the default delegator in entityengine.xml because I gave up trying to create a separate delegator for the external entity described

Re: How to store manufacturer product name different than one given by customer?

This nabble thread about brand names is somewhat related to this issue: http://ofbiz.135035.n4.nabble.com/Is-brands-supported-in-ofbiz-td3090415.html Again the internalName must be set to the name the customer assigns the product because its the only required field of the product entity and th

How to associate purchase order with sales order?

Anyone know how to associate a purchase order with a sales order? Seems like one of the OrderItemAssoc or OrderItemAssociation entities are meant to store such information but the only code I've found so far deals with drop shipments. Is there an UI that allows this information to be created/e

Re: JOINs across different DBs

Thanks Jad, I'm looking for any open-source equivalent to UnityJDBC but there doesn't seem to be much out there. Regardless of using such a tool, I think the OFBiz entity engine will issues joining the external db due to incompatible primary keys in the external db. I think view-entities re

Re: Any way to create view-entities joining entities from different datasources?

Hi Christian, Check my previous post: http://ofbiz.135035.n4.nabble.com/JOINs-across-different-DBs-td4647103.html Cheers, Christian Carlow-OFBizzer wrote > I assume that for entities of different datasources to be