By AgentD on

Hi all,

I've looked at the migrate and feeds modules for this, but it seems like what I want to do would actually be easier with an sql query.

I have a fresh install of Drupal 7, and want to import data into new nodes of a certain content type. The only fields I'm trying to import are title, a Link field (from the Link module), and then terms for 1 of 3 vocabularies (vocabularies already created in Drupal, each node would have terms for only 1 of the 3 created vocabs).

So I have titles, a bunch of urls, and separate terms, no body needed.

How can I do this in SQL?

Any help is really appreciated.

Thanks,
Dan

⋅ Categories: Drupal 7.x

Comments

nevets’s picture

nevets commented

You could use the feeds module to import the data.

MadMich’s picture

MadMich commented

I am interested in doing the same thing and have set up feeds.

But when I add a query and check save the 'Settings for SQL parser', i get the message 'Driver not specified for this database connection: myname'!
I've added the 'Drupal 7 driver for SQL Server and SQL Azure' module but it doesn't allow me to enable it?

I'm a noobie to SQL connections and would also like to find a tutorial, magical module or an indication that i'm going in the right direction?

Cheers

AgentD’s picture

AgentD commented

I've been trying feeds, but the last hurdle is my terms are imported as if wrapped in quotes.

So, the terms arts, artists which should be separate becomes "arts, artists" which isn't ideal. I can't figure out how to fix that.

Dan