Re: [GNC] Can I export a list of vendors and customers?
David, I might stand corrected. I haven't tested this for customers/vendors that don't have transactions, so give it a go and please report back what you find. Try one of the following: (both give the same end result) 1. Reports > Business > Payables Aging/Receivables Aging then Options > Display to show address & contact info if desired use Options > General to play with sort order 2. Business > Customer/Vendor > Customers Overview/Vendors Overview then use the Customer/Vendor List button on the toolbar (results in same as the Aging Report) Once you get the data you want onscreen, then you can copy/paste into a spreadsheet and save as CSV for importing elsewhere. Note, I don't know of any method that shows *all* info about a Customer/Vendor save for reading the XML uncompressed, or using a db backend and running a query or examining the tables directly. Also, I've only just tried this on 4.12. If it exists in older versions, I do not know. Regards, Adrien On 11/18/22 12:11 PM, Dr. David Kirkby wrote: Is it possible to export the customers as a .csv file in a database, and also I'd like to export the vendors. There are no transactions with these yet. ___ 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] Can I export a list of vendors and customers?
Chris, There is only a Customer Summary (no Vendor Summary) and at best, that can get you a list if you also select in Options > Display > Show Inactive. But I'm not sure it will include Customers with no invoice or payment history at all. (all of mine have history) You might be thinking of Business > Customer/Vendor > Customers/Vendors Overview. But unfortunately it is impossible to select any of the text on those tabs for copy/paste. Regards, Adrien On 11/19/22 4:56 PM, Chris Good wrote: I’m not at my PC now but you can run the (from memory) Customer Summary or Vendor Summary reports, then (like all GnuCash reports), use control-A to select all the data, then paste into a spreadsheet. ___ 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] Can I export a list of vendors and customers?
> Date: Fri, 18 Nov 2022 18:11:15 + > From: "Dr. David Kirkby" > To: GNU Cash User > Subject: [GNC] Can I export a list of vendors and customers? > Message-ID: > > Content-Type: text/plain; charset="UTF-8" > > Is it possible to export the customers as a .csv file in a database, and > also I'd like to export the vendors. There are no transactions with these > yet. > > Dr David Kirkby Ph.D > Email: drkir...@kirkbymicrowave.co.uk Web: > https://www.kirkbymicrowave.co.uk/ > Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) > Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. > Hi David, I’m not at my PC now but you can run the (from memory) Customer Summary or Vendor Summary reports, then (like all GnuCash reports), use control-A to select all the data, then paste into a spreadsheet. Regards, Chris Good ___ 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] Can I export a list of vendors and customers?
On Fri, 18 Nov 2022 14:58:56 -0800 Cam Ellison wrote: > On 2022-11-18 13:55, Adrien Monteleone wrote: > > Unfortunately no. > > > > Regards, > > Adrien > > > > On 11/18/22 12:11 PM, Dr. David Kirkby wrote: > >> Is it possible to export the customers as a .csv file in a > >> database, and also I'd like to export the vendors. There are no > >> transactions with these > >> yet. > > > > > If you store your transactions in a database instead of the standard > flat file, it's actually quite straightforward, especially with a > web-based database manager. Trying to work from the command line may > be a little more complicated. > > Cheers > > Cam > You could save once only in a suitable database format to get the data, then immediately save in compressed xml again if you don't want to use the database again. Liz ___ 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] Can I export a list of vendors and customers?
On 2022-11-18 13:55, Adrien Monteleone wrote: Unfortunately no. Regards, Adrien On 11/18/22 12:11 PM, Dr. David Kirkby wrote: Is it possible to export the customers as a .csv file in a database, and also I'd like to export the vendors. There are no transactions with these yet. If you store your transactions in a database instead of the standard flat file, it's actually quite straightforward, especially with a web-based database manager. Trying to work from the command line may be a little more complicated. Cheers Cam ___ 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] Can I export a list of vendors and customers?
Unfortunately no. Regards, Adrien On 11/18/22 12:11 PM, Dr. David Kirkby wrote: Is it possible to export the customers as a .csv file in a database, and also I'd like to export the vendors. There are no transactions with these yet. ___ 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] Can I export a list of vendors and customers?
Is it possible to export the customers as a .csv file in a database, and also I'd like to export the vendors. There are no transactions with these yet. Dr David Kirkby Ph.D Email: drkir...@kirkbymicrowave.co.uk Web: https://www.kirkbymicrowave.co.uk/ Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100) Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT. ___ 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.
