[freeside-users] Batch Import Format

[Ryan Spott]

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
>