Difference between revisions of "CreditLine Import/Export"
(→<font color=#ff0000>UNDER CONSTRUCTION</font>) |
|||
Line 12: | Line 12: | ||
+ | == Import == | ||
+ | |||
+ | [[Image:bnr_map.gif]] | ||
+ | |||
+ | 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''' | ||
+ | |||
+ | [[Image:Setup.1.gif]] | ||
+ | |||
+ | |||
+ | |||
+ | [[Image:Import1.jpg]] | ||
+ | |||
+ | Selecting '''Directly To Journal '''will bypass the server (useful only for transactions that have been already authorized) | ||
+ | |||
+ | '''Repeat, Interval '''(in seconds) and '''Random Interval '''fields are for stress testing. | ||
+ | |||
+ | '''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 | ||
+ | |||
+ | Click '''Ok '''to proceed. | ||
+ | |||
+ | === 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<br /> Number Description Remarks<br /> ------ ----------- -------<br /> 1 [#transactionTypes Transaction Type] (C1=sale )<br /> 2 Clerk (Operator Code )<br /> 3 Member Number<br /> 4 Credit Card number<br /> 5 Credit Card expiry date (MMYY format)<br /> 6 Amount (Mask #####0.00)<br /> 7 Member Zip Code<br /> 8 Member Address line 1 | ||
+ | |||
+ | == <font color="#008000">Export</font> == | ||
+ | |||
+ | [[Image:bnr_map.gif]] | ||
+ | |||
+ | Select '''On-Line->Export '''from '''CreditLine Manager''' | ||
+ | |||
+ | Export will import from a journal to a text file (see format below). | ||
+ | |||
+ | [[Image:Setup.3.gif]] | ||
+ | |||
+ | Click '''Ok '''to proceed. | ||
+ | |||
+ | === Command Line Export === | ||
+ | |||
+ | Please see <font color="#008000"> [http://911software.com/doc/Operation/CommandLine.htm Command Line Parameters]</font> | ||
+ | |||
+ | === 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<br /> ICVERIFY. (Export Transactions )<br /> '' | ||
+ | |||
+ | 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> | ||
+ | |||
+ | <br /> Field<br /> Number Description Remarks<br /> ------ ----------- -------<br /> 1 [#transactionTypes Transaction Type] (C1=sale )<br /> 2 Clerk (Operator Code )<br /> 3 Member Number<br /> 4 Credit Card number<br /> 5 Credit Card expiry date (MMYY format)<br /> 6 Amount (Mask #####0.00)<br /> 7 Member Zip Code<br /> 8 Member Address line 1<br /><br /> 9 Response Code ie: Y12345612345678Y at the beginning of this field indicates that<br /> the transaction was approved.<br /> N at the beginning of this field indicated that<br /> the transaction was declined.<br /><br /> | ||
+ | |||
+ | === <font color="#800000">''Appendix A. Transaction Type Table''</font> === | ||
+ | |||
+ | {| id="AutoNumber1" style="border-collapse: collapse" width="40%" border="1" | ||
+ | | width="110%" | <font face="Helvetica-Bold">'''Sale'''</font> | ||
+ | | width="21%" | <font color="#800000">'''C1'''</font> | ||
+ | |- | ||
+ | | width="110%" | '''<font face="Helvetica-Bold">Void</font>''' | ||
+ | | width="21%" | <font color="#800000">'''C2'''</font> | ||
+ | |- | ||
+ | | width="110%" | <font face="Helvetica-Bold">'''Credit/Refund/Return'''</font> | ||
+ | | width="21%" | <font color="#800000">'''C3'''</font> | ||
+ | |- | ||
+ | | width="110%" | '''<font face="Helvetica-Bold">Edit</font>''' | ||
+ | | width="21%" | <font color="#800000">'''CT'''</font> | ||
+ | |- | ||
+ | | width="110%" | <font face="Helvetica-Bold">'''Auth Only/Pre-Authorization'''</font> | ||
+ | | width="21%" | <font color="#800000">'''CA'''</font> | ||
+ | |- | ||
+ | | width="110%" | <font face="Helvetica-Bold">'''Force/Post-Authorization'''</font> | ||
+ | | width="21%" | <font color="#800000">'''C5'''</font> | ||
+ | |} | ||
+ | |||
+ | for more info please see [http://911software.com/files/icvsdk1.pdf ICVerify SDK Format Spec] | ||
[[Category:CreditLine Manual|Import/Export Guide]] | [[Category:CreditLine Manual|Import/Export Guide]] |
Revision as of 21:43, 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
Selecting Directly To Journal will bypass the server (useful only for transactions that have been already authorized)
Repeat, Interval (in seconds) and Random Interval fields are for stress testing.
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
Click Ok to proceed.
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 Remarks
------ ----------- -------
1 [#transactionTypes Transaction Type] (C1=sale )
2 Clerk (Operator Code )
3 Member Number
4 Credit Card number
5 Credit Card expiry date (MMYY format)
6 Amount (Mask #####0.00)
7 Member Zip Code
8 Member Address line 1
Export
Select On-Line->Export from CreditLine Manager
Export will import from a journal to a text file (see format below).
Click Ok to proceed.
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 Remarks
------ ----------- -------
1 [#transactionTypes Transaction Type] (C1=sale )
2 Clerk (Operator Code )
3 Member Number
4 Credit Card number
5 Credit Card expiry date (MMYY format)
6 Amount (Mask #####0.00)
7 Member Zip Code
8 Member Address line 1
9 Response Code ie: 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.
Appendix A. Transaction Type Table
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