RE: Scheduled service is hot or miss

[Sanders, Brian]

Maybe "unexpected" would have been a better word to use in this case. :)

-Original Message-
From: David E Jones [mailto:d...@me.com] 
Sent: Wednesday, June 24, 2009 11:53 AM
To: user@ofbiz.apache.org
Subject: Re: Scheduled service is hot or miss


In other words a different app server picked up the scheduled service  
and ran it?

That sounds like the normal behavior to me...

-David


On Jun 24, 2009, at 9:07 AM, Sanders, Brian wrote:

> Ok, last response on this...I figured out what the issue was when I  
> was
> debugging the job poller. Even though I set a breakpoint, the job  
> still
> ran, then I realized something...I still had an instance of the app
> running on my linux box which was hooked to the same database. So,
> perhaps this can help someone else should they encounter the same type
> of unusual behavior.
>
> -----Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com]
> Sent: Tuesday, June 23, 2009 1:30 PM
> To: user@ofbiz.apache.org
> Subject: RE: Scheduled service is hot or miss
>
> I think I figured it out. printPackSlip was running in a transaction  
> as
> was massPrintPackSlips. I set printPackSlip to not use transactions,  
> and
> so far, it's worked everytime. If anyone knows what *could* have been
> the issue, I'm all ears. If not, then I guess that's the end of this
> thread.
>
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com]
> Sent: Monday, June 22, 2009 12:28 PM
> To: user@ofbiz.apache.org
> Subject: RE: Scheduled service is hot or miss
>
> There was just 1 instance in which I did set a breakpoint and the job
> did not fire. Something else I'd like to add is that I see the job in
> the job list and OFBiz says that it completed, but the logs indicate
> otherwise. Are there any known issues where the job scheduler does not
> actually fire a task even though it thinks it did?
>
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com]
> Sent: Friday, June 19, 2009 12:45 PM
> To: user@ofbiz.apache.org
> Subject: RE: Scheduled service is hot or miss
>
> I forgot to mention that when I put a breakpoint in  
> sendPrintFromScreen,
> it works, so I think that's out of the question.
>
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com]
> Sent: Friday, June 19, 2009 11:58 AM
> To: user@ofbiz.apache.org
> Subject: Scheduled service is hot or miss
>
> Hello,
>
> I am using the 4.0 branch of OFBiz. I created 2 services:  
> printPackSlip
> and massPrintPackSlips. massPrintPackSlips is a copy of  
> massPrintOrders,
> but as the name suggests, it prints packslips instead by accepting a
> list of shipment id's. I created printPackSlip because it actually
> selects the appropriate printer based on the caller's address as  
> well as
> the packslip. printPackSlip is called async from updateShipment when  
> the
> shipment is marked as packed (The user clicks complete from the pack
> screen and the packslip automatically prints). printPackSlip calls
> massPrintPackSlips sync, which in turn calls sendPrintFromScreen  
> async.
> It may sound (over) complicated, but as I said, I just took existing
> code, modified it, and added a middleman to supply the parameters. In
> the end, the sendPrintFromScreen service shows up in the job list  
> and it
> marked as complete, but does not always work. It might work about 5
> times in a row, and then just stop. Does anyone know what the problem
> could be or how I might go about finding out for myself? Thanks.
>

RE: Scheduled service is hot or miss

[Sanders, Brian]

Ok, last response on this...I figured out what the issue was when I was
debugging the job poller. Even though I set a breakpoint, the job still
ran, then I realized something...I still had an instance of the app
running on my linux box which was hooked to the same database. So,
perhaps this can help someone else should they encounter the same type
of unusual behavior.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Tuesday, June 23, 2009 1:30 PM
To: user@ofbiz.apache.org
Subject: RE: Scheduled service is hot or miss

I think I figured it out. printPackSlip was running in a transaction as
was massPrintPackSlips. I set printPackSlip to not use transactions, and
so far, it's worked everytime. If anyone knows what *could* have been
the issue, I'm all ears. If not, then I guess that's the end of this
thread.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Monday, June 22, 2009 12:28 PM
To: user@ofbiz.apache.org
Subject: RE: Scheduled service is hot or miss

There was just 1 instance in which I did set a breakpoint and the job
did not fire. Something else I'd like to add is that I see the job in
the job list and OFBiz says that it completed, but the logs indicate
otherwise. Are there any known issues where the job scheduler does not
actually fire a task even though it thinks it did?

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Friday, June 19, 2009 12:45 PM
To: user@ofbiz.apache.org
Subject: RE: Scheduled service is hot or miss

I forgot to mention that when I put a breakpoint in sendPrintFromScreen,
it works, so I think that's out of the question.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Friday, June 19, 2009 11:58 AM
To: user@ofbiz.apache.org
Subject: Scheduled service is hot or miss

Hello,

I am using the 4.0 branch of OFBiz. I created 2 services: printPackSlip
and massPrintPackSlips. massPrintPackSlips is a copy of massPrintOrders,
but as the name suggests, it prints packslips instead by accepting a
list of shipment id's. I created printPackSlip because it actually
selects the appropriate printer based on the caller's address as well as
the packslip. printPackSlip is called async from updateShipment when the
shipment is marked as packed (The user clicks complete from the pack
screen and the packslip automatically prints). printPackSlip calls
massPrintPackSlips sync, which in turn calls sendPrintFromScreen async.
It may sound (over) complicated, but as I said, I just took existing
code, modified it, and added a middleman to supply the parameters. In
the end, the sendPrintFromScreen service shows up in the job list and it
marked as complete, but does not always work. It might work about 5
times in a row, and then just stop. Does anyone know what the problem
could be or how I might go about finding out for myself? Thanks.

RE: Scheduled service is hot or miss

[Sanders, Brian]

I think I figured it out. printPackSlip was running in a transaction as
was massPrintPackSlips. I set printPackSlip to not use transactions, and
so far, it's worked everytime. If anyone knows what *could* have been
the issue, I'm all ears. If not, then I guess that's the end of this
thread.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Monday, June 22, 2009 12:28 PM
To: user@ofbiz.apache.org
Subject: RE: Scheduled service is hot or miss

There was just 1 instance in which I did set a breakpoint and the job
did not fire. Something else I'd like to add is that I see the job in
the job list and OFBiz says that it completed, but the logs indicate
otherwise. Are there any known issues where the job scheduler does not
actually fire a task even though it thinks it did?

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Friday, June 19, 2009 12:45 PM
To: user@ofbiz.apache.org
Subject: RE: Scheduled service is hot or miss

I forgot to mention that when I put a breakpoint in sendPrintFromScreen,
it works, so I think that's out of the question.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Friday, June 19, 2009 11:58 AM
To: user@ofbiz.apache.org
Subject: Scheduled service is hot or miss

Hello,

I am using the 4.0 branch of OFBiz. I created 2 services: printPackSlip
and massPrintPackSlips. massPrintPackSlips is a copy of massPrintOrders,
but as the name suggests, it prints packslips instead by accepting a
list of shipment id's. I created printPackSlip because it actually
selects the appropriate printer based on the caller's address as well as
the packslip. printPackSlip is called async from updateShipment when the
shipment is marked as packed (The user clicks complete from the pack
screen and the packslip automatically prints). printPackSlip calls
massPrintPackSlips sync, which in turn calls sendPrintFromScreen async.
It may sound (over) complicated, but as I said, I just took existing
code, modified it, and added a middleman to supply the parameters. In
the end, the sendPrintFromScreen service shows up in the job list and it
marked as complete, but does not always work. It might work about 5
times in a row, and then just stop. Does anyone know what the problem
could be or how I might go about finding out for myself? Thanks.

RE: Scheduled service is hot or miss

[Sanders, Brian]

There was just 1 instance in which I did set a breakpoint and the job
did not fire. Something else I'd like to add is that I see the job in
the job list and OFBiz says that it completed, but the logs indicate
otherwise. Are there any known issues where the job scheduler does not
actually fire a task even though it thinks it did?

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Friday, June 19, 2009 12:45 PM
To: user@ofbiz.apache.org
Subject: RE: Scheduled service is hot or miss

I forgot to mention that when I put a breakpoint in sendPrintFromScreen,
it works, so I think that's out of the question.

-Original Message-----
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Friday, June 19, 2009 11:58 AM
To: user@ofbiz.apache.org
Subject: Scheduled service is hot or miss

Hello,

I am using the 4.0 branch of OFBiz. I created 2 services: printPackSlip
and massPrintPackSlips. massPrintPackSlips is a copy of massPrintOrders,
but as the name suggests, it prints packslips instead by accepting a
list of shipment id's. I created printPackSlip because it actually
selects the appropriate printer based on the caller's address as well as
the packslip. printPackSlip is called async from updateShipment when the
shipment is marked as packed (The user clicks complete from the pack
screen and the packslip automatically prints). printPackSlip calls
massPrintPackSlips sync, which in turn calls sendPrintFromScreen async.
It may sound (over) complicated, but as I said, I just took existing
code, modified it, and added a middleman to supply the parameters. In
the end, the sendPrintFromScreen service shows up in the job list and it
marked as complete, but does not always work. It might work about 5
times in a row, and then just stop. Does anyone know what the problem
could be or how I might go about finding out for myself? Thanks.

RE: Scheduled service is hot or miss

[Sanders, Brian]

I forgot to mention that when I put a breakpoint in sendPrintFromScreen,
it works, so I think that's out of the question.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Friday, June 19, 2009 11:58 AM
To: user@ofbiz.apache.org
Subject: Scheduled service is hot or miss

Hello,

I am using the 4.0 branch of OFBiz. I created 2 services: printPackSlip
and massPrintPackSlips. massPrintPackSlips is a copy of massPrintOrders,
but as the name suggests, it prints packslips instead by accepting a
list of shipment id's. I created printPackSlip because it actually
selects the appropriate printer based on the caller's address as well as
the packslip. printPackSlip is called async from updateShipment when the
shipment is marked as packed (The user clicks complete from the pack
screen and the packslip automatically prints). printPackSlip calls
massPrintPackSlips sync, which in turn calls sendPrintFromScreen async.
It may sound (over) complicated, but as I said, I just took existing
code, modified it, and added a middleman to supply the parameters. In
the end, the sendPrintFromScreen service shows up in the job list and it
marked as complete, but does not always work. It might work about 5
times in a row, and then just stop. Does anyone know what the problem
could be or how I might go about finding out for myself? Thanks.

Scheduled service is hot or miss

[Sanders, Brian]

Hello,

I am using the 4.0 branch of OFBiz. I created 2 services: printPackSlip
and massPrintPackSlips. massPrintPackSlips is a copy of massPrintOrders,
but as the name suggests, it prints packslips instead by accepting a
list of shipment id's. I created printPackSlip because it actually
selects the appropriate printer based on the caller's address as well as
the packslip. printPackSlip is called async from updateShipment when the
shipment is marked as packed (The user clicks complete from the pack
screen and the packslip automatically prints). printPackSlip calls
massPrintPackSlips sync, which in turn calls sendPrintFromScreen async.
It may sound (over) complicated, but as I said, I just took existing
code, modified it, and added a middleman to supply the parameters. In
the end, the sendPrintFromScreen service shows up in the job list and it
marked as complete, but does not always work. It might work about 5
times in a row, and then just stop. Does anyone know what the problem
could be or how I might go about finding out for myself? Thanks.

RE: New bulk printing features

[Sanders, Brian]

I know for a fact it worked with a Xerox Phaser 8400DP and the
PDFCreator printer (which isn't a physical printer). It doesn't hurt to
give the driver a shot.

-Original Message-
From: Ajey.bitin [mailto:ajey.ku...@palindromesoftware.com] 
Sent: Wednesday, June 10, 2009 4:52 PM
To: user@ofbiz.apache.org
Subject: RE: New bulk printing features


Thanks for the link. I've gone trough it once. It tells us "The printer
must
have PS printing capabilities. This can be verified on the printer's
Configuration Page." And on the configuration page of HP LaserJet 1018
http://h10010.www1.hp.com/wwpc/in/en/sm/WF06a/18972-18972-3328059-332806
6-3328066-1814092.html
nothing has been specified. I think, my printer does not support
postscript.

By the way, on which printer, you have tested all this?

Regards,

Ajey Kumar


bsanders1979 wrote:
> 
> Try this link: http://tinyurl.com/lvvj5n
> 
> You should see "HP postscript (PS) emulation driver". If it doesn't
> work, then google "HP LaserJet 1018 postscript" and click the first
> link.
> 
> -Original Message-
> From: Ajey.bitin [mailto:ajey.ku...@palindromesoftware.com] 
> Sent: Wednesday, June 10, 2009 4:30 PM
> To: user@ofbiz.apache.org
> Subject: RE: New bulk printing features
> 
> 
> Hi,
> 
> I could not find anywhere postscript drivers for HP LaserJet 1018, the
> printer I'm having. I'm not sure whether this printer supports
> postscript or
> not. Actually, there was no specification, Jacopo has mentioned that
it
> should be a Laser Printer only.
> 
> Do you know from where I can get postscript drivers for HP LaserJet
> 1018, if
> there any?
> 
> Regards,
> 
> Ajey Kumar
> 
> 
> bsanders1979 wrote:
>> 
>> Did you install the postscript driver for your printer? I just so
>> happened to need this feature in 4.0 and it was only locating
printers
>> that had postscript printing capability,
>> 
>> -Original Message-
>> From: Ajey.bitin [mailto:ajey.ku...@palindromesoftware.com] 
>> Sent: Saturday, June 06, 2009 2:10 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: New bulk printing features
>> 
>> 
>> Hi Jacopo,
>> 
>> I'm using the latest version of OFBiz and tried to do a bulk print
> with
>> Orders. I'm using HP LaserJet 1018 for this purpose as you mentioned
>> "Laser
>> for now".
>> 
>> Sorry to say, but I'm not able to print Order PDFs in bulk manner as
> it
>> is
>> throwing "invalid flavor exception". Can you please add some input
> here
>> that
>> which printer (Laser) you used to test all this integration and
> whether
>> the
>> Laser Printer I 'm using is capable to do all this operation or not?
>> 
>> I also tried to print all the supported flavor of my printer and got
>> that it
>> supports GIF, JPG, PNG, Octet-Stream etc flavors internally.
>> 
>> When I'm using "application/pdf" instead of "application/postscript",
>> still
>> it is raising invalid flavor exception.
>> 
>> Any kind of help in this concern is highly appreciated.
>> 
>> Regards,
>> 
>> Ajey Kumar
>> 
>> 
>> 
>> Jacopo Cappellato wrote:
>>> 
>>> As of rev. 521619 there is now the ability to submit an async print 
>>> request for many document (rendered from a screen definition with
> fop)
>> 
>>> and send it to a (laser, for now) printer.
>>> You can test it by selecting the "Print" option in the find order
> list
>> 
>>> screen. You can optionally select a printer from the drop down box.
>>> If no printer is selected the system will select the first that the 
>>> server's JVM can locate (so it must be defined in the server where
>> OFBiz 
>>> is running, even if it is a lan printer).
>>> 
>>> Let me know what you think (I did very few test, also with the help
> of
>> 
>>> David Shere), and I know that a lot can be done to improve these
>> feature.
>>> 
>>> Jacopo
>>> 
>>> 
>>> 
>> 
>> -- 
>> View this message in context:
>>
>
http://www.nabble.com/New-bulk-printing-features-tp9630723p23904252.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>> 
>> 
>> 
> 
> -- 
> View this message in context:
>
http://www.nabble.com/New-bulk-printing-features-tp9630723p23970409.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
> 
> 
> 

-- 
View this message in context:
http://www.nabble.com/New-bulk-printing-features-tp9630723p23970788.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

RE: New bulk printing features

[Sanders, Brian]

Try this link: http://tinyurl.com/lvvj5n

You should see "HP postscript (PS) emulation driver". If it doesn't
work, then google "HP LaserJet 1018 postscript" and click the first
link.

-Original Message-
From: Ajey.bitin [mailto:ajey.ku...@palindromesoftware.com] 
Sent: Wednesday, June 10, 2009 4:30 PM
To: user@ofbiz.apache.org
Subject: RE: New bulk printing features


Hi,

I could not find anywhere postscript drivers for HP LaserJet 1018, the
printer I'm having. I'm not sure whether this printer supports
postscript or
not. Actually, there was no specification, Jacopo has mentioned that it
should be a Laser Printer only.

Do you know from where I can get postscript drivers for HP LaserJet
1018, if
there any?

Regards,

Ajey Kumar


bsanders1979 wrote:
> 
> Did you install the postscript driver for your printer? I just so
> happened to need this feature in 4.0 and it was only locating printers
> that had postscript printing capability,
> 
> -Original Message-
> From: Ajey.bitin [mailto:ajey.ku...@palindromesoftware.com] 
> Sent: Saturday, June 06, 2009 2:10 PM
> To: user@ofbiz.apache.org
> Subject: Re: New bulk printing features
> 
> 
> Hi Jacopo,
> 
> I'm using the latest version of OFBiz and tried to do a bulk print
with
> Orders. I'm using HP LaserJet 1018 for this purpose as you mentioned
> "Laser
> for now".
> 
> Sorry to say, but I'm not able to print Order PDFs in bulk manner as
it
> is
> throwing "invalid flavor exception". Can you please add some input
here
> that
> which printer (Laser) you used to test all this integration and
whether
> the
> Laser Printer I 'm using is capable to do all this operation or not?
> 
> I also tried to print all the supported flavor of my printer and got
> that it
> supports GIF, JPG, PNG, Octet-Stream etc flavors internally.
> 
> When I'm using "application/pdf" instead of "application/postscript",
> still
> it is raising invalid flavor exception.
> 
> Any kind of help in this concern is highly appreciated.
> 
> Regards,
> 
> Ajey Kumar
> 
> 
> 
> Jacopo Cappellato wrote:
>> 
>> As of rev. 521619 there is now the ability to submit an async print 
>> request for many document (rendered from a screen definition with
fop)
> 
>> and send it to a (laser, for now) printer.
>> You can test it by selecting the "Print" option in the find order
list
> 
>> screen. You can optionally select a printer from the drop down box.
>> If no printer is selected the system will select the first that the 
>> server's JVM can locate (so it must be defined in the server where
> OFBiz 
>> is running, even if it is a lan printer).
>> 
>> Let me know what you think (I did very few test, also with the help
of
> 
>> David Shere), and I know that a lot can be done to improve these
> feature.
>> 
>> Jacopo
>> 
>> 
>> 
> 
> -- 
> View this message in context:
>
http://www.nabble.com/New-bulk-printing-features-tp9630723p23904252.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
> 
> 
> 

-- 
View this message in context:
http://www.nabble.com/New-bulk-printing-features-tp9630723p23970409.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

RE: New bulk printing features

[Sanders, Brian]

Did you install the postscript driver for your printer? I just so
happened to need this feature in 4.0 and it was only locating printers
that had postscript printing capability,

-Original Message-
From: Ajey.bitin [mailto:ajey.ku...@palindromesoftware.com] 
Sent: Saturday, June 06, 2009 2:10 PM
To: user@ofbiz.apache.org
Subject: Re: New bulk printing features


Hi Jacopo,

I'm using the latest version of OFBiz and tried to do a bulk print with
Orders. I'm using HP LaserJet 1018 for this purpose as you mentioned
"Laser
for now".

Sorry to say, but I'm not able to print Order PDFs in bulk manner as it
is
throwing "invalid flavor exception". Can you please add some input here
that
which printer (Laser) you used to test all this integration and whether
the
Laser Printer I 'm using is capable to do all this operation or not?

I also tried to print all the supported flavor of my printer and got
that it
supports GIF, JPG, PNG, Octet-Stream etc flavors internally.

When I'm using "application/pdf" instead of "application/postscript",
still
it is raising invalid flavor exception.

Any kind of help in this concern is highly appreciated.

Regards,

Ajey Kumar



Jacopo Cappellato wrote:
> 
> As of rev. 521619 there is now the ability to submit an async print 
> request for many document (rendered from a screen definition with fop)

> and send it to a (laser, for now) printer.
> You can test it by selecting the "Print" option in the find order list

> screen. You can optionally select a printer from the drop down box.
> If no printer is selected the system will select the first that the 
> server's JVM can locate (so it must be defined in the server where
OFBiz 
> is running, even if it is a lan printer).
> 
> Let me know what you think (I did very few test, also with the help of

> David Shere), and I know that a lot can be done to improve these
feature.
> 
> Jacopo
> 
> 
> 

-- 
View this message in context:
http://www.nabble.com/New-bulk-printing-features-tp9630723p23904252.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

RE: Jira servers

[Sanders, Brian]

In case you didn't check, both hostnames resolve to the same IP.

-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net] 
Sent: Saturday, June 06, 2009 11:09 AM
To: user@ofbiz.apache.org
Subject: Re: Jira servers

Ok was able to logon.
still wonder why the duplication.

BJ Freeman sent the following on 6/6/2009 7:49 AM:
> I stumble on to
> https://cwiki.apache.org
> is seems to be the same as
> https://issues.apache.org
> except I am not a user on the
> https://cwiki.apache.org
> 
> any input as to what the difference might be.
> 
> 
> 

-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&tr
k=tab_pro
Systems Integrator.

RE: entity-condition question

[Sanders, Brian]

Your condition looks like: (firstName like "${parameters.name}%" ||
middleName like "${parameters.name}%" || lastName like
"${parameters.name}%") && socialSecurityNumber equals
parameters.socialSecurityNumber) 

You are ANDing the name conditions with the SSN condition when you
should be ORing. So, Adrian is saying that '' should be ''

-Original Message-
From: Muhammad Aamir [mailto:m...@aamir.pk] 
Sent: Saturday, May 30, 2009 12:20 PM
To: user@ofbiz.apache.org
Subject: Re: entity-condition question

Hi Adrian, thanks for the reply but it makes no sense at least to me.

On Sat, May 30, 2009 at 12:54 AM, Adrian Crum 
wrote:

>
> Maybe your first condition-list element should be:
>
> 
>
> -Adrian
>
> --- On Fri, 5/29/09, Muhammad Aamir  wrote:
>
> > From: Muhammad Aamir 
> > Subject: entity-condition question
> > To: user@ofbiz.apache.org
> > Date: Friday, May 29, 2009, 2:19 PM
> > If a I pass a social security number,
> > it doesn't bring any thing, however
> > searching by name works:
> >
> >  > list="parties" entity-name="Person">
> >
> > 
> >
> > 
> >
> >  > operator="like"
> >
> > value="${parameters.name}%"
> > ignore-case="true" />
> >
> >  > operator="like"
> >
> > value="${parameters.name}%"
> > ignore-case="true" />
> >
> >  > operator="like"
> >
> > value="${parameters.name}%"
> > ignore-case="true" />
> >
> > 
> >
> >  >
> > operator="equals"
> > from-field="parameters.socialSecurityNumber"
> > ignore-if-empty="true"
> > ignore-if-null="true"/>
> >
> > 
> > 
> >
> > Thanks
> > Muhammad Aamir
> >
>
>
>
>

RE: Physical Inventory Review

[Sanders, Brian]

Can you explain how I might go about it? I can see some things that sort
of fit the bill, but I'm not quite sure about the others.

1. Not really worried about this, unless a solution already exists
2. This is really more of an entity that doesn't exist
3. I'm guessing that this would be the list of inventory items, although
I don't need all the columns
4. n/a
5. Where would this go?
6. This ultimately would be a list of InventoryItemVariance's that are
applied in step 8
7. Is there anything that already exists that would display the cost *
variance?
8. Apply all the variances as a batch

-Original Message-
From: David E Jones [mailto:david.jo...@hotwaxmedia.com] 
Sent: Thursday, May 14, 2009 3:55 PM
To: user@ofbiz.apache.org
Subject: Re: Physical Inventory Review


Most of it, yes.

-David


On May 14, 2009, at 9:15 AM, Sanders, Brian wrote:

> Every year, we have to do a "Physical Inventory" where everything is
> counted and the inventory is corrected. Here's a run-down of how our
> process works:
>
> 1.Freeze the inventory
> 2.Produce the "Physical Review" which basically a list of all the
> items to be counted
> 3.Produce count sheets (ie. Product Id, Bin #, Quantity)
> 4.Physically count the inventory
> 5.Key the counts into the review
> 6.Produce a variance report (Product, Expected Qty, Actual Qty)
> 7.Recount any products which raise a red flag (ie. items where
> cost * variance >= x)
> 8.Post the review (actually modifies the inventory)
>
>
>
> Does OFBiz have this sort of functionality?
>

Physical Inventory Review

[Sanders, Brian]

Every year, we have to do a "Physical Inventory" where everything is
counted and the inventory is corrected. Here's a run-down of how our
process works:

1.  Freeze the inventory
2.  Produce the "Physical Review" which basically a list of all the
items to be counted
3.  Produce count sheets (ie. Product Id, Bin #, Quantity)
4.  Physically count the inventory
5.  Key the counts into the review
6.  Produce a variance report (Product, Expected Qty, Actual Qty)
7.  Recount any products which raise a red flag (ie. items where
cost * variance >= x)
8.  Post the review (actually modifies the inventory)

 

Does OFBiz have this sort of functionality?

RE: how to change the path of xsi:noNamespaceSchemaLocation

[Sanders, Brian]

See:
http://docs.ofbiz.org/download/attachments/1218/eclipse_xml_catalog_howt
o.pdf

Here are the catalogs to make things even easier:
/framework/base/dtd/base-catalog.xml
/framework/entity/dtd/entity-catalog.xml
/framework/minilang/dtd/minilang-catalog.xml
/framework/service/dtd/service-catalog.xml
/framework/testtools/dtd/testtools-catalog.xml
/framework/widget/dtd/widget-catalog.xml

-Original Message-
From: S K Pradeep Kumar [mailto:pradeep.ku...@palindromesoftware.com] 
Sent: Wednesday, May 13, 2009 10:46 AM
To: user@ofbiz.apache.org
Subject: how to change the path of xsi:noNamespaceSchemaLocation

Hi All,

  I am using the older version ofbiz application and in my application i
am
getting the following error.

"InventoryServices.xml process error. Line: 22. Error message: Schema
error:
A group with "ref" present must not have children."

  This is because of the changes in the simple method xsd file as per
 
"http://docs.ofbiz.org/display/OFBTECH/Simple+Method+Cleanup+Effort+(Don
e)"

For that reason i want to change the path of the
"xsi:noNamespaceSchemaLocation" in
http://www.w3.org/2001/XMLSchema-instance";
xsi:noNamespaceSchemaLocation="
http://www.ofbiz.org/dtds/simple-methods.xsd";>
tag to the Local application xsds in the miniilang/dtd/ .

How to give the local path of the *.xsd in
xsi:noNamespaceSchemaLocation.


-- 
With regards,
S K Pradeep kumar

RE: Refunding adjustments only

[Sanders, Brian]

Hello Jacques,
We got the core functionality to work (the actual refund takes
place and the return completes), but there are a few more things that
need to happen. Essentially, if the adjustment is by itself, an invoice
does not get created and thus, there is no payment application.
According to Al, "in order to have an invoice, you have to have a
shipment, to have a shipment you need an item". Unfortunately, we do not
have time to code it correctly and meet our deadline, but I think we are
going to revisit it once we go live. If you can provide any sort of
guidance, that would be great. If you want, I will talk to him about
submitting a patch of what we got done so far to the Jira issue I
opened.

-Original Message-
From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
Sent: Sunday, April 26, 2009 5:29 PM
To: user@ofbiz.apache.org
Subject: Re: Refunding adjustments only

Hi Brian,

Do you finally have a solution for this ?

Jacques

From: "Sanders, Brian" 
> Part of an approach I considered to handle this situation would create
a
> dummy order adjustment so that I can link the manual return adjustment
> to the original order. Would anyone consider this a hack/bad idea?
What
> about adding an orderId field to ReturnAdjustment? I am for creating
the
> order adjustment because you're putting both types of return
adjustments
> into the same bucket. My colleague, however, feels that it would be
> better to add the orderId field to the entity. Also, I think this
> functionality would be a good addition to the release so I planned on
> attaching the patch to the Jira issue I opened. Thanks and have a good
> weekend.
> 
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com] 
> Sent: Wednesday, April 15, 2009 1:34 PM
> To: user@ofbiz.apache.org
> Subject: RE: Refunding adjustments only
> 
> Well, it turns out it's not fixed in the latest. While it does make it
> further into the code, it gets skipped over because of line 894:
> while (itemByOrderIt.hasNext()) {
> 
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com] 
> Sent: Wednesday, April 15, 2009 8:40 AM
> To: user@ofbiz.apache.org
> Subject: RE: Refunding adjustments only
> 
> Ok, I was looking at the head for 4.0. It appears that the issue is
> fixed in the latest. Thanks.
> 
> -Original Message-
> From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
> Sent: Tuesday, April 14, 2009 4:15 PM
> To: user@ofbiz.apache.org
> Subject: Re: Refunding adjustments only
> 
> Are you speaking about the last release available at the moment
> (r764940) ?
> I don't see nay TODO on line 801 and moreover this is not a line of
> OrderReturnServices.processRefundReturn() method.
> The last change in this file was commited by me in r763175 one week
ago
>
http://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/order/src/
> org/ofbiz/order/order/OrderReturnServices.java?r=763175
> 
> Could you clarify please ?
> 
> Jacques
> 
> From: "Sanders, Brian" 
>> It's in the head revision as well on line 801.
>> 
>> -Original Message-
>> From: Sanders, Brian [mailto:bsand...@connextions.com] 
>> Sent: Tuesday, April 14, 2009 12:32 PM
>> To: user@ofbiz.apache.org
>> Subject: RE: Refunding adjustments only
>> 
>> When the project was imported into our repo, the revision # was
> 684368.
>> The TODO was there.
>> 
>> -Original Message-
>> From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
>> Sent: Tuesday, April 14, 2009 12:01 PM
>> To: user@ofbiz.apache.org
>> Subject: Re: Refunding adjustments only
>> 
>> I did not find any TODO in OrderReturnServices.processRefundReturn()
>> Are you sure its plain OFBiz code ? 
>> If yes, which Release.revision are you using ?
>> 
>> Jacques
>> 
>> From: "Sanders, Brian" 
>> If you look at processRefundReturn, you will notice that none of the
>> code runs unless there is at least 1 line item. If you are refunding
>> only, say, freight charges, the refund will not actually occur. There
> is
>> a TODO labeled "add adjustment total" which sounds like the
developers
>> are aware of the issue. Is there a reason that it has not been
>> implemented yet? If I were to try and implement the functionality
>> myself, is there anything I should be aware off? Can anyone offer
some
>> tips/suggestions as to how to implement? Thanks.
>> 
>> 
>> 
>>
> 
>

RE: MS SQL > WARNING: Column [ACCTG_TRANS_ID] of table [dbo.ACCTG_TRANS] of entity [AcctgTrans] IS NOT a primary key ...

[Sanders, Brian]

I chased this down to DatabaseUtil.getColumnInfo(), line 1076 in 4.0.
Here's the code:
ResultSet rsPks = dbData.getPrimaryKeys(null, lookupSchemaName, null);

If the first 2 calls yield nothing, there is an empty block with a TODO
that says: now what to do? I guess try one table name at a time...

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Sunday, April 26, 2009 3:03 AM
To: user@ofbiz.apache.org
Subject: RE: MS SQL > WARNING: Column [ACCTG_TRANS_ID] of table
[dbo.ACCTG_TRANS] of entity [AcctgTrans] IS NOT a primary key ...

I noticed the same thing. The driver calls sp_pkeys twice (I assume
because the first result is empty), but gets nothing.

Here's the first call:
exec sp_pkeys  @table_qualifier = null, @table_owner = 'dbo',
@table_name = null

And here's the second:
exec sp_pkeys  @table_qualifier = null, @table_owner = 'dbo',
@table_name = '%'

I looked at the procedure and it doesn't appear that @table_name is
acceptable. If I call it with a specific table name, I get a result.
What you can do is add: 
check-pks-on-start="false" 
to the datasource to get rid of the errors/warnings.

-Original Message-
From: Adrian Crum [mailto:adrian.c...@yahoo.com] 
Sent: Saturday, April 25, 2009 2:26 PM
To: user@ofbiz.apache.org
Subject: Re: MS SQL > WARNING: Column [ACCTG_TRANS_ID] of table
[dbo.ACCTG_TRANS] of entity [AcctgTrans] IS NOT a primary key ...


In addition, I've run across this warning when I use a newer revision of
OFBiz with a database that was created with an older revision of OFBiz.
The database still contains primary keys that are no longer used in the
newer revision.

-Adrian


--- On Sat, 4/25/09, David E Jones  wrote:

> From: David E Jones 
> Subject: Re: MS SQL > WARNING: Column [ACCTG_TRANS_ID] of table
[dbo.ACCTG_TRANS] of entity [AcctgTrans] IS NOT a primary key ...
> To: user@ofbiz.apache.org
> Date: Saturday, April 25, 2009, 10:57 AM
> Have you looked at the database to see if those columns
> really are not part of the primary key? Sometimes there are
> JDBC driver quirks for checking things like primary keys, so
> the best thing to do is look in the database itself to
> verify.
> 
> -David
> 
> 
> On Apr 25, 2009, at 11:51 AM, snowch wrote:
> 
> > 
> > When I start my ofbiz 4.0 instance, I am receiving the
> following errors:
> > 
> > 2009-04-25 18:43:57,071 (main) [  
> DatabaseUtil.java:299:ERROR] WARNING:
> > Column [ACCTG_TRANS_ID] of table [dbo.ACCTG_TRANS] of
> entity [AcctgTrans] IS
> > NOT a primary key in the database, but IS a primary
> key in the entity
> > definition. The primary key for this table needs to be
> re-created or
> > modified to add this column to the primary key. Note
> that data may need to
> > be added first as a primary key column cannot have an
> null values.
> > 2009-04-25 18:43:57,072 (main) [  
> DatabaseUtil.java:299:ERROR] WARNING:
> > Column [ACCTG_TRANS_ID] of table
> [dbo.ACCTG_TRANS_ATTRIBUTE] of entity
> > [AcctgTransAttribute] IS NOT a primary key in the
> database, but IS a primary
> > key in the entity definition. The primary key for this
> table needs to be
> > re-created or modified to add this column to the
> primary key. Note that data
> > may need to be added first as a primary key column
> cannot have an null
> > values.
> > 
> > I have installed and configured MSSQL as per the notes
> in entityengine.xml
> > 
> > >   
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> >schema-name="dbo"
> >field-type-name="mssql"
> >check-on-start="true"
> >add-missing-on-start="true"
> >join-style="ansi"
> >alias-view-columns="false"
> >   
> use-fk-initially-deferred="false">
> >
> >
> >
> > >   
> jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> > 
> >
>
jdbc-uri="jdbc:sqlserver://192.168.69.5:1433;databaseName=MyDB;SelectMet
hod=cursor;"
> >jdbc-username="X"
> >jdbc-password="X"
> >   
> isolation-level="ReadCommitted"
> >pool-minsize="2"
> >pool-maxsize="20"/>
> >
> > 
> > Everything appears to be working ok, despite the
> warnings.
> > 
> > Any ideas?
> > 
> > Many thanks,
> > 
> > Chris
> > 
> > --View this message in context:
>
http://www.nabble.com/MS-SQL-%3E-WARNING%3A-Column--ACCTG_TRANS_ID--of-t
able--dbo.ACCTG_TRANS--of-entity--AcctgTrans--IS-NOT-a-primary-key-...-t
p23234651p23234651.html
> > Sent from the OFBiz - User mailing list archive at
> Nabble.com.
> >


  

RE: MS SQL > WARNING: Column [ACCTG_TRANS_ID] of table [dbo.ACCTG_TRANS] of entity [AcctgTrans] IS NOT a primary key ...

[Sanders, Brian]

I noticed the same thing. The driver calls sp_pkeys twice (I assume
because the first result is empty), but gets nothing.

Here's the first call:
exec sp_pkeys  @table_qualifier = null, @table_owner = 'dbo',
@table_name = null

And here's the second:
exec sp_pkeys  @table_qualifier = null, @table_owner = 'dbo',
@table_name = '%'

I looked at the procedure and it doesn't appear that @table_name is
acceptable. If I call it with a specific table name, I get a result.
What you can do is add: 
check-pks-on-start="false" 
to the datasource to get rid of the errors/warnings.

-Original Message-
From: Adrian Crum [mailto:adrian.c...@yahoo.com] 
Sent: Saturday, April 25, 2009 2:26 PM
To: user@ofbiz.apache.org
Subject: Re: MS SQL > WARNING: Column [ACCTG_TRANS_ID] of table
[dbo.ACCTG_TRANS] of entity [AcctgTrans] IS NOT a primary key ...


In addition, I've run across this warning when I use a newer revision of
OFBiz with a database that was created with an older revision of OFBiz.
The database still contains primary keys that are no longer used in the
newer revision.

-Adrian


--- On Sat, 4/25/09, David E Jones  wrote:

> From: David E Jones 
> Subject: Re: MS SQL > WARNING: Column [ACCTG_TRANS_ID] of table
[dbo.ACCTG_TRANS] of entity [AcctgTrans] IS NOT a primary key ...
> To: user@ofbiz.apache.org
> Date: Saturday, April 25, 2009, 10:57 AM
> Have you looked at the database to see if those columns
> really are not part of the primary key? Sometimes there are
> JDBC driver quirks for checking things like primary keys, so
> the best thing to do is look in the database itself to
> verify.
> 
> -David
> 
> 
> On Apr 25, 2009, at 11:51 AM, snowch wrote:
> 
> > 
> > When I start my ofbiz 4.0 instance, I am receiving the
> following errors:
> > 
> > 2009-04-25 18:43:57,071 (main) [  
> DatabaseUtil.java:299:ERROR] WARNING:
> > Column [ACCTG_TRANS_ID] of table [dbo.ACCTG_TRANS] of
> entity [AcctgTrans] IS
> > NOT a primary key in the database, but IS a primary
> key in the entity
> > definition. The primary key for this table needs to be
> re-created or
> > modified to add this column to the primary key. Note
> that data may need to
> > be added first as a primary key column cannot have an
> null values.
> > 2009-04-25 18:43:57,072 (main) [  
> DatabaseUtil.java:299:ERROR] WARNING:
> > Column [ACCTG_TRANS_ID] of table
> [dbo.ACCTG_TRANS_ATTRIBUTE] of entity
> > [AcctgTransAttribute] IS NOT a primary key in the
> database, but IS a primary
> > key in the entity definition. The primary key for this
> table needs to be
> > re-created or modified to add this column to the
> primary key. Note that data
> > may need to be added first as a primary key column
> cannot have an null
> > values.
> > 
> > I have installed and configured MSSQL as per the notes
> in entityengine.xml
> > 
> > >   
> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> >schema-name="dbo"
> >field-type-name="mssql"
> >check-on-start="true"
> >add-missing-on-start="true"
> >join-style="ansi"
> >alias-view-columns="false"
> >   
> use-fk-initially-deferred="false">
> >
> >
> >
> > >   
> jdbc-driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
> > 
> >
>
jdbc-uri="jdbc:sqlserver://192.168.69.5:1433;databaseName=MyDB;SelectMet
hod=cursor;"
> >jdbc-username="X"
> >jdbc-password="X"
> >   
> isolation-level="ReadCommitted"
> >pool-minsize="2"
> >pool-maxsize="20"/>
> >
> > 
> > Everything appears to be working ok, despite the
> warnings.
> > 
> > Any ideas?
> > 
> > Many thanks,
> > 
> > Chris
> > 
> > --View this message in context:
>
http://www.nabble.com/MS-SQL-%3E-WARNING%3A-Column--ACCTG_TRANS_ID--of-t
able--dbo.ACCTG_TRANS--of-entity--AcctgTrans--IS-NOT-a-primary-key-...-t
p23234651p23234651.html
> > Sent from the OFBiz - User mailing list archive at
> Nabble.com.
> >


  

RE: SQL Server JDBC driver

[Sanders, Brian]

where are you hooking into the order processing? Not quite sure what you
mean, but it's an OFBiz service which accepts/processes the XML.

are you following the flow of the normal order processing? Works fine
with MySql

is the payment processing using the ProductStore for determining the
payment processor Aim? I believe so because the import code is calling
CheckoutHelper.processPayment().

All this stuff works fine with MySql, but we are opting to go with Sql
Server 2005 in order to gain support from our DBAs.

-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net] 
Sent: Friday, April 24, 2009 4:08 PM
To: user@ofbiz.apache.org
Subject: Re: SQL Server JDBC driver

Little more clarity if you don't mind
where are you hooking into the order processing?
are you following the flow of the normal order processing?
is the payment processing using the ProductStore for determining the
payment processor Aim.

Sanders, Brian sent the following on 4/24/2009 12:49 PM:
> I meant in regards to OFBiz. I went ahead and used the official
driver,
> installed the XA and now we have a new issue. We wrote some custom
code
> which takes XML order data to create an order. The app gets stuck when
> trying to authorize the card because AIMPaymentServices.
> buildCustomerBillingInfo() is attempting to get the postal address
> associated with the credit card (GenericValue address =
> creditCard.getRelatedOne("PostalAddress");). While I'm not quite sure
> what the issue is, I suspect that is has something to do with XA. Our
> import process creates all this info, then calls the service to create
> the order. It seems that it hangs when getting the postal address
> because that data is in another transaction that has not been
committed.
> Basically, it seems that distributed transactions are not
working/being
> used. I found some similar posts on the internet, but no solutions.
BTW,
> I'm using 4.0. Thanks.
> 
>
http://mail-archives.apache.org/mod_mbox/ofbiz-user/200708.mbox/%3C46CC3
> bbb.2050...@salmonllc.com%3e
> 
> http://lists.ofbiz.org/pipermail/users/2004-January/002819.html
> 
> 
> -Original Message-
> From: BJ Freeman [mailto:bjf...@free-man.net] 
> Sent: Thursday, April 23, 2009 4:23 PM
> To: user@ofbiz.apache.org
> Subject: Re: SQL Server JDBC driver
> 
> that is best ask at the forum for the particular SQL server your are
> going to use.
> 
>  Sanders, Brian sent the following on 4/21/2009 9:32 AM:
>>> I just wanted to get some feedback as to which JDBC driver anyone
> would
>>> recommend to use for SQL Server.
>>>
>>>  
>>>
>>> Brian Sanders
>>>
>>> Application Support Analyst
>>>
> 
> 

-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
Systems Integrator.

RE: SQL Server JDBC driver

[Sanders, Brian]

I meant in regards to OFBiz. I went ahead and used the official driver,
installed the XA and now we have a new issue. We wrote some custom code
which takes XML order data to create an order. The app gets stuck when
trying to authorize the card because AIMPaymentServices.
buildCustomerBillingInfo() is attempting to get the postal address
associated with the credit card (GenericValue address =
creditCard.getRelatedOne("PostalAddress");). While I'm not quite sure
what the issue is, I suspect that is has something to do with XA. Our
import process creates all this info, then calls the service to create
the order. It seems that it hangs when getting the postal address
because that data is in another transaction that has not been committed.
Basically, it seems that distributed transactions are not working/being
used. I found some similar posts on the internet, but no solutions. BTW,
I'm using 4.0. Thanks.

http://mail-archives.apache.org/mod_mbox/ofbiz-user/200708.mbox/%3C46CC3
bbb.2050...@salmonllc.com%3e

http://lists.ofbiz.org/pipermail/users/2004-January/002819.html


-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net] 
Sent: Thursday, April 23, 2009 4:23 PM
To: user@ofbiz.apache.org
Subject: Re: SQL Server JDBC driver

that is best ask at the forum for the particular SQL server your are
going to use.

 Sanders, Brian sent the following on 4/21/2009 9:32 AM:
>> I just wanted to get some feedback as to which JDBC driver anyone
would
>> recommend to use for SQL Server.
>>
>>  
>>
>> Brian Sanders
>>
>> Application Support Analyst
>>
> 

RE: SQL Server JDBC driver

[Sanders, Brian]

Oops. Is it possible to edit my initial message so that contact info
doesn't leak to the inernet?

SQL Server JDBC driver

[Sanders, Brian]

I just wanted to get some feedback as to which JDBC driver anyone would
recommend to use for SQL Server.

 

Brian Sanders

Application Support Analyst

Connextions, Inc.

3600 eCommerce Place  

Orlando, FL 32808
main: 407.926.2400

cell:407.765.9817 

bsand...@connextions.com

www.connextions.com

 

RE: Refunding adjustments only

[Sanders, Brian]

Part of an approach I considered to handle this situation would create a
dummy order adjustment so that I can link the manual return adjustment
to the original order. Would anyone consider this a hack/bad idea? What
about adding an orderId field to ReturnAdjustment? I am for creating the
order adjustment because you're putting both types of return adjustments
into the same bucket. My colleague, however, feels that it would be
better to add the orderId field to the entity. Also, I think this
functionality would be a good addition to the release so I planned on
attaching the patch to the Jira issue I opened. Thanks and have a good
weekend.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Wednesday, April 15, 2009 1:34 PM
To: user@ofbiz.apache.org
Subject: RE: Refunding adjustments only

Well, it turns out it's not fixed in the latest. While it does make it
further into the code, it gets skipped over because of line 894:
while (itemByOrderIt.hasNext()) {

-Original Message-----
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Wednesday, April 15, 2009 8:40 AM
To: user@ofbiz.apache.org
Subject: RE: Refunding adjustments only

Ok, I was looking at the head for 4.0. It appears that the issue is
fixed in the latest. Thanks.

-Original Message-
From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
Sent: Tuesday, April 14, 2009 4:15 PM
To: user@ofbiz.apache.org
Subject: Re: Refunding adjustments only

Are you speaking about the last release available at the moment
(r764940) ?
I don't see nay TODO on line 801 and moreover this is not a line of
OrderReturnServices.processRefundReturn() method.
The last change in this file was commited by me in r763175 one week ago
http://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/order/src/
org/ofbiz/order/order/OrderReturnServices.java?r=763175

Could you clarify please ?

Jacques

From: "Sanders, Brian" 
> It's in the head revision as well on line 801.
> 
> -----Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com] 
> Sent: Tuesday, April 14, 2009 12:32 PM
> To: user@ofbiz.apache.org
> Subject: RE: Refunding adjustments only
> 
> When the project was imported into our repo, the revision # was
684368.
> The TODO was there.
> 
> -Original Message-
> From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
> Sent: Tuesday, April 14, 2009 12:01 PM
> To: user@ofbiz.apache.org
> Subject: Re: Refunding adjustments only
> 
> I did not find any TODO in OrderReturnServices.processRefundReturn()
> Are you sure its plain OFBiz code ? 
> If yes, which Release.revision are you using ?
> 
> Jacques
> 
> From: "Sanders, Brian" 
> If you look at processRefundReturn, you will notice that none of the
> code runs unless there is at least 1 line item. If you are refunding
> only, say, freight charges, the refund will not actually occur. There
is
> a TODO labeled "add adjustment total" which sounds like the developers
> are aware of the issue. Is there a reason that it has not been
> implemented yet? If I were to try and implement the functionality
> myself, is there anything I should be aware off? Can anyone offer some
> tips/suggestions as to how to implement? Thanks.
> 
> 
> 
>

RE: Using null as a search condition

[Sanders, Brian]

Nevermind. I'm just not getting results for some other reason.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Friday, April 17, 2009 4:16 PM
To: user@ofbiz.apache.org
Subject: Using null as a search condition

I need to find an entity where a column is null. How would I do this?

Using null as a search condition

[Sanders, Brian]

I need to find an entity where a column is null. How would I do this?

RE: Refunding adjustments only

[Sanders, Brian]

Well, it turns out it's not fixed in the latest. While it does make it
further into the code, it gets skipped over because of line 894:
while (itemByOrderIt.hasNext()) {

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Wednesday, April 15, 2009 8:40 AM
To: user@ofbiz.apache.org
Subject: RE: Refunding adjustments only

Ok, I was looking at the head for 4.0. It appears that the issue is
fixed in the latest. Thanks.

-Original Message-
From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
Sent: Tuesday, April 14, 2009 4:15 PM
To: user@ofbiz.apache.org
Subject: Re: Refunding adjustments only

Are you speaking about the last release available at the moment
(r764940) ?
I don't see nay TODO on line 801 and moreover this is not a line of
OrderReturnServices.processRefundReturn() method.
The last change in this file was commited by me in r763175 one week ago
http://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/order/src/
org/ofbiz/order/order/OrderReturnServices.java?r=763175

Could you clarify please ?

Jacques

From: "Sanders, Brian" 
> It's in the head revision as well on line 801.
> 
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com] 
> Sent: Tuesday, April 14, 2009 12:32 PM
> To: user@ofbiz.apache.org
> Subject: RE: Refunding adjustments only
> 
> When the project was imported into our repo, the revision # was
684368.
> The TODO was there.
> 
> -Original Message-
> From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
> Sent: Tuesday, April 14, 2009 12:01 PM
> To: user@ofbiz.apache.org
> Subject: Re: Refunding adjustments only
> 
> I did not find any TODO in OrderReturnServices.processRefundReturn()
> Are you sure its plain OFBiz code ? 
> If yes, which Release.revision are you using ?
> 
> Jacques
> 
> From: "Sanders, Brian" 
> If you look at processRefundReturn, you will notice that none of the
> code runs unless there is at least 1 line item. If you are refunding
> only, say, freight charges, the refund will not actually occur. There
is
> a TODO labeled "add adjustment total" which sounds like the developers
> are aware of the issue. Is there a reason that it has not been
> implemented yet? If I were to try and implement the functionality
> myself, is there anything I should be aware off? Can anyone offer some
> tips/suggestions as to how to implement? Thanks.
> 
> 
> 
>

RE: Refunding adjustments only

[Sanders, Brian]

Ok, I was looking at the head for 4.0. It appears that the issue is
fixed in the latest. Thanks.

-Original Message-
From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
Sent: Tuesday, April 14, 2009 4:15 PM
To: user@ofbiz.apache.org
Subject: Re: Refunding adjustments only

Are you speaking about the last release available at the moment
(r764940) ?
I don't see nay TODO on line 801 and moreover this is not a line of
OrderReturnServices.processRefundReturn() method.
The last change in this file was commited by me in r763175 one week ago
http://fisheye6.atlassian.com/browse/ofbiz/trunk/applications/order/src/
org/ofbiz/order/order/OrderReturnServices.java?r=763175

Could you clarify please ?

Jacques

From: "Sanders, Brian" 
> It's in the head revision as well on line 801.
> 
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com] 
> Sent: Tuesday, April 14, 2009 12:32 PM
> To: user@ofbiz.apache.org
> Subject: RE: Refunding adjustments only
> 
> When the project was imported into our repo, the revision # was
684368.
> The TODO was there.
> 
> -Original Message-
> From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
> Sent: Tuesday, April 14, 2009 12:01 PM
> To: user@ofbiz.apache.org
> Subject: Re: Refunding adjustments only
> 
> I did not find any TODO in OrderReturnServices.processRefundReturn()
> Are you sure its plain OFBiz code ? 
> If yes, which Release.revision are you using ?
> 
> Jacques
> 
> From: "Sanders, Brian" 
> If you look at processRefundReturn, you will notice that none of the
> code runs unless there is at least 1 line item. If you are refunding
> only, say, freight charges, the refund will not actually occur. There
is
> a TODO labeled "add adjustment total" which sounds like the developers
> are aware of the issue. Is there a reason that it has not been
> implemented yet? If I were to try and implement the functionality
> myself, is there anything I should be aware off? Can anyone offer some
> tips/suggestions as to how to implement? Thanks.
> 
> 
> 
>

RE: Refunding adjustments only

[Sanders, Brian]

It's in the head revision as well on line 801.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Tuesday, April 14, 2009 12:32 PM
To: user@ofbiz.apache.org
Subject: RE: Refunding adjustments only

When the project was imported into our repo, the revision # was 684368.
The TODO was there.

-Original Message-
From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
Sent: Tuesday, April 14, 2009 12:01 PM
To: user@ofbiz.apache.org
Subject: Re: Refunding adjustments only

I did not find any TODO in OrderReturnServices.processRefundReturn()
Are you sure its plain OFBiz code ? 
If yes, which Release.revision are you using ?

Jacques

From: "Sanders, Brian" 
If you look at processRefundReturn, you will notice that none of the
code runs unless there is at least 1 line item. If you are refunding
only, say, freight charges, the refund will not actually occur. There is
a TODO labeled "add adjustment total" which sounds like the developers
are aware of the issue. Is there a reason that it has not been
implemented yet? If I were to try and implement the functionality
myself, is there anything I should be aware off? Can anyone offer some
tips/suggestions as to how to implement? Thanks.

RE: Refunding adjustments only

[Sanders, Brian]

When the project was imported into our repo, the revision # was 684368.
The TODO was there.

-Original Message-
From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
Sent: Tuesday, April 14, 2009 12:01 PM
To: user@ofbiz.apache.org
Subject: Re: Refunding adjustments only

I did not find any TODO in OrderReturnServices.processRefundReturn()
Are you sure its plain OFBiz code ? 
If yes, which Release.revision are you using ?

Jacques

From: "Sanders, Brian" 
If you look at processRefundReturn, you will notice that none of the
code runs unless there is at least 1 line item. If you are refunding
only, say, freight charges, the refund will not actually occur. There is
a TODO labeled "add adjustment total" which sounds like the developers
are aware of the issue. Is there a reason that it has not been
implemented yet? If I were to try and implement the functionality
myself, is there anything I should be aware off? Can anyone offer some
tips/suggestions as to how to implement? Thanks.

Refunding adjustments only

[Sanders, Brian]

If you look at processRefundReturn, you will notice that none of the
code runs unless there is at least 1 line item. If you are refunding
only, say, freight charges, the refund will not actually occur. There is
a TODO labeled "add adjustment total" which sounds like the developers
are aware of the issue. Is there a reason that it has not been
implemented yet? If I were to try and implement the functionality
myself, is there anything I should be aware off? Can anyone offer some
tips/suggestions as to how to implement? Thanks.

Need to intercept inventory adjustment for return

[Sanders, Brian]

I have created an Item Status of "Scrapped" for a return item. When it
is selected, the customer will be issued a refund and the item will be
adjusted back into inventory. I was wondering if anyone can point to
where I could intercept the adjustment so that it does not occur. I'm
looking in the log, but I'm having some difficulty pinpointing it
myself. I will continue to investigate while I wait for responses.
Thanks.

RE: Automatic DB Update

[Sanders, Brian]

After a little investigation, it turns out that in the entityengine.xml
file, there is an attribute which belongs to : schema-name.
When OFBiz checks the database on startup, it was prepending the schema
to the table names which was causing the matching to fail. By removing
the attribute, OFBiz was able to make the match and add the column
automatically. If you look at
org.ofbiz.entity.jdbc.DatabaseUtil.checkDB():line 193, you will see the
statement:
if (tableNames.contains(entity.getTableName(datasourceInfo))) {

entity.getTableName(datasourceInfo) was returning .
whereas tableNames contained only the . When the column is added,
common sense tells me to look the column in the same place I defined it
(before/after a certain column), but it adds it to the end. I'm not sure
how easy it would be, but placing the column after a particular column
would be a nice feature. Unfortunately, I don't have the time to look
into incorporating it ATM, but maybe someone else would be able to.

-Original Message-----
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Friday, March 27, 2009 9:07 AM
To: user@ofbiz.apache.org
Subject: RE: Automatic DB Update

If you look near the bottom of
http://www.opensourcestrategies.com/ofbiz/hello_world3.php, you will see
an excerpt from a log file which shows DatabaseUtil adding a field to a
database. I checked the code and it looks like it should be adding the
field. Any ideas why this might not be working? I'm using a MySql db if
that makes any difference. Thanks.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Thursday, March 26, 2009 9:18 AM
To: user@ofbiz.apache.org
Subject: RE: Automatic DB Update

What I'm doing is adding a column/field to ReturnItem (although I think
I've changed my mind). I saw David's subsequent responses and will take
a look at those docs.

-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net] 
Sent: Wednesday, March 25, 2009 3:08 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic DB Update

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

make sure you add the path to your entity file in the
ofbiz-component.xml of the component you put it in.
  


BJ Freeman sent the following on 3/25/2009 9:38 AM:
> It will add tables.
> this is setup in the entityengine.xml
> to do this.
>  add-missing-on-start="true"
> 
> Sanders, Brian sent the following on 3/25/2009 6:30 AM:
>> >From what I've been reading, OFBiz is supposed to automatically
update
>> your database if you modify an entity. For some reason, I cannot get
>> mine to update. I've tried using the Update Tool to no avail. Can
anyone
>> tell me why I'm having issues? Thanks.
> 
> 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJyoENrP3NbaWWqE4RAkalAKC8vIAxtZiss6n7ZnRGSyS0AeBeWQCdFlOd
Bs5lL2QC9WmqPSxMZ00muAU=
=I9zV
-END PGP SIGNATURE-

RE: Default Product Price

[Sanders, Brian]

I figured it out: calculateProductPrice service

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Wednesday, April 01, 2009 1:10 PM
To: user@ofbiz.apache.org
Subject: Default Product Price

How would I go about getting the current default purchase price for a
product? The biggest issue I'm having is filtering on the date. What I
have so far is:

product.getRelatedByAnd("ProductPrice",UtilMisc.toMap("productPriceTypeI
d","DEFAULT_PRICE","productPricePurposeId","PURCHASE"));

 

I know I saw a method somewhere related to adding conditions, but cannot
find it now. Thanks.

Default Product Price

[Sanders, Brian]

How would I go about getting the current default purchase price for a
product? The biggest issue I'm having is filtering on the date. What I
have so far is:

product.getRelatedByAnd("ProductPrice",UtilMisc.toMap("productPriceTypeI
d","DEFAULT_PRICE","productPricePurposeId","PURCHASE"));

 

I know I saw a method somewhere related to adding conditions, but cannot
find it now. Thanks.

RE: Automatic DB Update

[Sanders, Brian]

If you look near the bottom of
http://www.opensourcestrategies.com/ofbiz/hello_world3.php, you will see
an excerpt from a log file which shows DatabaseUtil adding a field to a
database. I checked the code and it looks like it should be adding the
field. Any ideas why this might not be working? I'm using a MySql db if
that makes any difference. Thanks.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Thursday, March 26, 2009 9:18 AM
To: user@ofbiz.apache.org
Subject: RE: Automatic DB Update

What I'm doing is adding a column/field to ReturnItem (although I think
I've changed my mind). I saw David's subsequent responses and will take
a look at those docs.

-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net] 
Sent: Wednesday, March 25, 2009 3:08 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic DB Update

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

make sure you add the path to your entity file in the
ofbiz-component.xml of the component you put it in.
  


BJ Freeman sent the following on 3/25/2009 9:38 AM:
> It will add tables.
> this is setup in the entityengine.xml
> to do this.
>  add-missing-on-start="true"
> 
> Sanders, Brian sent the following on 3/25/2009 6:30 AM:
>> >From what I've been reading, OFBiz is supposed to automatically
update
>> your database if you modify an entity. For some reason, I cannot get
>> mine to update. I've tried using the Update Tool to no avail. Can
anyone
>> tell me why I'm having issues? Thanks.
> 
> 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJyoENrP3NbaWWqE4RAkalAKC8vIAxtZiss6n7ZnRGSyS0AeBeWQCdFlOd
Bs5lL2QC9WmqPSxMZ00muAU=
=I9zV
-END PGP SIGNATURE-

RE: Automatic DB Update

[Sanders, Brian]

What I'm doing is adding a column/field to ReturnItem (although I think
I've changed my mind). I saw David's subsequent responses and will take
a look at those docs.

-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net] 
Sent: Wednesday, March 25, 2009 3:08 PM
To: user@ofbiz.apache.org
Subject: Re: Automatic DB Update

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

make sure you add the path to your entity file in the
ofbiz-component.xml of the component you put it in.
  


BJ Freeman sent the following on 3/25/2009 9:38 AM:
> It will add tables.
> this is setup in the entityengine.xml
> to do this.
>  add-missing-on-start="true"
> 
> Sanders, Brian sent the following on 3/25/2009 6:30 AM:
>> >From what I've been reading, OFBiz is supposed to automatically
update
>> your database if you modify an entity. For some reason, I cannot get
>> mine to update. I've tried using the Update Tool to no avail. Can
anyone
>> tell me why I'm having issues? Thanks.
> 
> 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJyoENrP3NbaWWqE4RAkalAKC8vIAxtZiss6n7ZnRGSyS0AeBeWQCdFlOd
Bs5lL2QC9WmqPSxMZ00muAU=
=I9zV
-END PGP SIGNATURE-

Automatic DB Update

[Sanders, Brian]

>From what I've been reading, OFBiz is supposed to automatically update
your database if you modify an entity. For some reason, I cannot get
mine to update. I've tried using the Update Tool to no avail. Can anyone
tell me why I'm having issues? Thanks.

RE: Exchanges

[Sanders, Brian]

To keep things simple in this case, you may only exchange for an item of
equal value (ie. different size/color). 

-Original Message-
From: David E Jones [mailto:david.jo...@hotwaxmedia.com] 
Sent: Tuesday, March 24, 2009 2:51 PM
To: user@ofbiz.apache.org
Subject: Re: Exchanges


What does it do if the new product costs more or less than the old?

-David


On Mar 24, 2009, at 11:51 AM, Sanders, Brian wrote:

> So, here's the idea I want to try out:
> 1. I made an "Exchange" ReturnType
> 2. I made an "Exchange" OrderType
> 3. I added a "referenceProductId" relation to ReturnItem
> 4. I will probably add a "referenceQuantity" field to ReturnItem as  
> well
>
> In the return screen, if you select "Exchange", then the user will be
> asked for the product/quantity of the replacement item. Accepting the
> return will function just like a replace, except the item/quantity  
> will
> be pulled from the new fields.
>
> I just wanted to get some feedback as to whether or not this seems  
> like
> a good design. I feel that the logic is ok, but I'm unsure if adding  
> the
> reference fields to ReturnItem is the proper way to add the feature. I
> just don't want to paint myself (or anyone else) into this corner  
> where
> you have to add fields to entity to add a similar feature. Thanks.
>
> -Original Message-
> From: David E Jones [mailto:david.jo...@hotwaxmedia.com]
> Sent: Thursday, March 19, 2009 3:52 PM
> To: user@ofbiz.apache.org
> Subject: Re: Exchanges
>
>
> OFBiz does support various things that could be called an "Exchange".
> Usually this is done as a return for in-store credit, and then the
> customer can place whatever order they would like. A CSR could also do
> this on behalf of a customer without the customer having to place the
> actual order.
>
> Typically the return for replacement is for the same item and not
> exchanging for a different item, but with a little playing it could
> easily be used way... it's just more complicated since an exchange for
> a different item usually results in a credit to, or balance due from,
> the customer.
>
> -David
>
>
> On Mar 19, 2009, at 9:29 AM, Sanders, Brian wrote:
>
>> I haven't fully looked into it yet myself, but I'm told that OFBiz
>> does
>> not have exchange functionality. However, my understanding is that  
>> you
>> can do replacements. I will look into it in the meantime, but if  
>> OFBiz
>> does support exchanges, can someone point me in the right direction
>> (docs, ML, etc...)? Thanks.
>>
>

RE: Exchanges

[Sanders, Brian]

So, here's the idea I want to try out:
1. I made an "Exchange" ReturnType
2. I made an "Exchange" OrderType
3. I added a "referenceProductId" relation to ReturnItem
4. I will probably add a "referenceQuantity" field to ReturnItem as well

In the return screen, if you select "Exchange", then the user will be
asked for the product/quantity of the replacement item. Accepting the
return will function just like a replace, except the item/quantity will
be pulled from the new fields. 

I just wanted to get some feedback as to whether or not this seems like
a good design. I feel that the logic is ok, but I'm unsure if adding the
reference fields to ReturnItem is the proper way to add the feature. I
just don't want to paint myself (or anyone else) into this corner where
you have to add fields to entity to add a similar feature. Thanks.

-Original Message-
From: David E Jones [mailto:david.jo...@hotwaxmedia.com] 
Sent: Thursday, March 19, 2009 3:52 PM
To: user@ofbiz.apache.org
Subject: Re: Exchanges


OFBiz does support various things that could be called an "Exchange".  
Usually this is done as a return for in-store credit, and then the  
customer can place whatever order they would like. A CSR could also do  
this on behalf of a customer without the customer having to place the  
actual order.

Typically the return for replacement is for the same item and not  
exchanging for a different item, but with a little playing it could  
easily be used way... it's just more complicated since an exchange for  
a different item usually results in a credit to, or balance due from,  
the customer.

-David


On Mar 19, 2009, at 9:29 AM, Sanders, Brian wrote:

> I haven't fully looked into it yet myself, but I'm told that OFBiz  
> does
> not have exchange functionality. However, my understanding is that you
> can do replacements. I will look into it in the meantime, but if OFBiz
> does support exchanges, can someone point me in the right direction
> (docs, ML, etc...)? Thanks.
>

RE: Ant VS MVN in offbiz

[Sanders, Brian]

I like Maven and I have to disagree with the person who said "Maven is
less flexible than Ant". I'm not saying it's more/as flexible, but in my
experience with it, the plugins are designed to act a certain way if
they are not configured. This is intended to provide behavior that might
work for 90% (arbitrary guesstimate) of developers. If you want to tweak
the behavior of the plugin, then by all means do so in the POM. I
learned a lot about this by playing with the assembly plugin (which is
very cool). While I think it would be neat to see OFBiz "mavenized", I
don't see anything wrong with the current build system.

Exchanges

[Sanders, Brian]

I haven't fully looked into it yet myself, but I'm told that OFBiz does
not have exchange functionality. However, my understanding is that you
can do replacements. I will look into it in the meantime, but if OFBiz
does support exchanges, can someone point me in the right direction
(docs, ML, etc...)? Thanks.

RE: keepAlive

[Sanders, Brian]

I checked the XSD in /framework/minilang/dtd/simple-methods.xsd against
http://www.ofbiz.org/dtds/simple-methods.xsd and they are most certainly
different versions. Maybe there is a reason it's not done, but may I
suggest adding some sort of version identifier to the end of the XSD
file? Spring does this with its files (ie.
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd,
http://www.springframework.org/schema/beans/spring-beans-2.0.xsd,
http://www.springframework.org/schema/beans/spring-beans.xsd).

Again, you may have reasons for not following such a pattern, but it
couldn't hurt to suggest.

-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net] 
Sent: Tuesday, March 10, 2009 2:22 PM
To: user@ofbiz.apache.org
Subject: Re: keepAlive

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

try a
ant clean
and
ant run-install
depending on when you upgraded
you may have to do a
ant clean-all and purge your db if not the built in one.
then
ant run-install


Sanders, Brian sent the following on 3/10/2009 11:12 AM:
> I'm not sure what trunk revision of OFBiz I'm on, but it seems that
> OFBiz and the XSD file (http://www.ofbiz.org/dtds/simple-methods.xsd)
> are in disagreement as to what attributes should go with certain
> elements. For example, OFBiz is looking for the value-name attribute
in
> , while the XSD says that the attribute should be named
> value-field. Is this because the XSD is for another version, or
because
> something is wrong?
> 
> -----Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com] 
> Sent: Tuesday, March 10, 2009 1:53 PM
> To: user@ofbiz.apache.org
> Subject: RE: keepAlive
> 
> I think I found some leads. The log file indicates that some of the
> elements are wrong (ie. Error message: cvc-complex-type.3.2.2:
Attribute
> 'value-field' is not allowed to appear in element 'make-value'.)
> However, that's not what the XSD says.
> 
> -Original Message-
> From: Sanders, Brian [mailto:bsand...@connextions.com] 
> Sent: Tuesday, March 10, 2009 1:34 PM
> To: user@ofbiz.apache.org
> Subject: keepAlive
> 
> I'm trying to implement the keepAlive workaround per
> http://docs.ofbiz.org/pages/viewpage.action?pageId=1021
> <http://docs.ofbiz.org/pages/viewpage.action?pageId=1021>  
> 
> When I try to run the service, it says: Column 'GEO_TYPE_ID' cannot be
> null
> 
> Not sure what I'm doing wrong or how I could go about debugging the
code
> to see what I need to do. If anyone can suggest either somewhere to
set
> a breakpoint, or what I can do with the XML, it would be much
> appreciated. Thanks. 
> 
>  
> 
>  
> 
> 
> 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJtq+8rP3NbaWWqE4RAvJiAKCSxe+/v/AoiS/CMk8PyDCaFIhBCQCeIsoL
OnX+lpih23P1MuEiVbWeJQ4=
=7HNR
-END PGP SIGNATURE-

RE: keepAlive

[Sanders, Brian]

I'm not sure what trunk revision of OFBiz I'm on, but it seems that
OFBiz and the XSD file (http://www.ofbiz.org/dtds/simple-methods.xsd)
are in disagreement as to what attributes should go with certain
elements. For example, OFBiz is looking for the value-name attribute in
, while the XSD says that the attribute should be named
value-field. Is this because the XSD is for another version, or because
something is wrong?

-Original Message-----
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Tuesday, March 10, 2009 1:53 PM
To: user@ofbiz.apache.org
Subject: RE: keepAlive

I think I found some leads. The log file indicates that some of the
elements are wrong (ie. Error message: cvc-complex-type.3.2.2: Attribute
'value-field' is not allowed to appear in element 'make-value'.)
However, that's not what the XSD says.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Tuesday, March 10, 2009 1:34 PM
To: user@ofbiz.apache.org
Subject: keepAlive

I'm trying to implement the keepAlive workaround per
http://docs.ofbiz.org/pages/viewpage.action?pageId=1021
<http://docs.ofbiz.org/pages/viewpage.action?pageId=1021>  

When I try to run the service, it says: Column 'GEO_TYPE_ID' cannot be
null

Not sure what I'm doing wrong or how I could go about debugging the code
to see what I need to do. If anyone can suggest either somewhere to set
a breakpoint, or what I can do with the XML, it would be much
appreciated. Thanks. 

 

 

RE: keepAlive

[Sanders, Brian]

I think I found some leads. The log file indicates that some of the
elements are wrong (ie. Error message: cvc-complex-type.3.2.2: Attribute
'value-field' is not allowed to appear in element 'make-value'.)
However, that's not what the XSD says.

-Original Message-
From: Sanders, Brian [mailto:bsand...@connextions.com] 
Sent: Tuesday, March 10, 2009 1:34 PM
To: user@ofbiz.apache.org
Subject: keepAlive

I'm trying to implement the keepAlive workaround per
http://docs.ofbiz.org/pages/viewpage.action?pageId=1021
<http://docs.ofbiz.org/pages/viewpage.action?pageId=1021>  

When I try to run the service, it says: Column 'GEO_TYPE_ID' cannot be
null

Not sure what I'm doing wrong or how I could go about debugging the code
to see what I need to do. If anyone can suggest either somewhere to set
a breakpoint, or what I can do with the XML, it would be much
appreciated. Thanks. 

 

 

keepAlive

[Sanders, Brian]

I'm trying to implement the keepAlive workaround per
http://docs.ofbiz.org/pages/viewpage.action?pageId=1021
  

When I try to run the service, it says: Column 'GEO_TYPE_ID' cannot be
null

Not sure what I'm doing wrong or how I could go about debugging the code
to see what I need to do. If anyone can suggest either somewhere to set
a breakpoint, or what I can do with the XML, it would be much
appreciated. Thanks. 

 

 

RE: *.fo.ftl

[Sanders, Brian]

I don't necessarily rely on such tools, but they are good for creating a
rough draft of the end result. Once you get the general look you're
going for, then you go and hand-edit the code. I did find some tools on
the net that will convert HTML to FO. They're not perfect, but they may
be somewhat viable.

-Original Message-
From: David E Jones [mailto:david.jo...@hotwaxmedia.com] 
Sent: Thursday, March 05, 2009 1:33 PM
To: user@ofbiz.apache.org
Subject: Re: *.fo.ftl


"Hand-coding" XSL-FO is a lot like direct editing of HTML and CSS.  
Some people like editors that behave like a word processor so they  
never have to see an HTML tag, but most people (especially in recent  
years) seem to just go for the direct manipulation of HTML and CSS.  
There are very few web sites, especially dynamic (database driven) web  
sites, that don't have some or all of the HTML and CSS manually  
written. Part of the problem is that if you want flexibility then you  
can't effectively use many of the WYSIWIG style tools, so they're  
really only good for simple sites. This is made more dramatic by  
browser compatibility problems and such.

For XSL-FO the problem is a lot easier since the standards are better  
(and more consistently followed, unlike HTML and CSS). My guess about  
why such things are not more common is the same as for many tools,  
including tools for things in OFBiz: doing it by direct text editing  
is not that hard, so there just isn't much demand for special tools.

BTW, I'm talking specifically about things that are NOT static  
documents. None of the XSL-FO templates in OFBiz are used for static  
documents, so in addition to the editor having to understand XSL-FO it  
also has to understand the dynamic parts of the document... and that  
makes the editor a lot more complicated and a lot less useful compared  
to just editing the files.

So yes, all of the HTML, CSS, XSL-FO, JavaScript, Java, XML, etc, etc  
in OFBiz is created by hand (ever since late 2001 anyway, when we  
decided that good tool design is a better approach than code  
generation for poorly designed tools).

-David


On Mar 5, 2009, at 11:00 AM, Sanders, Brian wrote:

> Tis a commercial product. So, were these files hand coded then?
>
> -Original Message-
> From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com]
> Sent: Thursday, March 05, 2009 11:33 AM
> To: user@ofbiz.apache.org
> Subject: Re: *.fo.ftl
>
> Ha yes : xslfast
>
> Jacques
>
> From: "Jacques Le Roux" 
>> AFAIK, there are no free editors but some commercials (Google for
> <>)
>>
>> Jacques
>>
>> From: "Sanders, Brian" 
>> Were these files coded by hand, or was some sort of a WYSIWYG editor
>> used? I need to modify the pack slip and it's a bit of a headache.
> Does
>> anyone know of a decent, free editor/designer I might be able to use?
>> Thanks.
>>
>>
>>
>

RE: *.fo.ftl

[Sanders, Brian]

Tis a commercial product. So, were these files hand coded then?

-Original Message-
From: Jacques Le Roux [mailto:jacques.le.r...@les7arts.com] 
Sent: Thursday, March 05, 2009 11:33 AM
To: user@ofbiz.apache.org
Subject: Re: *.fo.ftl

Ha yes : xslfast

Jacques

From: "Jacques Le Roux" 
> AFAIK, there are no free editors but some commercials (Google for
<>)
> 
> Jacques
> 
> From: "Sanders, Brian" 
> Were these files coded by hand, or was some sort of a WYSIWYG editor
> used? I need to modify the pack slip and it's a bit of a headache.
Does
> anyone know of a decent, free editor/designer I might be able to use?
> Thanks.
> 
> 
>

*.fo.ftl

[Sanders, Brian]

Were these files coded by hand, or was some sort of a WYSIWYG editor
used? I need to modify the pack slip and it's a bit of a headache. Does
anyone know of a decent, free editor/designer I might be able to use?
Thanks.

RE: Obtain IP address from Contexts

[Sanders, Brian]

Thanks for the responses. I know how to obtain the IP address in, say,
the FTL template (already asked about that). I tried to find a request
object in the DispatchContext object to no avail. I was thinking that it
could be buried somewhere deeper and I'm really trying to figure out the
path to it if it is available in either the DispatchContext, or the
Context which is actually a Map.

-Original Message-
From: Kumaraswamy nandipati [mailto:kumarasw...@ecomzera.com] 
Sent: Saturday, February 28, 2009 8:30 PM
To: user@ofbiz.apache.org; Jacques Le Roux
Subject: Re: Obtain IP address from Contexts

Hi Sanders,

Its a basic concept. getting the ip address is depends upon the Request
object scope. By using request.getRemoteAddr() will give the request IP
address.


On Fri, Feb 27, 2009 at 10:33 PM, Jacques Le Roux <
jacques.le.r...@les7arts.com> wrote:

> You have to use HttpServletRequest for that. So it depends if you have
one
> in your context.
>
http://java.sun.com/products/servlet/2.2/javadoc/javax/servlet/ServletRe
quest.html#getRemoteAddr()<http://java.sun.com/products/servlet/2.2/java
doc/javax/servlet/ServletRequest.html#getRemoteAddr%28%29>
>
> If the service is used in a widget screen context you should be able
to get
> one. http://docs.ofbiz.org/x/axE
> From a job poller I guess not
>
> Jacques
>
> From: "Sanders, Brian" 
>
> When a service is called, is it possible to obtain the remote address
> from either the DispatchContext or the Context?
>
>
>
>


-- 
Thanks,
Kumaraswamy.N
91-9866805250.

RE: Using Ajax in Ofbiz

[Sanders, Brian]

I use a SOAP client based on jQuery. I can't really say how good/bad it is, but 
I tried to use another client first which was a PITA and I never got it 
working. I then tried this and found it easy to use. You can get it from 
http://plugins.jquery.com/project/jqSOAPClient

-Original Message-
From: Ján Valkovič [mailto:yan...@samsonzv.sk] 
Sent: Friday, February 27, 2009 8:25 AM
To: user@ofbiz.apache.org
Subject: Re: Using Ajax in Ofbiz

Hi,
try DWR ( http://directwebremoting.org/ ). You will need create service broker 
in java, like this (code sample):

@RemoteMethod
public Map callOfbizService(String serviceName, Map serviceContext) {

WebContext ctx = WebContextFactory.get();

try {
HttpServletRequest request = ctx.getHttpServletRequest();
GenericValue userLogin = (GenericValue) 
request.getSession().getAttribute("userLogin");
LocalDispatcher dispatcher = (GenericValue) 
request.getSession().getAttribute("dispatcher");
// some code
serviceContext.put("userLogin", userLogin);
Map resultFromRequestedService = 
dispatcher.runSync(serviceName, serviceContext);
// some other code 1
{ catch(Exception e) {
// catch action
}
// some other code 2
return resultFromRequestedService;
{

Hope this helps
ya

Dňa Pi, 2009-02-27 o 17:22 +0530, jayakumar t napísal:
> Hi All,
> 
> I am having a problem with Ajax in Ofbiz .In Ofbiz ajax request Send by
> using
> 
> new Ajax.Request("productService",etc
> 
> but it is not calling my jsonservice "productService".
> 
> Is there any need to include any other JS files in my ftl?
> 
> 
> regards
> 
> Jayakumar T

Obtain IP address from Contexts

[Sanders, Brian]

When a service is called, is it possible to obtain the remote address
from either the DispatchContext or the Context?

RE: Need client address in FTL

[Sanders, Brian]

That worked! Thanks.

-Original Message-
From: Kumaraswamy nandipati [mailto:kumarasw...@ecomzera.com] 
Sent: Friday, February 20, 2009 9:46 AM
To: user@ofbiz.apache.org
Subject: Re: Need client address in FTL

Hi.,


in FTL,

to get the client's IP using request method as follows:

*${request.getRemoteAddr()}*

- try this and update me whether it is working for you or not.

On Fri, Feb 20, 2009 at 7:54 PM, Sanders, Brian
wrote:

> This may be more of a Freemarker question, but the only solution I
found
> did not work. Is it possible to obtain the client's ip address in the
> FTL view template? I could probably add a variable to a class, but
just
> seems like a dirty hack to me.
>
>


-- 
Thanks,
Kumaraswamy.N
91-9866805250.

Need client address in FTL

[Sanders, Brian]

This may be more of a Freemarker question, but the only solution I found
did not work. Is it possible to obtain the client's ip address in the
FTL view template? I could probably add a variable to a class, but just
seems like a dirty hack to me. 

RE: Re-Populate form fields after failed validation

[Sanders, Brian]

Actually, I just figured it out a little while ago. The "completePack"
service is getting called when the form is submitted. In that same class
(PackingServices), there is a function named "setSessionPackageWeights".
If I call that before returning an error, then the text fields retain
their values. 

Brian Sanders


-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net] 
Sent: Wednesday, February 18, 2009 4:02 PM
To: user@ofbiz.apache.org
Subject: Re: Re-Populate form fields after failed validation

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

if the service does not remove any data from the maps, it should return.
for scales try using the
applications\product\src\ShipmentScaleApplet.java
it is remarked out in the build.

Sanders, Brian sent the following on 2/18/2009 10:27 AM:
> Hello,
> 
> I am searching the docs for the answer, but have not found it yet. I
am
> calling a service which needs to perform some validation. If the
> validation fails, certain text boxes lose their values when I am
> returned to the form. How could I go about re-populating the fields?
> Also, would anyone recommend against validating client-side using
> Ajax/SOAP? Basically, I need to check the actual weights of packages
> against their estimated weight on the Pack-Out screen. Thanks.
> 
>  
> 
> Brian Sanders
> 
>  
> 
> 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJnHc2rP3NbaWWqE4RArCyAJ4ql2Njmzy4th92lQqDpezjmr5oZwCcDdeV
rPrXxSU3w9LCKvEXhFerV18=
=F0f3
-END PGP SIGNATURE-

RE: %PDF-

[Sanders, Brian]

If you open a PDF file in a hex editor, you'll notice that the file
begins with that character sequence. My guess is that your output does
not constitute a valid PDF document.

Brian Sanders
Application Support Analyst


-Original Message-
From: Heidi Dehaes [mailto:info.ola...@gmail.com] 
Sent: Wednesday, February 18, 2009 3:10 PM
To: user@ofbiz.apache.org
Subject: %PDF-

Hello,

Does anyone has an idea what the reason is of the following error when i
ask
the creation of a PDF in Ofbiz orders.
It gives me anywhere the error in the opened window:

"File doesn't start with "%PDF-"  "


regards,
Heidi
www.olagos.eu

Re-Populate form fields after failed validation

[Sanders, Brian]

Hello,

I am searching the docs for the answer, but have not found it yet. I am
calling a service which needs to perform some validation. If the
validation fails, certain text boxes lose their values when I am
returned to the form. How could I go about re-populating the fields?
Also, would anyone recommend against validating client-side using
Ajax/SOAP? Basically, I need to check the actual weights of packages
against their estimated weight on the Pack-Out screen. Thanks.

 

Brian Sanders

 

Service Interaction Question

[Sanders, Brian]

Is it possible to make it so that I can post data to a service without
having to encapsulate the body in a SOAP envelope? I know that the .Net
framework supports it, so it's obviously feasible. Thanks.

 

Brian Sanders

Application Support Analyst

RE: Phone number as an Order Contact Mechanism

[Sanders, Brian]

The impression that I get from your response is that you think I'm
trying to customize the app to do this. I want to know if this
functionality is available OOTB. Is there a config file to
enable/configure such functionality? How does the app decide which party
contact mechs to add as order contact mechs? Thanks.

Brian Sanders
Application Support Analyst
Connextions, Inc.
3600 eCommerce Place  
Orlando, FL 32808

-Original Message-
From: BJ Freeman [mailto:bjf...@free-man.net] 
Sent: Wednesday, February 04, 2009 5:01 PM
To: user@ofbiz.apache.org
Subject: Re: Phone number as an Order Contact Mechanism

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

trace the code through the controller

Sanders, Brian sent the following on 2/4/2009 1:31 PM:
> I guess what I'm asking is: How do I do it in the interface?
> 
> Brian Sanders
> Application Support Analyst
> Connextions, Inc.
> 3600 eCommerce Place  
> Orlando, FL 32808
> 
> 
> -Original Message-
> From: David E Jones [mailto:david.jo...@hotwaxmedia.com] 
> Sent: Wednesday, February 04, 2009 4:16 PM
> To: user@ofbiz.apache.org
> Subject: Re: Phone number as an Order Contact Mechanism
> 
> 
> It can be both.
> 
> -David
> 
> 
> On Feb 4, 2009, at 2:14 PM, Sanders, Brian wrote:
> 
>> By default, does OFBiz allow the adding of a phone number as an Order
>> Contact Mechanism? If I manually insert a record to link the order  
>> to a
>> phone number, the "Find Order" screen renders it as I expected it to.
>> Sure, I could go thru Party, but for reporting purposes, it just
makes
>> more sense to have the phone number as a form of contact for an
order.
>> Thanks.
>>
>>
>>
>> Brian Sanders
>>
>> Application Support Analyst
>>
>> Connextions, Inc.
>>
>> 3600 eCommerce Place
>>
>> Orlando, FL 32808
>>
>>
>>
> 
> 
> 
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJihAMrP3NbaWWqE4RAiBhAJ9BPNPSkeKnZwmpksu1QPnijXxAjgCfdu1D
yFFXczvOQEfXWwXkH2bICzM=
=JMDb
-END PGP SIGNATURE-

RE: Phone number as an Order Contact Mechanism

[Sanders, Brian]

I guess what I'm asking is: How do I do it in the interface?

Brian Sanders
Application Support Analyst
Connextions, Inc.
3600 eCommerce Place  
Orlando, FL 32808


-Original Message-
From: David E Jones [mailto:david.jo...@hotwaxmedia.com] 
Sent: Wednesday, February 04, 2009 4:16 PM
To: user@ofbiz.apache.org
Subject: Re: Phone number as an Order Contact Mechanism


It can be both.

-David


On Feb 4, 2009, at 2:14 PM, Sanders, Brian wrote:

> By default, does OFBiz allow the adding of a phone number as an Order
> Contact Mechanism? If I manually insert a record to link the order  
> to a
> phone number, the "Find Order" screen renders it as I expected it to.
> Sure, I could go thru Party, but for reporting purposes, it just makes
> more sense to have the phone number as a form of contact for an order.
> Thanks.
>
>
>
> Brian Sanders
>
> Application Support Analyst
>
> Connextions, Inc.
>
> 3600 eCommerce Place
>
> Orlando, FL 32808
>
>
>

Phone number as an Order Contact Mechanism

[Sanders, Brian]

By default, does OFBiz allow the adding of a phone number as an Order
Contact Mechanism? If I manually insert a record to link the order to a
phone number, the "Find Order" screen renders it as I expected it to.
Sure, I could go thru Party, but for reporting purposes, it just makes
more sense to have the phone number as a form of contact for an order.
Thanks.

 

Brian Sanders

Application Support Analyst

Connextions, Inc.

3600 eCommerce Place  

Orlando, FL 32808