Difference between revisions of "CreditLine Import/Export"
(→Export Format) |
(→Import Format) |
||
| Line 30: | Line 30: | ||
=== Import Format === | === Import Format === | ||
| − | File Format | + | ====File Format==== |
| − | A single transaction is represented by a line. | + | *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> | "field1", "field2", "field3", "field4","field5","field6","field7","field8"<new line> | ||
Revision as of 22:29, 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
Usage
Import Feature will import from a text file (see format below) into the current journal. The Import Feature is useful for processing massive recurrent charges, for instance Club Membership. This tool is also used in Expired Transactions Re-Run.
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. This can be used if you need to stress test your software or integration with multiple transaction over and over again.
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 | e.g. C1 is sale. See Transaction Type for more types. |
| field2 | Clerk | Operator Code |
| 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. e.g. " 1.00" |
| field7 | Member Zip Code | |
| field8 | Member Adress Line 1 |
Export
Export will import from a journal to a text file (see format below).
Command Line Export
Please see CreditLine Command Line.
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 | e.g. C1 is sale. See Transaction Type for more types. |
| field2 | Clerk | Operator Code |
| 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. e.g. " 1.00" |
| 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 |
See Also
- For more info please see ICVerify SDK Format Spec
- Expired Transactions Re-Run
