[freeside-users] Real time processing events return status "Failed: Missing payinfo".
Ernie Dunbar
ernied at lightspeed.ca
Tue Mar 27 09:43:48 PDT 2018
No real update on this. It's nice to know that I'm not the only one however.
I've got a workaround that takes the output from the freeside-daily
script, and generates a list of links you can open in a browser and
repeatedly click "process payment" and "Ctrl-Tab" until your thumbs get
sore. It certainly reduces the amount of time that manual credit card
payments take (what used to take several days of really aggravating
tedium now takes about an hour of less aggravating tedium), but it's
definitely not the automation we expect in this day and age.
Attached is the script to generate the links. You need to modify it to
use the base URL for your system. There's plugins for most browsers to
open a huge list of links in new tabs like this.
(well, it used to be an attachment, but it was "waiting for moderator
approval" for being an attachment. Moderator approval never came.)
#!/bin/bash
# Change $baseurl to your site's Freeside URL. "mydomain.com" almost
certainly doesn't have a Freeside implementation.
baseurl='https://mydomain.com/freeside/'
month=`date +%b%d%Y`
today=`date +%b\ %e`
today="$today.*:"
if ! ls -l |grep -q "$today.*customerInvoices"
then
echo "ERROR:"
echo "You need a file named customerInvoices that contains the
output from the freeside_daily cron job"
echo "and it needs to have todays timestamp, or this just is not
going to work."
exit 1
fi
for i in `grep cust_bill_realtime_card customerInvoices |awk '{print
$7}' |sort |uniq`
do
custnum=`psql -c "SELECT custnum FROM cust_bill WHERE invnum=$i"
|egrep '^\s' |grep -v custnum |tr -d '[:blank:]'`
echo "$baseurl/misc/payment.cgi?payby=CARD;custnum=$custnum" >>
links$month.txt
done
On 2018-03-17 04:03 PM, Isaac Uban wrote:
> Any update on this??
> I'm having the same issue.
>
> *From:* John Wilson <mailto:johnwilson1969 at gmail.com>
> *Sent:* Thursday, February 08, 2018 6:09 PM
> *To:* Freeside users mailing list <mailto:freeside-users at freeside.biz>
> *Subject:* [SPAM] Re: [freeside-users] Real time processing events
> return status "Failed: Missing payinfo".
>
> Not sure... According the the docs, payinfo is:
>
> ---snip---
>
> /payinfo/
> /Payment information (payinfo) can be one of the following types:/
>
> /Card Number, P.O., comp issuer (4-8 lowercase alphanumerics;
> think username) prepayment identifier (see FS::prepay_credit
> <http://www.freeside.biz/mediawiki/index.php/Freeside:3:Documentation:Developer/FS/prepay_credit>),
> PayPal transaction ID/
>
> ---snip---
>
> Maybe someone knows a little more about how that information is
> handled differently when running a billing event verses real time????
>
>
>
>
> On Thu, Feb 8, 2018 at 3:34 PM Ernie Dunbar <ernied at lightspeed.ca
> <mailto:ernied at lightspeed.ca>> wrote:
>
> Hi John.
>
> The settings in the Real Time Processing event look like this:
>
>
>
> On 2018-02-08 11:06 AM, John Wilson wrote:
>> What are the settings in the "Real Time Processing" event?
>>
>> On Thu, Feb 8, 2018 at 1:50 PM Ernie Dunbar <ernied at lightspeed.ca
>> <mailto:ernied at lightspeed.ca>> wrote:
>>
>> Hi everyone.
>>
>> Our Freeside install has not been sending out our automatic
>> nightly payments to our payment processor through the
>> "freeside-daily" script. Our payment processor receives no
>> data about these attempted transactions, and Freeside's
>> billing events page for these customers displays the following:
>>
>> Event
>> <https://freeside.lightspeed.ca/freeside/search/cust_event.html?invnum=13423;_type=html;order_by=event>
>> Date Status Trigger Cust# Cust. Status Name Company
>> Address 1 Address 2 City State Zip Country Day phone
>> Night phone Mobile phone Fax number Invoicing email(s)
>> Real Time Processing Jan 15 2018 00:00:02 failed: Missing
>> payinfo Invoice #13423
>> <https://freeside.lightspeed.ca/freeside/view/cust_bill.cgi?13423>
>> 30003
>> <https://freeside.lightspeed.ca/freeside/view/cust_main.cgi?30003>
>> *Active*
>>
>> (Customer data redacted for privacy)
>>
>> When I google the error "failed: Missing payinfo" all I get
>> is a link to the code in Github that contains the error,
>> found at
>> https://github.com/freeside/Freeside/blob/master/FS/FS/cust_main/Billing_Realtime.pm
>>
>>
>> We're still able to manually process these payments, which is
>> strange. You'd think that if we'd some kind of error in the
>> way we've set up Freeside, or the way the customer is set up
>> in Freeside, then that would fail too. But we know that the
>> payment processor is working properly, they're just not
>> getting any payment requests from us until we do it manually.
>> Naturally, it's not feasible to spend several days going
>> through each account and clicking "Process credit card
>> payment" for over 3,000 customers.
>>
>> --
>> ---
>> Lightspeed Communications and Dolphin Global Tel
>> VoIP, Web Hosting, Server Colocation, ADSL and Cable Internet
>> Systems and Operations department.
>> http://www.lightspeed.ca http://www.dolphintel.com
>> Tech Support:604-482-1192 ext. 2 <tel:%28604%29%20482-1192>
>>
>> _______________________________________________
>> freeside-users mailing list
>> freeside-users at freeside.biz <mailto:freeside-users at freeside.biz>
>> http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>>
>>
>>
>> _______________________________________________
>> freeside-users mailing list
>> freeside-users at freeside.biz <mailto:freeside-users at freeside.biz>
>> http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
> --
> ---
> Lightspeed Communications and Dolphin Global Tel
> VoIP, Web Hosting, Server Colocation, ADSL and Cable Internet
> Systems and Operations department.
> http://www.lightspeed.ca http://www.dolphintel.com
> Tech Support:604-482-1192 ext. 2 <tel:%28604%29%20482-1192>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz <mailto:freeside-users at freeside.biz>
> http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
> ------------------------------------------------------------------------
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://mail.freeside.biz/cgi-bin/mailman/listinfo/freeside-users
--
---
Lightspeed Communications and Dolphin Global Tel
VoIP, Web Hosting, Server Colocation, ADSL and Cable Internet
Systems and Operations department.
http://www.lightspeed.ca http://www.dolphintel.com
Tech Support: 604-482-1192 ext. 2
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.freeside.biz/pipermail/freeside-users/attachments/20180327/795e7574/attachment-0001.html>
More information about the freeside-users
mailing list