tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/201-importing-csvInfinite Kind: Discussion 2018-10-18T14:02:46Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/365855262015-04-15T11:52:13Z2015-04-15T11:52:13ZImporting CSV<div><p>Look at the discussion CSV to QIF you should find some
suggestions their.</p></div>rmerrintag:infinitekind.tenderapp.com,2009-01-14:Comment/365855262015-04-15T12:15:13Z2015-04-15T12:15:22ZImporting CSV<div><p>If you attach a sample of your csv file I'll see what settings
are needed to import it.</p>
<p>Ben Spencer<br>
Infinite Kind Support</p></div>Ben Spencertag:infinitekind.tenderapp.com,2009-01-14:Comment/365855262015-04-15T14:07:35Z2015-04-15T14:07:46ZImporting CSV<div><p>Here it is. changed vendor and amounts, but format is the
same.</p>
<p>thanks</p>
<p>M</p></div>Mauriziotag:infinitekind.tenderapp.com,2009-01-14:Comment/365855262015-04-15T14:35:51Z2015-04-15T14:36:05ZImporting CSV<div><p>Can you tell me what the columns are in your csv file?</p>
<p>e.g.</p>
<p>12/02/2015;xxxxxxxxxxxxxxxxxxxxxxx;;34.5</p>
<p>1) Date<br>
2) is this supposed to be description or category?<br>
3) Is this debit?<br>
4) Is this credit?</p>
<p>Note that the Text File Importer extension does not support
debit and credit in separate columns. It only supports a single
amount column where a negative value indicates debit.</p>
<p>Ben Spencer<br>
Infinite Kind Support</p></div>Ben Spencertag:infinitekind.tenderapp.com,2009-01-14:Comment/365855262015-04-15T14:51:30Z2015-04-15T14:51:41ZImporting CSV<div><p>sure.<br>
Date-description-credit-debit<br>
I know the minus sign thing, but that's minor, it is not the
problem i'm facing. The old version, on top of giving the
possibility to define and save formats, also brought records in
with the blue circle, indicating the need to confirm/merge. And the
account as a standard to whatever... Now it is all gone...</p>
<p>Thanks,</p>
<p>maurizio</p></div>Mauriziotag:infinitekind.tenderapp.com,2009-01-14:Comment/365855262015-04-15T15:06:50Z2015-04-15T15:06:50ZImporting CSV<div><p>I believe I understand. I think when you say the "old version"
you are referring to the 3rd party extension called "CSV Importer".
"CSV Importer" is not an old version of "Text File Importer" it is
a different extension.</p>
<p>The extension "CSV Importer" is not yet available for MD2015. I
am afraid I do not know when the writer of this extension will
update it to be compatible MD2015.</p>
<p>Ben Spencer<br>
Infinite Kind Support</p></div>Ben Spencertag:infinitekind.tenderapp.com,2009-01-14:Comment/365855262015-04-15T15:20:01Z2015-04-15T15:20:01ZImporting CSV<div><p>Hi Maurizio, Ben,</p>
<p>The developer of the CSV Importer has created a version
compatible with MD 2015.</p>
<p>It can be downloaded from here:<br>
<a href="https://github.com/stant/mdcsvimporter2015/releases">https://github.com/stant/mdcsvimporter2015/releases</a></p>
<p>It is not yet signed by T.I.K. so you will receive a warning as
such when you go to install it.</p>
<p>BTW, I was able to import your CSV with the new version.</p>
<p>HTH -Kevin N.</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/365855262015-04-15T17:01:29Z2015-04-15T17:01:29ZImporting CSV<div><p>works like a charm!!!!</p>
<p>Many many thanks!</p>
<p>maurizio</p></div>Maurizio