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