Importing text file..

[superka]

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

[Angeman]

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.

[superka]

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.

hi,

i sent you right now the original file by mail..please let me know..

br

[Angeman]

Sorry I just checked and there are spaces between fields and not tabs so it can't be imported.

[superka]

Sorry I just checked and there are spaces between fields and not tabs so it can't be imported.

could i modify manually that stupid file?

[Angeman]

Yes you can replace the spaces between 2 fields with one tab and then you should be able to import it.

[superka]

Yes you can replace the spaces between 2 fields with one tab and then you should be able to import it.

last question then i will not bother you anymore..

which sysmbol is do you exactly mean for "tab"?

this one " " or this <>?

thanks as usual

br

[Angeman]

Capture d’écran 2010-11-14 à 10.57.37.png (72.07 KiB) Viewed 7197 times

[superka]

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