Difference between revisions of "CreditLine Import/Export"
Line 1: | Line 1: | ||
{{CreditLine Header|Manual}} | {{CreditLine Header|Manual}} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Import == | == Import == | ||
Line 52: | Line 41: | ||
{| border="1" cellpadding="5" | {| border="1" cellpadding="5" | ||
− | ! style="background:#efefef;" | Field | + | ! style="background:#efefef;" | Field |
! style="background:#efefef;" | Description | ! style="background:#efefef;" | Description | ||
! style="background:#efefef;" | Notes | ! style="background:#efefef;" | Notes | ||
|- | |- | ||
− | | | + | |field1 || [[#Transaction Types|Transaction Type]] || (C1=sale) |
|- | |- | ||
− | | | + | |field2 || Clerk || |
|- | |- | ||
− | | | + | |field3 || Member Number || |
|- | |- | ||
− | | | + | |field4 || Credit Card Number || |
|- | |- | ||
− | | | + | |field5 || Credit Card Exp Date || MMYY format (e.g. 1207) |
|- | |- | ||
− | | | + | |field6 || Amount|| #####0.00 where # is space as needed for total of 9 characters |
|- | |- | ||
− | | | + | |field7 || Member Zip Code || |
|- | |- | ||
− | | | + | |field8 || Member Adress Line 1|| |
− | + | ||
− | + | ||
|} | |} | ||
Line 95: | Line 82: | ||
Export can be used for third part interoperation or server synchronization. | Export can be used for third part interoperation or server synchronization. | ||
− | ''ICVerify Note: Update Member Accounts will read the upload file created by | + | → ''ICVerify Note: Update Member Accounts will read the upload file created by ICVERIFY. (Export Transactions )'' |
File Format: | File Format: | ||
Line 108: | Line 95: | ||
{| border="1" cellpadding="5" | {| border="1" cellpadding="5" | ||
− | ! style="background:#efefef;" | Field | + | ! style="background:#efefef;" | Field |
! style="background:#efefef;" | Description | ! style="background:#efefef;" | Description | ||
! style="background:#efefef;" | Notes | ! style="background:#efefef;" | Notes | ||
|- | |- | ||
− | | | + | |field1 || [[#Transaction Types|Transaction Type]] || (C1=sale) |
|- | |- | ||
− | | | + | |field2 || Clerk || |
|- | |- | ||
− | | | + | |field3 || Member Number || |
|- | |- | ||
− | | | + | |field4 || Credit Card Number || |
|- | |- | ||
− | | | + | |field5 || Credit Card Exp Date || MMYY format (e.g. 1207) |
|- | |- | ||
− | | | + | |field6 || Amount|| #####0.00 where # is space as needed for total of 9 characters |
|- | |- | ||
− | | | + | |field7 || Member Zip Code || |
|- | |- | ||
− | | | + | |field8 || Member Adress Line 1|| |
|- | |- | ||
− | | | + | |field9 || Response Code || '''Y12345612345678Y''' at the beginning of this field indicates that the transaction was approved. '''N''' at the beginning of this field indicated that the transaction was declined. |
− | + | ||
− | + | ||
|} | |} | ||
+ | |||
+ | |||
==Transaction Types== | ==Transaction Types== |
Revision as of 22:11, 17 January 2007
This article is part of the Payment Processing Software Library |
|
Get it... | |
Install it... | |
Connect to it... | |
Set it up... | |
Learn to use it... | |
→ Manual & User Guide | |
Fix it... | |
→ Errors & Troubleshooting | |
Get Help... | |
More Info ... | |
See also... | |
CreditLine Payment Processing Software Manual. This site can also be reached at http://docs.911software.com
→ Looking for better rates? Get a Free Credit Card Processing Cost Comparison!
Contents
Import
The Import Feature is useful for processing massive recurrent charges, for instance Club Membership.
Import will import from a text file (see format below) into the current journal.
Select On-Line->Import from CreditLine Manager
Directly To Journal Function
This is an advanced function! Selecting Directly To Journal will bypass the processor and import the transactions without obtaining new Auth Codes. It is recommended that you leave this check box unchecked.
Testing Functions
Repeat, Interval (in seconds) and Random Interval fields are for stress testing.
Output Destination
Approved Output is the file where the approved transaction results are directed
Declined Output is the file where the declined transaction results are directed
The Approved Output and Declined Output files have to be different so as not to override each other
Import Format
File Format:
A single transaction is represented by a line.
Every line in the file consists of fields in quotes separated by ','.
End of line is 0x13, 0x10 (standard new line)
"field1", "field2", "field3", "field4","field5","field6","field7","field8"<new line>
Field | Description | Notes |
---|---|---|
field1 | Transaction Type | (C1=sale) |
field2 | Clerk | |
field3 | Member Number | |
field4 | Credit Card Number | |
field5 | Credit Card Exp Date | MMYY format (e.g. 1207) |
field6 | Amount | #####0.00 where # is space as needed for total of 9 characters |
field7 | Member Zip Code | |
field8 | Member Adress Line 1 |
Export
Select On-Line->Export from CreditLine Manager
Export will import from a journal to a text file (see format below).
Command Line Export
Please see Command Line Parameters
Export Format
Export can be used for third part interoperation or server synchronization.
→ ICVerify Note: Update Member Accounts will read the upload file created by ICVERIFY. (Export Transactions )
File Format:
A single transaction is represented by a line.
Every line in the file consists of fields in quotes separated by ','.
End of line is 0x13, 0x10 (standard new line)
"field1", "field2", "field3", "field4","field5","field6","field7","field8","field9"<new line>
Field | Description | Notes |
---|---|---|
field1 | Transaction Type | (C1=sale) |
field2 | Clerk | |
field3 | Member Number | |
field4 | Credit Card Number | |
field5 | Credit Card Exp Date | MMYY format (e.g. 1207) |
field6 | Amount | #####0.00 where # is space as needed for total of 9 characters |
field7 | Member Zip Code | |
field8 | Member Adress Line 1 | |
field9 | Response Code | Y12345612345678Y at the beginning of this field indicates that the transaction was approved. N at the beginning of this field indicated that the transaction was declined. |
Transaction Types
Sale | C1 |
Void | C2 |
Credit/Refund/Return | C3 |
Edit | CT |
Auth Only/Pre-Authorization | CA |
Force/Post-Authorization | C5 |
for more info please see ICVerify SDK Format Spec