Re: [WebDNA] paypal FINALLY!!!!
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103339
interpreted = N
texte = This is my code for sending details of CC etc to PayFlow, getting response and then putting the response into a cart and a db. ThisOrder is the cart number =================================================================== [TEXT]content=[!] [/!]TRXTYPE=S[!] S=sale, A=Authorization, D=Collect Payment [/!]&ACCT=[URL][_CREDITCARDNUMBER][/URL][!] [/!]&CVV2=[URL][CCV2][/URL][!] [/!]&EXPDATE=[URL][_CCEXPIRY][/URL][!] [/!]&TENDER=C[!] [/!]&INVNUM=[ThisOrder][!] [/!]&AMT=[URL][_INVOICE-TOTAL][/URL][!] [/!]&STREET=[URL][_payment_address][/URL][!] [/!]&ZIP=[URL][_payment_postcode][/URL][!] [/!]&USER=[URL]PAYFLOWUSER[/URL[!] [/!]&PWD=[URL]PAYFLOWPASS[/URL][!] [/!]&VENDOR=[URL]PAYFLOWVENDOR[/URL][!] [/!]&PARTNER=[URL]PAYFLOWPARTNER[/URL][!] [/!][/TEXT] [text multi=T]payflow_result=[tcpconnect host=PAYFLOWURL&port=443&ssl=T][!] [/!][tcpsend skipheader=T]POST /transaction HTTP/1.0[UnURL]%0D%0A[/ UnURL][!] [/!]USER-AGENT: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) [UnURL]%0D%0A[/UnURL][!] [/!]Content-type: text/namevalue[UnURL]%0D%0A[/UnURL][!] [/!]Content-Length: [CountChars][content][/CountChars][UnURL]%0D%0A[/ UnURL][!] [/!]X-VPS-REQUEST-ID: [ThisOrder][random][UnURL]%0D%0A[/UnURL][!] [/!]X-VPS-CLIENT-TIMEOUT: 45[UnURL]%0D%0A[/UnURL][!] [/!]X-VPS-CLIENT-CERTIFICATION-ID: [URL]PAYFLOWCERTIFICATION-ID[/URL] [UnURL]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-INTEGRATION-PRODUCT: WebDNA[UnURL]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-INTEGRATION-VERSION: 6.1[UnURL]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-OS-NAME: Windows 2003[UnURL]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-OS-VERSION: [UnURL]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-RUNTIME-VERSION: [UnURL]%0D%0A[/UnURL][!] [/!]Content-type: text/namevalue[UnURL]%0D%0A[/UnURL][!] [/!][UnURL]%0D%0A[/UnURL][!] [/!][content][UnURL]%0D%0A[/UnURL][!] [/!][/TCPSend][!] [/!][/tcpconnect][/text] [!] -------------- This creates multi text variables -------------- [/!] [TEXT multi=T]PayFlow_result02=0&[PayFlow_Result][/TEXT] [If ("[RESULT]"="0")] [Then] [!] -------------- SUCCESS -------------- [/!] [Replace db=^data/pendingorders.db&eqOrderNodatarq=[ThisOrder]][!] [/!]payment_confirmed=T[!] [/!]&payment_notes=[URL][!] [/!][ACK]:[!] [/!][ConvertWords db=^data/paypalwords.db][TRANSACTIONID][/ ConvertWords]:[!] [/!][ConvertWords db=^data/paypalwords.db][AUTHORIZATIONID][/ ConvertWords]:[!] [/!][PAYMENTTYPE][!] [/!][/URL][!] [/!]&payment_date=[ThisDate][!] [/!]&payment_time=[ThisTime][!] [/!][/Replace] [SetHeader file=pendingcarts/[thisOrder]][!] [/!]&Header36=[URL][!] [/!][ACK]:[!] [/!][ConvertWords db=^data/paypalwords.db][TRANSACTIONID][/ ConvertWords]:[!] [/!][ConvertWords db=^data/paypalwords.db][AUTHORIZATIONID][/ ConvertWords]:[!] [/!][PAYMENTTYPE][!] [/!][/URL][!] [/!]&AuthNumber=[URL][ConvertWords db=^data/paypalwords.db] [AUTHORIZATIONID][/ConvertWords][/URL][!] [/!]&RepsoneText=[URL][ACK][/URL][!] [/!]&Status=[URL][PAYMENTSTATUS][/URL][!] [/!]&BatchNumber=[URL][ConvertWords db=^data/paypalwords.db][AMT][/ ConvertWords][/URL][!] [/!]&ReferenceNumber=[URL][ConvertWords db=^data/paypalwords.db] [TRANSACTIONID][/ConvertWords][/URL][!] [/!]&SequenceNumber=[URL][ConvertWords db=^data/paypalwords.db] [TIMESTAMP][/ConvertWords][/URL][!] [/!]&ItemNumber=[URL][PAYMENTTYPE][/URL][!] [/!][/SetHeader] [/Then] [Else] [!] -------------- FAILED -------------- [/!] [!]EXAMPLE: RESULT=26&RESPMSG=Invalid vendor account[/!] [Replace db=^data/pendingorders.db&eqOrderNodatarq=[ThisOrder]][!] [/!]payment_confirmed=F[!] [/!]&payment_notes=[URL][DATE]: [ThisTime]: [Result]:[RESPMSG]:[PNREF] [/URL][!] [/!]&payment_date=[ThisDate][!] [/!]&payment_time=[ThisTime][!] [/!][/Replace] [SetHeader file=pendingcarts/[thisOrder]][!] [/!]Header36=[URL][Result]:[RESPMSG][/URL][!] [/!][/SetHeader] [/Else] [/If] =================================================================== Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 20/08/2009, at 12:49 AM, Brian Harrington, Broker wrote: > i finally got it ;)) > > it was requiring the address but most everything I looked @ only had/ > required "shiptoaddress" and i even had a hard time finding > the address field names... this works! > > however... i still need a way to post the sale/response to a > database so any help would be great! > Brian > > [TEXT]content=[!] > [/!]METHOD=[URL]DoDirectPayment[/URL][!] > [/!]&USER=[URL]XXXXXX[/URL][!] > [/!]&PWD=[URL] XXXXXX[/URL][!] > [/!]&VERSION=[URL]3.2[/URL][!] > [/!]&SIGNATURE=[URL] XXXXXX[/URL][!] > [/!]&CREDITCARDTYPE=[URL]MasterCard[/URL][!] > [/!]&ACCT=[URL] XXXXXX[/URL][!] > [/!]&EXPDATE=[URL]022010[/URL][!] > [/!]&CVV2=[URL]305[/URL][!] > [/!]&AMT=[URL].75[/URL][!] > [/!]&TRANSACTIONID=[URL]1005[/URL][!] > [/!]&FIRSTNAME=[URL] XXXXXX[/URL][!] > [/!]&LASTNAME=[URL] XXXXXX[/URL][!] > [/!]&STREET=[URL] XXXXXX[/URL][!] > [/!]&CITY=[URL]BUFFALO[/URL][!] > [/!]&STATE=[URL]NY[/URL][!] > [/!]&ZIP=[URL]14222[/URL][!] > [/!]&COUNTRYCODE=[URL]US[/URL][!] > [/!]&PAYMENTACTION=[URL]Sale[/URL][!] > [/!]&IPADDRESS=[URL]072.045.150.022[/URL][!] > [/!]&RETURNURL=[URL]https://etrader.tv/paypaltestreply.tpl[/URL][!] > [/!][/TEXT] > > > > [tcpconnect host=api-3t.paypal.com&port=443&ssl=T][!] > [/!][tcpsend skipheader=T]POST /nvp HTTP/1.0[UnURL]%0D%0A[/UnURL][!] > [/!]USER-AGENT: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) > [UnURL]%0D%0A[/UnURL][!] > [/!]Content-type: text/namevalue[UnURL]%0D%0A[/UnURL][!] > [/!]Content-Length: [CountChars][content][/CountChars][UnURL]%0D%0A[/ > UnURL][!] > [/!]Content-type: text/namevalue[UnURL]%0D%0A[/UnURL][!] > [/!][UnURL]%0D%0A[/UnURL][!] > [/!][content][UnURL]%0D%0A[/UnURL][!] > [/!][/TCPSend][!] > [/!][/tcpconnect] > > > > On Aug 18, 2009, at 8:27 PM, Stuart Tremain wrote: > >> Brian >> >> The solution you downloaded was for PayPal Express Checkout. >> >> Paypal Website Pro/ Payflow Pro is a different animal. >> >> I will put a set of files together to do the job. It is FAR simpler >> than the Express Checkout but you need to have a SSL to do the data >> collection etc. >> >> Regards >> >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >> >> On 19/08/2009, at 6:29 AM, Brian Harrington, Broker wrote: >> >>> Does anyone else here maybe have a complete simple solution... >>> i did download Stuarts folder a week or so ago and tried to >>> reverse code it but it seem >>> to me missing some info and was over complicated w/ databases & >>> includes >>> for what seems to be simple task or connection... I also thinks >>> it's funny that paypal calls >>> theses http connections API's.... >>> >>> >>> >>> On Aug 18, 2009, at 9:05 AM, Brian Harrington, Broker wrote: >>> >>>> Hi Stuart.... >>>> >>>> here's a screenshot... they seem to be the same thing. >>>> do you have a single page that collects the reply into a useable >>>> webdna format...? >>>> >>>>
>>>> On Aug 17, 2009, at 10:06 PM, Stuart Tremain wrote: >>>> >>>>> That code will work with that product. More than likely why you >>>>> are having problems as what you have been using is more for >>>>> PayPal Express Payments. >>>>> >>>>> Regards >>>>> >>>>> Stuart Tremain >>>>> IDFK Web Developments >>>>> AUSTRALIA >>>>> webdna@idfk.com.au >>>>> >>>>> On 18/08/2009, at 11:34 AM, bharrington@1choicerealty.com wrote: >>>>> >>>>>> Website Payments Pro... >>>>>> >>>>>> >>>>>>> Am I correct that you are doing PayFlow Pro or similar ? >>>>>>> >>>>>>> Regards >>>>>>> >>>>>>> Stuart Tremain >>>>>>> IDFK Web Developments >>>>>>> AUSTRALIA >>>>>>> webdna@idfk.com.au >>>>>>> >>>>>>> On 18/08/2009, at 8:22 AM, Brian Harrington, Broker wrote: >>>>>>> >>>>>>>> sandbox seemed to be a pain so I was going live... >>>>>>>> i checked my cc (debit) mastercard number several times...? >>>>>>>> >>>>>>>> also... i put this on the page as looking into a database >>>>>>>> seemed >>>>>>>> like to much work... >>>>>>>> >>>>>>>> [table name=PayPalWords&fields=FROM,TO] >>>>>>>> %2e . >>>>>>>> %2d - >>>>>>>> & >>>>>>>> %2F / >>>>>>>> %2b + >>>>>>>> %3a : >>>>>>>> [/Table] >>>>>>>> >>>>>>>> [ConvertWords table=paypalwords][L_LONGMESSAGE0][/ConvertWords] >>>>>>>> >>>>>>>> put I don't ever get anything back other than the string... >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Aug 17, 2009, at 6:05 PM, Stuart Tremain wrote: >>>>>>>> >>>>>>>>> Brian >>>>>>>>> >>>>>>>>> PP is saying that the CC number is invalid >>>>>>>>> >>>>>>>>> >>>>>>>>> Sorry, your PayPal payment has failed because:
>>>>>>>>> [ConvertWords db=^paypal/paypalwords.db][L_LONGMESSAGE0][/ >>>>>>>>> ConvertWords] >>>>>>>>> >>>>>>>>> PayPalWords.db >>>>>>>>> FROM TO >>>>>>>>> %2e . >>>>>>>>> %2d - >>>>>>>>> & >>>>>>>>> %2F / >>>>>>>>> %2b + >>>>>>>>> %3a : >>>>>>>>> >>>>>>>>> >>>>>>>>> Are you using the PayPal developers sandbox ? >>>>>>>>> >>>>>>>>> Do you have the PayPal documentation for NVP ? >>>>>>>>> http://dev.idfk.com.au/paypal_for_webdna/Name_Pair_API_DeveloperGuide.pdf >>>>>>>>> >>>>>>>>> >>>>>>>>> Regards >>>>>>>>> >>>>>>>>> Stuart Tremain >>>>>>>>> IDFK Web Developments >>>>>>>>> AUSTRALIA >>>>>>>>> webdna@idfk.com.au >>>>>>>>> >>>>>>>>> On 18/08/2009, at 7:25 AM, Brian Harrington, Broker wrote: >>>>>>>>> >>>>>>>>>> I've been playing w/this script for a few hours now but keep >>>>>>>>>> getting.... >>>>>>>>>> >>>>>>>>>> TIMESTAMP=2009%2d08%2d17T21%3a18%3a31Z&CORRELATIONID=211aa248fda4&ACK=Failure&VERSION=3%2e2&BUILD=997644&L_ERRORCODE0=10527&L_SHORTMESSAGE0=Invalid%20Data&L_LONGMESSAGE0=This%20transaction%20cannot%20be%20processed%2e%20Please%20enter%20a%20valid%20credit%20card%20number%20and%20type%2e&L_SEVERITYCODE0=Error&AMT=0%2e75&CURRENCYCODE=USD >>>>>>>>>> >>>>>>>>>> I also don't know how to collect the reply... any help >>>>>>>>>> would be >>>>>>>>>> great! thanks. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> [TEXT]content=[!] >>>>>>>>>> [/!]METHOD=[URL]DoDirectPayment[/URL][!] >>>>>>>>>> [/!]&USER=[URL]mypaypaluser[/URL][!] >>>>>>>>>> [/!]&PWD=[URL]mypaypalpassword[/URL][!] >>>>>>>>>> [/!]&VERSION=[URL]3.2[/URL][!] >>>>>>>>>> [/!]&SIGNATURE=[URL]mypaypalsignature[/URL][!] >>>>>>>>>> [/!]&CREDITCARDTYPE=[URL]MasterCard[/URL][!] >>>>>>>>>> [/!]&ACCT=[URL]5555555555555555[/URL][!] >>>>>>>>>> [/!]&EXPDATE=[URL]042012[/URL][!] >>>>>>>>>> [/!]&CVV2=[URL]999[/URL][!] >>>>>>>>>> [/!]&AMT=[URL].75[/URL][!] >>>>>>>>>> [/!]&FIRSTNAME=[URL]Brian[/URL][!] >>>>>>>>>> [/!]&LASTNAME=[URL]Harrington[/URL][!] >>>>>>>>>> [/!]&PAYMENTACTION=[URL]Sale[/URL][!] >>>>>>>>>> [/!]&IPADDRESS=[URL]072.045.150.022[/URL][!] >>>>>>>>>> [/!][/TEXT] >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> [tcpconnect host=api-3t.paypal.com&port=443&ssl=T][!] >>>>>>>>>> [/!][tcpsend skipheader=T]POST /nvp HTTP/1.0[UnURL]%0D%0A[/ >>>>>>>>>> UnURL][!] >>>>>>>>>> [/!]USER-AGENT: Mozilla/4.0 (compatible; MSIE 5.01; Windows >>>>>>>>>> NT 5.0) >>>>>>>>>> [UnURL]%0D%0A[/UnURL][!] >>>>>>>>>> [/!]Content-type: text/namevalue[UnURL]%0D%0A[/UnURL][!] >>>>>>>>>> [/!]Content-Length: [CountChars][content][/CountChars] >>>>>>>>>> [UnURL]%0D >>>>>>>>>> %0A[/UnURL][!] >>>>>>>>>> [/!]Content-type: text/namevalue[UnURL]%0D%0A[/UnURL][!] >>>>>>>>>> [/!][UnURL]%0D%0A[/UnURL][!] >>>>>>>>>> [/!][content][UnURL]%0D%0A[/UnURL][!] >>>>>>>>>> [/!][/TCPSend][!] >>>>>>>>>> [/!][/tcpconnect] >>>>>>>>> >>>>>>>>> --------------------------------------------------------- >>>>>>>>> This message is sent to you because you are subscribed to >>>>>>>>> the mailing list . >>>>>>>>> To unsubscribe, E-mail to: >>>>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>>>>> Bug Reporting: >>>>>>>>> http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>>>>>> >>>>>>>> >>>>>>>> --------------------------------------------------------- >>>>>>>> This message is sent to you because you are subscribed to >>>>>>>> the mailing list . >>>>>>>> To unsubscribe, E-mail to: >>>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>>>> Bug Reporting: >>>>>>>> http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>>>> >>>>>>> --------------------------------------------------------- >>>>>>> This message is sent to you because you are subscribed to >>>>>>> the mailing list . >>>>>>> To unsubscribe, E-mail to: >>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>>> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> --------------------------------------------------------- >>>>>> This message is sent to you because you are subscribed to >>>>>> the mailing list . >>>>>> To unsubscribe, E-mail to: >>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>> >>>>> --------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>> >>>> >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> old archives: http://dev.webdna.us/TalkListArchive/ >>> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >> > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288
Associated Messages, from the most recent to the oldest:
This is my code for sending details of CC etc to PayFlow, getting response and then putting the response into a cart and a db. ThisOrder is the cart number =================================================================== [text]content=[!] [/!]TRXTYPE=S[!] S=sale, A=Authorization, D=Collect Payment [/!]&ACCT=[url][_CREDITCARDNUMBER][/URL][!] [/!]&CVV2=[url][CCV2][/URL][!] [/!]&EXPDATE=[url][_CCEXPIRY][/URL][!] [/!]&TENDER=C[!] [/!]&INVNUM=[ThisOrder][!] [/!]&AMT=[url][_INVOICE-TOTAL][/URL][!] [/!]&STREET=[url][_payment_address][/URL][!] [/!]&ZIP=[url][_payment_postcode][/URL][!] [/!]&USER=[url]PAYFLOWUSER[/URL[!] [/!]&PWD=[url]PAYFLOWPASS[/URL][!] [/!]&VENDOR=[url]PAYFLOWVENDOR[/URL][!] [/!]&PARTNER=[url]PAYFLOWPARTNER[/URL][!] [/!][/TEXT] [text multi=T]payflow_result=[tcpconnect host=PAYFLOWURL&port=443&ssl=T][!] [/!][tcpsend skipheader=T]POST /transaction HTTP/1.0[unurl]%0D%0A[/ UnURL][!] [/!]USER-AGENT: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) [unurl]%0D%0A[/UnURL][!] [/!]Content-type: text/namevalue[unurl]%0D%0A[/UnURL][!] [/!]Content-Length: [countchars][content][/CountChars][unurl]%0D%0A[/ UnURL][!] [/!]X-VPS-REQUEST-ID: [ThisOrder][random][unurl]%0D%0A[/UnURL][!] [/!]X-VPS-CLIENT-TIMEOUT: 45[unurl]%0D%0A[/UnURL][!] [/!]X-VPS-CLIENT-CERTIFICATION-ID: [url]PAYFLOWCERTIFICATION-ID[/URL] [unurl]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-INTEGRATION-PRODUCT: WebDNA[unurl]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-INTEGRATION-VERSION: 6.1[unurl]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-OS-NAME: Windows 2003[unurl]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-OS-VERSION: [unurl]%0D%0A[/UnURL][!] [/!]X-VPS-VIT-RUNTIME-VERSION: [unurl]%0D%0A[/UnURL][!] [/!]Content-type: text/namevalue[unurl]%0D%0A[/UnURL][!] [/!][unurl]%0D%0A[/UnURL][!] [/!][content][unurl]%0D%0A[/UnURL][!] [/!][/TCPSend][!] [/!][/tcpconnect][/text] [!] -------------- This creates multi text variables -------------- [/!] [TEXT multi=T]PayFlow_result02=0&[PayFlow_Result][/TEXT] [If ("[RESULT]"="0")] [Then] [!] -------------- SUCCESS -------------- [/!] [Replace db=^data/pendingorders.db&eqOrderNodatarq=[ThisOrder]][!] [/!]payment_confirmed=T[!] [/!]&payment_notes=[url][!] [/!][ACK]:[!] [/!][ConvertWords db=^data/paypalwords.db][TRANSACTIONID][/ ConvertWords]:[!] [/!][ConvertWords db=^data/paypalwords.db][AUTHORIZATIONID][/ ConvertWords]:[!] [/!][PAYMENTTYPE][!] [/!][/URL][!] [/!]&payment_date=[ThisDate][!] [/!]&payment_time=[ThisTime][!] [/!][/Replace] [SetHeader file=pendingcarts/[thisOrder]][!] [/!]&Header36=[url][!] [/!][ACK]:[!] [/!][ConvertWords db=^data/paypalwords.db][TRANSACTIONID][/ ConvertWords]:[!] [/!][ConvertWords db=^data/paypalwords.db][AUTHORIZATIONID][/ ConvertWords]:[!] [/!][PAYMENTTYPE][!] [/!][/URL][!] [/!]&AuthNumber=[url][ConvertWords db=^data/paypalwords.db] [AUTHORIZATIONID][/ConvertWords][/URL][!] [/!]&RepsoneText=[url][ACK][/URL][!] [/!]&Status=[url][PAYMENTSTATUS][/URL][!] [/!]&BatchNumber=[url][ConvertWords db=^data/paypalwords.db][AMT][/ ConvertWords][/URL][!] [/!]&ReferenceNumber=[url][ConvertWords db=^data/paypalwords.db] [TRANSACTIONID][/ConvertWords][/URL][!] [/!]&SequenceNumber=[url][ConvertWords db=^data/paypalwords.db] [TIMESTAMP][/ConvertWords][/URL][!] [/!]&ItemNumber=[url][PAYMENTTYPE][/URL][!] [/!][/SetHeader] [/Then] [Else] [!] -------------- FAILED -------------- [/!] [!]EXAMPLE: RESULT=26&RESPMSG=Invalid vendor account[/!] [Replace db=^data/pendingorders.db&eqOrderNodatarq=[ThisOrder]][!] [/!]payment_confirmed=F[!] [/!]&payment_notes=[url][date]: [ThisTime]: [Result]:[RESPMSG]:[PNREF] [/URL][!] [/!]&payment_date=[ThisDate][!] [/!]&payment_time=[ThisTime][!] [/!][/Replace] [SetHeader file=pendingcarts/[thisOrder]][!] [/!]Header36=[url][Result]:[RESPMSG][/URL][!] [/!][/SetHeader] [/Else] [/If] =================================================================== Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 20/08/2009, at 12:49 AM, Brian Harrington, Broker wrote: > i finally got it ;)) > > it was requiring the address but most everything I looked @ only had/ > required "shiptoaddress" and i even had a hard time finding > the address field names... this works! > > however... i still need a way to post the sale/response to a > database so any help would be great! > Brian > > [text]content=[!] > [/!]METHOD=[url]DoDirectPayment[/URL][!] > [/!]&USER=[url]XXXXXX[/URL][!] > [/!]&PWD=[url] XXXXXX[/URL][!] > [/!]&VERSION=[url]3.2[/URL][!] > [/!]&SIGNATURE=[url] XXXXXX[/URL][!] > [/!]&CREDITCARDTYPE=[url]MasterCard[/URL][!] > [/!]&ACCT=[url] XXXXXX[/URL][!] > [/!]&EXPDATE=[url]022010[/URL][!] > [/!]&CVV2=[url]305[/URL][!] > [/!]&AMT=[url].75[/URL][!] > [/!]&TRANSACTIONID=[url]1005[/URL][!] > [/!]&FIRSTNAME=[url] XXXXXX[/URL][!] > [/!]&LASTNAME=[url] XXXXXX[/URL][!] > [/!]&STREET=[url] XXXXXX[/URL][!] > [/!]&CITY=[url]BUFFALO[/URL][!] > [/!]&STATE=[url]NY[/URL][!] > [/!]&ZIP=[url]14222[/URL][!] > [/!]&COUNTRYCODE=[url]US[/URL][!] > [/!]&PAYMENTACTION=[url]Sale[/URL][!] > [/!]&IPADDRESS=[url]072.045.150.022[/URL][!] > [/!]&RETURNURL=[url]https://etrader.tv/paypaltestreply.tpl[/URL][!] > [/!][/TEXT] > > > > [tcpconnect host=api-3t.paypal.com&port=443&ssl=T][!] > [/!][tcpsend skipheader=T]POST /nvp HTTP/1.0[unurl]%0D%0A[/UnURL][!] > [/!]USER-AGENT: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) > [unurl]%0D%0A[/UnURL][!] > [/!]Content-type: text/namevalue[unurl]%0D%0A[/UnURL][!] > [/!]Content-Length: [countchars][content][/CountChars][unurl]%0D%0A[/ > UnURL][!] > [/!]Content-type: text/namevalue[unurl]%0D%0A[/UnURL][!] > [/!][unurl]%0D%0A[/UnURL][!] > [/!][content][unurl]%0D%0A[/UnURL][!] > [/!][/TCPSend][!] > [/!][/tcpconnect] > > > > On Aug 18, 2009, at 8:27 PM, Stuart Tremain wrote: > >> Brian >> >> The solution you downloaded was for PayPal Express Checkout. >> >> Paypal Website Pro/ Payflow Pro is a different animal. >> >> I will put a set of files together to do the job. It is FAR simpler >> than the Express Checkout but you need to have a SSL to do the data >> collection etc. >> >> Regards >> >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >> >> On 19/08/2009, at 6:29 AM, Brian Harrington, Broker wrote: >> >>> Does anyone else here maybe have a complete simple solution... >>> i did download Stuarts folder a week or so ago and tried to >>> reverse code it but it seem >>> to me missing some info and was over complicated w/ databases & >>> includes >>> for what seems to be simple task or connection... I also thinks >>> it's funny that paypal calls >>> theses http connections API's.... >>> >>> >>> >>> On Aug 18, 2009, at 9:05 AM, Brian Harrington, Broker wrote: >>> >>>> Hi Stuart.... >>>> >>>> here's a screenshot... they seem to be the same thing. >>>> do you have a single page that collects the reply into a useable >>>> webdna format...? >>>> >>>> >>>> On Aug 17, 2009, at 10:06 PM, Stuart Tremain wrote: >>>> >>>>> That code will work with that product. More than likely why you >>>>> are having problems as what you have been using is more for >>>>> PayPal Express Payments. >>>>> >>>>> Regards >>>>> >>>>> Stuart Tremain >>>>> IDFK Web Developments >>>>> AUSTRALIA >>>>> webdna@idfk.com.au >>>>> >>>>> On 18/08/2009, at 11:34 AM, bharrington@1choicerealty.com wrote: >>>>> >>>>>> Website Payments Pro... >>>>>> >>>>>> >>>>>>> Am I correct that you are doing PayFlow Pro or similar ? >>>>>>> >>>>>>> Regards >>>>>>> >>>>>>> Stuart Tremain >>>>>>> IDFK Web Developments >>>>>>> AUSTRALIA >>>>>>> webdna@idfk.com.au >>>>>>> >>>>>>> On 18/08/2009, at 8:22 AM, Brian Harrington, Broker wrote: >>>>>>> >>>>>>>> sandbox seemed to be a pain so I was going live... >>>>>>>> i checked my cc (debit) mastercard number several times...? >>>>>>>> >>>>>>>> also... i put this on the page as looking into a database >>>>>>>> seemed >>>>>>>> like to much work... >>>>>>>> >>>>>>>> [table name=PayPalWords&fields=FROM,TO] >>>>>>>> %2e . >>>>>>>> %2d - >>>>>>>> & >>>>>>>> %2F / >>>>>>>> %2b + >>>>>>>> %3a : >>>>>>>> [/Table] >>>>>>>> >>>>>>>> [ConvertWords table=paypalwords][L_LONGMESSAGE0][/ConvertWords] >>>>>>>> >>>>>>>> put I don't ever get anything back other than the string... >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Aug 17, 2009, at 6:05 PM, Stuart Tremain wrote: >>>>>>>> >>>>>>>>> Brian >>>>>>>>> >>>>>>>>> PP is saying that the CC number is invalid >>>>>>>>> >>>>>>>>> >>>>>>>>> Sorry, your PayPal payment has failed because:
>>>>>>>>> [ConvertWords db=^paypal/paypalwords.db][L_LONGMESSAGE0][/ >>>>>>>>> ConvertWords] >>>>>>>>> >>>>>>>>> PayPalWords.db >>>>>>>>> FROM TO >>>>>>>>> %2e . >>>>>>>>> %2d - >>>>>>>>> & >>>>>>>>> %2F / >>>>>>>>> %2b + >>>>>>>>> %3a : >>>>>>>>> >>>>>>>>> >>>>>>>>> Are you using the PayPal developers sandbox ? >>>>>>>>> >>>>>>>>> Do you have the PayPal documentation for NVP ? >>>>>>>>> http://dev.idfk.com.au/paypal_for_webdna/Name_Pair_API_DeveloperGuide.pdf >>>>>>>>> >>>>>>>>> >>>>>>>>> Regards >>>>>>>>> >>>>>>>>> Stuart Tremain >>>>>>>>> IDFK Web Developments >>>>>>>>> AUSTRALIA >>>>>>>>> webdna@idfk.com.au >>>>>>>>> >>>>>>>>> On 18/08/2009, at 7:25 AM, Brian Harrington, Broker wrote: >>>>>>>>> >>>>>>>>>> I've been playing w/this script for a few hours now but keep >>>>>>>>>> getting.... >>>>>>>>>> >>>>>>>>>> TIMESTAMP=2009%2d08%2d17T21%3a18%3a31Z&CORRELATIONID=211aa248fda4&ACK=Failure&VERSION=3%2e2&BUILD=997644&L_ERRORCODE0=10527&L_SHORTMESSAGE0=Invalid%20Data&L_LONGMESSAGE0=This%20transaction%20cannot%20be%20processed%2e%20Please%20enter%20a%20valid%20credit%20card%20number%20and%20type%2e&L_SEVERITYCODE0=Error&AMT=0%2e75&CURRENCYCODE=USD >>>>>>>>>> >>>>>>>>>> I also don't know how to collect the reply... any help >>>>>>>>>> would be >>>>>>>>>> great! thanks. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> [text]content=[!] >>>>>>>>>> [/!]METHOD=[url]DoDirectPayment[/URL][!] >>>>>>>>>> [/!]&USER=[url]mypaypaluser[/URL][!] >>>>>>>>>> [/!]&PWD=[url]mypaypalpassword[/URL][!] >>>>>>>>>> [/!]&VERSION=[url]3.2[/URL][!] >>>>>>>>>> [/!]&SIGNATURE=[url]mypaypalsignature[/URL][!] >>>>>>>>>> [/!]&CREDITCARDTYPE=[url]MasterCard[/URL][!] >>>>>>>>>> [/!]&ACCT=[url]5555555555555555[/URL][!] >>>>>>>>>> [/!]&EXPDATE=[url]042012[/URL][!] >>>>>>>>>> [/!]&CVV2=[url]999[/URL][!] >>>>>>>>>> [/!]&AMT=[url].75[/URL][!] >>>>>>>>>> [/!]&FIRSTNAME=[url]Brian[/URL][!] >>>>>>>>>> [/!]&LASTNAME=[url]Harrington[/URL][!] >>>>>>>>>> [/!]&PAYMENTACTION=[url]Sale[/URL][!] >>>>>>>>>> [/!]&IPADDRESS=[url]072.045.150.022[/URL][!] >>>>>>>>>> [/!][/TEXT] >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> [tcpconnect host=api-3t.paypal.com&port=443&ssl=T][!] >>>>>>>>>> [/!][tcpsend skipheader=T]POST /nvp HTTP/1.0[unurl]%0D%0A[/ >>>>>>>>>> UnURL][!] >>>>>>>>>> [/!]USER-AGENT: Mozilla/4.0 (compatible; MSIE 5.01; Windows >>>>>>>>>> NT 5.0) >>>>>>>>>> [unurl]%0D%0A[/UnURL][!] >>>>>>>>>> [/!]Content-type: text/namevalue[unurl]%0D%0A[/UnURL][!] >>>>>>>>>> [/!]Content-Length: [countchars][content][/CountChars] >>>>>>>>>> [unurl]%0D >>>>>>>>>> %0A[/UnURL][!] >>>>>>>>>> [/!]Content-type: text/namevalue[unurl]%0D%0A[/UnURL][!] >>>>>>>>>> [/!][unurl]%0D%0A[/UnURL][!] >>>>>>>>>> [/!][content][unurl]%0D%0A[/UnURL][!] >>>>>>>>>> [/!][/TCPSend][!] >>>>>>>>>> [/!][/tcpconnect] >>>>>>>>> >>>>>>>>> --------------------------------------------------------- >>>>>>>>> This message is sent to you because you are subscribed to >>>>>>>>> the mailing list . >>>>>>>>> To unsubscribe, E-mail to: >>>>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>>>>> Bug Reporting: >>>>>>>>> http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>>>>>> >>>>>>>> >>>>>>>> --------------------------------------------------------- >>>>>>>> This message is sent to you because you are subscribed to >>>>>>>> the mailing list . >>>>>>>> To unsubscribe, E-mail to: >>>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>>>> Bug Reporting: >>>>>>>> http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>>>> >>>>>>> --------------------------------------------------------- >>>>>>> This message is sent to you because you are subscribed to >>>>>>> the mailing list . >>>>>>> To unsubscribe, E-mail to: >>>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>>> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> --------------------------------------------------------- >>>>>> This message is sent to you because you are subscribed to >>>>>> the mailing list . >>>>>> To unsubscribe, E-mail to: >>>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>>> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>> >>>>> --------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>>> archives: http://mail.webdna.us/list/talk@webdna.us >>>>> old archives: http://dev.webdna.us/TalkListArchive/ >>>>> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >>>>> >>>> >>> >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> old archives: http://dev.webdna.us/TalkListArchive/ >>> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ >> Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 >> > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288
Stuart Tremain
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Formulas.db + Users.db (1997)
Re:quit command on NT (1997)
Where is Orders.db appended? (2000)
Site Search Suggestions (2004)
Problem passing variables - IE vs Netscape (2000)
M$loth messes with our sites (again) 2004/02/03 (2004)
Signal Raised (1997)
Emailer or [sendmail] questions ... (1998)
Date/Time format problems (1997)
Summing fields (1997)
DB Line endings (2002)
Search (1997)
Setting up shop (1997)
class path Pay Flo Pro (2002)
[WebDNA] Auction (2009)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
How to verify email address (1997)
Deleting Orders (1997)
spell check site (2005)
RE: [WebDNA] two ideas for running a cluster of WebDNA servers (2019)