2015-04-14 GnuCash IRC logs
00:19:36 *** josePHPagoda has quit IRC
00:56:07 *** GabrieleV_ has joined #gnucash
00:56:45 *** GabrieleV has quit IRC
00:56:46 *** GabrieleV_ is now known as GabrieleV
01:17:12 *** MechtiIde has joined #gnucash
01:36:39 *** GabrieleV_ has joined #gnucash
01:37:21 *** GabrieleV has quit IRC
01:37:21 *** GabrieleV_ is now known as GabrieleV
01:41:53 *** O01eg has quit IRC
01:57:09 *** GabrieleV_ has joined #gnucash
01:57:24 *** GabrieleV has quit IRC
01:57:24 *** GabrieleV_ is now known as GabrieleV
01:59:41 *** fell has quit IRC
02:02:19 *** MechtiIde has quit IRC
02:21:59 *** Krzysiek_K has joined #gnucash
02:23:13 *** Abhish has quit IRC
02:45:21 *** cartsoftware has quit IRC
02:52:34 *** markusv has joined #gnucash
02:52:38 *** markusv has left #gnucash
02:52:41 *** markusv has joined #gnucash
03:07:47 *** fabior has joined #gnucash
03:11:05 *** ErKa has quit IRC
03:27:49 *** Krzysiek_K has left #gnucash
03:31:49 *** gjanssens has joined #gnucash
03:31:49 *** gncbot sets mode: +o gjanssens
03:45:32 *** uXus has quit IRC
03:48:17 *** uXus has joined #gnucash
04:27:05 *** floh1111 has joined #gnucash
04:45:48 *** floh1111_ has joined #gnucash
04:50:43 *** floh1111 has quit IRC
05:50:39 *** gjanssens has quit IRC
05:54:20 *** gjanssens has joined #gnucash
05:54:21 *** gncbot sets mode: +o gjanssens
06:00:47 *** floh1111_ has quit IRC
06:37:13 *** Jimraehl1 has left #gnucash
06:44:07 *** Jimraehl1 has joined #gnucash
06:52:58 *** mikee_ has joined #gnucash
06:58:24 *** floh1111 has joined #gnucash
06:59:59 *** mikee has quit IRC
07:00:00 *** mikee_ is now known as mikee
07:08:23 *** fabior has quit IRC
07:21:58 *** josePHPagoda has joined #gnucash
07:40:48 *** floh1111 has quit IRC
07:44:08 *** andy has quit IRC
07:53:59 *** andy has joined #gnucash
07:55:57 *** rickoehn has joined #gnucash
08:12:38 *** fell has joined #gnucash
08:12:38 *** gncbot sets mode: +o fell
08:31:30 *** taime1 has joined #gnucash
08:32:06 <taime1> is it safe to unpost an invoice to add a line item?
08:48:43 *** MagicFab has joined #gnucash
09:00:10 *** lcf1 has joined #gnucash
09:00:20 <lcf1> hell
09:00:24 <lcf1> o
09:02:21 <kimmo2> sup
09:03:04 <lcf1> I want to change the path which includes name1 to the same path with name2; this for the files associated with a transaction. I think I need to know the file that the links are kept in. Can you help me please?
09:04:36 <kimmo2> that would be in the general ledger
09:04:58 <kimmo2> it's save format is encrypted/compressed by default, so you might want to save that as xml and inspect it
09:05:16 <kimmo2> file -> save as -> select xml as format
09:06:01 <lcf1> I am migrating accounts from one computer to another, I am name1 on the original computer and name2 on the new one. The path is something like /Home/bob/.....and I want to change it (for every associated document) to /Home/lcf...
09:08:09 <kimmo2> yeah, you'd want to edit the xml file, the file location is part of the transaction node
09:08:10 <lcf1> I would like to do a find and replace because I have hundreds of associated files (mostly pdf format...not that that is relevant)
09:08:43 <lcf1> so which file do I save as....I'm also on linux
09:09:06 <kimmo2> just something, like ledger.gnucash
09:09:27 <kimmo2> and then just edit the xml file with something like emacs and do a search and replace
09:09:44 <kimmo2> M-S-%
09:09:49 <kimmo2> err, M-%
09:09:51 <lcf1> so ledger.gnucash is the file holding the associated files links?
09:10:21 <kimmo2> yeah, everything is in a single file (I'm assuming you're using file backend here)
09:11:56 <lcf1> I don't have a ledger.gnucash file on my system.
09:12:32 <lcf1> Is that the name of the file (for instance) that I save as?
09:12:52 <kimmo2> yeah
09:13:04 <lcf1> If so which file do I pull up and then save as?
09:13:30 <kimmo2> your ledger
09:13:37 <kimmo2> whatever gnucash opens by default
09:14:42 <lcf1> so thats going to be mynamegnucash.gnucash?
09:16:10 *** cartsoftware has joined #gnucash
09:29:00 *** markusv has left #gnucash
09:34:15 *** cartsoftware1 has joined #gnucash
09:34:50 *** lmat has joined #gnucash
09:39:32 *** cartsoftware has quit IRC
09:40:01 *** josePHPagoda has quit IRC
09:40:38 <lcf1> still at kimmo2, just getting to grips with emacs for the first time
09:44:19 *** cartsoftware1 has quit IRC
09:45:44 *** cartsoftware has joined #gnucash
09:51:12 *** fabior has joined #gnucash
10:10:56 <warlord> taime1: Yes... but if it was already "paid" you'll have to "re pay" it ... If it wasn't paid then it's absolutely safe.
10:11:34 <warlord> lcf1: Are you talking about linked images?
10:26:12 *** aqua___ has joined #gnucash
10:26:34 *** Abhish has joined #gnucash
10:33:20 <lcf1> warlord: when you see a transaction line in any ledger, say an expense account that lists items of expenditure; then right click on that line and you can 'Associate File with Transaction'. Once this is done you can then view that file. This is the error that pops up because I moved the accounts to a different computer and want to modify the path (en mass) to replace "bob" with "lcf". The associated files copied over ok but I need to chnage the path to make then v
10:33:20 <lcf1> GnuCash could not open the associated URI:
10:33:20 <lcf1> file:///home/bob/Documents/CELCA/Treasury/GNUcashAccounts/PR104/Claim3/PR104-440%20Index%20Claim3.pdf
10:34:52 <lcf1> Error running gnome-open '/home/bob/Documents/CELCA/Treasury/GNUcashAccounts/PR104/Claim3/PR104-440%20Index%20Claim3.pdf'
10:34:52 <lcf1> Process returned error code 256
10:36:15 <lcf1> What I want to do is find "bob"and replace with "lcf"
10:38:40 *** lcf1 has left #gnucash
10:42:51 *** lcf1 has joined #gnucash
10:45:58 *** lcf1 has left #gnucash
10:48:21 *** lcf1 has joined #gnucash
10:48:42 *** StuM has quit IRC
10:49:38 <warlord> lcf1: right, as I said, it's the "linked image" files. Alas, no, there is no way to change them en-masse. The best option is to backup your data file and then process the XML by hand. Note that this isn't a supported operation, but it should work if you're careful. (That's the reason to backup the datafile first)
10:50:43 <lcf1> so the .gnucash file is an xml formatted file?
10:52:59 <warlord> Assuming you're using the XML backend, then yes. (Well, it might be a GZip'd XML file)
10:53:15 <lcf1> I just get an error message trying to open (a copy) of the file and if I do a save as or export within gnucash as an xml file I can't parse that either.
10:53:27 <lcf1> What is the xml backend
10:53:51 <warlord> What do you mean that you "can't parse that either"?
10:54:13 <warlord> the xml backend is the file storage system in Gnucash -- it's what you chose when you did File -> Save (As) when you saved your data file
10:54:28 <warlord> Alternates are the SQL backend..
10:54:42 <lcf1> I've tried exporting as csv but can't see any references to a path or file either
10:55:27 <lcf1> are...you mean the database
10:56:04 <warlord> No, exporting to CSV wont show the linked image data.
10:56:15 <warlord> It's only exporting the transactional information
10:56:20 <warlord> you want to edit your data file..
10:56:37 <warlord> What do you get from: file <filename>.gnucash
10:57:29 <lcf1> OK, thanks for your patience.....I just need an editing tool it seems.
10:58:37 <lcf1> emacs was advised but it doesn't show anything...I'll try and unzip the main file first
10:58:40 <warlord> yes. emacs, vi, or any other editing tool can work. You could even use perl, python, or sed to edit it in place
10:59:00 <warlord> Yes, if it's compressed you absolutely need to gunzip it first!!!!
10:59:09 <warlord> That's why I said it could be a compressed xml file.
10:59:11 <warlord> (gzipped)
11:00:12 <kimmo2> once you get it unzipped, just run: perl -pi -e 's,home/bob/,home/lcf,g' filename
11:03:54 <warlord> backup your file first
11:10:01 *** Abhish has quit IRC
11:12:45 <lcf1> OK, I've made a copy and called it testgzip. I've opened a terminal and:- gzip -d testgzip
11:13:03 <lcf1> The return said: testgzip: unknown suffix -- ignored
11:13:28 <lcf1> I tried .gnucash, .xml as suffices but no luck
11:13:48 <lcf1> what is the suffix for a gzipped file?
11:14:20 <lcf1> tried sudo too but same return
11:15:00 <warlord> make it test.gnucash.gz
11:15:07 <warlord> then gunzip test.gnucash.gz
11:15:13 <warlord> then run that perl command
11:15:19 <lcf1> just have....smacked myself too
11:15:19 <warlord> then File -> Open test.gnucash
11:21:06 <lcf1> nearly did it....we need to replace 'lcf' with 'lcf/'....could you tweek you code please. I'll start again with a fresh copy.
11:24:16 <warlord> perl -pi -e 's,home/bob/,home/lcf/,g'
11:41:47 <lcf1> I think we are there, not quite but I can now see the xml file and the changes look good. Just need to work backwards now and recompress the file then rename it and substitute it for the original
11:52:37 *** lmat has quit IRC
11:53:46 *** josePHPagoda has joined #gnucash
11:58:44 *** O01eg has joined #gnucash
12:09:24 *** Abhish has joined #gnucash
12:11:47 <warlord> lcf1: no need to re-compress
12:12:19 *** cartsoftware1 has joined #gnucash
12:12:58 *** ErKa has joined #gnucash
12:14:23 *** aqua___ has quit IRC
12:19:10 *** cartsoftware has quit IRC
12:19:47 <lcf1> is that what the g was about in the code
12:19:51 <taime1> warlord: when I unpost an invoice, I'm asked if I want to reset the tax tables. I don't understand that question or how to answer it. Any idea?
12:20:41 <warlord> lcf1: in the perl code? no, that meant "global". It's just that Gnucash doesnt need the file compressed; just rename your file back to your original file.gnucash name and then File -> Open it. GnuCash will auto-compress on the next save.
12:21:15 <warlord> taime1: When you post the invoice is stores your tax tables so that if you change the tax table it wont affect posted invoices.
12:21:32 <warlord> The question is: keep the original tax tables, or reset them to the "current" versions?
12:27:31 <taime1> I must be really dense because I still don't understand how to answer that question
12:27:49 <taime1> does unposting an invoice potentially affect all other invoices?
12:29:32 <lcf1> Thank you kimmo2. Thank you Warlord. My head is sore from smacking the back of it but the good news is I now have a fully restored huge linked library of associated documents presented as they should. Well worth a days work.
12:33:14 *** lcf1 has left #gnucash
12:33:34 <taime1> Warlord, I think I understand. Correct me if I am wrong here but answering this question with a yes or no is irrelevant if I do not ever change my tax tables system-wide, correct?
12:34:28 *** fabior has quit IRC
12:35:11 *** lwells has quit IRC
12:35:43 <taime1> but i suppose the safest way to answer would be "keep the tables"?
12:41:39 <warlord> taime1: no, it only affects that one invoice
12:42:21 <warlord> taime1: that is correct, if you never change your tax tables then it's safe to choose either option.
12:42:57 <warlord> BUt e.g. if your sales tax changed on Jan 1st, but you unpost an invoice from Dec 20th, you would definitely NOT want to reset the tax tables; you'd want to keep last year's tax rate.
12:46:01 *** aqua___ has joined #gnucash
12:47:00 *** aqua___ has quit IRC
12:48:23 *** aqua___ has joined #gnucash
12:49:28 *** fabior has joined #gnucash
12:53:18 *** aqua_ has joined #gnucash
12:54:39 *** aqua___ has quit IRC
12:54:47 *** cartsoftware1 has quit IRC
13:00:27 *** jralls is now known as jralls_afk
13:01:23 *** fell_ has joined #gnucash
13:01:23 *** gncbot sets mode: +o fell_
13:03:03 *** MagicFab has quit IRC
13:03:21 *** lmat has joined #gnucash
13:10:25 *** fell has quit IRC
13:10:48 *** fell_ is now known as fell
13:11:40 *** MagicFab has joined #gnucash
13:13:34 <taime1> warlord: thank you very much for clearing that up.
13:14:57 <warlord> taime1: you're welcome
13:15:59 *** taime1 has quit IRC
13:27:50 *** aqua_ has quit IRC
13:35:33 *** ErKa has quit IRC
13:59:34 *** fabior has quit IRC
13:59:48 *** Krzysiek_K has joined #gnucash
14:02:15 *** GabrieleV has quit IRC
14:02:15 *** GabrieleV_ has joined #gnucash
14:02:32 *** GabrieleV_ is now known as GabrieleV
14:05:29 *** mikee_ has joined #gnucash
14:05:30 *** mikee has quit IRC
14:05:39 *** mikee_ is now known as mikee
14:24:34 *** Krzysiek_K has left #gnucash
14:43:49 *** Abhish has quit IRC
14:44:01 *** Abhish has joined #gnucash
14:49:14 *** ErKa has joined #gnucash
15:22:41 *** himaxx has joined #gnucash
15:24:05 *** MechtiIde has joined #gnucash
15:24:08 *** himaxx has quit IRC
15:24:46 *** fabior has joined #gnucash
15:25:31 *** cartsoftware has joined #gnucash
16:01:08 *** fabior has quit IRC
16:04:08 *** fabior has joined #gnucash
16:06:00 *** MechtiIde has quit IRC
16:06:19 *** MagicFab has quit IRC
16:12:36 *** gjanssens has quit IRC
16:32:16 *** GabrieleV_ has joined #gnucash
16:32:34 *** GabrieleV has quit IRC
16:32:34 *** GabrieleV_ is now known as GabrieleV
16:40:17 *** MagicFab has joined #gnucash
17:10:48 *** aqua_ has joined #gnucash
17:27:26 *** fabior has quit IRC
17:51:48 *** wizkid239 has quit IRC
17:54:54 *** aqua_ has quit IRC
17:58:33 *** rickoehn has quit IRC
18:02:50 *** aqua_ has joined #gnucash
18:36:16 *** himaxx has joined #gnucash
18:48:07 *** himaxx has quit IRC
19:36:49 *** GabrieleV_ has joined #gnucash
19:36:53 *** GabrieleV has quit IRC
19:36:53 *** GabrieleV_ is now known as GabrieleV
19:51:12 *** StuM has joined #gnucash
20:24:45 *** lmat_ has joined #gnucash
20:28:38 *** lmat has quit IRC
20:33:38 *** Abhish has quit IRC
20:50:25 *** Jimraehl1 has quit IRC
20:50:44 *** Jimraehl1 has joined #gnucash
20:55:36 *** lmat_ has quit IRC
21:00:11 *** lmat has joined #gnucash
21:32:48 *** lmat has quit IRC
21:36:20 *** GabrieleV_ has joined #gnucash
21:36:55 *** GabrieleV has quit IRC
21:36:56 *** GabrieleV_ is now known as GabrieleV
22:02:06 *** ErKa has quit IRC
22:25:51 *** GabrieleV_ has joined #gnucash
22:26:31 *** GabrieleV has quit IRC
22:26:31 *** GabrieleV_ is now known as GabrieleV
22:36:41 *** Abhish has joined #gnucash
23:01:37 *** Coderjoe_ has joined #gnucash
23:05:52 *** Coderjoe has quit IRC
23:16:35 *** ErKa has joined #gnucash
23:34:30 *** wizkid238 has joined #gnucash
23:37:51 *** aqua_ has quit IRC
23:55:54 *** GabrieleV_ has joined #gnucash
23:55:57 *** GabrieleV has quit IRC
23:55:57 *** GabrieleV_ is now known as GabrieleV