Search Again: export to cardservice From: Dave Tanguay Date: Thursday, January 7, 1999 Time: 9:53:14 pm Hi Shawn, I have a merchant account with CardService http://cardservice.com but they are sending me through http://authorize.net So I used the option Cardservice to export our credit card info. I am trying to export a credit card batch. When the cardserv.txt file is generate, it uses comma delimited fields. I tried the custom export option too with no luck. Our software requires a TAB delimited field Is there a way we can accomplish this? Here's an excerpt from the owner's manual if that helps. -Dave There are 21 fields required in the tab delimited text file you will upload for processing. All transactions contained in your file are processed in the currently open batch and are settled with any other transactions submitted under your account within that same batch. Fields are delimited with the TAB character. Do not encapsulate fields with quotes. Fields that are not required and that you don't use should still be represented with just the TAB. Do not include field names in the first record. You can name give the file any filename that is meaningful to you. Most text files end with a .txt file extension. Minimum required fields for a successful transaction (by number - see below): 3,4,5,6,7 Suggested minimum required fields (by number - see below): 1,2,3,4,5,6,7,9,10,11,14 1.INVOICE (Must be all numeric) 2.DESCRIPTION 3.AMOUNT (MUST have decimal point and 2 digits for cents in all cases. Use negative sign for CR type transactions.) 4.METHOD (Must be exactly one of: Visa, MasterCard, American Express, Discover, ACH) 5.TYPE (Must be exactly one of: NA, AO, CR, PA. NA=Normal Transaction, AO=Auth Only, CR=Credit, PA=Post Auth) 6.CARDNUMBER 7.EXPDATE (Must be either mmyy or mm/yy) 8.AUTHCODE (For PA type transactions only and is required in such case) 9.CUSTOMERID 10.NAME 11.ADDRESS (Suggested for Address Verification System <AVS>) 12.CITY 13.STATE 14.ZIP (Suggested for Address Verification System <AVS>) 15.COUNTRY 16.PHONE 17.FAX 18.EMAIL (If provided, customer will receive a standard E-mailed receipt, assuming that your account is configured to send customers an E-mail receipt) 19.BANKNAME (For ACH method transactions) 20.ACCTNUMBER (For ACH method transactions - up to 17 digits) 21.ABACODE (ABA Transit/Routing number. For ACH method transactions - MUST be 9 digits)

Messages In This Thread: export to cardservice by Dave Tanguay on Jan 7, 1999 at 9:53:14 pm Re: export to cardservice by Walter Carter on Jan 7, 1999 at 10:01:51 pm Re: export to cardservice by Shawn Hogan on Jan 7, 1999 at 10:08:58 pm Re: export to cardservice by Dave Tanguay on Jan 7, 1999 at 10:14:33 pm Re: export to cardservice by Dave Tanguay on Jan 7, 1999 at 10:14:57 pm Re: export to cardservice by Shawn Hogan on Jan 7, 1999 at 10:32:12 pm Re: export to cardservice by Walter Carter on Jan 7, 1999 at 10:43:27 pm Re: export to cardservice by Dave Tanguay on Jan 7, 1999 at 10:55:16 pm Re: export to cardservice by Shawn Hogan on Jan 7, 1999 at 11:06:27 pm Re: export to cardservice by Todd Reese on Jan 8, 1999 at 9:49:53 am