tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/72896-another-importing-csv-problemInfinite Kind: Discussion 2021-09-26T15:49:18Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/494039962021-09-25T13:59:06Z2021-09-25T13:59:06ZAnother Importing CSV problem<div><p>Hi ljpierce_ely,</p>
<p>There is a contradiction in your post.</p>
<p>You state that in your CSV file that debits and credits are "All in the same column.". However, the two examples of your transactions place debits and credits in separate columns.</p>
<p>Can you attach a sample of the actual CSV file? It's fine if you sanitize it down to just those two transactions but It should contain at least 1 debit and 1 credit transaction.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/494039962021-09-25T21:20:25Z2021-09-25T21:20:30ZAnother Importing CSV problem<div><p>Kevin,<br>
The two examples I included, one from Amazon and the other a deposit from Paypal, are copy and pasted directly from the CSV file.<br>
I draw your attention to the amounts shown. The amount from Amazon has a - in front of the amount and the amount from Paypal does not have that character.<br>
As for whether they are in the same column I have to admit that I'm not sure. I assumed and we all know that assumptions are the mother of all F-ups.<br>
The only difference I can readily see, and admittedly it may be significant, is that the withdrawl from Amazon has two "," after the amount, and the deposit from Paypal has two "," before the amount.<br>
Nevertheless, the program puts all amounts into the deposit column within the applicable account.<br>
Lance</p>
<pre>
<code>On Saturday, September 25, 2021, 06:59:14 AM PDT, -Kevin N. <tender+db2407919d@tenderapp.com> wrote:</code>
</pre>
<table>
<tr>
<td></td>
</tr>
</table></div>ljpierce_elytag:infinitekind.tenderapp.com,2009-01-14:Comment/494039962021-09-25T22:08:04Z2021-09-25T22:08:04ZAnother Importing CSV problem<div><p>Hi Lance,</p>
<p>Try this...</p>
<p>Since the payment amount is represented by a negative value, set both fields of the importer to 'Credit Amount'. (see screenshot)</p>
<p>Using the attached CU.txt file, I was able to successfully import the two transactions as expected.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.tag:infinitekind.tenderapp.com,2009-01-14:Comment/494039962021-09-26T01:30:21Z2021-09-26T01:30:25ZAnother Importing CSV problem<div><p>That did it. Thank you!!!!!</p>
<pre>
<code>On Saturday, September 25, 2021, 03:08:18 PM PDT, -Kevin N. <tender+db2407919d@tenderapp.com> wrote:</code>
</pre>
<table>
<tr>
<td></td>
</tr>
</table></div>ljpierce_elytag:infinitekind.tenderapp.com,2009-01-14:Comment/494039962021-09-26T01:43:17Z2021-09-26T01:43:17ZAnother Importing CSV problem<div><p>Hi Lance,</p>
<p>I'm glad to hear that it worked.</p>
<p>Thank you for reporting back with your results.</p>
<p>-Kevin N. (not a member of MD support)</p></div>-Kevin N.