Best way to populate database tables.
gordonbooker - June 20, 2008 - 00:55
My site uses some custom database tables in order to make a list of song titles with their artists and year of creation:
http://www.timadshead.co.uk/index.php?q=node/18
It's a very simple three table relational database format
Table 1: ID and Title
Table 2: ID and Artist
Table 3: Links ID's and adds year
I am happy to fill in the database on my local machine and copy the tables over if needs be.
I have made something using the webform module, and copying the input to my tables, but it's not ideal as it's difficult to edit and delete records.
I was wondering if there are any programs that would let me make the simple form that could populate this design.
if you have a spreadsheet
if you have a spreadsheet with all the info you want to import you could simply set up a content type using cck and then import the spreadsheet using the node import module...
http://drupal.org/project/node_import
http://drupal.org/project/cck
OR
You could set up two different taxonomies (artist and year), and set both of them to autofill, and then create a node type (album) and then simply tag the albums.... you could try using node_import with the second approach, but i'm not sure how that will work out.
Thankyou
Many thanks, I'll look into that now.