[freeside-users] Batch Import Format
ccrum
ccrum at dot11net.com
Wed Dec 30 12:24:05 PST 2009
OK, so it works with a test number (guess I have to have all the
CVV's?), except it does not like my pkgpart. Is this supposed to be a
number or a string? It doesn't like a number there in my file. Getting:
Error: can't insert customer for blah, blah, blah: inserting svc_
(transaction rolled back): Unknown svcpart
I've tried a string, but it just locks up. I'm assuming that it is
looking for one of the Package Definitions I have defined. Is that correct?
Cameron
Ryan Spott wrote:
> Try the following for test numbers:
>
> CARD TYPE NUMBER
> Master Card (16 Digits) 5105105105105100
> Master Card (16 Digits) 5555555555554444
> Visa (13 Digits) 4222222222222
> Visa (16 Digits) 4111111111111111
> Visa (16 Digits) 4012888888881881
> American Express (15 Digits) 378282246310005
> American Express (15 Digits) 371449635398431
> Amex Corporate (15 Digits) 378734493671000
> Dinners Club (14 Digits) 38520000023237
> Dinners Club (14 Digits) 30569309025904
> Discover (16 Digits) 6011111111111117
> Discover (16 Digits) 6011000990139424
> JCB (16 Digits) 3530111333300000
> JCB (16 Digits) 3566002020360505
>
>
> On Wed, Dec 30, 2009 at 11:56 AM, ccrum <ccrum at dot11net.com> wrote:
>
>> Ok, looking at this too long has caused a brain fog. I had not selected an
>> agent. Soooo....now I'm having a different problem. From the line below, I'm
>> getting invalid credit card number. Obviously, my real data has the whole 16
>> digit number and not the *'s. I've tried different formats on the exp date,
>> put in a bogus cvv, all with no success. Any ideas?
>>
>> Cameron
>>
>> ccrum wrote:
>>
>>> I'm trying to run a batch import of customers. I've checked and double
>>> checked my data and made sure that I have all the fields in the proper
>>> places, right number of fields, etc. However, I'm still getting an error.
>>> The problem is the missing field "agentnum". It does not appear in the
>>> format spec, yet when I try to import, I'm getting the error:
>>>
>>> Error: can't insert customer for blah, blah,blah: Illegal or empty
>>> (numeric) agentnum:
>>>
>>> Can anyone tell me where this field needs to be in the Extended plus
>>> company format?
>>>
>>> Here is a line from my input file:
>>> 2411907471,2,Doe,Jane,,6480 Oak Hollow
>>> Drive,,Burleson,TX,76028,US,8175551212,,Doe,Jane,,6480 Oak
>>> Hollow,,Burleson,TX,76028,US,4755********1870,,01/2011,dake0 at dot11net.net,1,username,password
>>>
>>> I using:
>>> Freeside 1.9.1
>>> Debian 4.1.2-25
>>> Postgre database
>>> perl v5.10.0
>>>
>>> _______________________________________________
>>> freeside-users mailing list
>>> freeside-users at freeside.biz
>>> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>>>
>>>
>>>
>> _______________________________________________
>> freeside-users mailing list
>> freeside-users at freeside.biz
>> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>>
>>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>
>
>
More information about the freeside-users
mailing list