Re: [GNC] CSV transaction import settings
Geoff, I finally found time to fire up the other computer that has the CSV import settings for that data file and the needed GCM file. I didn't want the rest of the settings copied to the other computer, so I just copied out the three import configurations and pasted them into the GCM in the other computer. Then I found them when I tried to import CSV files from those financial institutions. Again, thanks for your help. On Thu, Oct 6, 2022 at 7:28 PM Geoff wrote: > Hi David > > On Windows 10**, there is a directory called: > > C:\Users\{YOUR_NAME}\AppData\Roaming\GnuCash\books\ > > Which contains a file for each set of books called: > > {BOOK_NAME}.gnucash.gcm > > In that file, there are, inter alia, sections for your saved CSV Import > configurations that look like this: > > [Import csv,transaction - {BLAH BLAH}] > Name={BLAH BLAH} > SkipStartLines=1 > SkipEndLines=0 > SkipAltLines=false > CsvFormat=true > Separators=, > DateFormat=1 > CurrencyFormat=0 > Encoding=UTF-8 > MultiSplit=true > ColumnTypes=Date;Num;Description;Transaction > Commodity;Action;Account;Deposit;Price; > > > ** So, on Linux you will need to find that file using something like this: > > sudo find / -name {BOOK_NAME}.gnucash.gcm -print > > > Hope this helps. > > Regards > > Geoff > = > > On 7/10/2022 12:49 am, David Carlson wrote: > > Where are the settings stored? I thought I copied all the GnuCash stuff > > from one computer to another Ubuntu machine. I got my memorized reports > > but not the CSV Transactions import settings. > > > -- David Carlson ___ 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] CSV transaction import settings
Thanks Geoff. Looks like there will be an editing task to get that into the computer that doesn't have it. On Thu, Oct 6, 2022 at 7:28 PM Geoff wrote: > Hi David > > On Windows 10**, there is a directory called: > > C:\Users\{YOUR_NAME}\AppData\Roaming\GnuCash\books\ > > Which contains a file for each set of books called: > > {BOOK_NAME}.gnucash.gcm > > In that file, there are, inter alia, sections for your saved CSV Import > configurations that look like this: > > [Import csv,transaction - {BLAH BLAH}] > Name={BLAH BLAH} > SkipStartLines=1 > SkipEndLines=0 > SkipAltLines=false > CsvFormat=true > Separators=, > DateFormat=1 > CurrencyFormat=0 > Encoding=UTF-8 > MultiSplit=true > ColumnTypes=Date;Num;Description;Transaction > Commodity;Action;Account;Deposit;Price; > > > ** So, on Linux you will need to find that file using something like this: > > sudo find / -name {BOOK_NAME}.gnucash.gcm -print > > > Hope this helps. > > Regards > > Geoff > = > > On 7/10/2022 12:49 am, David Carlson wrote: > > Where are the settings stored? I thought I copied all the GnuCash stuff > > from one computer to another Ubuntu machine. I got my memorized reports > > but not the CSV Transactions import settings. > > > -- David Carlson ___ 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] CSV transaction import settings
Hi David On Windows 10**, there is a directory called: C:\Users\{YOUR_NAME}\AppData\Roaming\GnuCash\books\ Which contains a file for each set of books called: {BOOK_NAME}.gnucash.gcm In that file, there are, inter alia, sections for your saved CSV Import configurations that look like this: [Import csv,transaction - {BLAH BLAH}] Name={BLAH BLAH} SkipStartLines=1 SkipEndLines=0 SkipAltLines=false CsvFormat=true Separators=, DateFormat=1 CurrencyFormat=0 Encoding=UTF-8 MultiSplit=true ColumnTypes=Date;Num;Description;Transaction Commodity;Action;Account;Deposit;Price; ** So, on Linux you will need to find that file using something like this: sudo find / -name {BOOK_NAME}.gnucash.gcm -print Hope this helps. Regards Geoff = On 7/10/2022 12:49 am, David Carlson wrote: Where are the settings stored? I thought I copied all the GnuCash stuff from one computer to another Ubuntu machine. I got my memorized reports but not the CSV Transactions import settings. ___ 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] CSV transaction import settings
Ack - newbie screwup. Please disregard my last. Sigh. Ji On 7 Oct 2022 at 8:04, Christopher Lam wrote: > In release 4.12 - try Help > About > > On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > David, > > > > It looks like you want the chart here: > > > > https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux > > > > 1. /home//.local/share/gnucash > > 2. /home//.local/share/gtk-3.0 > > 3. /home//.config/gnucash > > 4. /home//.config/gtk-3.0 > > > > One of those four directories should have the file you are looking > > for. > > > > Based on the expected files listed in that chart, I'd hazard that > > either > > #1 or #3 is the proper location. > > > > Regards, > > Adrien > > > > On 10/6/22 3:16 PM, David Carlson wrote: > > > I went through that part of the FAQ and I got lost with locations > > > and paths and relative paths but no hard filename to search for > > > with my filemanager. If it is there I gave up in frustration > > > before I found it. > > > > > > ___ > > 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] CSV transaction import settings
Thank you, I did (I actually read the faq before calling for help). The data is not going to the location shown in 'About', it's going to the directory from which the installer was run. Very puzzling. Thre were a couple of entries in the registry which had a '/' (forward slash) in the path - not a convention windoze uses. Appreciated! Jim On 7 Oct 2022 at 8:04, Christopher Lam wrote: > In release 4.12 - try Help > About > > On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > David, > > > > It looks like you want the chart here: > > > > https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux > > > > 1. /home//.local/share/gnucash > > 2. /home//.local/share/gtk-3.0 > > 3. /home//.config/gnucash > > 4. /home//.config/gtk-3.0 > > > > One of those four directories should have the file you are looking > > for. > > > > Based on the expected files listed in that chart, I'd hazard that > > either > > #1 or #3 is the proper location. > > > > Regards, > > Adrien > > > > On 10/6/22 3:16 PM, David Carlson wrote: > > > I went through that part of the FAQ and I got lost with locations > > > and paths and relative paths but no hard filename to search for > > > with my filemanager. If it is there I gave up in frustration > > > before I found it. > > > > > > ___ > > 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] CSV transaction import settings
In release 4.12 - try Help > About On Fri, 7 Oct 2022 at 05:26, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > David, > > It looks like you want the chart here: > > https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux > > 1. /home//.local/share/gnucash > 2. /home//.local/share/gtk-3.0 > 3. /home//.config/gnucash > 4. /home//.config/gtk-3.0 > > One of those four directories should have the file you are looking for. > > Based on the expected files listed in that chart, I'd hazard that either > #1 or #3 is the proper location. > > Regards, > Adrien > > On 10/6/22 3:16 PM, David Carlson wrote: > > I went through that part of the FAQ and I got lost with locations and > > paths and relative paths but no hard filename to search for with my > > filemanager. If it is there I gave up in frustration before I found it. > > > ___ > 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] CSV transaction import settings
I didn't find that diagram. Thanks. Maybe what I want is under USER_CONFIG_HOME On Thu, Oct 6, 2022 at 4:27 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > David, > > It looks like you want the chart here: > > https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux > > 1. /home//.local/share/gnucash > 2. /home//.local/share/gtk-3.0 > 3. /home//.config/gnucash > 4. /home//.config/gtk-3.0 > > One of those four directories should have the file you are looking for. > > Based on the expected files listed in that chart, I'd hazard that either > #1 or #3 is the proper location. > > Regards, > Adrien > > On 10/6/22 3:16 PM, David Carlson wrote: > > I went through that part of the FAQ and I got lost with locations and > > paths and relative paths but no hard filename to search for with my > > filemanager. If it is there I gave up in frustration before I found it. > > > ___ > 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. > -- David Carlson ___ 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] CSV transaction import settings
David, It looks like you want the chart here: https://wiki.gnucash.org/wiki/Configuration_Diagrams_-_Linux 1. /home//.local/share/gnucash 2. /home//.local/share/gtk-3.0 3. /home//.config/gnucash 4. /home//.config/gtk-3.0 One of those four directories should have the file you are looking for. Based on the expected files listed in that chart, I'd hazard that either #1 or #3 is the proper location. Regards, Adrien On 10/6/22 3:16 PM, David Carlson wrote: I went through that part of the FAQ and I got lost with locations and paths and relative paths but no hard filename to search for with my filemanager. If it is there I gave up in frustration before I found it. ___ 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] CSV transaction import settings
I went through that part of the FAQ and I got lost with locations and paths and relative paths but no hard filename to search for with my filemanager. If it is there I gave up in frustration before I found it. On Thu, Oct 6, 2022 at 1:08 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > David, > > The Wiki FAQ has a section on file locations. I don't have the exact > answer off-hand, but I'm sure one of those locations has what you are > looking for. (allegedly, there are no other places used by GnuCash) > > Regards, > Adrien > > On 10/6/22 8:49 AM, David Carlson wrote: > > Where are the settings stored? I thought I copied all the GnuCash stuff > > from one computer to another Ubuntu machine. I got my memorized reports > > but not the CSV Transactions import settings. > > > > > ___ > 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. > -- David Carlson ___ 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] CSV transaction import settings
David, The Wiki FAQ has a section on file locations. I don't have the exact answer off-hand, but I'm sure one of those locations has what you are looking for. (allegedly, there are no other places used by GnuCash) Regards, Adrien On 10/6/22 8:49 AM, David Carlson wrote: Where are the settings stored? I thought I copied all the GnuCash stuff from one computer to another Ubuntu machine. I got my memorized reports but not the CSV Transactions import settings. ___ 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.
[GNC] CSV transaction import settings
Where are the settings stored? I thought I copied all the GnuCash stuff from one computer to another Ubuntu machine. I got my memorized reports but not the CSV Transactions import settings. -- David Carlson ___ 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.