I have a database of around 5,000 movies which I need to import into a CCK type (I've created around a dozen fields) for my new Drupal 6 site - any suggestions?

Comments

MidGe48’s picture

Heya vidmark,

As far as I know there is currently no way to do what you suggest very easily.

The team on Node Import module are working on it, but no date as to when it will be ready. I am in teh same boat and upon looking at ways of doing it, I decided to wait until Node_import is ready. I have a 20,000 nodes to be imported.

Having said that, there are ways of doing it via SQL but you have to make sure all pointers are right. There are a few tables involved. It is not a trivial job.

I would love to be corrected on this. Ie. for someone telling me it is possible, that there is an easy way.

Cheers

www.ZuNOB.com

vidmarc’s picture

I've installed the "in progress" Node_import. I think it might work for the basic text info I need to imprt. I'll keep you posted on how I get on.

-----------------------------------------------------------------------
Cult Movie Forums

MidGe48’s picture

You have guts! :) Good on you.

I would be very pleased if you did let me know how it went, and many other people would to, I am sure.

Good luck!

www.ZuNOB.com

sockah’s picture

Thanks for directing me to this threat MidGe. I too would appreciate an update Vidmark.

I have a csv file with about 15,000 rows I am trying to turn into a node type with CCK fields. If I could use node import to do it, it would be a huge help.

daveslc’s picture

How do you import into CCK nodes manually (SQL)?

I don't want to wait for node import...

WorldFallz’s picture

What I did was setup a bare d5 site with just the modules I needed for the import, then imported the data, and upgraded the site to d6.

===
"Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime." - Lao Tzu
"God helps those who help themselves." - Ben Franklin
"Search is your best friend." - Worldfallz

webdev2’s picture

I did the same thing for a wordpress blog import - first to D5 then upgraded to D6.

vidmarc’s picture

I tried to do the import into Drupal 6 earlier today. Sadly however I continually get a dropped connection when moving to step 3 of "node_import/add"

Perhaps the uploaded file is too large? It's 1.85 MB.

If anybody has any suggestions I'd be really glad to hear from you!

-----------------------------------------------------------------------
Cult Movie Forums

vidmarc’s picture

I've had "safe mode" switched off, as i thought that might be one of the problems.

However, rather than being taken to step 4 of "node_import" I'm now just getting a blank screen.

Anyone?

-----------------------------------------------------------------------
Cult Movie Forums

vidmarc’s picture

I seem to have "almost" got the node_import" module working by reducing the number of data entries to import from 5,500 to 500 at a time.

However, the CCK fields I created are not being listed in the field import options - only the standard CCK fields etc.

Is there somewhere I need to effectively "switch" these on?

-----------------------------------------------------------------------
Cult Movie Forums

WorldFallz’s picture

If you're trying to import cck fields with the d6 version of node_import (which you mention in your first post), it says right on the project page (as well as the release page) that the d6 version does not yet support cck (which is why we suggested importing into d5 then upgrading to d6).

===
"Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime." - Lao Tzu
"God helps those who help themselves." - Ben Franklin
"Search is your best friend." - Worldfallz

juan_g’s picture

Until CCK is supported by the D6 version of Node Import, currently under development, a relevant issue on this matter is Port node-import to Drupal 6, where some workarounds are mentioned (CSV Parser, etc.).

I've also quoted WorldFallz's workaround from this thread on that issue, and on the handbook page Migrating to Drupal.

WorldFallz’s picture

Thanks-- I always mean to track down issues / handbook pages like that and update them from good info in threads, i just never seem to get around to it. =/

===
"Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime." - Lao Tzu
"God helps those who help themselves." - Ben Franklin
"Search is your best friend." - Worldfallz