Process to remind sales invoice not paid

2012-06-14 Thread Nicolas Malin
Hi, I checked with OFBiz if is possible to have a process to remind to a customer by letter an invoice that the due date is past and isn't paid. I don't found with ootb, this process exist in OFBiz ? Else I made on enhancement : * Add an entity CommunicationEventInvoice * Add entry menu

Re: Restful service in ofbiz

2012-06-14 Thread Foo Shyn Chung
Thanx Ankit. I'm just curious whether the mentioned improvement in the article is being done or not (to have something like the expose=true for REST). Thanx FooShyn On Wed, Jun 13, 2012 at 7:41 PM, Ankit Jain ankit.i...@gmail.com wrote: Hi FooShyn, I have used the restful services by

AW: Process to remind sales invoice not paid

2012-06-14 Thread c . schinzer
I would aproach this via a nightly job fetching all unaid invoices and sending a mail (or put a letter on a printer queue). Check Service Engine, ECAs and minilanguage to build that. That's theory so far. I need to build something very similar and I am about to implement. Any guidance from

Re: Restful service in ofbiz

2012-06-14 Thread Ankit Jain
I dont think its done yet. Regards, Ankit Jain On Thu, Jun 14, 2012 at 1:07 PM, Foo Shyn Chung ipoh...@gmail.com wrote: Thanx Ankit. I'm just curious whether the mentioned improvement in the article is being done or not (to have something like the expose=true for REST). Thanx FooShyn

Re: Removing Controller in URL

2012-06-14 Thread Jacques Le Roux
This works well, we abuse it here Jacques From: BJ Freeman bjf...@free-man.net let us know how it worked. Deepak Agarwal sent the following on 6/12/2012 2:01 PM: Just for the sake of if somebody wants to remove 'control' from user at all then one can configure a rule in tuckey: rule

Re: Process to remind sales invoice not paid

2012-06-14 Thread Jacques Le Roux
Hi Nicolas, Carsten, This would be a good contribution for order component it seems... You could share throuhg a Jira maybe... Jacques From: c.schin...@googlemail.com I would aproach this via a nightly job fetching all unaid invoices and sending a mail (or put a letter on a printer queue).

Re: Demo trunk is not updated

2012-06-14 Thread Jacques Le Roux
Thanks for report Ankit, Trunk demo did not update since http://svn.apache.org/viewvc?rev=1344771view=rev Not sure why, I will check when I will get a *real* chance... Jacques From: Ankit Jain ankit.i...@gmail.com Error on demo trunk on show cart page

Re: How to reload confige on fly

2012-06-14 Thread Jacques Le Roux
You can't for Java class (need a compile and restart), also properties, web.xml and actually JEE at large Controllers, widgets (menus, screens, forms), Groovy and Freemaker are possible Jacques From: 彭家辉 jiahui...@gmail.com Hello Everyone: Who can tell me how to make it in the ofbiz

Re: Restful service in ofbiz

2012-06-14 Thread Foo Shyn Chung
Thanx Ankit. One thing, i'd followed the document and so far have been able to work out the REST service to perform the ping. However when I add in the authentication and using the restclient in my firefox to test it, i keep on getting authentication failed error. The restclient on my firefox is

Re: Process to remind sales invoice not paid

2012-06-14 Thread Pierre Smits
Nicolas, First of all, great suggestion! You know you have the overview of outstanding invoices in both AP and AR. Maybe it would be usefull to include such a function in there. Fin Admin (specifically charged with credit control) would work from that screen the majority of their time. If the

Re: Process to remind sales invoice not paid

2012-06-14 Thread Pierre Smits
Carsten, I agree that such a solution might be useful to organisations with large volumes of invoices. Question I have though is: how do we enable management of this solution? Meaning, end users need to be able to setup (a) print queue(s) themselves. Or did you have a programmatic solution in

Re: Restful service in ofbiz

2012-06-14 Thread Ankit Jain
I have tested it on advanced REST client on Chrome try this https://chrome.google.com/webstore/detail/hgmloofddffdnphfgcellkdfbfbjeloo HTH Regards, Ankit Jain On Thu, Jun 14, 2012 at 2:58 PM, Foo Shyn Chung ipoh...@gmail.com wrote: Thanx Ankit. One thing, i'd followed the document and so

AW: Re: Process to remind sales invoice not paid

2012-06-14 Thread c . schinzer
Hi Pierre, I was just assuming that some old-school businesses (like I have 3+) would rather want to print out and 'snail mail' I.e. Use Post Service instead of e-mail (you won't believe how conservative people are getting over here these days ...) The 'print queue' could very well be a

Re: Restful service in ofbiz

2012-06-14 Thread Foo Shyn Chung
I'm getting the same error : org.ofbiz.service.ServiceAuthException: User authorization is required for this service: ping The raw input of my headers are: login.username: admin login.password: ofbiz Do i need to use the https URL instead of normal http ? Thanx FooShyn On Thu, Jun 14, 2012

Re: Restful service in ofbiz

2012-06-14 Thread Foo Shyn Chung
Sorry my mistake. Mis-typed the header name in the PingResource and end up getting the wrong result. Am able to get it to work now. Thanks a lot for the help. Thanx FooShyn On Thu, Jun 14, 2012 at 5:46 PM, Foo Shyn Chung ipoh...@gmail.com wrote: I'm getting the same error :

How to model products / prices for user configurable products

2012-06-14 Thread Martin Grotzke
Hi, I'm evaluating OFBiz for an online shop that shall also provide plissees (s.th. like http://plissees.com/). For the plissee configuration we want to create/integrate a custom product configurator, and I'm wondering how the product data, prices and the users product configuration would be

SQL Exception while executing the following:INSERT INTO SERVER_HIT

2012-06-14 Thread Sachin
Getting this error: SQL Exception while executing the following:INSERT INTO SERVER_HIT Exception: org.ofbiz.entity.GenericDataSourceException com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '44200-root.main-2012-06-14 16:06:28-REQUEST' for key 1

Re: Navigation menus are not working in firefox 12.0

2012-06-14 Thread Jacques Le Roux
I comes from time to time in FF for a moment already (I use 13). Usually I simply refresh and it works again, not this time? Trunk demo using trunk HEAD works in FF13 here Jacques - Original Message - From: Ankit Jain To: user@ofbiz.apache.org Sent: Thursday, June 14, 2012

Re: Navigation menus are not working in firefox 12.0

2012-06-14 Thread Ankit Jain
I have upgraded my browser to 13.0 now its working. Thanks Jacques. :) Regards, Ankit Jain On Thu, Jun 14, 2012 at 4:20 PM, Jacques Le Roux jacques.le.r...@les7arts.com wrote: I comes from time to time in FF for a moment already (I use 13). Usually I simply refresh and it works again,

Re: Process to remind sales invoice not paid

2012-06-14 Thread Nicolas Malin
Hi Pierre, Your suggestion is interesting and I had the same idea but not implement for time reason ;) I open an issue https://issues.apache.org/jira/browse/OFBIZ-4938 with my first works near my customer delivery that works only on one invoice (but I think with many invoice on reminder)

Re: AW: Process to remind sales invoice not paid

2012-06-14 Thread Nicolas Malin
Carsten, For your requirement, you can look my issue https://issues.apache.org/jira/browse/OFBIZ-4938 and add a service that search not paid invoice without commEvent or a commEvent more the X days old. After use EmailTemplateSetting configuration to send mail. Nicolas Le 14/06/2012

Re: Process to remind sales invoice not paid

2012-06-14 Thread Pierre Smits
Nicolas, I will have a look later today/tomorrow, Regards, Pierre 2012/6/14 Nicolas Malin malin.nico...@librenberry.net Hi Pierre, Your suggestion is interesting and I had the same idea but not implement for time reason ;) I open an issue

Re: Process to remind sales invoice not paid

2012-06-14 Thread Hans Bakker
Hi Nicolas, this is fairly easy to implement because send an invoice per email is already under the button on the invoice detail. Just setup a background daily job to check the payment date of open invoices if it is over the current date use the function to send the invoice with a

How to send order details to 3rd party email address

2012-06-14 Thread Martin Grotzke
Hi, our use case is that in our shop the user shall be able to configure a product (Pleated blinds) that is built/packed by an external manufaturer/packer. The idea is to send an email to the manufacturer with details regarding the ordered/configured product and the customer address (for

How to include ftl from another module using a variable?

2012-06-14 Thread Michael Brohl
Hi, I want to include a freemarker template using the #include / directive from another module. The template path is given to the including ftl (in module1) through a screen variable in the form component://module2/path/to/ftl/name.ftl. The variable is named myTemplate. Code .. #include

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

2012-06-14 Thread mz4wheeler
Well, you simply need to remove the offending record in the server_hit table. You could probably just empty the table delete from server_hit if you don't care about it's contents. However, it's odd that you would get this error to begin with. I'm wondering if it has to do with past problems

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

2012-06-14 Thread Deepak Dixit
Hi Sachin, Which version of mysql are you using? This error occurs due to mysql issue, as mysql does not support the millisecond for timestamp field, and if two request executes on same time with millisecond timestamp differences then you can get this error message. (Generally for those

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

2012-06-14 Thread Mike
[6 Dec 2011 17:25] Paul DuBois Noted in 5.6.4 changelog. MySQL now supports fractional seconds for TIME, DATETIME, and TIMESTAMP values, with up to microsecond precision. On Thu, Jun 14, 2012 at 10:05 AM, Deepak Dixit deepak.di...@hotwaxmedia.com wrote: Hi Sachin, Which version of mysql

Re: SQL Exception while executing the following:INSERT INTO SERVER_HIT

2012-06-14 Thread Deepak Dixit
But this fix is not included in release till now :) mysql 5.6.* is an development release not an stable release. Thanks Regards -- Deepak Dixit On Jun 14, 2012, at 11:04 PM, Mike wrote: [6 Dec 2011 17:25] Paul DuBois Noted in 5.6.4 changelog. MySQL now supports fractional seconds

Re: startofbiz.bat obsolete?

2012-06-14 Thread Andre Maule
--Original Message-- From: Jacopo Cappellato To: user@ofbiz.apache.org ReplyTo: user@ofbiz.apache.org Subject: Re: startofbiz.bat obsolete? Sent: Jun 13, 2012 05:28 Hi FooShyn, the new command is now: ../tools/startofbiz.bat Jacopo On Jun 13, 2012, at 10:20 AM, Foo Shyn Chung wrote: