[GNC] exporting Company name/Customer number for use in creating .csv for importing invoices to GnuCash

[Jonathan Francoeur]

FYI...  The "owner_id - Customer or vendor number" corresponds to the
"Project" column in my spreadsheet.

On Sun, Jul 7, 2019 at 12:51 AM Jonathan Francoeur <goedible at gmail.com>
wrote:

>
>
> --
> Hi.  I'd like to import invoices from the .csv that I export from my "Timersheeter
> 2.0.1 <https://www.apkmonk.com/app/com.zero8timetracking.timesheeter/>"
> app.
> I'm trying to use one sheet in libre office calc for pasting the app data;
> and another sheet from which I can export a .csv for import to GnuCash.
> The app exports Time entries separatelly from exense entries to I've
> created a few sheets to put them all together and the end product looks
> like this:
> [image: select.png]
> My problem is with the "owner_id - Customer or vendor number".  My app
> exports the names like "Tessa" so I believe that I need an intermediary
> sheet to to use as an index for the Customer name and Customer ID.
> "Tessa", "000001".
>
> Is there a way to get this data from GnuCash and paste into my spreadsheet
> I am able to select one row at a time in the Customers Overview tab yet I
> can not copy and paste in to my spreadsheet.
> How can I make a table with this data?
> [image: customers.png]
> Or, is there a better way to do am attempting?
>
> Thanks for you consideration.
>
>
> "You are what you eat.  Be your Landscape!"
> <http://eeLandscaping.blogspot.com>
> J <http://www.facebook.com/people/Jonathan-Brian-Francoeur/580595513>onathan
> Brian Francoeur
> <http://www.facebook.com/people/Jonathan-Brian-Francoeur/580595513>
> Landscape design, consultations, creation and care
> <https://docs.google.com/document/d/1lyjTLI4QVd_z-P6EPfxRqC22f6omfYt_YeJmeoJALIQ/edit?hl=en_US>
> Certified Horticultural Landscaper
> <http://www.hcp.bc.ca/index.php?option=com_content&view=article&id=53&Itemid=60>,
> Permaculture designer
> <http://www.permaculture.org/nm/index.php/site/permaculture_design_course/>,
> Sustainable gardener
> <http://www.linnaeafarm.org/farm/show2s/Garden_Programme> and Organic
> Master Gardener
> <http://www.gaiacollege.ca/organic-master-gardener-course.html>.
> goedible at gmail.com  tel:  (250) 642-0267
> eeLandscaping.blogspot.com <http://eelandscaping.blogspot.com>
> 6411 Sooke Rd., Sooke, B.C., Canada, V9Z-0A8
> <https://www.google.ca/maps/place/Everything+Edible+Landscaping,+6411+Sooke+Rd.,+Sooke,+BC+V9Z+0A8/@48.3819275,-123.708261,13z/data=!4m2!3m1!1s0x548f056f06cbad49:0xddc41f6f5e57feb>
>
>

-- 
"You are what you eat.  Be your Landscape!"
<http://eeLandscaping.blogspot.com>
J <http://www.facebook.com/people/Jonathan-Brian-Francoeur/580595513>onathan
Brian Francoeur
<http://www.facebook.com/people/Jonathan-Brian-Francoeur/580595513>
Landscape design, consultations, creation and care
<https://docs.google.com/document/d/1lyjTLI4QVd_z-P6EPfxRqC22f6omfYt_YeJmeoJALIQ/edit?hl=en_US>
Certified Horticultural Landscaper
<http://www.hcp.bc.ca/index.php?option=com_content&view=article&id=53&Itemid=60>,
Permaculture designer
<http://www.permaculture.org/nm/index.php/site/permaculture_design_course/>,
Sustainable gardener
<http://www.linnaeafarm.org/farm/show2s/Garden_Programme> and Organic
Master Gardener
<http://www.gaiacollege.ca/organic-master-gardener-course.html>.
goedible at gmail.com  tel:  (250) 642-0267
eeLandscaping.blogspot.com <http://eelandscaping.blogspot.com>
6411 Sooke Rd., Sooke, B.C., Canada, V9Z-0A8
<https://www.google.ca/maps/place/Everything+Edible+Landscaping,+6411+Sooke+Rd.,+Sooke,+BC+V9Z+0A8/@48.3819275,-123.708261,13z/data=!4m2!3m1!1s0x548f056f06cbad49:0xddc41f6f5e57feb>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: customers.png
Type: image/png
Size: 169891 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190707/bc61f13c/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: select.png
Type: image/png
Size: 152883 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190707/bc61f13c/attachment-0003.png>