Database help…
6
- At December 29, 2007
- By ken
- In tech
OK, any of you Über-genius-types out there wanna help the AV Club? I have an Access database I wrote in 2002 for my wife to store her recipes. Very effective at the time, but not so much now. I want to move it to the web, and I’d like to power it with wordpress.
What’s the easiest way to export an Access database and import it into wordpress? I can come out of Access in just about any format, and I’m assuming CSV (comma separate variable, but you already knew that, didn’t you) is the way to go. Would love to hear your ideas. Comment here or use the contact form.
George
Well, it depends on what you want to do with it. What kind of database is your WordPress using? I haven’t looked at WP in awhile. You would probably have to upload your access database to the server hosting your WP, then write a script to transfer the recipes over. I’m assuming she wants to use them as posts. The script would have to import each recipe as if it’s a new post, but use whatever code that says it shouldn’t be public. Then she can edit the posts and set them to go live whenever she wants. Hopefully that makes sense.
ken
It can be a public database, recipes as posts… look at http://www.avclub.us/food
Paul
Is she wanting to keep it inside Access and continue updating it locally, or is this going to be a full-on commitment to the web? My recommendation is to move it entirely away from Access and into a fast, robust form like a MySQL database. I think George is on the right track, but if you can export your Access db as a CSV file, you could do some PHP/MySQL magic to push those recipes into a MySQL db. I’m not sure how she wants it formatted on wordpress, but I know that wordpress requires MySQL on its backend. This way would be pretty tricky, but in the end you’d have a ton of flexibility. Maybe I just like to put myself through unnecessary pain when designing these fun little web apps.
ken
That’s exactly the goal… leave Access completely and put it into an SQL database on the web. Look at http://www.avclub.us/food
Being in Word Press it would be easily taggable and searchable, and having it on the web would make a lot of sense.
So… where to start?
(translate, does anyone want to help with this operation?)
Ken
Lee D
Can you send me a copy of the access db you have right now? Well, not right now as in this second. You know what I mean. And can you put the recipe you have on avclub.us/food in it so I can see what fields would contain what data? I assume the /food wp is a separate install? I’ll see if I can’t cook something up using my own wp install. I have actually had to do some looking through the wp tables in the last 6 months so am at least slightly familiar with them.
Paul Nalley
Ken,
I work for Foothills Church in Seneca. I would be glad to help you with this. I do all of our DB stuff for our site as well as have done it for years other jobs. My email is above let me know if you need any help.