Importing a csv file into icompta 3

Discussions about iCompta on iOS
Post Reply
Bongo
Posts: 49
Joined: 23 November 2013, 07:39

Importing a csv file into icompta 3

Post by Bongo » 27 December 2014, 16:12

I am trying to import a csv file from an excel workbook into Icompta 3. After validating the settings and going into the Mapping Accounts section and pressing Validate the Mapping section appears. On trying to map the fields the fields at the bottom do not appear separately but are all in one line separated by /. Can you please tell me what I am doing wrong?

User avatar
Angeman
Administrateur
Posts: 1903
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Importing a csv file into icompta 3

Post by Angeman » 27 December 2014, 16:31

It looks like you didn't put the right the CSV separator in the import settings. Can you open the CSV file with a text editor and copy/paste a few lines ?

Bongo
Posts: 49
Joined: 23 November 2013, 07:39

Re: Importing a csv file into icompta 3

Post by Bongo » 27 December 2014, 16:45

Angeman wrote:It looks like you didn't put the right the CSV separator in the import settings. Can you open the CSV file with a text editor and copy/paste a few lines ?
Here are a few lines. Thanks


ID|Date|Remarks|Withdrawals|Deposits|Category|Date1|Categorised|Payee|Comment|Number|Status|Name|Type|Transfer to
1|11/02/2014|CHEQUE 001440 REF XINL-13694|460||Household|11/02/2014||Godfrey|Kitchen Cupboard|CHEQUE 001440 REF XINL-13694|Cleared||Cheque|
2|11/02/2014|REF ZAFB-00595 STANDING INSTRUCTION 007 TRF TO CURRENT ACCOUNT MT HBMT 033-054602-050||448.96|Transfer of Funds|11/02/2014|||||Cleared|Transfer to HSBC Current Account|Electronic payment|
3|18/02/2014|REF ZAFB-00439 STANDING INSTRUCTION 007 TRF TO CURRENT ACCOUNT MT HBMT 033-054602-050||158.11|Transfer of Funds|18/02/2014|||||Cleared|Transfer to HSBC Current Account|Electronic payment|
4|19/02/2014|REF XDDD-00028CITADEL INSURANCEDIRECT DEBIT11452 Azzopardi|158.11||Investment|19/02/2014||Citadel Insurance|Perla Retirement Scheme||Cleared|Investment|Electronic Payment|Investments
5|27/02/2014|DEPOSIT REF YCI9-01068 SEPA CT RECEIVED 015SABSBP140224001AA01008274 DEPARTMENT OF SOCIAL SECURITY NATIONAL MINIMUM PENSION 00065242G||427.04|Pensions|27/02/2014||Marilise|Social Security Pension Marilise|DEPOSIT REF YCI9-01068 SEPA CT RECEIVED 015SABSBP140224001AA01008274 DEPARTMENT OF SOCIAL SECURITY NATIONAL MINIMUM PENSION 00065242G|Cleared|Pension|Electronic payment|
6|11/03/2014|REF XDDD-00025CITADEL INSURANCEDIRECT DEBIT11452 Azzopardi|158.11||Investment|11/03/2014||Citadel Insurance|Perla Retirement Scheme||Cleared|Investment|Electronic Payment|Investments
7|11/03/2014|SEPA CT RECEIVED3938/7237358MALTA GOVERNMENT REGISTEREDOVERNMENTPayment Of Interest 4.8 MGS 2028 (I)||1020|Dividend/Interest|11/03/2014||Me||||||
8|11/03/2014|CHEQUE 001387 REF XINL-10615|400||Travel|11/03/2014||Discover Access Malta Ltd|Trip to Lourdes Flight and Accomodation|CHEQUE 001387 REF XINL-10615|Cleared||Cheque|
9|09/2014|TRANSFER REF YDI7-00008 INW SEPA DD CORE (FRST) CITDD-DBT-END-2508141328583985 MT41ZZZ019623436TCITADEL INSURANCE PLCCITDD-DBT-MND-2508141328583985 Citadel Life - Policy No. 4149|162.85||Investment|02/09/2014||Citadel Insurance|Perla Retirement Scheme||Cleared|Investment|Electronic Payment|Investments
812014|TRANSFER REF YDI6-01517INW SEPA DD CORE (RCUR)5500714860300103MT33ZZZ012826209TGO PLCDDM213158765-14GO DIRECT DEBIT Client NC 55007148|27.57||GO|10/11/2014||GO||||||

User avatar
Angeman
Administrateur
Posts: 1903
Joined: 28 December 2008, 21:28
Location: Toulouse, France
Contact:

Re: Importing a csv file into icompta 3

Post by Angeman » 27 December 2014, 19:01

The separator is unusual, it's '|' that's why it doesn't work. So you should replace all '|' with ';' with your text editor and then import the modified file in iCompta.

Bongo
Posts: 49
Joined: 23 November 2013, 07:39

Re: Importing a csv file into icompta 3

Post by Bongo » 28 December 2014, 18:44

I managed. Thanks

Post Reply