<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=NL style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Beste Geert,<o:p></o:p></span></p><p class=MsoNormal><span lang=NL style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=NL style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Bedankt. Ik was er l bang voor. Inmiddels heb ik via Excel de kolom met het bedrag gesplitst in twee kolommen, ‘Storting’ en ‘Opname’. Dat was eigenlijk heel eenvoudig. Vervolgens gesaved als .csv en geimporteerd in GNUCash. Helaas mislukt het toch, en volgens GNU Cash is dat omdat het programma geen raad weet met de nieuwe kolom.’Kolom storting kon niet worden verwerkt’<o:p></o:p></span></p><div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;padding:0cm 0cm 1.0pt 0cm'><p class=MsoNormal style='border:none;padding:0cm'><span lang=NL style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Ik paste hieronder dan maar een stukje van die csv-file. Misschien heb je er iets over te melden. Ik zal ook de engelse lijst proberen.<o:p></o:p></span></p></div><p class=MsoNormal style='text-autospace:none'><span lang=NL style='font-size:11.0pt;font-family:"Courier New"'>19-12-2013;Mw J M van der Kaaij;3199487;9;;Naam: Mw J M van der Kaaij Omschrijving: overboeking IBAN: NL69INGB0003199487<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=NL style='font-size:11.0pt;font-family:"Courier New"'>19-12-2013;Theo Richel;2598516;19;;Naam: Theo Richel Omschrijving: overboeking IBAN: NL29INGB0002598516<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=NL style='font-size:11.0pt;font-family:"Courier New"'>23-12-2013;Stichting Escrow Icepay;136343341;;64,9;Naam: Stichting Escrow Icepay Omschrijving: supnl100011761 0020000707126608 100 011761 SuperNaturals.nl Kenmerk: 23-12-2013 11:58 0020000707126608 IBAN: NL06RABO0136343341<o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><span lang=NL style='font-size:11.0pt;font-family:"Courier New"'>23-12-2013;Mw J M van der Kaaij;3199487;400;;Naam: Mw J M van der Kaaij Omschrijving: overboeking IBAN: NL69INGB0003199487<o:p></o:p></span></p><p class=MsoNormal><span lang=NL style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=NL style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>--------------------<o:p></o:p></span></p><p class=MsoNormal><span lang=NL style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=NL style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=NL style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=NL style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Geert Janssens [mailto:janssens-geert@telenet.be] <br><b>Sent:</b> zaterdag 28 juni 2014 12:33<br><b>To:</b> gnucash-nl@gnucash.org<br></span><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Cc:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Theo Richel<br><b>Subject:</b> Re: [Gnucash-nl] Ingbank data importeren<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Courier New"'>Hallo,<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-paragraph-type:empty;-qt-block-indent:0'><span style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>Deze opsplitsing zal je zelf vooraf in je csv file moeten maken. GnuCash kan dit niet voor jou.<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-paragraph-type:empty;-qt-block-indent:0'><span style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>Een mogelijkheid hiervoor is het csv bestand in LibreOffice Calc of Ms Excel openen en de kolom daar opsplitsen.<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-paragraph-type:empty;-qt-block-indent:0'><span style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>Een andere piste zou ook kunnen zijn om van een qif bestand te vertrekken in plaats van een csv bestand. De Qif importer werkt over het algemeen betrouwbaarder dan de csv importer.<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-paragraph-type:empty;-qt-block-indent:0'><span style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>Ik weet niet of Ing de mogelijkheid heeft om je transacties via qif te exporteren. Indien niet, geloof ik dat er online verschillende tools te vinden zijn die je csv bestand kunnen omzetten naar qif formaat. Zoek bv naar cvs2qif.<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-paragraph-type:empty;-qt-block-indent:0'><span style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>Mvg,<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-paragraph-type:empty;-qt-block-indent:0'><span style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>Geert<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-paragraph-type:empty;-qt-block-indent:0'><span style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>PS: De gnucash-nl lijst is vrij jong. Over csv of qif import zijn al vaak vragen gesteld in het verleden, maar meestal op de hoofdlijst "gnucash-user", een Engelstalige lijst voor gebruikersvragen.<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-paragraph-type:empty;-qt-block-indent:0'><span style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>On Saturday 28 June 2014 10:56:49 Theo Richel wrote:<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> Goedendag,<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> Ik ben een nieuwbakken gebruiker van GNUCash en ik probeer nu een<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> CSV-lijst met transacties van de Ingbank in te laden. Dat lukt<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> redelijk, alleen begrijp ik het volgende niet.<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> De CSV-lijst bevat 1 kolom waarin staat aangegeven of een bepaalde<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> transactie een bij- dan wel een afschrijving bevat. Maar de<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> importwizard van GNUCash heeft hiervoor twee kolommen: Storting en<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> Opname. Hoe verdeel ik 1 kolom over twee kolommen?<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> Ik heb in het archief van deze lijst wel twee vragen over deze import<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> gelezen, maar geen antwoorden, maar misschien zijn er recentere<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> ontwikkelingen.<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> <o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0;-qt-user-state:0'><span style='font-size:10.0pt;font-family:"Courier New"'>> Dank<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-paragraph-type:empty;-qt-block-indent:0'><span style='font-size:10.0pt;font-family:"Courier New"'> <o:p></o:p></span></p></div></body></html>