Re : CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
Locked
Re : CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
 
|
My Response Servlet works well.
I mixed between WorldPay and Paypal examples. I use the "LinkedList" of the PaypalExample in the "setPaymentPreference" method. Sherlocks works !!! It's very effective for European webmasters Thanks Eric >I think your payment details (Credit card number etc.) are collected by >Shelocks. If this the case, I would suggest you to look at how Paypal >works. I never did this kind of integration before. > > Thanks, > > Raj > > Eric wrote: >> Raj, everybody, >> >> When I process to a purchase in the ecommerce web site, >> on the "Final Checkout Review" page (with Payment Information : >> "Sherlocks") >> here I click on "Submit order" button. >> This act creates a recording in the "OrderPaymentPreference" table with >> the statusId field "PAYMENT_NOT_RECEIVED" >> The next pages are my Sherlocks Request Servlet to begin the payment, >> then the bank server pages and at least my Sherlocks Response Servlet. >> Here I want to modify the same recording in order to modify the statusId >> field from "PAYMENT_NOT_RECEIVED" to "PAYMENT_RECEIVED" or another >> status, >> with my Sherlocks Response Servlet (in a second time this will be an >> AutoResponse Servlet from bank server to Ofbiz server). >> >> My question is the same : what class / service can I use in order to >> modify a recording in the "OrderPaymentPreference" table ? >> >> Thank you very much >> >> Eric >> >> >>> Eric, >>> >>> I don't think you need to modify any of the OFBiz classes to implement a >>> payment processor service. The error you are getting may be due to >>> misconfiguration or wrong implementation for service. >>> >>> Thanks, >>> >>> Raj >>> >>> Eric wrote: >>>> Hello >>>> >>>> I'm trying to implement this service. >>>> I'm following the WorldPay example. >>>> In the response (file : applications/accounting/src ... >>>> /thirdparty/worldpay/SelectRespServlet.java) >>>> I get an error (line 284) because the request to modify the >>>> ORDER_PAYMENT_PREFERENCE table >>>> is a INSERT query and not an UPDATE query, so I get >>>> ERROR: duplicate key violates unique constraint >>>> "pk_order_payment_preference" >>>> >>>> How can I use an UDPATE query in order to modify the defined row (in >>>> ORDER_PAYMENT_PREFERENCE table) >>>> and update with the external credit card payment datas from the bank >>>> >>>> What class / service have I to use in order to record external payments >>>> ? >>>> >>>> Thanks >>>> >>> >>> >>> >>> >>> -- >>> No virus found in this incoming message. >>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 - >>> Release Date: 20/05/2008 16:45 >>> >>> >> >> > > > > > -- > No virus found in this incoming message. > Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 - > Release Date: 20/05/2008 16:45 > > |
Re: Re : CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
|
|
This is good news.
If you are willing to contribute your work, just create a new Jira issue and attach your patch to it. Kind regards, Jacopo On May 22, 2008, at 12:45 PM, Eric DE MAULDE wrote: > My Response Servlet works well. > I mixed between WorldPay and Paypal examples. > I use the "LinkedList" of the PaypalExample in the > "setPaymentPreference" method. > > Sherlocks works !!! > It's very effective for European webmasters > > Thanks > > Eric > > >> I think your payment details (Credit card number etc.) are >> collected by Shelocks. If this the case, I would suggest you to >> look at how Paypal works. I never did this kind of integration >> before. >> >> Thanks, >> >> Raj >> >> Eric wrote: >>> Raj, everybody, >>> >>> When I process to a purchase in the ecommerce web site, >>> on the "Final Checkout Review" page (with Payment Information : >>> "Sherlocks") >>> here I click on "Submit order" button. >>> This act creates a recording in the "OrderPaymentPreference" table >>> with the statusId field "PAYMENT_NOT_RECEIVED" >>> The next pages are my Sherlocks Request Servlet to begin the >>> payment, then the bank server pages and at least my Sherlocks >>> Response Servlet. >>> Here I want to modify the same recording in order to modify the >>> statusId field from "PAYMENT_NOT_RECEIVED" to "PAYMENT_RECEIVED" >>> or another status, >>> with my Sherlocks Response Servlet (in a second time this will be >>> an AutoResponse Servlet from bank server to Ofbiz server). >>> >>> My question is the same : what class / service can I use in order >>> to modify a recording in the "OrderPaymentPreference" table ? >>> >>> Thank you very much >>> >>> Eric >>> >>> >>>> Eric, >>>> >>>> I don't think you need to modify any of the OFBiz classes to >>>> implement a payment processor service. The error you are getting >>>> may be due to misconfiguration or wrong implementation for service. >>>> >>>> Thanks, >>>> >>>> Raj >>>> >>>> Eric wrote: >>>>> Hello >>>>> >>>>> I'm trying to implement this service. >>>>> I'm following the WorldPay example. >>>>> In the response (file : applications/accounting/src ... / >>>>> thirdparty/worldpay/SelectRespServlet.java) >>>>> I get an error (line 284) because the request to modify the >>>>> ORDER_PAYMENT_PREFERENCE table >>>>> is a INSERT query and not an UPDATE query, so I get >>>>> ERROR: duplicate key violates unique constraint >>>>> "pk_order_payment_preference" >>>>> >>>>> How can I use an UDPATE query in order to modify the defined row >>>>> (in ORDER_PAYMENT_PREFERENCE table) >>>>> and update with the external credit card payment datas from the >>>>> bank >>>>> >>>>> What class / service have I to use in order to record external >>>>> payments ? >>>>> >>>>> Thanks >>>>> >>>> >>>> >>>> >>>> >>>> -- >>>> No virus found in this incoming message. >>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 >>>> - Release Date: 20/05/2008 16:45 >>>> >>>> >>> >>> >> >> >> >> >> -- >> No virus found in this incoming message. >> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 - >> Release Date: 20/05/2008 16:45 >> > |
Re: CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
Administrator
|
In reply to this post by Eric DE MAULDE
Hi Eric,
Is it some code you could throw in trunk ? Jacques From: "Eric DE MAULDE" <[hidden email]> > My Response Servlet works well. > I mixed between WorldPay and Paypal examples. > I use the "LinkedList" of the PaypalExample in the "setPaymentPreference" > method. > > Sherlocks works !!! > It's very effective for European webmasters > > Thanks > > Eric > > >>I think your payment details (Credit card number etc.) are collected by >>Shelocks. If this the case, I would suggest you to look at how Paypal >>works. I never did this kind of integration before. >> >> Thanks, >> >> Raj >> >> Eric wrote: >>> Raj, everybody, >>> >>> When I process to a purchase in the ecommerce web site, >>> on the "Final Checkout Review" page (with Payment Information : >>> "Sherlocks") >>> here I click on "Submit order" button. >>> This act creates a recording in the "OrderPaymentPreference" table with >>> the statusId field "PAYMENT_NOT_RECEIVED" >>> The next pages are my Sherlocks Request Servlet to begin the payment, >>> then the bank server pages and at least my Sherlocks Response Servlet. >>> Here I want to modify the same recording in order to modify the statusId >>> field from "PAYMENT_NOT_RECEIVED" to "PAYMENT_RECEIVED" or another >>> status, >>> with my Sherlocks Response Servlet (in a second time this will be an >>> AutoResponse Servlet from bank server to Ofbiz server). >>> >>> My question is the same : what class / service can I use in order to >>> modify a recording in the "OrderPaymentPreference" table ? >>> >>> Thank you very much >>> >>> Eric >>> >>> >>>> Eric, >>>> >>>> I don't think you need to modify any of the OFBiz classes to implement a >>>> payment processor service. The error you are getting may be due to >>>> misconfiguration or wrong implementation for service. >>>> >>>> Thanks, >>>> >>>> Raj >>>> >>>> Eric wrote: >>>>> Hello >>>>> >>>>> I'm trying to implement this service. >>>>> I'm following the WorldPay example. >>>>> In the response (file : applications/accounting/src ... >>>>> /thirdparty/worldpay/SelectRespServlet.java) >>>>> I get an error (line 284) because the request to modify the >>>>> ORDER_PAYMENT_PREFERENCE table >>>>> is a INSERT query and not an UPDATE query, so I get >>>>> ERROR: duplicate key violates unique constraint >>>>> "pk_order_payment_preference" >>>>> >>>>> How can I use an UDPATE query in order to modify the defined row (in >>>>> ORDER_PAYMENT_PREFERENCE table) >>>>> and update with the external credit card payment datas from the bank >>>>> >>>>> What class / service have I to use in order to record external payments >>>>> ? >>>>> >>>>> Thanks >>>>> >>>> >>>> >>>> >>>> >>>> -- >>>> No virus found in this incoming message. >>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 - >>>> Release Date: 20/05/2008 16:45 >>>> >>>> >>> >>> >> >> >> >> >> -- >> No virus found in this incoming message. >> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 - >> Release Date: 20/05/2008 16:45 >> >> > |
Re: CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
|
|
Yes, of course
I'm not a good developer because I'm beginning to study Java Today I improve the management of the different banking responses This weekend I summarize my implementation And I must use the OFBiz trunk instead the Release.4.0 branch And after I post my "patch" I don't know the JIRA webtool Eric > Hi Eric, > > Is it some code you could throw in trunk ? > > Jacques > > From: "Eric DE MAULDE" <[hidden email]> >> My Response Servlet works well. >> I mixed between WorldPay and Paypal examples. >> I use the "LinkedList" of the PaypalExample in the "setPaymentPreference" >> method. >> >> Sherlocks works !!! >> It's very effective for European webmasters >> >> Thanks >> >> Eric >> >> >>>I think your payment details (Credit card number etc.) are collected by >>>Shelocks. If this the case, I would suggest you to look at how Paypal >>>works. I never did this kind of integration before. >>> >>> Thanks, >>> >>> Raj >>> >>> Eric wrote: >>>> Raj, everybody, >>>> >>>> When I process to a purchase in the ecommerce web site, >>>> on the "Final Checkout Review" page (with Payment Information : >>>> "Sherlocks") >>>> here I click on "Submit order" button. >>>> This act creates a recording in the "OrderPaymentPreference" table with >>>> the statusId field "PAYMENT_NOT_RECEIVED" >>>> The next pages are my Sherlocks Request Servlet to begin the payment, >>>> then the bank server pages and at least my Sherlocks Response Servlet. >>>> Here I want to modify the same recording in order to modify the >>>> statusId field from "PAYMENT_NOT_RECEIVED" to "PAYMENT_RECEIVED" or >>>> another status, >>>> with my Sherlocks Response Servlet (in a second time this will be an >>>> AutoResponse Servlet from bank server to Ofbiz server). >>>> >>>> My question is the same : what class / service can I use in order to >>>> modify a recording in the "OrderPaymentPreference" table ? >>>> >>>> Thank you very much >>>> >>>> Eric >>>> >>>> >>>>> Eric, >>>>> >>>>> I don't think you need to modify any of the OFBiz classes to implement >>>>> a payment processor service. The error you are getting may be due to >>>>> misconfiguration or wrong implementation for service. >>>>> >>>>> Thanks, >>>>> >>>>> Raj >>>>> >>>>> Eric wrote: >>>>>> Hello >>>>>> >>>>>> I'm trying to implement this service. >>>>>> I'm following the WorldPay example. >>>>>> In the response (file : applications/accounting/src ... >>>>>> /thirdparty/worldpay/SelectRespServlet.java) >>>>>> I get an error (line 284) because the request to modify the >>>>>> ORDER_PAYMENT_PREFERENCE table >>>>>> is a INSERT query and not an UPDATE query, so I get >>>>>> ERROR: duplicate key violates unique constraint >>>>>> "pk_order_payment_preference" >>>>>> >>>>>> How can I use an UDPATE query in order to modify the defined row (in >>>>>> ORDER_PAYMENT_PREFERENCE table) >>>>>> and update with the external credit card payment datas from the bank >>>>>> >>>>>> What class / service have I to use in order to record external >>>>>> payments ? >>>>>> >>>>>> Thanks >>>>>> >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> No virus found in this incoming message. >>>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 - >>>>> Release Date: 20/05/2008 16:45 >>>>> >>>>> >>>> >>>> >>> >>> >>> >>> >>> -- >>> No virus found in this incoming message. >>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 - >>> Release Date: 20/05/2008 16:45 >>> >>> >> > > > > -- > No virus found in this incoming message. > Checked by AVG. Version: 7.5.524 / Virus Database: 269.24.0/1459 - Release > Date: 21/05/2008 17:34 > > |
Re: CLOSE : external banking service of credit card payment (Sherlocks by Atos Origin)
|
Administrator
|
All is very easy as soon as you have understood what you need to know (like a lot of things actually but not all ;o)
Please follow carefully http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Contributors+Best+Practices Thanks Jacques From: "Eric DE MAULDE" <[hidden email]> > Yes, of course > > I'm not a good developer because I'm beginning to study Java > Today I improve the management of the different banking responses > This weekend I summarize my implementation > And I must use the OFBiz trunk instead the Release.4.0 branch > And after I post my "patch" > I don't know the JIRA webtool > > Eric > > >> Hi Eric, >> >> Is it some code you could throw in trunk ? >> >> Jacques >> >> From: "Eric DE MAULDE" <[hidden email]> >>> My Response Servlet works well. >>> I mixed between WorldPay and Paypal examples. >>> I use the "LinkedList" of the PaypalExample in the "setPaymentPreference" >>> method. >>> >>> Sherlocks works !!! >>> It's very effective for European webmasters >>> >>> Thanks >>> >>> Eric >>> >>> >>>>I think your payment details (Credit card number etc.) are collected by >>>>Shelocks. If this the case, I would suggest you to look at how Paypal >>>>works. I never did this kind of integration before. >>>> >>>> Thanks, >>>> >>>> Raj >>>> >>>> Eric wrote: >>>>> Raj, everybody, >>>>> >>>>> When I process to a purchase in the ecommerce web site, >>>>> on the "Final Checkout Review" page (with Payment Information : >>>>> "Sherlocks") >>>>> here I click on "Submit order" button. >>>>> This act creates a recording in the "OrderPaymentPreference" table with >>>>> the statusId field "PAYMENT_NOT_RECEIVED" >>>>> The next pages are my Sherlocks Request Servlet to begin the payment, >>>>> then the bank server pages and at least my Sherlocks Response Servlet. >>>>> Here I want to modify the same recording in order to modify the >>>>> statusId field from "PAYMENT_NOT_RECEIVED" to "PAYMENT_RECEIVED" or >>>>> another status, >>>>> with my Sherlocks Response Servlet (in a second time this will be an >>>>> AutoResponse Servlet from bank server to Ofbiz server). >>>>> >>>>> My question is the same : what class / service can I use in order to >>>>> modify a recording in the "OrderPaymentPreference" table ? >>>>> >>>>> Thank you very much >>>>> >>>>> Eric >>>>> >>>>> >>>>>> Eric, >>>>>> >>>>>> I don't think you need to modify any of the OFBiz classes to implement >>>>>> a payment processor service. The error you are getting may be due to >>>>>> misconfiguration or wrong implementation for service. >>>>>> >>>>>> Thanks, >>>>>> >>>>>> Raj >>>>>> >>>>>> Eric wrote: >>>>>>> Hello >>>>>>> >>>>>>> I'm trying to implement this service. >>>>>>> I'm following the WorldPay example. >>>>>>> In the response (file : applications/accounting/src ... >>>>>>> /thirdparty/worldpay/SelectRespServlet.java) >>>>>>> I get an error (line 284) because the request to modify the >>>>>>> ORDER_PAYMENT_PREFERENCE table >>>>>>> is a INSERT query and not an UPDATE query, so I get >>>>>>> ERROR: duplicate key violates unique constraint >>>>>>> "pk_order_payment_preference" >>>>>>> >>>>>>> How can I use an UDPATE query in order to modify the defined row (in >>>>>>> ORDER_PAYMENT_PREFERENCE table) >>>>>>> and update with the external credit card payment datas from the bank >>>>>>> >>>>>>> What class / service have I to use in order to record external >>>>>>> payments ? >>>>>>> >>>>>>> Thanks >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> No virus found in this incoming message. >>>>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 - >>>>>> Release Date: 20/05/2008 16:45 >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> >>>> -- >>>> No virus found in this incoming message. >>>> Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.21/1457 - >>>> Release Date: 20/05/2008 16:45 >>>> >>>> >>> >> >> >> >> -- >> No virus found in this incoming message. >> Checked by AVG. Version: 7.5.524 / Virus Database: 269.24.0/1459 - Release >> Date: 21/05/2008 17:34 >> >> > |
IMPLEMENTATION : external banking service of credit card payment (Sherlocks by Atos Origin)
|
|
In order to implement this service to the OFBiz trunk,
I sent a request to my French bank (LCL, Le Crédit Lyonnais) and Atos Origin _ Bank : I use the demontration key (certificate) of my bank Their business designation of this service is "Sherlocks" _ Atos Origin : this company is the owner of this service. It rents this service to another banks. Their business designation of this service is "SIPS" I keep you up-to-date. Eric DE MAULDE |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |