Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Greetings. I want to create a database for recipes. I have finally found a program that can download recipes from resources online. The program allows you to export a recipe as HTML and plain text....
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Something like evernote might be a good choice. The closest free equivalent to Access would be: http://www.openoffice.org/product/base.html
Which does run on a mac.
Paid choices would include...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Would really need to see the text file format to give much guidance. Does the text file have a category in it? If so, no need for multiple tables. Just use one table that can be filtered very...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
If you follow normalization rules everything should be broken down in to its own tables (ethnic type, heath type, ingredients, etc) then your "recipes" table should be mostly be a name and links to...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
I create database under Access isn't hard to do. Instead of using Excel you can add the data you want into access.
Which MS Office do you?
1. Start off with a blank template
2. Use the...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Creating the physical database isn't the issue. The issue is taking my current data (text) and correctly and efficiently putting it into the database.
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
your issue is going to be parsing the info. You "could" dump it all as is in to 1 cell and just output it but I would not recommend it.
* Exported from MasterCook *
...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
The wheel has already been invented:
http://www.amazon.com/ValuSoft-72066-Mastercook-11-0/dp/B003DO96FU
...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Haha, I'm well aware of those. I'm working on an idea that goes PAST that type of software.
Thanks for all the replies!
I just found one piece of software called Now You're Cooking. I was able...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
you dont need a database, just create a folder in your mac called "recipes"
and then for each recipe you export, give it a descriptive file name like "garlic chicken with lemon grass.txt" and place...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
You got it exactly right.
The database isn't for me. I have an idea and after talking to developers, I need to make a database of recipes first. That's why I need the end product to be a database....
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Let's use this recipe source as an example. If I copy and pasted all of these into one text file, is there a secret way to import it correctly into Access? Would saving it to Excel instead be...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Wow, missed this response.
So based on this example, you'll want fields for Recipe Name, Amount, Measure, Ingredient/Prep Method, Measure, Instructions.Serving Size (optional), and Prep Time...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Well if you already have it setup in Excel you can export from excel and import it into Access since both Access and Excel are based on the same process you can put it into text mode on the Acess. If...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
have you looked at something like this http://www.inakasoftware.com/
not sure which OS you are using you mention Mac then Access there is no Access for Mac?
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Many ways to do this. You can create a table for each category of recipe, like Breakfast, Dessert, Pies, Lunch, Brunch, Dinner, etc. How you want to organize your tables is completely up to you.
...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
That is the simplest, but it doesn't address situations where you might have all the minor ingredients on hand but be lacking the main thing. It would be nice to say "show all recipes with x, y, z"...
Need help creating a database
Expired
Thread created 08-18-2012 by akkkmed
0 Score
17 Replies
959 Views
Ask yourself....how do you want to recall this information from the database? By ingredients? By name? By category of food? By health content?
