OFBIZ
Locked
 
|
I had created table " pickDate1" in database but when i am trying to insert date in table i am getting this error
Type conversion of field [pickDate1] to type [java.sql.Timestamp] failed for value "3": org.ofbiz.base.util.GeneralException: Could not convert 3 to java.sql.Timestamp: (Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff) Please Reply soon Thankyou ANIL BHAT |
|
|
That is not the normal way to interface with ofbiz.
this is not a normal log entry from ofbiz. you might want to get on a forum about the database you are using. and ask them. from what it says you did not specify a correct date format. 2275429 sent the following on 11/30/2007 8:39 PM: > I had created table " pickDate1" in database but when i am trying to insert > date in table i am getting this error > Type conversion of field [pickDate1] to type [java.sql.Timestamp] failed for > value "3": org.ofbiz.base.util.GeneralException: Could not convert 3 to > java.sql.Timestamp: (Timestamp format must be yyyy-mm-dd hh:mm:ss.fffffffff) > > Please Reply soon > Thankyou > ANIL BHAT > |
|
|
sendPrintFromScreen() works a charm if you have a post script printer.
However, I am having problems getting it to work with "text/plain". You might ask why I wanna do that, and the answer is that my current customer has half a dozen workhorse dot matrix printers that spit out a hundred pages a minute for about 5cents. So, I want to utilize these for some ordinary printing jobs like reprinting invoices for internal use and the like. So, I modified sendPrintFromScreen() so that if it doesn't find a postscript printer with the printer name that was passed in, it changes the contentType to "text/plain" and checks again. It always finds this one if I have not picked a postscript printer. The problem is that the renderer does not seem to put formfeeds at the end. This is not a problem when you only print one, but when you are massPrinting, everything gets pretty hosed. My test setup is printing three invoices from : https://localhost:8443/ordermgr/control/findorders?printerName=OKIData9721&s erviceName=/ordermgr/control/massPrintOrders?hideFields=YpartyId=NOAA%20NWAF C&hideFields=YpartyId=NOAA%20NWAFC&screenLocation=component://order/widget/o rdermgr/OrderPrintForms.xml#OrderPDF Anyone have any idea how to encourage the fop guy to put a ff after the document is finished in plain text? I am fairly sure this is the problem because I can use DocFlavor flavor = DocFlavor.INPUT_STREAM.AUTOSENSE; printer = PrintServiceLookup.lookupDefaultPrintService(); // Create the print job DocPrintJob job = printer.createPrintJob(); Doc doc = new SimpleDoc(myDoc, flavor, null); // Print it job.print(doc, null); And send in a FF terminated string and it all works fine. I would just prefer to use that FOP renderer so I don't have to hand code a bunch of stuff. Skip |
|
|
Hmmm, forget this. It's late. The problem is that the invoices I was
printing were outputing multiple lines for each line in the form and therefore hosing line count. Skip -----Original Message----- From: skip@thedevers [mailto:[hidden email]] Sent: Friday, November 30, 2007 10:26 PM To: [hidden email] Subject: Printing sendPrintFromScreen() works a charm if you have a post script printer. However, I am having problems getting it to work with "text/plain". You might ask why I wanna do that, and the answer is that my current customer has half a dozen workhorse dot matrix printers that spit out a hundred pages a minute for about 5cents. So, I want to utilize these for some ordinary printing jobs like reprinting invoices for internal use and the like. So, I modified sendPrintFromScreen() so that if it doesn't find a postscript printer with the printer name that was passed in, it changes the contentType to "text/plain" and checks again. It always finds this one if I have not picked a postscript printer. The problem is that the renderer does not seem to put formfeeds at the end. This is not a problem when you only print one, but when you are massPrinting, everything gets pretty hosed. My test setup is printing three invoices from : https://localhost:8443/ordermgr/control/findorders?printerName=OKIData9721&s erviceName=/ordermgr/control/massPrintOrders?hideFields=YpartyId=NOAA%20NWAF C&hideFields=YpartyId=NOAA%20NWAFC&screenLocation=component://order/widget/o rdermgr/OrderPrintForms.xml#OrderPDF Anyone have any idea how to encourage the fop guy to put a ff after the document is finished in plain text? I am fairly sure this is the problem because I can use DocFlavor flavor = DocFlavor.INPUT_STREAM.AUTOSENSE; printer = PrintServiceLookup.lookupDefaultPrintService(); // Create the print job DocPrintJob job = printer.createPrintJob(); Doc doc = new SimpleDoc(myDoc, flavor, null); // Print it job.print(doc, null); And send in a FF terminated string and it all works fine. I would just prefer to use that FOP renderer so I don't have to hand code a bunch of stuff. Skip |
|
|
By the way,
I think that you can specify the "text/plain" option in the view-map entry of the screen (without modifying the code in sendPrintFromScreen). Jacopo skip@thedevers wrote: > Hmmm, forget this. It's late. The problem is that the invoices I was > printing were outputing multiple lines for each line in the form and > therefore hosing line count. > > Skip > > -----Original Message----- > From: skip@thedevers [mailto:[hidden email]] > Sent: Friday, November 30, 2007 10:26 PM > To: [hidden email] > Subject: Printing > > > sendPrintFromScreen() works a charm if you have a post script printer. > > However, I am having problems getting it to work with "text/plain". You > might ask why I wanna do that, and the answer is that my current customer > has half a dozen workhorse dot matrix printers that spit out a hundred pages > a minute for about 5cents. > > So, I want to utilize these for some ordinary printing jobs like reprinting > invoices for internal use and the like. > > So, I modified sendPrintFromScreen() so that if it doesn't find a postscript > printer with the printer name that was passed in, it changes the contentType > to "text/plain" and checks again. It always finds this one if I have not > picked a postscript printer. > > The problem is that the renderer does not seem to put formfeeds at the end. > This is not a problem when you only print one, but when you are > massPrinting, everything gets pretty hosed. > > My test setup is printing three invoices from : > > https://localhost:8443/ordermgr/control/findorders?printerName=OKIData9721&s > erviceName=/ordermgr/control/massPrintOrders?hideFields=YpartyId=NOAA%20NWAF > C&hideFields=YpartyId=NOAA%20NWAFC&screenLocation=component://order/widget/o > rdermgr/OrderPrintForms.xml#OrderPDF > > Anyone have any idea how to encourage the fop guy to put a ff after the > document is finished in plain text? > > I am fairly sure this is the problem because I can use > > DocFlavor flavor = DocFlavor.INPUT_STREAM.AUTOSENSE; > printer = PrintServiceLookup.lookupDefaultPrintService(); > // Create the print job > DocPrintJob job = printer.createPrintJob(); > Doc doc = new SimpleDoc(myDoc, flavor, null); > // Print it > job.print(doc, null); > > And send in a FF terminated string and it all works fine. I would just > prefer to use that FOP renderer so I don't have to hand code a bunch of > stuff. > > Skip > |
|
|
Hmm, no kidding, where eez seez view-map entry? I check in web tools and
the screen I was printing from and didn't see a place to set it. Are you talking about a view-map setting in some controller? Skip -----Original Message----- From: Jacopo Cappellato [mailto:[hidden email]] Sent: Friday, November 30, 2007 11:25 PM To: [hidden email] Subject: Re: Printing By the way, I think that you can specify the "text/plain" option in the view-map entry of the screen (without modifying the code in sendPrintFromScreen). Jacopo skip@thedevers wrote: > Hmmm, forget this. It's late. The problem is that the invoices I was > printing were outputing multiple lines for each line in the form and > therefore hosing line count. > > Skip > > -----Original Message----- > From: skip@thedevers [mailto:[hidden email]] > Sent: Friday, November 30, 2007 10:26 PM > To: [hidden email] > Subject: Printing > > > sendPrintFromScreen() works a charm if you have a post script printer. > > However, I am having problems getting it to work with "text/plain". You > might ask why I wanna do that, and the answer is that my current customer > has half a dozen workhorse dot matrix printers that spit out a hundred > a minute for about 5cents. > > So, I want to utilize these for some ordinary printing jobs like reprinting > invoices for internal use and the like. > > So, I modified sendPrintFromScreen() so that if it doesn't find a postscript > printer with the printer name that was passed in, it changes the contentType > to "text/plain" and checks again. It always finds this one if I have not > picked a postscript printer. > > The problem is that the renderer does not seem to put formfeeds at the end. > This is not a problem when you only print one, but when you are > massPrinting, everything gets pretty hosed. > > My test setup is printing three invoices from : > > https://localhost:8443/ordermgr/control/findorders?printerName=OKIData9721&s > erviceName=/ordermgr/control/massPrintOrders?hideFields=YpartyId=NOAA%20NWAF > C&hideFields=YpartyId=NOAA%20NWAFC&screenLocation=component://order/widget/o > rdermgr/OrderPrintForms.xml#OrderPDF > > Anyone have any idea how to encourage the fop guy to put a ff after the > document is finished in plain text? > > I am fairly sure this is the problem because I can use > > DocFlavor flavor = DocFlavor.INPUT_STREAM.AUTOSENSE; > printer = PrintServiceLookup.lookupDefaultPrintService(); > // Create the print job > DocPrintJob job = printer.createPrintJob(); > Doc doc = new SimpleDoc(myDoc, flavor, null); > // Print it > job.print(doc, null); > > And send in a FF terminated string and it all works fine. I would just > prefer to use that FOP renderer so I don't have to hand code a bunch of > stuff. > > Skip > |
|
|
Yes,
sorry, I meant that you can define a new controller's entry (new request map and view map) for the text print of your report and set in the view-map the content type. It *should* work. Jacopo skip@thedevers wrote: > Hmm, no kidding, where eez seez view-map entry? I check in web tools and > the screen I was printing from and didn't see a place to set it. > > Are you talking about a view-map setting in some controller? > > Skip > > -----Original Message----- > From: Jacopo Cappellato [mailto:[hidden email]] > Sent: Friday, November 30, 2007 11:25 PM > To: [hidden email] > Subject: Re: Printing > > > By the way, > > I think that you can specify the "text/plain" option in the view-map > entry of the screen (without modifying the code in sendPrintFromScreen). > > Jacopo > > skip@thedevers wrote: >> Hmmm, forget this. It's late. The problem is that the invoices I was >> printing were outputing multiple lines for each line in the form and >> therefore hosing line count. >> >> Skip >> >> -----Original Message----- >> From: skip@thedevers [mailto:[hidden email]] >> Sent: Friday, November 30, 2007 10:26 PM >> To: [hidden email] >> Subject: Printing >> >> >> sendPrintFromScreen() works a charm if you have a post script printer. >> >> However, I am having problems getting it to work with "text/plain". You >> might ask why I wanna do that, and the answer is that my current customer >> has half a dozen workhorse dot matrix printers that spit out a hundred > pages >> a minute for about 5cents. >> >> So, I want to utilize these for some ordinary printing jobs like > reprinting >> invoices for internal use and the like. >> >> So, I modified sendPrintFromScreen() so that if it doesn't find a > postscript >> printer with the printer name that was passed in, it changes the > contentType >> to "text/plain" and checks again. It always finds this one if I have not >> picked a postscript printer. >> >> The problem is that the renderer does not seem to put formfeeds at the > end. >> This is not a problem when you only print one, but when you are >> massPrinting, everything gets pretty hosed. >> >> My test setup is printing three invoices from : >> >> > https://localhost:8443/ordermgr/control/findorders?printerName=OKIData9721&s > erviceName=/ordermgr/control/massPrintOrders?hideFields=YpartyId=NOAA%20NWAF > C&hideFields=YpartyId=NOAA%20NWAFC&screenLocation=component://order/widget/o >> rdermgr/OrderPrintForms.xml#OrderPDF >> >> Anyone have any idea how to encourage the fop guy to put a ff after the >> document is finished in plain text? >> >> I am fairly sure this is the problem because I can use >> >> DocFlavor flavor = DocFlavor.INPUT_STREAM.AUTOSENSE; >> printer = PrintServiceLookup.lookupDefaultPrintService(); >> // Create the print job >> DocPrintJob job = printer.createPrintJob(); >> Doc doc = new SimpleDoc(myDoc, flavor, null); >> // Print it >> job.print(doc, null); >> >> And send in a FF terminated string and it all works fine. I would just >> prefer to use that FOP renderer so I don't have to hand code a bunch of >> stuff. >> >> Skip >> > > |
|
|
Thanks Jacopo, I'll give that a try!
-----Original Message----- From: Jacopo Cappellato [mailto:[hidden email]] Sent: Friday, November 30, 2007 11:42 PM To: [hidden email] Subject: Re: Printing Yes, sorry, I meant that you can define a new controller's entry (new request map and view map) for the text print of your report and set in the view-map the content type. It *should* work. Jacopo skip@thedevers wrote: > Hmm, no kidding, where eez seez view-map entry? I check in web tools and > the screen I was printing from and didn't see a place to set it. > > Are you talking about a view-map setting in some controller? > > Skip > > -----Original Message----- > From: Jacopo Cappellato [mailto:[hidden email]] > Sent: Friday, November 30, 2007 11:25 PM > To: [hidden email] > Subject: Re: Printing > > > By the way, > > I think that you can specify the "text/plain" option in the view-map > entry of the screen (without modifying the code in sendPrintFromScreen). > > Jacopo > > skip@thedevers wrote: >> Hmmm, forget this. It's late. The problem is that the invoices I was >> printing were outputing multiple lines for each line in the form and >> therefore hosing line count. >> >> Skip >> >> -----Original Message----- >> From: skip@thedevers [mailto:[hidden email]] >> Sent: Friday, November 30, 2007 10:26 PM >> To: [hidden email] >> Subject: Printing >> >> >> sendPrintFromScreen() works a charm if you have a post script printer. >> >> However, I am having problems getting it to work with "text/plain". You >> might ask why I wanna do that, and the answer is that my current customer >> has half a dozen workhorse dot matrix printers that spit out a hundred > pages >> a minute for about 5cents. >> >> So, I want to utilize these for some ordinary printing jobs like > reprinting >> invoices for internal use and the like. >> >> So, I modified sendPrintFromScreen() so that if it doesn't find a > postscript >> printer with the printer name that was passed in, it changes the > contentType >> to "text/plain" and checks again. It always finds this one if I have not >> picked a postscript printer. >> >> The problem is that the renderer does not seem to put formfeeds at the > end. >> This is not a problem when you only print one, but when you are >> massPrinting, everything gets pretty hosed. >> >> My test setup is printing three invoices from : >> >> > > erviceName=/ordermgr/control/massPrintOrders?hideFields=YpartyId=NOAA%20NWAF > C&hideFields=YpartyId=NOAA%20NWAFC&screenLocation=component://order/widget/o >> rdermgr/OrderPrintForms.xml#OrderPDF >> >> Anyone have any idea how to encourage the fop guy to put a ff after the >> document is finished in plain text? >> >> I am fairly sure this is the problem because I can use >> >> DocFlavor flavor = DocFlavor.INPUT_STREAM.AUTOSENSE; >> printer = PrintServiceLookup.lookupDefaultPrintService(); >> // Create the print job >> DocPrintJob job = printer.createPrintJob(); >> Doc doc = new SimpleDoc(myDoc, flavor, null); >> // Print it >> job.print(doc, null); >> >> And send in a FF terminated string and it all works fine. I would just >> prefer to use that FOP renderer so I don't have to hand code a bunch of >> stuff. >> >> Skip >> > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |