[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