Re: [GNC] - File Path for associated files
Yeah! Thanks a lot!! I couldn't get the gzip -d file.xml.gz to do the extesion renaming, but just used gzip -d file.gz and then renamed it after the decompression. All text replaced and all transaction links working fine!!! Thanks a lot to all !!! ( I even started learning about sed :) ) I would never have even started to know where to begin on this ! Thanks, John On 13/09/2018 06:42, Adrien Monteleone wrote: FYI, You don’t have to re-compress the file. I just opened the uncompressed version with GnuCash and it worked just fine. Regards, Adrien On Sep 12, 2018, at 5:21 PM, Stephen M. Butler wrote: On 09/12/2018 02:56 PM, John Sears via gnucash-user wrote: I tried gedit and atom .. but only seem to get gibberish..my first few lines.. ù "�a�`��0;��F%V����f�`uK@�S@�g�u�t|Ϭ�<>���==>=mx먞��r|���ݒ�O_��?��7���7~����o}�,ǧ}z��;���'���o�||�뗎O��~��w��{|.��~R��C?��{�=;�u�=�#.���\~Ƿ���yK?��{��>?;�=\_�|���ß^:���.��W}���g5?;;SH����.xu-b)g�����q����8��;�o�8���}{v���1��5Ϟ�?�~��w�'�>>�.l�z8��{�O�;��;zq̥i�=���U>+r?���(~����<��M痏��I��<�r���o�z��.\�⠷AU���}��=?��ώ�[�Fc,��V;+��5��e�����Ż^��Kħ�� ���?û��__zY��t;�O�[�_�t��'���__>|�t79���|�=��_}���g�s�z�ˏ�.�txy�r" I'll investigate sed I think this is a compressed file. Your earlier editor must have automatically uncompressed it. Perhaps why GNC couldn't open as it may have left it uncompressed. On my box I made a copy of the gnucash file and called it 'smb.gz' then the command 'uncompress smb.gz' worked great and left a file called 'smb' that I could open with vi. Sed should also be able to handle the resulting file. Just remember to compress it again and change the name back to the original (keep the original under a different name). --Steve PS. I forgot what strings you were changing but I used to use sed on a daily basis. So, if you need help just hit the list again. On 12/09/2018 23:53, Adrien Monteleone wrote: You should not need to manually mount any external drive like a USB key. It will automount for you in the /media part of the file tree as you noticed. Your issue is likely more as John noted that LO mucked up the XML. If you don’t want to attempt sed or nano, try Gedit (all come with Ubuntu) or Atom. (need to install that one separately) I’d have to say, sed is probably the fastest method but you’ll need to read over a few pages of sed command examples on replacing text, be mindful of escaping special characters like “/“ and “:”. Otherwise, Gedit and Atom are straight forward with no learning curve with Find & Replace operations similar to LO. Regards, Adrien On Sep 12, 2018, at 8:23 AM, John Sears via gnucash-user wrote: Hi, yep, I have no problem finding the files and opening them on the filing system ( naultilus) .. Although I have not done any mounting per se.. should I ? On 12/09/2018 21:17, Michael or Penny Novack wrote: On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: So my files were all stored on G:/documents/xxx.pdf Now that I have transferred to Linux, this path is not recognised - " GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" Is there a way to bulk edit the paths of all the links so that Linux will recognise the SD path? I would prefer not to go into every single transaction to do this, as I have a lot of linked files. Or is there someway ( and this might be more of a Linux question) to map the SD card to the "file:///G" terminology. Thanks! Been a while since I used a 'nix operating system and I don't know what modern linuxes might provide for "automounting". But in a traditional 'nix environment you don't just stick in removable devices. You also have to "mount" (and when removing, "umount") them. In other words, I think yours is a "new 'nix user" problem. Forget gnucash for a moment. Can you put a file (say a document) on a removable device and then plug that device into your 'nix machine and open it? The path will not be the same as in Windows. The path to the data (in linux) will depend on WHERE in the linux file system you mounted it? << The "mount" command will have specified that >> Michael Michael D Novack -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___
Re: [GNC] - File Path for associated files
On 09/12/2018 03:42 PM, Adrien Monteleone wrote: > FYI, You don’t have to re-compress the file. > > I just opened the uncompressed version with GnuCash and it worked just fine. > > Regards, > Adrien OK. I'll try to remember that. Feels a little lazy not returning 'em to the prior state. <> >> On Sep 12, 2018, at 5:21 PM, Stephen M. Butler wrote: >> >> On 09/12/2018 02:56 PM, John Sears via gnucash-user wrote: >>> I tried gedit and atom .. but only seem to get gibberish..my >>> first few lines.. ù >>> >>> "�a�`��0;��F%V����f�`uK@�S@�g�u�t|Ϭ�<>���==>=mx먞��r|���ݒ�O_��?��7���7~����o}�,ǧ}z��;���'���o�||�뗎O��~��w��{|.��~R��C?��{�=;�u�=�#.���\~Ƿ���yK?��{��>?;�=\_�|���ß^:���.��W}���g5?;;SH����.xu-b)g�����q����8��;�o�8���}{v���1��5Ϟ�?�~��w�'�>>�.l�z8��{�O�;��;zq̥i�=���U>+r?���(~����<��M痏��I��<�r���o�z��.\�⠷AU���}��=?��ώ�[�Fc,��V;+��5��e�����Ż^��Kħ�� >>> ���?û��__zY��t;�O�[�_�t��'���__>|�t79���|�=��_}���g�s�z�ˏ�.�txy�r" >>> >>> >>> >>> I'll investigate sed >>> >>> >> I think this is a compressed file. Your earlier editor must have >> automatically uncompressed it. Perhaps why GNC couldn't open as it may >> have left it uncompressed. On my box I made a copy of the gnucash file >> and called it 'smb.gz' then the command 'uncompress smb.gz' worked >> great and left a file called 'smb' that I could open with vi. Sed >> should also be able to handle the resulting file. >> >> Just remember to compress it again and change the name back to the >> original (keep the original under a different name). >> >> --Steve >> >> PS. I forgot what strings you were changing but I used to use sed on a >> daily basis. So, if you need help just hit the list again. >>> On 12/09/2018 23:53, Adrien Monteleone wrote: You should not need to manually mount any external drive like a USB key. It will automount for you in the /media part of the file tree as you noticed. Your issue is likely more as John noted that LO mucked up the XML. If you don’t want to attempt sed or nano, try Gedit (all come with Ubuntu) or Atom. (need to install that one separately) I’d have to say, sed is probably the fastest method but you’ll need to read over a few pages of sed command examples on replacing text, be mindful of escaping special characters like “/“ and “:”. Otherwise, Gedit and Atom are straight forward with no learning curve with Find & Replace operations similar to LO. Regards, Adrien > On Sep 12, 2018, at 8:23 AM, John Sears via gnucash-user > wrote: > > Hi, > > yep, I have no problem finding the files and opening them on the > filing system ( naultilus) .. > > Although I have not done any mounting per se.. should I ? > > > > On 12/09/2018 21:17, Michael or Penny Novack wrote: >> On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: >> >>> So my files were all stored on G:/documents/xxx.pdf >>> >>> Now that I have transferred to Linux, this path is not recognised - " >>> GNUCash could not open the associated URI: >>> file:///G:/documents/xxx.pdf" >>> >>> Is there a way to bulk edit the paths of all the links so that Linux >>> will recognise the SD path? I would prefer not to go into every >>> single transaction to do this, as I have a lot of linked files. >>> >>> Or is there someway ( and this might be more of a Linux question) >>> to map >>> the SD card to the "file:///G" terminology. >>> >>> Thanks! >> Been a while since I used a 'nix operating system and I don't >> know what modern linuxes might provide for "automounting". But in a >> traditional 'nix environment you don't just stick in removable >> devices. You also have to "mount" (and when removing, "umount") them. >> >> In other words, I think yours is a "new 'nix user" problem. Forget >> gnucash for a moment. Can you put a file (say a document) on a >> removable device and then plug that device into your 'nix machine >> and open it? The path will not be the same as in Windows. The path >> to the data (in linux) will depend on WHERE in the linux file >> system you mounted it? << The "mount" command will have specified >> that >> >> >> Michael >> >> Michael D Novack >> -- >> Stephen M Butler, PMP, PSM >> stephen.m.butle...@gmail.com >> kg...@arrl.net >> 253-350-0166 >> --- >> GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If y
Re: [GNC] - File Path for associated files
FYI, You don’t have to re-compress the file. I just opened the uncompressed version with GnuCash and it worked just fine. Regards, Adrien > On Sep 12, 2018, at 5:21 PM, Stephen M. Butler wrote: > > On 09/12/2018 02:56 PM, John Sears via gnucash-user wrote: >> I tried gedit and atom .. but only seem to get gibberish..my >> first few lines.. ù >> >> "�a�`��0;��F%V����f�`uK@�S@�g�u�t|Ϭ�<>���==>=mx먞��r|���ݒ�O_��?��7���7~����o}�,ǧ}z��;���'���o�||�뗎O��~��w��{|.��~R��C?��{�=;�u�=�#.���\~Ƿ���yK?��{��>?;�=\_�|���ß^:���.��W}���g5?;;SH����.xu-b)g�����q����8��;�o�8���}{v���1��5Ϟ�?�~��w�'�>>�.l�z8��{�O�;��;zq̥i�=���U>+r?���(~����<��M痏��I��<�r���o�z��.\�⠷AU���}��=?��ώ�[�Fc,��V;+��5��e�����Ż^��Kħ�� >> ���?û��__zY��t;�O�[�_�t��'���__>|�t79���|�=��_}���g�s�z�ˏ�.�txy�r" >> >> >> >> I'll investigate sed >> >> > > I think this is a compressed file. Your earlier editor must have > automatically uncompressed it. Perhaps why GNC couldn't open as it may > have left it uncompressed. On my box I made a copy of the gnucash file > and called it 'smb.gz' then the command 'uncompress smb.gz' worked > great and left a file called 'smb' that I could open with vi. Sed > should also be able to handle the resulting file. > > Just remember to compress it again and change the name back to the > original (keep the original under a different name). > > --Steve > > PS. I forgot what strings you were changing but I used to use sed on a > daily basis. So, if you need help just hit the list again. >> On 12/09/2018 23:53, Adrien Monteleone wrote: >>> You should not need to manually mount any external drive like a USB >>> key. It will automount for you in the /media part of the file tree as >>> you noticed. >>> >>> Your issue is likely more as John noted that LO mucked up the XML. If >>> you don’t want to attempt sed or nano, try Gedit (all come with >>> Ubuntu) or Atom. (need to install that one separately) >>> >>> I’d have to say, sed is probably the fastest method but you’ll need >>> to read over a few pages of sed command examples on replacing text, >>> be mindful of escaping special characters like “/“ and “:”. >>> Otherwise, Gedit and Atom are straight forward with no learning curve >>> with Find & Replace operations similar to LO. >>> >>> Regards, >>> Adrien >>> On Sep 12, 2018, at 8:23 AM, John Sears via gnucash-user wrote: Hi, yep, I have no problem finding the files and opening them on the filing system ( naultilus) .. Although I have not done any mounting per se.. should I ? On 12/09/2018 21:17, Michael or Penny Novack wrote: > On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: > >> So my files were all stored on G:/documents/xxx.pdf >> >> Now that I have transferred to Linux, this path is not recognised - " >> GNUCash could not open the associated URI: >> file:///G:/documents/xxx.pdf" >> >> Is there a way to bulk edit the paths of all the links so that Linux >> will recognise the SD path? I would prefer not to go into every >> single transaction to do this, as I have a lot of linked files. >> >> Or is there someway ( and this might be more of a Linux question) >> to map >> the SD card to the "file:///G" terminology. >> >> Thanks! > Been a while since I used a 'nix operating system and I don't > know what modern linuxes might provide for "automounting". But in a > traditional 'nix environment you don't just stick in removable > devices. You also have to "mount" (and when removing, "umount") them. > > In other words, I think yours is a "new 'nix user" problem. Forget > gnucash for a moment. Can you put a file (say a document) on a > removable device and then plug that device into your 'nix machine > and open it? The path will not be the same as in Windows. The path > to the data (in linux) will depend on WHERE in the linux file > system you mounted it? << The "mount" command will have specified > that >> > > Michael > > Michael D Novack > > -- > Stephen M Butler, PMP, PSM > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > --- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-Al
Re: [GNC] - File Path for associated files
On 09/12/2018 02:56 PM, John Sears via gnucash-user wrote: > I tried gedit and atom .. but only seem to get gibberish.. my > first few lines.. ù > > "�a�`��0;��F%V����f�`uK@�S@�g�u�t|Ϭ�<>���==>=mx먞��r|���ݒ�O_��?��7���7~����o}�,ǧ}z��;���'���o�||�뗎O��~��w��{|.��~R��C?��{�=;�u�=�#.���\~Ƿ���yK?��{��>?;�=\_�|���ß^:���.��W}���g5?;;SH����.xu-b)g�����q����8��;�o�8���}{v���1��5Ϟ�?�~��w�'�>>�.l�z8��{�O�;��;zq̥i�=���U>+r?���(~����<��M痏��I��<�r���o�z��.\�⠷AU���}��=?��ώ�[�Fc,��V;+��5��e�����Ż^��Kħ�� > ���?û��__zY��t;�O�[�_�t��'���__>|�t79���|�=��_}���g�s�z�ˏ�.�txy�r" > > > > I'll investigate sed > > I think this is a compressed file. Your earlier editor must have automatically uncompressed it. Perhaps why GNC couldn't open as it may have left it uncompressed. On my box I made a copy of the gnucash file and called it 'smb.gz' then the command 'uncompress smb.gz' worked great and left a file called 'smb' that I could open with vi. Sed should also be able to handle the resulting file. Just remember to compress it again and change the name back to the original (keep the original under a different name). --Steve PS. I forgot what strings you were changing but I used to use sed on a daily basis. So, if you need help just hit the list again. > On 12/09/2018 23:53, Adrien Monteleone wrote: >> You should not need to manually mount any external drive like a USB >> key. It will automount for you in the /media part of the file tree as >> you noticed. >> >> Your issue is likely more as John noted that LO mucked up the XML. If >> you don’t want to attempt sed or nano, try Gedit (all come with >> Ubuntu) or Atom. (need to install that one separately) >> >> I’d have to say, sed is probably the fastest method but you’ll need >> to read over a few pages of sed command examples on replacing text, >> be mindful of escaping special characters like “/“ and “:”. >> Otherwise, Gedit and Atom are straight forward with no learning curve >> with Find & Replace operations similar to LO. >> >> Regards, >> Adrien >> >>> On Sep 12, 2018, at 8:23 AM, John Sears via gnucash-user >>> wrote: >>> >>> Hi, >>> >>> yep, I have no problem finding the files and opening them on the >>> filing system ( naultilus) .. >>> >>> Although I have not done any mounting per se.. should I ? >>> >>> >>> >>> On 12/09/2018 21:17, Michael or Penny Novack wrote: On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: > So my files were all stored on G:/documents/xxx.pdf > > Now that I have transferred to Linux, this path is not recognised - " > GNUCash could not open the associated URI: > file:///G:/documents/xxx.pdf" > > Is there a way to bulk edit the paths of all the links so that Linux > will recognise the SD path? I would prefer not to go into every > single transaction to do this, as I have a lot of linked files. > > Or is there someway ( and this might be more of a Linux question) > to map > the SD card to the "file:///G" terminology. > > Thanks! Been a while since I used a 'nix operating system and I don't know what modern linuxes might provide for "automounting". But in a traditional 'nix environment you don't just stick in removable devices. You also have to "mount" (and when removing, "umount") them. In other words, I think yours is a "new 'nix user" problem. Forget gnucash for a moment. Can you put a file (say a document) on a removable device and then plug that device into your 'nix machine and open it? The path will not be the same as in Windows. The path to the data (in linux) will depend on WHERE in the linux file system you mounted it? << The "mount" command will have specified that >> Michael Michael D Novack -- Stephen M Butler, PMP, PSM stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
The file *is* compressed. Opening a non-compressed version of the file will get you something like this: http://www.gnucash.org/XML/gnc"; xmlns:act="http://www.gnucash.org/XML/act"; xmlns:book="http://www.gnucash.org/XML/book"; xmlns:cd=“http://www.gnucash.org/XML/cd"; ... etc. Rename the copy, removing the .gnucash and replace it with .gz In a terminal, use the gzip -d command to decompress the file. Something like this: gzip -d mybook.xml.gz It will rename it to .xml, stripping the .gz extension. (unless you specified an outfile parameter in the gzip command) NOW, open the .xml file in gedit or atom. You’ll see something like I showed above. Then do a Find/Replace on your file paths, and make certain that all path separators are “/“ and not “\”. You don’t need to recompress the file, just rename it to .gnucash and open it from the File menu of GnuCash. When you next save it, GnuCash will re-compress it. Regards, Adrien > On Sep 12, 2018, at 4:56 PM, John Sears via gnucash-user > wrote: > > I tried gedit and atom .. but only seem to get gibberish..my first few > lines.. ù > > "�a�`��0;��F%V����f�`uK@�S@�g�u�t|Ϭ�<>���==>=mx먞��r|���ݒ�O_��?��7���7~����o}�,ǧ}z��;���'���o�||�뗎O��~��w��{|.��~R��C?��{�=;�u�=�#.���\~Ƿ���yK?��{��>?;�=\_�|���ß^:���.��W}���g5?;;SH����.xu-b)g�����q����8��;�o�8���}{v���1��5Ϟ�?�~��w�'�>>�.l�z8��{�O�;��;zq̥i�=���U>+r?���(~����<��M痏��I��<�r���o�z��.\�⠷AU���}��=?��ώ�[�Fc,��V;+��5��e�����Ż^��Kħ�� > > ���?û��__zY��t;�O�[�_�t��'���__>|�t79���|�=��_}���g�s�z�ˏ�.�txy�r" > > > I'll investigate sed > > > On 12/09/2018 23:53, Adrien Monteleone wrote: >> You should not need to manually mount any external drive like a USB key. It >> will automount for you in the /media part of the file tree as you noticed. >> >> Your issue is likely more as John noted that LO mucked up the XML. If you >> don’t want to attempt sed or nano, try Gedit (all come with Ubuntu) or Atom. >> (need to install that one separately) >> >> I’d have to say, sed is probably the fastest method but you’ll need to read >> over a few pages of sed command examples on replacing text, be mindful of >> escaping special characters like “/“ and “:”. Otherwise, Gedit and Atom are >> straight forward with no learning curve with Find & Replace operations >> similar to LO. >> >> Regards, >> Adrien >> >>> On Sep 12, 2018, at 8:23 AM, John Sears via gnucash-user >>> wrote: >>> >>> Hi, >>> >>> yep, I have no problem finding the files and opening them on the filing >>> system ( naultilus) .. >>> >>> Although I have not done any mounting per se.. should I ? >>> >>> >>> >>> On 12/09/2018 21:17, Michael or Penny Novack wrote: On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: > So my files were all stored on G:/documents/xxx.pdf > > Now that I have transferred to Linux, this path is not recognised - " > GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" > > Is there a way to bulk edit the paths of all the links so that Linux > will recognise the SD path? I would prefer not to go into every > single transaction to do this, as I have a lot of linked files. > > Or is there someway ( and this might be more of a Linux question) to map > the SD card to the "file:///G" terminology. > > Thanks! Been a while since I used a 'nix operating system and I don't know what modern linuxes might provide for "automounting". But in a traditional 'nix environment you don't just stick in removable devices. You also have to "mount" (and when removing, "umount") them. In other words, I think yours is a "new 'nix user" problem. Forget gnucash for a moment. Can you put a file (say a document) on a removable device and then plug that device into your 'nix machine and open it? The path will not be the same as in Windows. The path to the data (in linux) will depend on WHERE in the linux file system you mounted it? << The "mount" command will have specified that >> Michael Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>>
Re: [GNC] - File Path for associated files
I tried gedit and atom .. but only seem to get gibberish.. my first few lines.. ù "�a�`��0;��F%V����f�`uK@�S@�g�u�t|Ϭ�<>���==>=mx먞��r|���ݒ�O_��?��7���7~����o}�,ǧ}z��;���'���o�||�뗎O��~��w��{|.��~R��C?��{�=;�u�=�#.���\~Ƿ���yK?��{��>?;�=\_�|���ß^:���.��W}���g5?;;SH����.xu-b)g�����q����8��;�o�8���}{v���1��5Ϟ�?�~��w�'�>>�.l�z8��{�O�;��;zq̥i�=���U>+r?���(~����<��M痏��I��<�r���o�z��.\�⠷AU���}��=?��ώ�[�Fc,��V;+��5��e�����Ż^��Kħ�� ���?û��__zY��t;�O�[�_�t��'���__>|�t79���|�=��_}���g�s�z�ˏ�.�txy�r" I'll investigate sed On 12/09/2018 23:53, Adrien Monteleone wrote: You should not need to manually mount any external drive like a USB key. It will automount for you in the /media part of the file tree as you noticed. Your issue is likely more as John noted that LO mucked up the XML. If you don’t want to attempt sed or nano, try Gedit (all come with Ubuntu) or Atom. (need to install that one separately) I’d have to say, sed is probably the fastest method but you’ll need to read over a few pages of sed command examples on replacing text, be mindful of escaping special characters like “/“ and “:”. Otherwise, Gedit and Atom are straight forward with no learning curve with Find & Replace operations similar to LO. Regards, Adrien On Sep 12, 2018, at 8:23 AM, John Sears via gnucash-user wrote: Hi, yep, I have no problem finding the files and opening them on the filing system ( naultilus) .. Although I have not done any mounting per se.. should I ? On 12/09/2018 21:17, Michael or Penny Novack wrote: On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: So my files were all stored on G:/documents/xxx.pdf Now that I have transferred to Linux, this path is not recognised - " GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" Is there a way to bulk edit the paths of all the links so that Linux will recognise the SD path? I would prefer not to go into every single transaction to do this, as I have a lot of linked files. Or is there someway ( and this might be more of a Linux question) to map the SD card to the "file:///G" terminology. Thanks! Been a while since I used a 'nix operating system and I don't know what modern linuxes might provide for "automounting". But in a traditional 'nix environment you don't just stick in removable devices. You also have to "mount" (and when removing, "umount") them. In other words, I think yours is a "new 'nix user" problem. Forget gnucash for a moment. Can you put a file (say a document) on a removable device and then plug that device into your 'nix machine and open it? The path will not be the same as in Windows. The path to the data (in linux) will depend on WHERE in the linux file system you mounted it? << The "mount" command will have specified that >> Michael Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
You should not need to manually mount any external drive like a USB key. It will automount for you in the /media part of the file tree as you noticed. Your issue is likely more as John noted that LO mucked up the XML. If you don’t want to attempt sed or nano, try Gedit (all come with Ubuntu) or Atom. (need to install that one separately) I’d have to say, sed is probably the fastest method but you’ll need to read over a few pages of sed command examples on replacing text, be mindful of escaping special characters like “/“ and “:”. Otherwise, Gedit and Atom are straight forward with no learning curve with Find & Replace operations similar to LO. Regards, Adrien > On Sep 12, 2018, at 8:23 AM, John Sears via gnucash-user > wrote: > > Hi, > > yep, I have no problem finding the files and opening them on the filing > system ( naultilus) .. > > Although I have not done any mounting per se.. should I ? > > > > On 12/09/2018 21:17, Michael or Penny Novack wrote: >> On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: >> >>> So my files were all stored on G:/documents/xxx.pdf >>> >>> Now that I have transferred to Linux, this path is not recognised - " >>> GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" >>> >>> Is there a way to bulk edit the paths of all the links so that Linux >>> will recognise the SD path? I would prefer not to go into every >>> single transaction to do this, as I have a lot of linked files. >>> >>> Or is there someway ( and this might be more of a Linux question) to map >>> the SD card to the "file:///G" terminology. >>> >>> Thanks! >> Been a while since I used a 'nix operating system and I don't know what >> modern linuxes might provide for "automounting". But in a traditional 'nix >> environment you don't just stick in removable devices. You also have to >> "mount" (and when removing, "umount") them. >> >> In other words, I think yours is a "new 'nix user" problem. Forget gnucash >> for a moment. Can you put a file (say a document) on a removable device and >> then plug that device into your 'nix machine and open it? The path will not >> be the same as in Windows. The path to the data (in linux) will depend on >> WHERE in the linux file system you mounted it? << The "mount" command will >> have specified that >> >> >> Michael >> >> Michael D Novack >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
The new nano 3.0 is now very fast at opening large files. (for those to skittish to jump into vim and emacs) Regards, Adrien > On Sep 12, 2018, at 8:37 AM, John Ralls wrote: > > LibreOffice is a word processor with its own XML features. It very likely > didn’t preserve GnuCash’s XML but instead substituted its own. Try again > using a plain text editor like vi, vim, emacs, etc. > > Regards, > John Ralls > > >> On Sep 12, 2018, at 4:42 AM, John Sears via gnucash-user >> wrote: >> >> Hi , >> >> My file doesn't seem to be compressed. I managed to open it up directly in >> LibreOffice Word and do the replacement. and then save the file as a .xml. >> ( over 9000 pages !) >> >> I don't seem to be able to open this XML file in GNC.. I get the "No >> suitable backend was found for /media/john/USB DISK/trialgnucash2.gnucash." >> >> Any ideas? >> >> I'm sorry if these are such newbie quesions :( >> >> Thanks John >> >> GNC 2.6.19 >> >> >> On 12/09/2018 11:49, Adrien Monteleone wrote: >>> Perhaps someone else who’s come across this might offer some tips, but >>> here’s how I’d approach it: >>> >>> Your data file (if using the default backend) is just an XML file that is >>> compressed. >>> >>> Uncompress it (with tar) and use either your favorite text editor or sed >>> command to conduct a find&replace. >>> >>> If you’re using one of the SQL backends, you can run an UPDATE command to >>> replace the given text. (research this command well for your particular >>> backend before proceeding) >>> >>> You only need to replace the “G:/documents” or whatever you used part of >>> the file path, not the actual pdf file name. If the bulk of the path is the >>> same as before, just say mounted on /media instead of G:/ then you only >>> need to replace “G:” with “/media” (the slash left over after “:” will >>> continue the path) >>> >>> In any case, I’d work on a copy of your data file and then check it out to >>> make sure everything is fine. Then perhaps store the non-modified copy as >>> an extra backup just in case you find a problem down the road. >>> >>> Don’t forget to change your default path in GnuCash preferences. >>> >>> Regards, >>> Adrien >>> On Sep 11, 2018, at 7:00 PM, John Sears via gnucash-user wrote: When using the associate files function for a transaction within GNUCash on Windows, I stored all of my pdfs on an external USB/ SD card. Windows mapped this address with a letter, G, in this case. ( I also store my accounts on this same card now) So my files were all stored on G:/documents/xxx.pdf Now that I have transferred to Linux, this path is not recognised - " GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" Is there a way to bulk edit the paths of all the links so that Linux will recognise the SD path? I would prefer not to go into every single transaction to do this, as I have a lot of linked files. Or is there someway ( and this might be more of a Linux question) to map the SD card to the "file:///G" terminology. Thanks! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC t
Re: [GNC] - File Path for associated files
Geert, what I'm hearing you say is that someone actually built a time machine and went back in time and implemented my idea. I didn't think it was all that great of an idea, but what you are suggesting makes a lot of sense. 😊 Thanks, I never noticed that! Michael On Wed, Sep 12, 2018 at 9:08 AM, Geert Janssens wrote: > Op woensdag 12 september 2018 15:45:17 CEST schreef Fross, Michael: > > Directly editing the XML files is really scary to me. Seems like it > would > > be simple, but scary. > > > > One idea for the future is to have a GNUCash configured Associated Files > > directory. This would be the root of all associated files. In the > > datafile, the filepath would originate from this directory. A user could > > move these files to a new location with a simple UI directory update in > > preferences. > > > > For example: > > > > GNUCash Associated Directory=C:\Gnucash\AssociatedFiles > > > > Files: > > C:\Gnucash\AssociatedFiles\file1 > > C:\Gnucash\AssociatedFiles\launderedmoney\file2 > > C:\Gnucash\AssociatedFiles\fencedgoods\file3 > > > > Then in the XML files, the paths would be stored as: > > > > GNUCashAssociatedFiles/file1 > > GNUCashAssociatedFiles/launderedmoney\file2 > > GNUCashAssociatedFiles/fencedgoods\file3 > > > > Thoughts? > > > It's there already (though perhaps only in 3.x): > Preferences->General->Path Head for Transaction Association Files > > I have no idea if changing this would do anything with absolute path names > already in the book. And I would doubt very much I would be able to do > something with Windows paths on a linux system. But for future > associations > this should help. > > Geert > > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
Op woensdag 12 september 2018 15:45:17 CEST schreef Fross, Michael: > Directly editing the XML files is really scary to me. Seems like it would > be simple, but scary. > > One idea for the future is to have a GNUCash configured Associated Files > directory. This would be the root of all associated files. In the > datafile, the filepath would originate from this directory. A user could > move these files to a new location with a simple UI directory update in > preferences. > > For example: > > GNUCash Associated Directory=C:\Gnucash\AssociatedFiles > > Files: > C:\Gnucash\AssociatedFiles\file1 > C:\Gnucash\AssociatedFiles\launderedmoney\file2 > C:\Gnucash\AssociatedFiles\fencedgoods\file3 > > Then in the XML files, the paths would be stored as: > > GNUCashAssociatedFiles/file1 > GNUCashAssociatedFiles/launderedmoney\file2 > GNUCashAssociatedFiles/fencedgoods\file3 > > Thoughts? > It's there already (though perhaps only in 3.x): Preferences->General->Path Head for Transaction Association Files I have no idea if changing this would do anything with absolute path names already in the book. And I would doubt very much I would be able to do something with Windows paths on a linux system. But for future associations this should help. Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
Directly editing the XML files is really scary to me. Seems like it would be simple, but scary. One idea for the future is to have a GNUCash configured Associated Files directory. This would be the root of all associated files. In the datafile, the filepath would originate from this directory. A user could move these files to a new location with a simple UI directory update in preferences. For example: GNUCash Associated Directory=C:\Gnucash\AssociatedFiles Files: C:\Gnucash\AssociatedFiles\file1 C:\Gnucash\AssociatedFiles\launderedmoney\file2 C:\Gnucash\AssociatedFiles\fencedgoods\file3 Then in the XML files, the paths would be stored as: GNUCashAssociatedFiles/file1 GNUCashAssociatedFiles/launderedmoney\file2 GNUCashAssociatedFiles/fencedgoods\file3 Thoughts? Michael On Wed, Sep 12, 2018 at 8:23 AM, John Sears via gnucash-user < gnucash-user@gnucash.org> wrote: > Hi, > > yep, I have no problem finding the files and opening them on the filing > system ( naultilus) .. > > Although I have not done any mounting per se.. should I ? > > > > > On 12/09/2018 21:17, Michael or Penny Novack wrote: > >> On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: >> >> So my files were all stored on G:/documents/xxx.pdf >>> >>> Now that I have transferred to Linux, this path is not recognised - " >>> GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" >>> >>> Is there a way to bulk edit the paths of all the links so that Linux >>> will recognise the SD path? I would prefer not to go into every >>> single transaction to do this, as I have a lot of linked files. >>> >>> Or is there someway ( and this might be more of a Linux question) to map >>> the SD card to the "file:///G" terminology. >>> >>> Thanks! >>> >> Been a while since I used a 'nix operating system and I don't know what >> modern linuxes might provide for "automounting". But in a traditional 'nix >> environment you don't just stick in removable devices. You also have to >> "mount" (and when removing, "umount") them. >> >> In other words, I think yours is a "new 'nix user" problem. Forget >> gnucash for a moment. Can you put a file (say a document) on a removable >> device and then plug that device into your 'nix machine and open it? The >> path will not be the same as in Windows. The path to the data (in linux) >> will depend on WHERE in the linux file system you mounted it? << The >> "mount" command will have specified that >> >> >> Michael >> >> Michael D Novack >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
LibreOffice is a word processor with its own XML features. It very likely didn’t preserve GnuCash’s XML but instead substituted its own. Try again using a plain text editor like vi, vim, emacs, etc. Regards, John Ralls > On Sep 12, 2018, at 4:42 AM, John Sears via gnucash-user > wrote: > > Hi , > > My file doesn't seem to be compressed. I managed to open it up directly in > LibreOffice Word and do the replacement. and then save the file as a .xml. ( > over 9000 pages !) > > I don't seem to be able to open this XML file in GNC.. I get the "No > suitable backend was found for /media/john/USB DISK/trialgnucash2.gnucash." > > Any ideas? > > I'm sorry if these are such newbie quesions :( > > Thanks John > > GNC 2.6.19 > > > On 12/09/2018 11:49, Adrien Monteleone wrote: >> Perhaps someone else who’s come across this might offer some tips, but >> here’s how I’d approach it: >> >> Your data file (if using the default backend) is just an XML file that is >> compressed. >> >> Uncompress it (with tar) and use either your favorite text editor or sed >> command to conduct a find&replace. >> >> If you’re using one of the SQL backends, you can run an UPDATE command to >> replace the given text. (research this command well for your particular >> backend before proceeding) >> >> You only need to replace the “G:/documents” or whatever you used part of the >> file path, not the actual pdf file name. If the bulk of the path is the same >> as before, just say mounted on /media instead of G:/ then you only need to >> replace “G:” with “/media” (the slash left over after “:” will continue the >> path) >> >> In any case, I’d work on a copy of your data file and then check it out to >> make sure everything is fine. Then perhaps store the non-modified copy as an >> extra backup just in case you find a problem down the road. >> >> Don’t forget to change your default path in GnuCash preferences. >> >> Regards, >> Adrien >> >>> On Sep 11, 2018, at 7:00 PM, John Sears via gnucash-user >>> wrote: >>> >>> When using the associate files function for a transaction within >>> GNUCash on Windows, I stored all of my pdfs on an external USB/ SD >>> card. Windows mapped this address with a letter, G, in this case. ( I >>> also store my accounts on this same card now) >>> >>> So my files were all stored on G:/documents/xxx.pdf >>> >>> Now that I have transferred to Linux, this path is not recognised - " >>> GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" >>> >>> Is there a way to bulk edit the paths of all the links so that Linux >>> will recognise the SD path? I would prefer not to go into every >>> single transaction to do this, as I have a lot of linked files. >>> >>> Or is there someway ( and this might be more of a Linux question) to map >>> the SD card to the "file:///G" terminology. >>> >>> Thanks! >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
Hi, yep, I have no problem finding the files and opening them on the filing system ( naultilus) .. Although I have not done any mounting per se.. should I ? On 12/09/2018 21:17, Michael or Penny Novack wrote: On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: So my files were all stored on G:/documents/xxx.pdf Now that I have transferred to Linux, this path is not recognised - " GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" Is there a way to bulk edit the paths of all the links so that Linux will recognise the SD path? I would prefer not to go into every single transaction to do this, as I have a lot of linked files. Or is there someway ( and this might be more of a Linux question) to map the SD card to the "file:///G" terminology. Thanks! Been a while since I used a 'nix operating system and I don't know what modern linuxes might provide for "automounting". But in a traditional 'nix environment you don't just stick in removable devices. You also have to "mount" (and when removing, "umount") them. In other words, I think yours is a "new 'nix user" problem. Forget gnucash for a moment. Can you put a file (say a document) on a removable device and then plug that device into your 'nix machine and open it? The path will not be the same as in Windows. The path to the data (in linux) will depend on WHERE in the linux file system you mounted it? << The "mount" command will have specified that >> Michael Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
On 9/11/2018 8:00 PM, John Sears via gnucash-user wrote: So my files were all stored on G:/documents/xxx.pdf Now that I have transferred to Linux, this path is not recognised - " GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" Is there a way to bulk edit the paths of all the links so that Linux will recognise the SD path? I would prefer not to go into every single transaction to do this, as I have a lot of linked files. Or is there someway ( and this might be more of a Linux question) to map the SD card to the "file:///G" terminology. Thanks! Been a while since I used a 'nix operating system and I don't know what modern linuxes might provide for "automounting". But in a traditional 'nix environment you don't just stick in removable devices. You also have to "mount" (and when removing, "umount") them. In other words, I think yours is a "new 'nix user" problem. Forget gnucash for a moment. Can you put a file (say a document) on a removable device and then plug that device into your 'nix machine and open it? The path will not be the same as in Windows. The path to the data (in linux) will depend on WHERE in the linux file system you mounted it? << The "mount" command will have specified that >> Michael Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
Hi , My file doesn't seem to be compressed. I managed to open it up directly in LibreOffice Word and do the replacement. and then save the file as a .xml. ( over 9000 pages !) I don't seem to be able to open this XML file in GNC.. I get the "No suitable backend was found for /media/john/USB DISK/trialgnucash2.gnucash." Any ideas? I'm sorry if these are such newbie quesions :( Thanks John GNC 2.6.19 On 12/09/2018 11:49, Adrien Monteleone wrote: Perhaps someone else who’s come across this might offer some tips, but here’s how I’d approach it: Your data file (if using the default backend) is just an XML file that is compressed. Uncompress it (with tar) and use either your favorite text editor or sed command to conduct a find&replace. If you’re using one of the SQL backends, you can run an UPDATE command to replace the given text. (research this command well for your particular backend before proceeding) You only need to replace the “G:/documents” or whatever you used part of the file path, not the actual pdf file name. If the bulk of the path is the same as before, just say mounted on /media instead of G:/ then you only need to replace “G:” with “/media” (the slash left over after “:” will continue the path) In any case, I’d work on a copy of your data file and then check it out to make sure everything is fine. Then perhaps store the non-modified copy as an extra backup just in case you find a problem down the road. Don’t forget to change your default path in GnuCash preferences. Regards, Adrien On Sep 11, 2018, at 7:00 PM, John Sears via gnucash-user wrote: When using the associate files function for a transaction within GNUCash on Windows, I stored all of my pdfs on an external USB/ SD card. Windows mapped this address with a letter, G, in this case. ( I also store my accounts on this same card now) So my files were all stored on G:/documents/xxx.pdf Now that I have transferred to Linux, this path is not recognised - " GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" Is there a way to bulk edit the paths of all the links so that Linux will recognise the SD path? I would prefer not to go into every single transaction to do this, as I have a lot of linked files. Or is there someway ( and this might be more of a Linux question) to map the SD card to the "file:///G" terminology. Thanks! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] - File Path for associated files
Perhaps someone else who’s come across this might offer some tips, but here’s how I’d approach it: Your data file (if using the default backend) is just an XML file that is compressed. Uncompress it (with tar) and use either your favorite text editor or sed command to conduct a find&replace. If you’re using one of the SQL backends, you can run an UPDATE command to replace the given text. (research this command well for your particular backend before proceeding) You only need to replace the “G:/documents” or whatever you used part of the file path, not the actual pdf file name. If the bulk of the path is the same as before, just say mounted on /media instead of G:/ then you only need to replace “G:” with “/media” (the slash left over after “:” will continue the path) In any case, I’d work on a copy of your data file and then check it out to make sure everything is fine. Then perhaps store the non-modified copy as an extra backup just in case you find a problem down the road. Don’t forget to change your default path in GnuCash preferences. Regards, Adrien > On Sep 11, 2018, at 7:00 PM, John Sears via gnucash-user > wrote: > > When using the associate files function for a transaction within > GNUCash on Windows, I stored all of my pdfs on an external USB/ SD > card. Windows mapped this address with a letter, G, in this case. ( I > also store my accounts on this same card now) > > So my files were all stored on G:/documents/xxx.pdf > > Now that I have transferred to Linux, this path is not recognised - " > GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" > > Is there a way to bulk edit the paths of all the links so that Linux > will recognise the SD path? I would prefer not to go into every > single transaction to do this, as I have a lot of linked files. > > Or is there someway ( and this might be more of a Linux question) to map > the SD card to the "file:///G" terminology. > > Thanks! > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] - File Path for associated files
When using the associate files function for a transaction within GNUCash on Windows, I stored all of my pdfs on an external USB/ SD card. Windows mapped this address with a letter, G, in this case. ( I also store my accounts on this same card now) So my files were all stored on G:/documents/xxx.pdf Now that I have transferred to Linux, this path is not recognised - " GNUCash could not open the associated URI: file:///G:/documents/xxx.pdf" Is there a way to bulk edit the paths of all the links so that Linux will recognise the SD path? I would prefer not to go into every single transaction to do this, as I have a lot of linked files. Or is there someway ( and this might be more of a Linux question) to map the SD card to the "file:///G" terminology. Thanks! ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.