Mobilefish.com - Online CSV to ClieOp file generator help

Online CSV to ClieOp file generator help

Setting

Remark

CSV data

After you have converted an Excel file into a CSV file, you must upload the data. If you use the Firefox 3.6 or Google Chrome 7.0 browser you can load the CSV file using the "Upload the CSV file" functionality. With other browsers, this functionality is not shown. In the latter case you must open the CSV file with the Notepad program and then copy the entire content. Then paste the content into the CSV data entry field.

The CSV data contains one or more lines which are called items.

CSV data example with 2 items:

1081056568;Greenpeace;Amsterdam;125.00;10 jan 2010;Greenpeace Donation
1363824228;Bakery Stoepje;Ede;50.00;12 feb 2010;Birthday cake

The CSV data can contain the following information:

Name payer / name beneficiary (Max 35 characters)
For business payments, it is the beneficiary name.
For direct debits, it is the payers name.

Name payer / name beneficiary is only mandatory for unchecked transaction types.

If batch type "business payments" is selected, then these are the unchecked transaction types:
- 0000 - unchecked creditor payment to an account with maximum 7 digits
- 0003 - unchecked salary payment to an account with maximum 7 digits
If batch type "direct debits" is selected, then these are the unchecked transaction types:
- 1002 - unchecked direct debit off an account with maximum 7 digits
Amount (Max 453780216.08 euros)
The amount is mandatory and all amounts are in the Euro currency.
You can use the point or the comma as the decimal separator.
The amount shall not exceed 453780216.08 euros with maximum 2 digits after the decimal separator. All amounts added in a batch must not exceed 45378021609.01 euro's.

Examples:
1367.10 is correct
12,45 is correct
23 is correct
0.23 is correct
23.1 is incorrect
573.123 is incorrect
23. is incorrect
.23 is incorrect
Account number (Max 10 digits)
The account number is mandatory.

The account number may contain leading zeros and points, eg:
- 1007782404
- 13.71.76.69.16
- 80.424.6106
- 0290639255
- 0005868817
- 3734
The account number must not exceed 10 digits (after removal of leading zeros).

Account numbers with 9 or 10 digits have a control mechanism in it, the so-called 11-test, to check whether the number is correct.

Account numbers with 1 to 7 digits have no 11-test control mechanism in it. These numbers are ING account numbers, former Postbank giro account numbers.

Account numbers with 8-digits do not exist.

For business payments, it is the beneficiary account number.
For direct debits, it is the payers account number.
Payment reference (Max 16 characters)
The payment reference is optional.
Description 1 to 4.
Each description must have max 32 characters.
Description 1 to 4 are optional.

If 1 to 4 fixed descriptions are present in the batch, then these fixed descriptions are always shown first for each item. Any existing descriptions moves over (and may disappear).

The fixed descriptions appears first on the bank statement.
City payer / city beneficiary (Max 35 characters)
The city is optional.
Equens ignores the city field, but your bank may need it to validate account numbers in unchecked items.

This online service has set the following limits:

Up to 1000 items per batch.
The ClieOp file can contain up to 2 batches.

Note:
Unchecked items have account numbers with up to 7 digits (former giro account numbers). These numbers have no self validating mechanism (11-test). To check these account numbers for authenticity you must supply the corresponding name (and if necessary the city). The bank will then apply name-number checks. If you are sure the account numbers are correct, you may specify these items as checked items. For checked items, the name (and city) is not necessary and the bank shall not apply name-number checks on account numbers with up to 7-digits.

Account numbers with 9 or 10 digits have a self-validating mechanism (11-test). The bank will not apply name-numbers checks and items which such account numbers are always considered checked items.

The characters you can use in the "name payer / name beneficiary", "payment reference", "description 1 to 4" and "city payer / city beneficiary" can be found below.

The following characters are allowed:

Character	Description
A - Z	upper case
a - z	lower case
0 - 9	digits
space
.	full stop
(	left bracket
)	right bracket
+	plus
&	ampersand
$	dollar
*	asterisk
:	colon
;	semicolon
-	hyphen
/	slash
,	comma
%	percent
?	question mark
@	at
=	equals
'	single quotation mark
"	double quotation mark

If you use other characters they will be converted using the character conversion table below.

From		To
ASCII value	Character	ASCII value	Character
32		32
33	!	32
34	"	34	"
35	#	32
36	$	36	$
37	%	37	%
38	&	38	&
39	'	39	'
40	(	40	(
41	)	41	)
42	*	42	*
43	+	43	+
44	,	44	,
45	-	45	-
46	.	46	.
47	/	47	/
48	0	48	0
49	1	49	1
50	2	50	2
51	3	51	3
52	4	52	4
53	5	53	5
54	6	54	6
55	7	55	7
56	8	56	8
57	9	57	9
58	:	58	:
59	;	59	;
60	<	32
61	=	61	=
62	>	32
63	?	63	?
64	@	64	@
65	A	65	A
66	B	66	B
67	C	67	C
68	D	68	D
69	E	69	E
70	F	70	F
71	G	71	G
72	H	72	H
73	I	73	I
74	J	74	J
75	K	75	K
76	L	76	L
77	M	77	M
78	N	78	N
79	O	79	O
80	P	80	P
81	Q	81	Q
82	R	82	R
83	S	83	S
84	T	84	T
85	U	85	U
86	V	86	V
87	W	87	W
88	X	88	X
89	Y	89	Y
90	Z	90	Z
91	[	32
92	\	32
93	]	32
94	^	32
95	_	32
96	`	32
97	a	97	a
98	b	98	b
99	c	99	c
100	d	100	d
101	e	101	e
102	f	102	f
103	g	103	g
104	h	104	h
105	i	105	i
106	j	106	j
107	k	107	k
108	l	108	l
109	m	109	m
110	n	110	n
111	o	111	o
112	p	112	p
113	q	113	q
114	r	114	r
115	s	115	s
116	t	116	t
117	u	117	u
118	v	118	v
119	w	119	w
120	x	120	x
121	y	121	y
122	z	122	z
123	{	32
124	\|	32
125	}	32
126	~	32
127		32
128	€	69	E
129		32
130	‚	32
131	ƒ	102	f
132	„	32
133	…	32
134	†	32
135	‡	32
136	ˆ	32
137	‰	32
138	Š	83	S
139	‹	32
140	Œ	32
141		32
142	Ž	90	Z
143		32
144		32
145	‘	32
146	’	32
147	“	32
148	”	32
149	•	32
150	–	32
151	—	32
152	˜	32
153	™	32
154	š	115	s
155	›	32
156	œ	32
157		32
158	ž	122	z
159	Ÿ	89	Y
160		32
161	¡	105	i
162	¢	99	c
163	£	32
164	¤	32
165	¥	32
166	¦	32
167	§	32
168	¨	32
169	©	32
170	ª	32
171	«	32
172	¬	32
173		32
174	®	32
175	¯	32
176	°	32
177	±	32
178	²	32
179	³	32
180	´	32
181	µ	32
182	¶	32
183	·	32
184	¸	32
185	¹	32
186	º	32
187	»	32
188	¼	32
189	½	32
190	¾	32
191	¿	32
192	À	65	A
193	Á	65	A
194	Â	65	A
195	Ã	65	A
196	Ä	65	A
197	Å	65	A
198	Æ	32
199	Ç	67	C
200	È	69	E
201	É	69	E
202	Ê	69	E
203	Ë	69	E
204	Ì	73	I
205	Í	73	I
206	Î	73	I
207	Ï	73	I
208	Ð	32
209	Ñ	78	N
210	Ò	79	O
211	Ó	79	O
212	Ô	79	O
213	Õ	79	O
214	Ö	79	O
215	×	32
216	Ø	79	O
217	Ù	85	U
218	Ú	85	U
219	Û	85	U
220	Ü	85	U
221	Ý	89	Y
222	Þ	32
223	ß	32
224	à	97	a
225	á	97	a
226	â	97	a
227	ã	97	a
228	ä	97	a
229	å	97	a
230	æ	32
231	ç	99	c
232	è	101	e
233	é	101	e
234	ê	101	e
235	ë	101	e
236	ì	105	i
237	í	105	i
238	î	105	i
239	ï	105	i
240	ð	111	o
241	ñ	110	n
242	ò	111	o
243	ó	111	o
244	ô	111	o
245	õ	111	o
246	ö	111	o
247	÷	32
248	ø	111	o
249	ù	117	u
250	ú	117	u
251	û	117	u
252	ü	117	u
253	ý	121	y
254	þ	32
255	ÿ	121	y