Re: More Confusion

2007-09-11 Thread Jacopo Cappellato
What OFBiz version are you using? Could you please try to recreate the 
same issue here:


https://demo.hotwaxmedia.com/ordermgr/control/main

Thanks,

Jacopo


[EMAIL PROTECTED] wrote:

Just to verify this, I cleaned everything out to start from scratch.  I used
the Order-Order Entry module to make a sale for $100 + shipping and tax and
quick shipped it.
This was to a billing account.

I now have a single entry for OrderPaymentPreference of $100++ and
paymentMethodId=EXT_BILLACT and statusId = PAYMENT_RECEIVED
I have a single entry for PaymentApplication where amountApplied = $100++
and a billingAccountId and invoiceId.

I call the service getBillingAccountBalance() in BillingAccountWorker and
get returned $5000 when the account limit is $5000.  It should have been
$4900--.

I added some logging to getBillingAccountBalance() and discovered that the
OrderPaymentPreference was not subtracted because it was  status
PAYMENT_RECEIVED.

PaymentApplication was also ignored because invoiceId != null.

As expected, when I recorded a payment of $100++ on the account, I now have
a $5100++ balance.

Did I miss a step or is this logic in getBillingAccountBalance() wrong or
should the order application have made a second posting to
OrderPaymentPreferences.

Maybe these billing accounts are not intended for Customer sales?  Is
OrderPaymentPreference maybe mis-named and should be OrderPayments?

Any help understanding these issues would be appreciated.  I am writing a
real A/R application with aging and the like and want to keep it as clean
and compatible with Ofbiz core code as possible.



Skip





More Confusion

2007-09-11 Thread [EMAIL PROTECTED]
Just to verify this, I cleaned everything out to start from scratch.  I used
the Order-Order Entry module to make a sale for $100 + shipping and tax and
quick shipped it.
This was to a billing account.

I now have a single entry for OrderPaymentPreference of $100++ and
paymentMethodId=EXT_BILLACT and statusId = PAYMENT_RECEIVED
I have a single entry for PaymentApplication where amountApplied = $100++
and a billingAccountId and invoiceId.

I call the service getBillingAccountBalance() in BillingAccountWorker and
get returned $5000 when the account limit is $5000.  It should have been
$4900--.

I added some logging to getBillingAccountBalance() and discovered that the
OrderPaymentPreference was not subtracted because it was  status
PAYMENT_RECEIVED.

PaymentApplication was also ignored because invoiceId != null.

As expected, when I recorded a payment of $100++ on the account, I now have
a $5100++ balance.

Did I miss a step or is this logic in getBillingAccountBalance() wrong or
should the order application have made a second posting to
OrderPaymentPreferences.

Maybe these billing accounts are not intended for Customer sales?  Is
OrderPaymentPreference maybe mis-named and should be OrderPayments?

Any help understanding these issues would be appreciated.  I am writing a
real A/R application with aging and the like and want to keep it as clean
and compatible with Ofbiz core code as possible.



Skip



OrderPaymentPreference

2007-09-11 Thread [EMAIL PROTECTED]
I am confused about the naming and use of the OrderPaymentPreference Entity.
I have done some limited testing and observation and it looks to me like the
sum of maxAmount for any orderId should exactly equal the grandTotal or the
OrderHeader record with the same orderId.

Is that correct, and if not, under what conditions might they not match?
(Or maybe I am barking up the wrong tree.)  I am looking at this in
relationg to BillingAccounts (and in general just trying to understand it).

I am worried about this because a Payment uses a PaymentApplication which
references an invoiceId and no mention of the orderId used by
OrderPayentPreference.  Is there some linking entity or bridge I am missing?

Skip



Re: Link Party

2007-09-11 Thread Jonathon -- Improov
IMO, the problem with "mere linkage" is that there'd be so many scattered pieces of data to stitch 
together. Data retrieval or traversal will get a little heavy.


Might be better to simply reconcile duplicate Party(s) into one Party, and drop the duplicates 
thereafter.


That said, I think the Link function can still work very nicely as an interim measure. Or even as 
a permanent measure, if you don't mind having to keep track of scattered pieces of data. One 
possible snag is when you perform a "lookup" function, say like "Find all Party(s) with name like 
Blah". Your "lookup" function must consider linked Party(s) (aka duplicates), and NOT return those 
results.


Jonathon

Dave Tenerowicz wrote:

Yes, that's what we'll be doing.
IP address and visitorId would not be useful, since (in Phase 1) this is 
strictly an order taking function via sales reps- so there is no party 
specific IP address or visitorId.

Thanks for the suggestions though!

I gather that the Link function would offer no benefit for this, since 
no one has mentioned it??


-Dave

David E Jones wrote:


I think most companies do it by comparing things like name, phone 
number, address, etc.


Not sure where the IP address idea came from...

-David


Jonathon -- Improov wrote:
What's the usual way to reconcile duplicates in Party(s)? Like if we 
have multiple Party(s) for the same person.


Perhaps have an administrator click a button that pools together 
suspected duplicate Party(s)? The administrator can then transfer all 
related records from one duplicate to another, possibly with audit 
trails intact too. Sounds like heavy coding work, though.


I'll need to handle the above, since there is no way I can prevent a 
user from creating duplicate Party(s).


Or more strictly prevent duplicates in the first place? Maybe I can 
have like a "3-point comparison" function that decides whether the 
user is entering duplicate data. I suppose I can dictate that there 
can be no duplicates in "name and postal code and mobile phone number 
(plus any other super-personal details)".


Jonathon

David E Jones wrote:


The visitorId may be more reliable... at least you know it's the 
same browser with that. See the Visitor table and related 
functionality.


-David


[EMAIL PROTECTED] wrote:
When IP addresses are typically assigned dynamically, I doubt this 
will be

useful.  Better to store a back resolved host name if you can get one.
Still not infallible if two users use the same machine.

Skip

-Original Message-
From: BJ Freeman [mailto:[EMAIL PROTECTED]
Sent: Monday, September 10, 2007 8:22 PM
To: user@ofbiz.apache.org
Subject: Re: Link Party


An IP of each order is recorded.
you may be able to have a service the links orders by iP address.
this is not infallible but can help.


Dave Tenerowicz sent the following on 9/10/2007 3:03 PM:
Can anyone tell me what the Link Party function under Party 
Manager does?
An implementation we are doing includes a significant number of 
customer

records that are duplicates. In these cases the same party may have
placed Orders under different partyId's. The client claims that
identification of duplicates  can only be done by humans( I doubt 
this

!!, but that is another story). What they have requested is that we
develop a service that will assign all records related to one 
party to

another partyId. I am wondering if Link Party can be leveraged here.

Thanks for any input
















No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.485 / Virus Database: 269.13.15/1002 - Release Date: 9/11/2007 5:46 PM




RE: Primary IRC channel on freenode

2007-09-11 Thread Vikrant.Rathore
Hi Tim,

Thanks for the information would join the channel.

Regards,
Vikrant


-Original Message-
From: Tim Ruppert [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, September 12, 2007 10:24 AM
To: user@ofbiz.apache.org
Subject: Re: Primary IRC channel on freenode

Vikrant, it's already there my friend.  chat.us.freenode.net #ofbiz



Cheers,
Tim
--
Tim Ruppert
HotWax Media
HYPERLINK "http://www.hotwaxmedia.com"http://www.hotwaxmedia.com

o:801.649.6594
f:801.649.6595


On Sep 11, 2007, at 7:31 PM, mailto:[EMAIL PROTECTED]"[EMAIL 
PROTECTED]> mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]> wrote:


Hi Everyone,



I am interested in opening an IRC channel for ofbiz on freenode.net similar to 
plone and django. Please let me know your thoughts.



David,



It would be great if we can have an IRC channel so we can have someone 
available to help newbie on a regular basis.



For Plone and Django I am using it and fine it really very convenient.


Regards,

Vikrant




No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.485 / Virus Database: 269.13.15/1002 - Release Date: 9/11/2007 
5:46 PM




No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.485 / Virus Database: 269.13.15/1002 - Release Date: 9/11/2007 
5:46 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.485 / Virus Database: 269.13.15/1002 - Release Date: 9/11/2007 
5:46 PM
 


Re: Primary IRC channel on freenode

2007-09-11 Thread Tim Ruppert

Vikrant, it's already there my friend.  chat.us.freenode.net #ofbiz

Cheers,
Tim
--
Tim Ruppert
HotWax Media
http://www.hotwaxmedia.com

o:801.649.6594
f:801.649.6595


On Sep 11, 2007, at 7:31 PM, <[EMAIL PROTECTED]>  
<[EMAIL PROTECTED]> wrote:



Hi Everyone,



I am interested in opening an IRC channel for ofbiz on freenode.net  
similar to plone and django. Please let me know your thoughts.




David,



It would be great if we can have an IRC channel so we can have  
someone available to help newbie on a regular basis.




For Plone and Django I am using it and fine it really very convenient.


Regards,

Vikrant




No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.485 / Virus Database: 269.13.15/1002 - Release Date:  
9/11/2007 5:46 PM






smime.p7s
Description: S/MIME cryptographic signature


Primary IRC channel on freenode

2007-09-11 Thread Vikrant.Rathore
Hi Everyone,

 

I am interested in opening an IRC channel for ofbiz on freenode.net similar to 
plone and django. Please let me know your thoughts.

 

David,

 

It would be great if we can have an IRC channel so we can have someone 
available to help newbie on a regular basis.

 

For Plone and Django I am using it and fine it really very convenient.


Regards,

Vikrant

 


No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.485 / Virus Database: 269.13.15/1002 - Release Date: 9/11/2007 
5:46 PM
 


Re: Ofbiz for restaurants - please advise

2007-09-11 Thread Ray Barlow
Comments below...

Bilgin Ibryam wrote:
> Ray, Jacques, thank you for answering.
>
> Ray, first i will answer your questions.
> I will need to run multiple pos terminals, possibly with own peripherals and
> some shared (printers may be). As you guessed for this purpose i will use
> applets. But the applet should be used only for this tasks, not for the
> whole UI.
> For now, the only hardware requirement are touchscreen and printers, so at
> this stage it will be mostly UI customization. But the hardware requirement
> will come after that.
>   
As mentioned in another thread touch screens are OS driven and only tend
to result in XY mouse click events, therefore not part of the
application deployment more OS driver configuration, LTSP maybe.
If you require one hardware item like a printer then you need some sort
of terminal configuration system which will just as easily scale to
multiple. Perhaps you can wrap a table or two around the existing xml
configuration files to serve those to terminals as they log in, maybe
linked to IP address, machine name or even a cookie?
> The screens should be similar to existing pos (i checked other pos systems,
> they all looks the same), but i donot want to use XML for button titles and
> product hard coding as it is in ofbiz pos. The products should come
> dynamically from categories and catalogs, like in order manager (especially
> as ecommerce).
>   
OK that's a nice addition to have a data driven panel for categories and
products, but you have a lot of other buttons, panels and screens to
handle so what are you proposing for those?
> Jacques,
> First i tried to go extending POS. I saw your message in opentaps forum
> saying that customer recording will be soon implemented in pos. Then there
> is issue in jira for manipulating configurable products through POS (it is
> almost finished), issue for loading orders to POS created from order
> manager...
> Even all these future POS improvement plans, implementing other requirements
> will need much more time for me, mainly because i am not well familiar with
> XUI framework. And also there are lots of ready things for web in ofbiz. On
> the other hand, the peripherals will be harder to integrate, but there
> should be something difficult ;)
>   
Maybe I'm not understanding your reason but you seem to be suggesting
the use of html because you're not familiar with XUI rather than any
technical reasoning. Is that correct? I'm no expert on XUI and you don't
need to be to work on the POS module, one day and you can learn the
basics of it.

Don't misunderstand me I'm not fanatical about keeping XUI but I would
like to see your implementation replace the existing POS as an
improvement, where by it provides the same features and more. But rich
UI using html can be hard work, it may have gotten easier with AJAX and
others but you need to prove there won't be to much latency with server
round trips or get bogged down with lots of java script code which is
always a nightmare.

Ray
> With 'using html' i mean that i will use ofbiz widgets and ftl (but not
> XUI). Possibly mostly ftls for more flexibility in applying custom styles.
> Thanks for the links. Till then i could not find a web pos example. It looks
> there are lots of interesting things in French sites :)
>
> Regarding orders, i will listen to you both and try to find a way for one
> order per table. There is no multiple orders editing example in ofbiz, and
> it could be risky and for sure time consuming operation.
> The main requirement for me is to group the products for each customer in
> the order/table and then multiple payments (usually one payment per group).
> Is there any other way to group products in the shopping cart? I guess only
> for ship groups.
>
> Thanks for your valuable time and comments.
>
>   


Re: Link Party

2007-09-11 Thread Dave Tenerowicz

Yes, that's what we'll be doing.
IP address and visitorId would not be useful, since (in Phase 1) this is 
strictly an order taking function via sales reps- so there is no party 
specific IP address or visitorId.

Thanks for the suggestions though!

I gather that the Link function would offer no benefit for this, since 
no one has mentioned it??


-Dave

David E Jones wrote:


I think most companies do it by comparing things like name, phone 
number, address, etc.


Not sure where the IP address idea came from...

-David


Jonathon -- Improov wrote:
What's the usual way to reconcile duplicates in Party(s)? Like if we 
have multiple Party(s) for the same person.


Perhaps have an administrator click a button that pools together 
suspected duplicate Party(s)? The administrator can then transfer all 
related records from one duplicate to another, possibly with audit 
trails intact too. Sounds like heavy coding work, though.


I'll need to handle the above, since there is no way I can prevent a 
user from creating duplicate Party(s).


Or more strictly prevent duplicates in the first place? Maybe I can 
have like a "3-point comparison" function that decides whether the 
user is entering duplicate data. I suppose I can dictate that there 
can be no duplicates in "name and postal code and mobile phone number 
(plus any other super-personal details)".


Jonathon

David E Jones wrote:


The visitorId may be more reliable... at least you know it's the 
same browser with that. See the Visitor table and related 
functionality.


-David


[EMAIL PROTECTED] wrote:
When IP addresses are typically assigned dynamically, I doubt this 
will be

useful.  Better to store a back resolved host name if you can get one.
Still not infallible if two users use the same machine.

Skip

-Original Message-
From: BJ Freeman [mailto:[EMAIL PROTECTED]
Sent: Monday, September 10, 2007 8:22 PM
To: user@ofbiz.apache.org
Subject: Re: Link Party


An IP of each order is recorded.
you may be able to have a service the links orders by iP address.
this is not infallible but can help.


Dave Tenerowicz sent the following on 9/10/2007 3:03 PM:
Can anyone tell me what the Link Party function under Party 
Manager does?
An implementation we are doing includes a significant number of 
customer

records that are duplicates. In these cases the same party may have
placed Orders under different partyId's. The client claims that
identification of duplicates  can only be done by humans( I doubt 
this

!!, but that is another story). What they have requested is that we
develop a service that will assign all records related to one 
party to

another partyId. I am wondering if Link Party can be leveraged here.

Thanks for any input













--
Dave Tenerowicz
[EMAIL PROTECTED]

Office: 303.493.6727
Mobile 303.906.6116
Fax 303.814.8330

Visit us at http://www.salmonllc.com



Re: Ofbiz for restaurants - please advise

2007-09-11 Thread Bilgin Ibryam

Ray, Jacques, thank you for answering.

Ray, first i will answer your questions.
I will need to run multiple pos terminals, possibly with own peripherals and
some shared (printers may be). As you guessed for this purpose i will use
applets. But the applet should be used only for this tasks, not for the
whole UI.
For now, the only hardware requirement are touchscreen and printers, so at
this stage it will be mostly UI customization. But the hardware requirement
will come after that.
The screens should be similar to existing pos (i checked other pos systems,
they all looks the same), but i donot want to use XML for button titles and
product hard coding as it is in ofbiz pos. The products should come
dynamically from categories and catalogs, like in order manager (especially
as ecommerce).

Jacques,
First i tried to go extending POS. I saw your message in opentaps forum
saying that customer recording will be soon implemented in pos. Then there
is issue in jira for manipulating configurable products through POS (it is
almost finished), issue for loading orders to POS created from order
manager...
Even all these future POS improvement plans, implementing other requirements
will need much more time for me, mainly because i am not well familiar with
XUI framework. And also there are lots of ready things for web in ofbiz. On
the other hand, the peripherals will be harder to integrate, but there
should be something difficult ;)
With 'using html' i mean that i will use ofbiz widgets and ftl (but not
XUI). Possibly mostly ftls for more flexibility in applying custom styles.
Thanks for the links. Till then i could not find a web pos example. It looks
there are lots of interesting things in French sites :)

Regarding orders, i will listen to you both and try to find a way for one
order per table. There is no multiple orders editing example in ofbiz, and
it could be risky and for sure time consuming operation.
The main requirement for me is to group the products for each customer in
the order/table and then multiple payments (usually one payment per group).
Is there any other way to group products in the shopping cart? I guess only
for ship groups.

Thanks for your valuable time and comments.

-- 
View this message in context: 
http://www.nabble.com/Ofbiz-for-restaurants---please-advise-tf4414083.html#a12624061
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: getProductRequirementMethod

2007-09-11 Thread Mark Erbaugh
On Tue, 2007-09-11 at 13:43 -0400, Walter Vaughan wrote:
> Mark Erbaugh wrote:
> > I can not
> > find a definition for getProductRequirementMethod 
> 
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/script/org/ofbiz/order/order/OrderServices.xml?view=markup

Walter,

Thank you.  I must have done something wrong in my search, because now
that I look in my version of OrderServices.xml I find it - don't know
why it didn't show up before.

Of course, this still leaves the question why I am getting the original
error:

Message: Error running simple method [checkCreateOrderRequirement] in
XML file [org/ofbiz/order/order/OrderServices.xml]:  (Could not find
SimpleMethod XML document in resource:
org/ofbiz/order/order/OrderServices.xml)

Thanks,
Mark





Re: ofBiz for a Super Market

2007-09-11 Thread Brett Palmer
Thomas,

If you do use Flex or Lazlo you will need to access the services
through the ofbiz controller (presentation layer).

You will also have to re-implement existing funtionality in Flex/Lazlo
if you don't use ofbiz screens.

If you need to use a UI like flex I would isolate it to some key
funtionality and try to use existing apps where possible.


Brett


On 9/11/07, Al Byers <[EMAIL PROTECTED]> wrote:
> Thomas,
>
> I have been doing a bit with Dojo (http://www.dojotoolkit.org) lately and I
> recommend it. I think it will be possible to integrate the XML-based screen
> widget technology with that toolkit, but I don't know how soon it will be
> happening.
>
> BTW, I have been adding bits and pieces of GIS functionality to OFBiz so you
> could use GeoRSS (search in JIRA for GeoRSS) to work with Google Maps or
> there is the skeleton of a WFS interface in OFBiz which would allow you to
> get the long/lat values from other clients such as MapBuilder.
>
> -Al
>
> On 9/11/07, Thomas Jiji <[EMAIL PROTECTED]> wrote:
> >
> > Hi all,
> >
> >
> >
> > Im getting ready to jump in OfBiz to build a supermarket E-Store
> > (Multi-Facility, Pick up-Delivery, recurrent Shopping lists, recipes).
> >
> > I've been reading alot on ofBiz this past week but i still need a
> > confirmation for this issue.
> >
> >
> >
> > 1) Using the ofBiz Service Engine or any other form of API, is it
> > possible to build a Rich UI ( Lazslo, Flex ...) on top of that API ?
> >
> >
> >
> > 2)Has anyone seen a Supermarket e-store built on ofBiz, because i didnt
> > see one the the Project List
> >
> >
> >
> > It would be much appreciated to get an answer back.
> >
> >
> >
> > Thank you.
> >
> >
> >
> >
> >
> > -- Thomas Jiji
> >
> >
> >
> >
>


Re: getProductRequirementMethod

2007-09-11 Thread Walter Vaughan

Mark Erbaugh wrote:

I can not
find a definition for getProductRequirementMethod 


http://svn.apache.org/viewvc/ofbiz/trunk/applications/order/script/org/ofbiz/order/order/OrderServices.xml?view=markup


getProductRequirementMethod

2007-09-11 Thread Mark Erbaugh
I'm still working through the Ofbiz manufacturing process.

I'm getting errors

Message: Error running simple method [checkCreateOrderRequirement] in
XML file [org/ofbiz/order/order/OrderServices.xml]:  (Could not find
SimpleMethod XML document in resource:
org/ofbiz/order/order/OrderServices.xml)


I've looked at the OrderServices.xml code and
checkCreateOrderRequirement is there.  However it calls
getProductRequirementMethod (as do several other methods), but I can not
find a definition for getProductRequirementMethod (I did a global text
search on the entire project).

Thanks,
Mark



Re: Travel Demo / Websites

2007-09-11 Thread Adrian Crum

The Hot Deploy folder will contain the add-ons after you download and install 
the add-ons.

The OpenTravel system is built from OFBiz but it is not a part of the core project. You have to go 
to their site to get it.



Mark Erbaugh wrote:


On Tue, 2007-09-11 at 09:15 -0700, BJ Freeman wrote:


not sure what version of ofbiz your using.



I'm using release 4 from the SVN.



The latest SVN does not have the webtravel demo application included.
previous SVN before move to apache did have this.
you can go to http://opentravelsystem.org/so/control/ots
and see the demo and get the source code.


the folder structure has been modified some over the last few years.
basically the applications folder are found in the Data model Books
referred to on the website.



I do have "Data Model Resource Book, Volume 1" and I'm working throught
that as I work through Ofbiz.



there is either a "specialized" or "Special purpose" folder that
things
like the travel demo are in.
note that some application like the cmfsa and open travel are put in
the
Hot deploy folder and are not part of the ofbiz SVN.



There is nothing but a README.txt in my hot-deploy folder.

So is this a case of the sample data includes setup information but the
supporting components have been moved from the main app and into a
special purpose category?

It's not a big deal for me. My big concern right now is to get the
manufacturing working for a potential client.

Mark




Re: Link Party

2007-09-11 Thread Jonathon -- Improov
For the ecommerce side of things? Nice. Sort of like flagging possible duplicates for backend 
handling.


Jonathon

BJ Freeman wrote:

in the application I wrote for accepting real-time orders from a
website, I have a service that is run to check different parms in the IP
and address fields. It then sets the order to hold status if there are
matches to the parms.
this shows up in the order task list to be dealt with by a human.

Jonathon -- Improov sent the following on 9/11/2007 7:29 AM:

Hmm. My very next project absolutely requires that. The duplicates don't
come from eCommerce, BUT still... I'm not gonna prompt users about
possible duplicates when they enter data (want to accelerate initial
data entry effort).

I'll need a webtool for the admin (or other permitted parties) to
periodically reconcile duplicate Party(s). Will be doing it soon.

Let me know what criteria should be checked? So far, I'm just thinking
"name, postal code, birthdate, mobile phone number". Note that my
application mandates the entry of birthdate, not so for ecommerce apps.
Help me do something that is also usable by ecommerce side?

Thanks.

Jonathon

Jacques Le Roux wrote:

Yes this sounds interesting, to me at least. There is always plenty of
party duplicates coming from eCommerce.

An administrator webtool as suggested by Jonathon may be interesting
too...

Jacques

De : "Bilgin Ibryam" <[EMAIL PROTECTED]>

I also have the same need and idea for preventing duplicate
person/customer
entries but still no time for it. My idea was to write an event for
checking
some key fields like Jonathon said and if they already exist in the
DB to
require a confirmation before recording(duplicating) the new customer.

Is it a good idea to have such a mechanism for precheck in ofbiz ?
May be
more generic one.
--
View this message in context:
http://www.nabble.com/Link-Party-tf4418931.html#a12612663
Sent from the OFBiz - User mailing list archive at Nabble.com.














Re: Travel Demo / Websites

2007-09-11 Thread Mark Erbaugh
On Tue, 2007-09-11 at 09:15 -0700, BJ Freeman wrote:
> not sure what version of ofbiz your using.

I'm using release 4 from the SVN.

> The latest SVN does not have the webtravel demo application included.
> previous SVN before move to apache did have this.
> you can go to http://opentravelsystem.org/so/control/ots
> and see the demo and get the source code.
> 
> 
> the folder structure has been modified some over the last few years.
> basically the applications folder are found in the Data model Books
> referred to on the website.

I do have "Data Model Resource Book, Volume 1" and I'm working throught
that as I work through Ofbiz.

> there is either a "specialized" or "Special purpose" folder that
> things
> like the travel demo are in.
> note that some application like the cmfsa and open travel are put in
> the
> Hot deploy folder and are not part of the ofbiz SVN.

There is nothing but a README.txt in my hot-deploy folder.

So is this a case of the sample data includes setup information but the
supporting components have been moved from the main app and into a
special purpose category?

It's not a big deal for me. My big concern right now is to get the
manufacturing working for a potential client.

Mark



Re: ofBiz for a Super Market

2007-09-11 Thread Al Byers
Thomas,

I have been doing a bit with Dojo (http://www.dojotoolkit.org) lately and I
recommend it. I think it will be possible to integrate the XML-based screen
widget technology with that toolkit, but I don't know how soon it will be
happening.

BTW, I have been adding bits and pieces of GIS functionality to OFBiz so you
could use GeoRSS (search in JIRA for GeoRSS) to work with Google Maps or
there is the skeleton of a WFS interface in OFBiz which would allow you to
get the long/lat values from other clients such as MapBuilder.

-Al

On 9/11/07, Thomas Jiji <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
>
>
> Im getting ready to jump in OfBiz to build a supermarket E-Store
> (Multi-Facility, Pick up-Delivery, recurrent Shopping lists, recipes).
>
> I've been reading alot on ofBiz this past week but i still need a
> confirmation for this issue.
>
>
>
> 1) Using the ofBiz Service Engine or any other form of API, is it
> possible to build a Rich UI ( Lazslo, Flex ...) on top of that API ?
>
>
>
> 2)Has anyone seen a Supermarket e-store built on ofBiz, because i didnt
> see one the the Project List
>
>
>
> It would be much appreciated to get an answer back.
>
>
>
> Thank you.
>
>
>
>
>
> -- Thomas Jiji
>
>
>
>


PO Approval

2007-09-11 Thread Mark Erbaugh
I'm working through the manufacturing process.  I've created some raw
materials and am trying to create a PO to order them.

I've got the PO created and can even print it, but when viewing the PO
and I click on "Approve Order," I get the error:

ERROR : Cannot store status changes :SQL Exception occurred on commit
(Cannot commit a transactional connection: See JDBC 2.0 Optional Package
Specification section 7.1 (p25))

In the console in Eclipse, I'm also seeing an error message:

[Error] :2:12: cvc-elt.1: Cannot find the declaration of element
'ofbiz-ser'.

and

Message: Error running simple method [checkCreateOrderRequirement] in
XML file [org/ofbiz/order/order/OrderServices.xml]:  (Could not find
SimpleMethod XML document in resource:
org/ofbiz/order/order/OrderServices.xml)


Thanks,
Mark



Re: Travel Demo / Websites

2007-09-11 Thread BJ Freeman
not sure what version of ofbiz your using.
The latest SVN does not have the webtravel demo application included.
previous SVN before move to apache did have this.
you can go to http://opentravelsystem.org/so/control/ots
and see the demo and get the source code.


the folder structure has been modified some over the last few years.
basically the applications folder are found in the Data model Books
referred to on the website.
there is either a "specialized" or "Special purpose" folder that things
like the travel demo are in.
note that some application like the cmfsa and open travel are put in the
Hot deploy folder and are not part of the ofbiz SVN.



Mark Erbaugh sent the following on 9/11/2007 8:36 AM:
> On Tue, 2007-09-11 at 07:54 -0700, Adrian Crum wrote:
>> The  element in the component's ofbiz-component.xml file.
>>
>>
>> Mark Erbaugh wrote:
>>
>>> While browsing the Ofbiz default setup, it appears that there is a
>>> Travel Demo (OpenTravelSystem) website, but I can't find how to
>> access
>>> it.
>>>
>>> Also, where is the mount point for a given website maintained. I
>> know
>>> from the documentation and from WebTools | View Components that the
>>> ecommerce demo is mounted at ecommerce (and that the ecommerce clone
>> is
>>> mounted at ecomclone), but I can't find the mount points in any
>> editable
>>> setup table for the websites.
> 
> 
> Thank you. I've found the webapp element for the ecommerce and ecommerce
> clone websites.  Where is the webapp for the travel demo?
> 
> Mark
> 
> 
> 
> 


RE: Link Party

2007-09-11 Thread Skip
I have the same needs for duplicate checker and am happy to split the
workload.

Skip

-Original Message-
From: Jonathon -- Improov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 11, 2007 7:30 AM
To: user@ofbiz.apache.org
Subject: Re: Link Party


Hmm. My very next project absolutely requires that. The duplicates don't
come from eCommerce, BUT
still... I'm not gonna prompt users about possible duplicates when they
enter data (want to
accelerate initial data entry effort).

I'll need a webtool for the admin (or other permitted parties) to
periodically reconcile duplicate
Party(s). Will be doing it soon.

Let me know what criteria should be checked? So far, I'm just thinking
"name, postal code,
birthdate, mobile phone number". Note that my application mandates the entry
of birthdate, not so
for ecommerce apps. Help me do something that is also usable by ecommerce
side?

Thanks.

Jonathon

Jacques Le Roux wrote:
> Yes this sounds interesting, to me at least. There is always plenty of
party duplicates coming from eCommerce.
>
> An administrator webtool as suggested by Jonathon may be interesting
too...
>
> Jacques
>
> De : "Bilgin Ibryam" <[EMAIL PROTECTED]>
>>
>> I also have the same need and idea for preventing duplicate
person/customer
>> entries but still no time for it. My idea was to write an event for
checking
>> some key fields like Jonathon said and if they already exist in the DB to
>> require a confirmation before recording(duplicating) the new customer.
>>
>> Is it a good idea to have such a mechanism for precheck in ofbiz ? May be
>> more generic one.
>> --
>> View this message in context:
http://www.nabble.com/Link-Party-tf4418931.html#a12612663
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>




RE: Link Party

2007-09-11 Thread Skip
I'll have the same duplicate removal requirement and am happy to split the
workload.

-Original Message-
From: Jonathon -- Improov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 11, 2007 7:30 AM
To: user@ofbiz.apache.org
Subject: Re: Link Party


Hmm. My very next project absolutely requires that. The duplicates don't
come from eCommerce, BUT
still... I'm not gonna prompt users about possible duplicates when they
enter data (want to
accelerate initial data entry effort).

I'll need a webtool for the admin (or other permitted parties) to
periodically reconcile duplicate
Party(s). Will be doing it soon.

Let me know what criteria should be checked? So far, I'm just thinking
"name, postal code,
birthdate, mobile phone number". Note that my application mandates the entry
of birthdate, not so
for ecommerce apps. Help me do something that is also usable by ecommerce
side?

Thanks.

Jonathon

Jacques Le Roux wrote:
> Yes this sounds interesting, to me at least. There is always plenty of
party duplicates coming from eCommerce.
>
> An administrator webtool as suggested by Jonathon may be interesting
too...
>
> Jacques
>
> De : "Bilgin Ibryam" <[EMAIL PROTECTED]>
>>
>> I also have the same need and idea for preventing duplicate
person/customer
>> entries but still no time for it. My idea was to write an event for
checking
>> some key fields like Jonathon said and if they already exist in the DB to
>> require a confirmation before recording(duplicating) the new customer.
>>
>> Is it a good idea to have such a mechanism for precheck in ofbiz ? May be
>> more generic one.
>> --
>> View this message in context:
http://www.nabble.com/Link-Party-tf4418931.html#a12612663
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>




Re: Travel Demo / Websites

2007-09-11 Thread Mark Erbaugh
On Tue, 2007-09-11 at 07:54 -0700, Adrian Crum wrote:
> The  element in the component's ofbiz-component.xml file.
> 
> 
> Mark Erbaugh wrote:
> 
> > While browsing the Ofbiz default setup, it appears that there is a
> > Travel Demo (OpenTravelSystem) website, but I can't find how to
> access
> > it.
> > 
> > Also, where is the mount point for a given website maintained. I
> know
> > from the documentation and from WebTools | View Components that the
> > ecommerce demo is mounted at ecommerce (and that the ecommerce clone
> is
> > mounted at ecomclone), but I can't find the mount points in any
> editable
> > setup table for the websites.


Thank you. I've found the webapp element for the ecommerce and ecommerce
clone websites.  Where is the webapp for the travel demo?

Mark



Re: Link Party

2007-09-11 Thread BJ Freeman
in the application I wrote for accepting real-time orders from a
website, I have a service that is run to check different parms in the IP
and address fields. It then sets the order to hold status if there are
matches to the parms.
this shows up in the order task list to be dealt with by a human.

Jonathon -- Improov sent the following on 9/11/2007 7:29 AM:
> Hmm. My very next project absolutely requires that. The duplicates don't
> come from eCommerce, BUT still... I'm not gonna prompt users about
> possible duplicates when they enter data (want to accelerate initial
> data entry effort).
> 
> I'll need a webtool for the admin (or other permitted parties) to
> periodically reconcile duplicate Party(s). Will be doing it soon.
> 
> Let me know what criteria should be checked? So far, I'm just thinking
> "name, postal code, birthdate, mobile phone number". Note that my
> application mandates the entry of birthdate, not so for ecommerce apps.
> Help me do something that is also usable by ecommerce side?
> 
> Thanks.
> 
> Jonathon
> 
> Jacques Le Roux wrote:
>> Yes this sounds interesting, to me at least. There is always plenty of
>> party duplicates coming from eCommerce.
>>
>> An administrator webtool as suggested by Jonathon may be interesting
>> too...
>>
>> Jacques
>>
>> De : "Bilgin Ibryam" <[EMAIL PROTECTED]>
>>>
>>> I also have the same need and idea for preventing duplicate
>>> person/customer
>>> entries but still no time for it. My idea was to write an event for
>>> checking
>>> some key fields like Jonathon said and if they already exist in the
>>> DB to
>>> require a confirmation before recording(duplicating) the new customer.
>>>
>>> Is it a good idea to have such a mechanism for precheck in ofbiz ?
>>> May be
>>> more generic one.
>>> -- 
>>> View this message in context:
>>> http://www.nabble.com/Link-Party-tf4418931.html#a12612663
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
> 
> 
> 
> 


Re: Ofbiz - Inventory

2007-09-11 Thread Mark Erbaugh
On Tue, 2007-09-11 at 16:48 +0200, Jacopo Cappellato wrote:
> yes, the facility can be a warehouse and you maintain inventory in it.
> you create finished goods, raw materials etc... in the Catalog 
> application: "Create Product" in fact they are all Products.
> 

Thank you. That looks like what I was looking for.

Mark



Re: Travel Demo / Websites

2007-09-11 Thread Adrian Crum

The  element in the component's ofbiz-component.xml file.


Mark Erbaugh wrote:


While browsing the Ofbiz default setup, it appears that there is a
Travel Demo (OpenTravelSystem) website, but I can't find how to access
it.

Also, where is the mount point for a given website maintained. I know
from the documentation and from WebTools | View Components that the
ecommerce demo is mounted at ecommerce (and that the ecommerce clone is
mounted at ecomclone), but I can't find the mount points in any editable
setup table for the websites.

Thanks,
Mark




Travel Demo / Websites

2007-09-11 Thread Mark Erbaugh
While browsing the Ofbiz default setup, it appears that there is a
Travel Demo (OpenTravelSystem) website, but I can't find how to access
it.

Also, where is the mount point for a given website maintained. I know
from the documentation and from WebTools | View Components that the
ecommerce demo is mounted at ecommerce (and that the ecommerce clone is
mounted at ecomclone), but I can't find the mount points in any editable
setup table for the websites.

Thanks,
Mark



Re: Ofbiz - Inventory

2007-09-11 Thread Jacopo Cappellato

Hi Mark,

Mark Erbaugh wrote:

I am setting up Ofbiz to demo manufacturing for a small company.

How does one add products?  The only place I've found in the default
application (Release 4) is FacilityMgr | Facilities | Inventory, but
this seems more appropriate for maintaining inventory in a given
location.



yes, the facility can be a warehouse and you maintain inventory in it.
you create finished goods, raw materials etc... in the Catalog 
application: "Create Product" in fact they are all Products.



I want to add both finished goods and raw materials so I can set up
BOMs, MRP and Production Runs.


Have a look at how the demo product PROD_COST is setup: it has a simple 
BOM and you can create production runs for it... it should give you an 
idea on how things are modeled.




Is there anything else I need to know about the manufacturing option?


:-)

Jacopo



Thanks,
Mark





Ofbiz - Inventory

2007-09-11 Thread Mark Erbaugh
I am setting up Ofbiz to demo manufacturing for a small company.

How does one add products?  The only place I've found in the default
application (Release 4) is FacilityMgr | Facilities | Inventory, but
this seems more appropriate for maintaining inventory in a given
location.

I want to add both finished goods and raw materials so I can set up
BOMs, MRP and Production Runs.

Is there anything else I need to know about the manufacturing option?

Thanks,
Mark



Re: Link Party

2007-09-11 Thread Bilgin Ibryam

Sorry, i didnot get that it was related for ecommerce duplicate entries. I
need to prevent backend (mostly party manager) duplicate entries. And in
this situation a warning generated from a seca precheck will be enough. I
should go this way.

Thanks
-- 
View this message in context: 
http://www.nabble.com/Link-Party-tf4418931.html#a12616026
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Link Party

2007-09-11 Thread Jonathon -- Improov
Hmm. My very next project absolutely requires that. The duplicates don't come from eCommerce, BUT 
still... I'm not gonna prompt users about possible duplicates when they enter data (want to 
accelerate initial data entry effort).


I'll need a webtool for the admin (or other permitted parties) to periodically reconcile duplicate 
Party(s). Will be doing it soon.


Let me know what criteria should be checked? So far, I'm just thinking "name, postal code, 
birthdate, mobile phone number". Note that my application mandates the entry of birthdate, not so 
for ecommerce apps. Help me do something that is also usable by ecommerce side?


Thanks.

Jonathon

Jacques Le Roux wrote:

Yes this sounds interesting, to me at least. There is always plenty of party 
duplicates coming from eCommerce.

An administrator webtool as suggested by Jonathon may be interesting too...

Jacques

De : "Bilgin Ibryam" <[EMAIL PROTECTED]>


I also have the same need and idea for preventing duplicate person/customer
entries but still no time for it. My idea was to write an event for checking
some key fields like Jonathon said and if they already exist in the DB to
require a confirmation before recording(duplicating) the new customer.

Is it a good idea to have such a mechanism for precheck in ofbiz ? May be
more generic one.
--
View this message in context: 
http://www.nabble.com/Link-Party-tf4418931.html#a12612663
Sent from the OFBiz - User mailing list archive at Nabble.com.








ofBiz for a Super Market

2007-09-11 Thread Thomas Jiji
Hi all,

 

Im getting ready to jump in OfBiz to build a supermarket E-Store
(Multi-Facility, Pick up-Delivery, recurrent Shopping lists, recipes).

I've been reading alot on ofBiz this past week but i still need a
confirmation for this issue. 

 

1) Using the ofBiz Service Engine or any other form of API, is it
possible to build a Rich UI ( Lazslo, Flex ...) on top of that API ?

 

2)Has anyone seen a Supermarket e-store built on ofBiz, because i didnt
see one the the Project List

 

It would be much appreciated to get an answer back.

 

Thank you.

 

 

-- Thomas Jiji

 



Re: Link Party

2007-09-11 Thread Jacques Le Roux
Yes this sounds interesting, to me at least. There is always plenty of party 
duplicates coming from eCommerce.

An administrator webtool as suggested by Jonathon may be interesting too...

Jacques

De : "Bilgin Ibryam" <[EMAIL PROTECTED]>
> 
> 
> I also have the same need and idea for preventing duplicate person/customer
> entries but still no time for it. My idea was to write an event for checking
> some key fields like Jonathon said and if they already exist in the DB to
> require a confirmation before recording(duplicating) the new customer.
> 
> Is it a good idea to have such a mechanism for precheck in ofbiz ? May be
> more generic one.
> -- 
> View this message in context: 
> http://www.nabble.com/Link-Party-tf4418931.html#a12612663
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>


Re: Link Party

2007-09-11 Thread Jonathon -- Improov

I did a pre-check (via SECA) that also asks for confirmation when a possible 
duplicate is detected.

But like I said, I just can't absolutely prevent users from entering duplicates!

Yes, the pre-check does help reduce instances of duplicates, since users are reminded about 
already existing records.


At some point, we still need to reconcile duplicates caused by human error. I'm interested in this 
particular process.


The case in discussion sounds like it has something to do with checkouts from ecommerce, where 
anonymous shoppers create multiple userLogins. No way we can tell the anonymous shopper this: "Hi, 
there's somebody else named Blah Bleh in our database. We'll show you all his details so you can 
kindly confirm if that is really you?"


Jonathon

Bilgin Ibryam wrote:


I also have the same need and idea for preventing duplicate person/customer
entries but still no time for it. My idea was to write an event for checking
some key fields like Jonathon said and if they already exist in the DB to
require a confirmation before recording(duplicating) the new customer.

Is it a good idea to have such a mechanism for precheck in ofbiz ? May be
more generic one.




Re: Link Party

2007-09-11 Thread Bilgin Ibryam


I also have the same need and idea for preventing duplicate person/customer
entries but still no time for it. My idea was to write an event for checking
some key fields like Jonathon said and if they already exist in the DB to
require a confirmation before recording(duplicating) the new customer.

Is it a good idea to have such a mechanism for precheck in ofbiz ? May be
more generic one.
-- 
View this message in context: 
http://www.nabble.com/Link-Party-tf4418931.html#a12612663
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Link Party

2007-09-11 Thread BJ Freeman
dynamically assigned are usually only 256 so a class c scan is possible.
if the Host is a DHCP server it could have many blocks.
a lot of times for fraud checking, the normal data is changed, like
name, phone, address.
and we have customers that have more than one shipping address, phone
so just comparing names can be a problem, like john smith.


[EMAIL PROTECTED] sent the following on 9/10/2007 10:42 PM:
> When IP addresses are typically assigned dynamically, I doubt this will be
> useful.  Better to store a back resolved host name if you can get one.
> Still not infallible if two users use the same machine.
> 
> Skip
> 
> -Original Message-
> From: BJ Freeman [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 10, 2007 8:22 PM
> To: user@ofbiz.apache.org
> Subject: Re: Link Party
> 
> 
> An IP of each order is recorded.
> you may be able to have a service the links orders by iP address.
> this is not infallible but can help.
> 
> 
> Dave Tenerowicz sent the following on 9/10/2007 3:03 PM:
>> Can anyone tell me what the Link Party function under Party Manager does?
>> An implementation we are doing includes a significant number of customer
>> records that are duplicates. In these cases the same party may have
>> placed Orders under different partyId's. The client claims that
>> identification of duplicates  can only be done by humans( I doubt this
>> !!, but that is another story). What they have requested is that we
>> develop a service that will assign all records related to one party to
>> another partyId. I am wondering if Link Party can be leveraged here.
>>
>> Thanks for any input
>>
> 
> 
> 
> 


Oracle database

2007-09-11 Thread Vinod Kumar Kashyap

Hi

I want to switch my database to Oracle
Everything goes right until all tables are created but when I run the server
again, it gives the error table already exists

Is this a problem of oracle or I am going somewhere wrong. Please help.


-- 
View this message in context: 
http://www.nabble.com/Oracle-database-tf4421494.html#a12611439
Sent from the OFBiz - User mailing list archive at Nabble.com.