Hi again,
next step (very important to me) is to import the data my Italian bank let me download as a text file. It is like below (in red):
C/C 01005 21600 ***********5
Divisa C/C EUR
Saldo contabile al 10/11/2010 +(my amount)
Data contabile Data valuta Causale ABI Descrizione Importo
1 08/11/2010 31/10/2010 66 Spese invio documento trasparen al 31.10.10 -1,00
2 08/11/2010 08/11/2010 45 Utilizzo carta di credito -1552,07
3 02/11/2010 29/10/2010 66 Canone Conto BNL Revolution -6,90
4 28/10/2010 28/10/2010 05 Prelievo Bancomat del 28.10.10 ore 18:41 Carta 174601 C/o -300,00
5 28/10/2010 19/10/2010 13 Vostro assegno di conto corrente n. estinto pressDEI PASCHI DI SIENA -676,29
6 28/10/2010 25/10/2010 43 Pagamento tramite POS del 25.10.10 Carta TopCash Circuito MAE -19,37
how can i set (or is it possible?) the popup dialog to import properly datas?
thanks in advance
Importing text file..
- Angeman
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Importing text file..
Is there a tab or a space between the different fields ? If it's a space you won't be able to import your file sorry.
Re: Importing text file..
hi,Angeman wrote:Is there a tab or a space between the different fields ? If it's a space you won't be able to import your file sorry.
i sent you right now the original file by mail..please let me know..
br
- Angeman
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Importing text file..
Sorry I just checked and there are spaces between fields and not tabs so it can't be imported.
Re: Importing text file..
could i modify manually that stupid file?Angeman wrote:Sorry I just checked and there are spaces between fields and not tabs so it can't be imported.
- Angeman
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Importing text file..
Yes you can replace the spaces between 2 fields with one tab and then you should be able to import it.
Re: Importing text file..
last question then i will not bother you anymore..Angeman wrote:Yes you can replace the spaces between 2 fields with one tab and then you should be able to import it.
which sysmbol is do you exactly mean for "tab"?
this one " " or this <>?
thanks as usual
br
Re: Importing text file..
hi,
please be pacient..
i sent you i txt file that is the output of my homebanking.
Now can you please modify (to let iCompta import data) and send me back as sample, only 1 line of the .txt i sent you?
It will be a sample to me and will show me how to modify that files to be imported..just 1 line will be enought..
thanks again for your availability
please be pacient..
i sent you i txt file that is the output of my homebanking.
Now can you please modify (to let iCompta import data) and send me back as sample, only 1 line of the .txt i sent you?
It will be a sample to me and will show me how to modify that files to be imported..just 1 line will be enought..
thanks again for your availability