Re: [GNC] GUID Register Codes
*note, while there are many ways to view the tables in one of the SQL backends, an easy one is to use the SQLite manager plugin for Firefox with the SQLite3 backend. (it is an older type plugin, so I keep a copy of Waterfox Classic around to use it.) Or you could use DBeaver database tool - Win Mac and Linux Free versions https://dbeaver.io/ Very useful and covers a wide range of databases. On Sat, 30 Dec 2023 at 04:09, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > That's how I would do it with the XML backend too. > > If you are crafty with scripts, you can likely create a table/file, > mapping the account names to GUIDs for future reference. > > or, > > Switch to one of the SQL backends and write a query, or just examine the > "accounts" table directly. Of course, in this case, you have the added > complication that only the end leaf account names are saved in plain > text. But the 'parent GUID' is also stored, so it is possible to sort > out similarly named accounts. > > *note, while there are many ways to view the tables in one of the SQL > backends, an easy one is to use the SQLite manager plugin for Firefox > with the SQLite3 backend. (it is an older type plugin, so I keep a copy > of Waterfox Classic around to use it.) > > Regards, > Adrien > > On 12/29/23 6:56 PM, Jim DeLaHunt wrote: > > Stephen: > > > > I can't answer your question fully, but I can give you some insight. > > > > "GUID" stands for "Globally Unique Identifier". Each GUID is a large > > number, which is generated in such a way that it is highly likely to be > > different than any other GUID generated on any computer at any time > > according to the same rules. On the other hand, the same GUID value > > might show up in multiple places. Sometimes software developers generate > > a GUID and embed it their code, so that everyone gets a copy of the same > > GUID value. Another name for GUID is UUID, meaning "Universally" instead > > of "Globally". > > > > GUIDs are written to SQL databases, but they are not a creature of SQL. > > GnuCash also generates them when the book file is stored in XML form (as > > a ".gnucash" file). And, because they are globally unique, it is > > likely that your book contains different GUIDs than anybody else's book. > > Each account has a GUID associated, but there is no reason to believe > > that anyone else will have the same GUIDs for their accounts as you have > > for yours. > > > > I don't have an easy way to find out which GUID corresponds what account > > or other object. My way of doing that is to save my book as an XML file, > > open the file with a text editor, and search for the GUID value. > > Somewhere in the file will be data which defines the account, and it > > will include the GUID value and account name in close proximity. But > > that may or may not be the best way for you to proceed. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GUID Register Codes
On 2023-12-29 22:53, Stephen wrote: …Having the GUID … could have GUIDed me perhaps. I really appreciate y'alls help. I saw what you did there. Bravo! —Jim "I am not a dad but I tell dad jokes" DeLaHunt ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GUID Register Codes
Thanks everyone! Just what I needed to get over the hump. As David Cousens wrote there is usually no need to know what these codes are or to access them. In my case I was mostly and merely curious how things work but I did have the idea to adjust column sizes to be uniform across all or most accounts by editing the .gcm file. Having the GUID associated with a particular account that was either the model or perhaps the exception (because of the specifics of the transfers length maybe?) could have GUIDed me perhaps. I really appreciate y'alls help. On 12/29/2023 11:38 PM, David Cousens wrote: Stephen, The GUUIDs are used internally within the GnuCash code to identify an account/register.Each GUUID is associated with a specific account name and position in the account tree heirarchy. There is usually no need for a user to know what they are or to access them except in advanced debugging of the code. If you save your data file in uncompressed XML format ( not in the same location your data file is usually stored in, e.g. use the Downloads directory to store the uncmpressed data file) with the compress files checkbox unchecked in the General Tab of the Edit Preferences menu to a location on your hard disk you, you can open the xml format file with a text editor. Then do file save as and save the file in the format you normally use so GnuCash is again pointing at your normal data file and not the uncompressed xml vesion you have just created. If you open both the corresponding .gcm file and the uncompressed data file in the text editor you can copy the guid from the .gcm file and then search for it in the uncompressed xml version of the datafile. The account tree data is located within tags of the form and will contain a records of the form Cash in Wallet 8ad4a8287286721a15ca3df0e1d1325a among others. If you copy the guuid of the register you want to identify from the .gcm file and search for a record with copied guuid in the uncompressed xml data file you will be able to identify the account name and the other account data associated with the register. Only ever do this on a copy of your datafile not the original as the risk of making the datafile unusable if you accidentally change anything and then save the changes to the file is quite high.Preferrably always keep an unedited backup copy of the data file as well jut to be sure. David Cousens On Fri, 2023-12-29 at 17:30 -0600, Stephen wrote: The previous postings about "Balance Column Lost" have led me to ask about GUID register codes as I repaired some column width problems. By trial and error I was able to modify the .GCM file to repair the width of a couple of columns that I had narrowed (not to 0 or 1 but 5). Adrien Monteleone's guidance worked very well although scrolling looking for a small width was faster than a search after 0 and 1 produced no results. So Thanks! I am still stumped by the registries GUID codes. How can I find out which register is referenced by each of the GUID codes, please? I have a feeling that it may have something to do with SQL but that too has eluded me in past efforts open SQL files and make any sense of it. Appreciate any guidance...the more simple the better! Thank you. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GUID Register Codes
Stephen, The GUUIDs are used internally within the GnuCash code to identify an account/register.Each GUUID is associated with a specific account name and position in the account tree heirarchy. There is usually no need for a user to know what they are or to access them except in advanced debugging of the code. If you save your data file in uncompressed XML format ( not in the same location your data file is usually stored in, e.g. use the Downloads directory to store the uncmpressed data file) with the compress files checkbox unchecked in the General Tab of the Edit Preferences menu to a location on your hard disk you, you can open the xml format file with a text editor. Then do file save as and save the file in the format you normally use so GnuCash is again pointing at your normal data file and not the uncompressed xml vesion you have just created. If you open both the corresponding .gcm file and the uncompressed data file in the text editor you can copy the guid from the .gcm file and then search for it in the uncompressed xml version of the datafile. The account tree data is located within tags of the form and will contain a records of the form Cash in Wallet 8ad4a8287286721a15ca3df0e1d1325a among others. If you copy the guuid of the register you want to identify from the .gcm file and search for a record with copied guuid in the uncompressed xml data file you will be able to identify the account name and the other account data associated with the register. Only ever do this on a copy of your datafile not the original as the risk of making the datafile unusable if you accidentally change anything and then save the changes to the file is quite high.Preferrably always keep an unedited backup copy of the data file as well jut to be sure. David Cousens On Fri, 2023-12-29 at 17:30 -0600, Stephen wrote: > The previous postings about "Balance Column Lost" have led me to ask > about GUID register codes as I repaired some column width problems. By > trial and error I was able to modify the .GCM file to repair the width > of a couple of columns that I had narrowed (not to 0 or 1 but 5). Adrien > Monteleone's guidance worked very well although scrolling looking for a > small width was faster than a search after 0 and 1 produced no results. > So Thanks! I am still stumped by the registries GUID codes. How can I > find out which register is referenced by each of the GUID codes, please? > I have a feeling that it may have something to do with SQL but that too > has eluded me in past efforts open SQL files and make any sense of it. > Appreciate any guidance...the more simple the better! Thank you. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GUID Register Codes
That's how I would do it with the XML backend too. If you are crafty with scripts, you can likely create a table/file, mapping the account names to GUIDs for future reference. or, Switch to one of the SQL backends and write a query, or just examine the "accounts" table directly. Of course, in this case, you have the added complication that only the end leaf account names are saved in plain text. But the 'parent GUID' is also stored, so it is possible to sort out similarly named accounts. *note, while there are many ways to view the tables in one of the SQL backends, an easy one is to use the SQLite manager plugin for Firefox with the SQLite3 backend. (it is an older type plugin, so I keep a copy of Waterfox Classic around to use it.) Regards, Adrien On 12/29/23 6:56 PM, Jim DeLaHunt wrote: Stephen: I can't answer your question fully, but I can give you some insight. "GUID" stands for "Globally Unique Identifier". Each GUID is a large number, which is generated in such a way that it is highly likely to be different than any other GUID generated on any computer at any time according to the same rules. On the other hand, the same GUID value might show up in multiple places. Sometimes software developers generate a GUID and embed it their code, so that everyone gets a copy of the same GUID value. Another name for GUID is UUID, meaning "Universally" instead of "Globally". GUIDs are written to SQL databases, but they are not a creature of SQL. GnuCash also generates them when the book file is stored in XML form (as a ".gnucash" file). And, because they are globally unique, it is likely that your book contains different GUIDs than anybody else's book. Each account has a GUID associated, but there is no reason to believe that anyone else will have the same GUIDs for their accounts as you have for yours. I don't have an easy way to find out which GUID corresponds what account or other object. My way of doing that is to save my book as an XML file, open the file with a text editor, and search for the GUID value. Somewhere in the file will be data which defines the account, and it will include the GUID value and account name in close proximity. But that may or may not be the best way for you to proceed. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] GUID Register Codes
Stephen: I can't answer your question fully, but I can give you some insight. "GUID" stands for "Globally Unique Identifier". Each GUID is a large number, which is generated in such a way that it is highly likely to be different than any other GUID generated on any computer at any time according to the same rules. On the other hand, the same GUID value might show up in multiple places. Sometimes software developers generate a GUID and embed it their code, so that everyone gets a copy of the same GUID value. Another name for GUID is UUID, meaning "Universally" instead of "Globally". GUIDs are written to SQL databases, but they are not a creature of SQL. GnuCash also generates them when the book file is stored in XML form (as a ".gnucash" file). And, because they are globally unique, it is likely that your book contains different GUIDs than anybody else's book. Each account has a GUID associated, but there is no reason to believe that anyone else will have the same GUIDs for their accounts as you have for yours. I don't have an easy way to find out which GUID corresponds what account or other object. My way of doing that is to save my book as an XML file, open the file with a text editor, and search for the GUID value. Somewhere in the file will be data which defines the account, and it will include the GUID value and account name in close proximity. But that may or may not be the best way for you to proceed. Best regards, —Jim DeLaHunt On 2023-12-29 15:30, Stephen wrote: The previous postings about "Balance Column Lost" have led me to ask about GUID register codes as I repaired some column width problems. By trial and error I was able to modify the .GCM file to repair the width of a couple of columns that I had narrowed (not to 0 or 1 but 5). Adrien Monteleone's guidance worked very well although scrolling looking for a small width was faster than a search after 0 and 1 produced no results. So Thanks! I am still stumped by the registries GUID codes. How can I find out which register is referenced by each of the GUID codes, please? I have a feeling that it may have something to do with SQL but that too has eluded me in past efforts open SQL files and make any sense of it. Appreciate any guidance...the more simple the better! Thank you. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
