Help Desk

helpdesk.petroleumrx.com

Call Us

(480) 464-6053

Email

info@petroleumrx.com

PetroleumRx > Uncategorized  > CFN CSU import supports delimited file

CFN CSU import supports delimited file

The CSU (card status update) file from CFN has traditionally been a fixed-length feed containing 23 fields.  However, they can be set to provide instead a comma-delimited format with 61 fields.  We can now import that format.  Note that with this switch, all prior 23 field displays on the card ‘+’ screen will be invalidated, to be replaced in time with the 61 field version.  Here are the 61 fields:

1       CardNumber
2       Participant Number
3       Account Number
4       Vehicle Number
5       Expiration Date (yymm)
6       Manual Entry Code
7       Limit Code
8       Product Auth Code
9       Card Status
10      DID Number
11      User ID
12      Change Date (yymmdd)
13      Change Time (hhmmss, 24 hour time)
14      Change Type (A,M,S)
15      Number of Copies
16      Shipping Category (0-3)
17      Label (line #1)
18      Label (line #2)
19      Profile Number
20      POS Site Restricted (Yes = 1,No = 0)
21      Card Type (S,D,V)
22      Vehicle Control (0,2)
23      Custom DID Number
24      Custom Products 1
25      Custom Products 2
26      Custom Products 3
27      Custom Products 4
28      Custom Products 5
29      Custom Products 6
30      Custom Products 7
31      Custom Products 8
32      Custom Gallons
33      Zip Code Lockout 1
34      Zip Code Lockout 2
35      Zip Code Lockout 3
36      Zip Code Lockout 4
37      Zip Code Lockout 5
38      State Lockout 1
39      State Lockout 2
40      State Lockout 3
41      State Lockout 4
42      State Lockout 5
43      State Lockout 6
44      State Lockout 7
45      State Lockout 8
46      State Lockout 9
47      State Lockout 10
48      Custom Prompt Text
49      Last Odometer
50      Range Per Tank
51      Range Tolerance %
52      Oregon Diesel Exempt
53      Oregon Weight Mile Permit
54      Prompt 1
55      Prompt 2
56      Prompt 3
57      Prompt Value 1
58      Prompt Value 2
59      Prompt Value 3
60      Job No
61      PO

The 23 fields in fixed length are these:

1       CardNumber
2       Participant Number
3       Account Number
4       Vehicle Number
5       Expiration Date (yymm)
6       Manual Entry Code
7       Limit Code
8       Product Auth Code
9       Card Status
10      DID Number
11      User ID
12      Change Date (yymmdd)
13      Change Time (hhmmss, 24 hour time)
14      Change Type (A,M,S)
15      Number of Copies
16      Shipping Category (0-3)
17      Label (line #1)
18      Label (line #2)
19      Profile Number
20      POS Site Restricted (Yes = 1,No = 0)
21      (filler)
22      Vehicle Control (0,2)
23      Custom DID Number

Tags: