Difference between revisions of "CreditLine Import/Export"
(→=Directly To Journal Function) |
|||
Line 51: | Line 51: | ||
"field1", "field2", "field3", "field4","field5","field6","field7","field8"<new line> | "field1", "field2", "field3", "field4","field5","field6","field7","field8"<new line> | ||
− | Field | + | {| border="1" cellpadding="5" |
+ | ! style="background:#efefef;" | Field Number | ||
+ | ! style="background:#efefef;" | Description | ||
+ | ! style="background:#efefef;" | Notes | ||
+ | |- | ||
+ | |1 || [[#Transaction Types|Transaction Type]] || (C1=sale) | ||
+ | |- | ||
+ | |2 || Clerk || (C1=sale) | ||
+ | |- | ||
+ | |3 || Member Number || (C1=sale) | ||
+ | |- | ||
+ | |4 || Credit Card Number || | ||
+ | |- | ||
+ | |4 || Credit Card Number || | ||
+ | |- | ||
+ | |5 || Credit Card Exp Date || MMYY format (e.g. 1207) | ||
+ | |- | ||
+ | |6 || Amount|| || #####0.00 where # is space as needed for total of 9 characters | ||
+ | |- | ||
+ | |7 || Member Zip Code || | ||
+ | |- | ||
+ | |8 || Member Adress Line 1|| | ||
+ | |} | ||
− | == | + | == Export == |
− | [[Image: | + | [[Image:ToolsExport.gif|none|framed]] |
Select '''On-Line->Export '''from '''CreditLine Manager''' | Select '''On-Line->Export '''from '''CreditLine Manager''' | ||
Line 61: | Line 83: | ||
Export will import from a journal to a text file (see format below). | Export will import from a journal to a text file (see format below). | ||
− | [[Image: | + | [[Image:Export.gif|none|framed|Click '''Ok '''to proceed]] |
+ | |||
− | |||
=== Command Line Export === | === Command Line Export === | ||
Line 85: | Line 107: | ||
"field1", "field2", "field3", "field4","field5","field6","field7","field8","field9"<new line> | "field1", "field2", "field3", "field4","field5","field6","field7","field8","field9"<new line> | ||
− | + | {| border="1" cellpadding="5" | |
+ | ! style="background:#efefef;" | Field Number | ||
+ | ! style="background:#efefef;" | Description | ||
+ | ! style="background:#efefef;" | Notes | ||
+ | |- | ||
+ | |1 || [[#Transaction Types|Transaction Type]] || (C1=sale) | ||
+ | |- | ||
+ | |2 || Clerk || (C1=sale) | ||
+ | |- | ||
+ | |3 || Member Number || (C1=sale) | ||
+ | |- | ||
+ | |4 || Credit Card Number || | ||
+ | |- | ||
+ | |4 || Credit Card Number || | ||
+ | |- | ||
+ | |5 || Credit Card Exp Date || MMYY format (e.g. 1207) | ||
+ | |- | ||
+ | |6 || Amount|| || #####0.00 where # is space as needed for total of 9 characters | ||
+ | |- | ||
+ | |7 || Member Zip Code || | ||
+ | |- | ||
+ | |8 || Member Adress Line 1|| | ||
+ | |- | ||
+ | |9 || 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== |
{| id="AutoNumber1" style="border-collapse: collapse" width="40%" border="1" | {| id="AutoNumber1" style="border-collapse: collapse" width="40%" border="1" |
Revision as of 22:06, 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
CreditLine Import/Export Guide
Please follow this link Import/Export Guide
UNDER CONSTRUCTION
This area is under construction. Please use the link above. Thank you!
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 Number | Description | Notes | |
---|---|---|---|
1 | Transaction Type | (C1=sale) | |
2 | Clerk | (C1=sale) | |
3 | Member Number | (C1=sale) | |
4 | Credit Card Number | ||
4 | Credit Card Number | ||
5 | Credit Card Exp Date | MMYY format (e.g. 1207) | |
6 | Amount | #####0.00 where # is space as needed for total of 9 characters | |
7 | Member Zip Code | ||
8 | 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 Number | Description | Notes | |
---|---|---|---|
1 | Transaction Type | (C1=sale) | |
2 | Clerk | (C1=sale) | |
3 | Member Number | (C1=sale) | |
4 | Credit Card Number | ||
4 | Credit Card Number | ||
5 | Credit Card Exp Date | MMYY format (e.g. 1207) | |
6 | Amount | #####0.00 where # is space as needed for total of 9 characters | |
7 | Member Zip Code | ||
8 | Member Adress Line 1 | ||
9 | 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