export ingedients

General discussion on BeerTools Pro Software.

export ingedients

Postby jawsfree » Sat Apr 20, 2013 8:59 am

is there a way to export my ingredients database to excel or other editable format? The problem is that when I just try to print the list it includes the description and all I need is a list of name, origin and quantity.
AMD Phenom IIX4 830 Processor 2.80 GHz
6.00 GB RAM
Microsoft Windows 7 Home Premium
Service Pack 1
64-bit Operating System
User avatar
jawsfree
Light Lager
Light Lager
 
Posts: 14
Joined: Mon Apr 10, 2006 7:47 am

Re: export ingedients

Postby slothrob » Sun Apr 21, 2013 4:32 pm

I found a simple way to do this:
- Click on your ingredients database in the left column, so that your database ingredients appear in the upper browsing window.
- Cick on the first ingredient in that upper window, to highlight it.
- Use Ctrl-a to highlight all ingredients in the window.
- Ctrl-c will copy the list.
- Ctrl-v will paste the list into an open spreadsheet.

When I tried this in an Appleworks spreadsheet, it formatted the list so that each ingredient got it's own row, then the name, origin, description and amount each got their own column. It was very nicely formatted and easy to edit, since you could simply delete the column that contained the description if you wanted to remove that from every ingredient.
BTP v2.0.* Windows XP
User avatar
slothrob
Moderator
Moderator
 
Posts: 1770
Joined: Mon Apr 10, 2006 12:36 pm
Location: Greater Boston

Re: export ingedients

Postby jawsfree » Mon Apr 22, 2013 6:46 am

Thanks Slothrob that worked perfect. :D
AMD Phenom IIX4 830 Processor 2.80 GHz
6.00 GB RAM
Microsoft Windows 7 Home Premium
Service Pack 1
64-bit Operating System
User avatar
jawsfree
Light Lager
Light Lager
 
Posts: 14
Joined: Mon Apr 10, 2006 7:47 am

Re: export ingedients

Postby slothrob » Thu Apr 25, 2013 4:47 am

I'm glad it helped!
BTP v2.0.* Windows XP
User avatar
slothrob
Moderator
Moderator
 
Posts: 1770
Joined: Mon Apr 10, 2006 12:36 pm
Location: Greater Boston


Return to BeerTools Pro General Topics

Who is online

Users browsing this forum: Bing [Bot] and 1 guest