http://www.thelinuxwiki.com/index.php?action=history&feed=atom&title=importing_paypal_csv_into_gnucash
importing paypal csv into gnucash - Revision history
2026-04-29T01:29:51Z
Revision history for this page on the wiki
MediaWiki 1.21.5
http://www.thelinuxwiki.com/index.php?title=importing_paypal_csv_into_gnucash&diff=573&oldid=prev
Nighthawk at 21:17, 11 October 2013
2013-10-11T21:17:16Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 21:17, 11 October 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>script to format the paypal csv</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>script to format the paypal csv</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline"> <p></del>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf substr($1,2) "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!="0.00") printf substr($1,2) "," $8 "," $12 "," "paypal fee for " $16 "\n"}' <del class="diffchange diffchange-inline">> paypal_formatted.csv</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf substr($1,2) "," $7 "," $12 "," <ins class="diffchange diffchange-inline">"\</ins>"Item ID " $16 " " $15 <ins class="diffchange diffchange-inline">"\</ins>"\n" ; if ($8!="0.00") printf substr($1,2) "," $8 "," $12 "," <ins class="diffchange diffchange-inline">"\</ins>"paypal fee for " $16 <ins class="diffchange diffchange-inline">"\</ins>"\n"}'  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[category:gnucash]]</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[category:gnucash]]</div></td></tr>
</table>
Nighthawk
http://www.thelinuxwiki.com/index.php?title=importing_paypal_csv_into_gnucash&diff=572&oldid=prev
Nighthawk at 21:11, 11 October 2013
2013-10-11T21:11:46Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 21:11, 11 October 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>script to format the paypal csv</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>script to format the paypal csv</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div> </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  <p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf substr($1,2) "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!="0.00") printf substr($1,2) "," $8 "," $12 "," "paypal fee for " $16 "\n"}' <ins class="diffchange diffchange-inline">> paypal_formatted.csv</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  <p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf substr($1,2) "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!=<del class="diffchange diffchange-inline">"\</del>"0.00<del class="diffchange diffchange-inline">\"</del>") printf substr($1,2) "," $8 "," $12 "," "paypal fee for " $16 "\n"}'  </div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[category:gnucash]]</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[category:gnucash]]</div></td></tr>
</table>
Nighthawk
http://www.thelinuxwiki.com/index.php?title=importing_paypal_csv_into_gnucash&diff=571&oldid=prev
Nighthawk at 21:01, 11 October 2013
2013-10-11T21:01:00Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 21:01, 11 October 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>script to format the paypal csv</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>script to format the paypal csv</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  <p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf $1 "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!="\"0.00\"") printf $1 "," $8 "," $12 "," "paypal fee for " $16 "\n"}' <del class="diffchange diffchange-inline">> paypal_formatted.csv</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  <p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf <ins class="diffchange diffchange-inline">substr(</ins>$1<ins class="diffchange diffchange-inline">,2) </ins>"," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!="\"0.00\"") printf <ins class="diffchange diffchange-inline">substr(</ins>$1<ins class="diffchange diffchange-inline">,2) </ins>"," $8 "," $12 "," "paypal fee for " $16 "\n"}'  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[category:gnucash]]</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[category:gnucash]]</div></td></tr>
</table>
Nighthawk
http://www.thelinuxwiki.com/index.php?title=importing_paypal_csv_into_gnucash&diff=570&oldid=prev
Nighthawk: Created page with "script to format the paypal csv <p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf $1 "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8..."
2013-10-11T20:48:16Z
<p>Created page with "script to format the paypal csv <p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf $1 "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8..."</p>
<p><b>New page</b></p><div>script to format the paypal csv<br />
<p>cat Download.csv | sed -e '1d' | awk -F "\",\"" '{ for (i=1; i<=NF; i++); printf $1 "," $7 "," $12 "," "Item ID " $16 " " $15 "\n" ; if ($8!="\"0.00\"") printf $1 "," $8 "," $12 "," "paypal fee for " $16 "\n"}' > paypal_formatted.csv<br />
<br />
[[category:gnucash]]</div>
Nighthawk