Re: Error: Only one posting with null amount allowed per transaction
Hello, "John Wiegley" writes: > OK, now can you get me a small enough file that reproduces this issue so that > I can manifest the error on my side? This one-line CSV file triggers the problem. -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/y65v89ihwy3.fsf%40mun.ca. foo.csv Description: Binary data Thanks, Roger -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/y65v89ihwy3.fsf%40mun.ca.
Re: Error: Only one posting with null amount allowed per transaction
>>>>> "RM" == Roger Mason writes: RM> touch my.ledger RM> ledger convert /home/rmason/Personal/Finances/PlainText/foo.csv -f /home/rmason/Personal/Finances/PlainText/my.ledger RM> While parsing file "/home/rmason/Personal/Finances/PlainText/foo.csv", line 1: RM> While parsing CSV line: RM> 2023-11-20,"Point of Sale - Interac RETAIL PURCHASE 000001553028 CIRCLE K # 252",100.54, RM> Error: Only one posting with null amount allowed per transaction OK, now can you get me a small enough file that reproduces this issue so that I can manifest the error on my side? Thanks, John -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/m2y1efneis.fsf%40newartisans.com.
Re: Error: Only one posting with null amount allowed per transaction
Hello, "John Wiegley" writes: > > Can you try with absolute paths for both files? > > John ledger convert /home/rmason/Personal/Finances/PlainText/foo.csv Error: No journal file was specified (please use -f) ledger convert /home/rmason/Personal/Finances/PlainText/foo.csv -f /home/rmason/Personal/Finances/PlainText/my.ledger Error: Cannot read journal file "/home/rmason/Personal/Finances/PlainText/my.ledger" touch my.ledger ledger convert /home/rmason/Personal/Finances/PlainText/foo.csv -f /home/rmason/Personal/Finances/PlainText/my.ledger While parsing file "/home/rmason/Personal/Finances/PlainText/foo.csv", line 1: While parsing CSV line: 2023-11-20,"Point of Sale - Interac RETAIL PURCHASE 000001553028 CIRCLE K # 252",100.54, Error: Only one posting with null amount allowed per transaction Thanks again for the help. Roger -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/y65jzpze8yy.fsf%40mun.ca.
Re: Error: Only one posting with null amount allowed per transaction
> "RM" == Roger Mason writes: RM> If I run: RM> ledger convert foo.csv -f ./my.ledger RM> I get: Error: Cannot read journal file RM> "/usr/home/rmason/Personal/Finances/PlainText/foo.csv" Can you try with absolute paths for both files? John -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/m2a5qyhqlp.fsf%40newartisans.com.
Re: Error: Only one posting with null amount allowed per transaction
"John Wiegley" writes: >> "RM" == Roger Mason writes: > > RM> I don't know what information you need but this is the top few lines of > RM> the CSV file: > > RM> date,description,debit,credit > RM> 2023-11-20,"Point of Sale - Interac RETAIL PURCHASE 01553028 CIRCLE K > # 252",100.54, > RM> 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 01671085 SOBEYS > #590,3.00, > RM> 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 332310187408 DOLLARAMA > #1440,50.60, > > When I create a file containing these lines, and run “ledger convert” on it, > it outputs the following: > > Vulcan ~/dl $ ledger convert foo.dat If I run 'ledger convert foo.csv' the response is: Error: No journal file was specified (please use -f) so I run: ledger convert foo.csv -f my.ledger and get the error above. If I run: ledger convert foo.csv -f ./my.ledger I get: Error: Cannot read journal file "/usr/home/rmason/Personal/Finances/PlainText/foo.csv" Thanks again, Roger -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/y655y1t1mor.fsf%40mun.ca.
Re: Error: Only one posting with null amount allowed per transaction
> "RM" == Roger Mason writes: RM> I don't know what information you need but this is the top few lines of RM> the CSV file: RM> date,description,debit,credit RM> 2023-11-20,"Point of Sale - Interac RETAIL PURCHASE 01553028 CIRCLE K # 252",100.54, RM> 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 01671085 SOBEYS #590,3.00, RM> 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 332310187408 DOLLARAMA #1440,50.60, When I create a file containing these lines, and run “ledger convert” on it, it outputs the following: Vulcan ~/dl $ ledger convert foo.dat 2023/11/20 * Point of Sale - Interac RETAIL PURCHASE 01553028 CIRCLE K # 252 Expenses:Unknown$-100.54 Equity:Unknown 2023/11/20 * Point of Sale - Interac RETAIL PURCHASE 01671085 SOBEYS #590 Expenses:Unknown $-3.00 Equity:Unknown 2023/11/20 * Point of Sale - Interac RETAIL PURCHASE 332310187408 DOLLARAMA #1440 Expenses:Unknown $-50.60 Equity:Unknown Is there anything more I need to reproduce the error? John -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/m2v89tfq8b.fsf%40newartisans.com.
Re: Error: Only one posting with null amount allowed per transaction
Hello, "John Wiegley" writes: >>>>>> "s" == sprock writes: > > s> I'm getting this error: > > s> While parsing file "/usr/home/sprock/Personal/Finances/ledger.csv", line 1: > s> While parsing CSV line: 2023-11-20,Point of Sale - Interac RETAIL > s> PURCHASE 01553028 CIRCLE K # 252,100.54, > > s> Error: Only one posting with null amount allowed per transaction > > s> using this command line: > s> ledger convert ledger.csv --input-date-format "%Y-%m-%d" -f my.ledger > > The convert sub-command does quite a bit of work, so it’s hard to say exactly > what’s going wrong in this scenario from the information provided. > > John Thanks for your reply. I don't know what information you need but this is the top few lines of the CSV file: date,description,debit,credit 2023-11-20,"Point of Sale - Interac RETAIL PURCHASE 01553028 CIRCLE K # 252",100.54, 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 01671085 SOBEYS #590,3.00, 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 332310187408 DOLLARAMA #1440,50.60, The failure occurs at line 1. The target journal (my.ledger) exists but is empty. I have also tried the convert command with my.ledger containing this: 2023-01-01 Opening Balance Assets:Checking 342.63 Equity:Opening Balances and getting the same error. I am using ledger-3.2.1 on FreeBSD 12.4. Please let me know if you need further information. Thanks, Roger -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/y65leapczby.fsf%40mun.ca.
Re: Error: Only one posting with null amount allowed per transaction
>>>>> "s" == sprock writes: s> I'm getting this error: s> While parsing file "/usr/home/sprock/Personal/Finances/ledger.csv", line 1: s> While parsing CSV line: 2023-11-20,Point of Sale - Interac RETAIL s> PURCHASE 01553028 CIRCLE K # 252,100.54, s> Error: Only one posting with null amount allowed per transaction s> using this command line: s> ledger convert ledger.csv --input-date-format "%Y-%m-%d" -f my.ledger The convert sub-command does quite a bit of work, so it’s hard to say exactly what’s going wrong in this scenario from the information provided. John -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/m2leapegzv.fsf%40newartisans.com.
Error: Only one posting with null amount allowed per transaction
Hello, I'm getting this error: While parsing file "/usr/home/sprock/Personal/Finances/ledger.csv", line 1: While parsing CSV line: 2023-11-20,Point of Sale - Interac RETAIL PURCHASE 01553028 CIRCLE K # 252,100.54, Error: Only one posting with null amount allowed per transaction using this command line: ledger convert ledger.csv --input-date-format "%Y-%m-%d" -f my.ledger I'm new to this so please excuse me if I am being stupid. Thanks. -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/57eac08a-1204-4597-bbb2-9c5cdffe5e11n%40googlegroups.com.
I get "Error: Only one posting with null amount allowed per transaction" when importing CSV file
Hello, A new user to ledger here. I have a tmp.csv file that contains the following: --8<---cut here---start->8--- date,,,payee,,debit,credit 2023-04-22,2023-04-24,0311,COSTCO WHSE#1322,Merchandise,,10.99 --8<---cut here---end--->8--- But I get an error when running the command: husain@localhost:~/Finance$ ledger convert tmp.csv --input-date-format "%Y-%m-%d" --rich-data -f personal.dat While parsing file "/home/husain/Finance/tmp.csv", line 1: While parsing CSV line: 2023-04-22,2023-04-24,0311,COSTCO WHSE#1322,Merchandise,,10.99 Error: Only one posting with null amount allowed per transaction I get the same error as well if I run the following: husain@localhost:~/Finance$ ledger convert tmp.csv --input-date-format "%Y-%m-%d" --rich-data -f personal.dat --account Assets:Bank --invert While parsing file "/home/husain/Finance/tmp.csv", line 1: While parsing CSV line: 2023-04-22,2023-04-24,0311,COSTCO WHSE#1322,Merchandise,,10.99 Error: Cannot negate an uninitialized amount I am not sure what is going on. Guidance would be appreciated. Note that I am running into this issue after consulting the documentation in: https://ledger-cli.org/doc/ledger3.html#The-convert-command The documentation includes a command similar to the one listed above. I also consulted the man page. However, the man page is not clear on how to use the convert command as it does not group the options together. I am, for example, unsure what the "-f" flag does here. Thanks, Husain -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ledger-cli/87r0r5ozxd.fsf%40alshehhi.io.
Error: Only one posting with null amount allowed per transaction because of note
I've noticed that adding a note to a periodic entry without specifying the redundant transaction values produces a null amount error: # this works fine: $ cat /tmp/sample ~ monthly ; note assets:checking $1,000.00 income:work:salary -$1,000.00 $ ledger --forecast d[2011] reg -f /tmp/sample 10-Dec-01 Forecast transaction assets:checking $1,000.00 $1,000.00 10-Dec-01 Forecast transaction income:work:salary $-1,000.000 # removing the redundant info from the entry breaks it for some reason: $ cat /tmp/sample ~ monthly ; note assets:checking $1,000.00 income:work:salary $ ledger --forecast d[2011] reg -f /tmp/sample While parsing file /tmp/sample, line 4: While parsing periodic transaction: ~ monthly ; note assets:checking $1,000.00 income:work:salary Error: Only one posting with null amount allowed per transaction # this works without notes: $ cat /tmp/sample ~ monthly assets:checking $1,000.00 income:work:salary [pl...@durandal ledger]$ ledger --forecast d[2011] reg -f /tmp/ sample 10-Dec-01 Forecast transaction assets:checking $1,000.00 $1,000.00 10-Dec-01 Forecast transaction income:work:salary $-1,000.000 $ ledger --version Ledger 3.0.0-20100623, the command-line accounting tool I expect all three cases to not fail with an error. Is this a (known) bug?