Hi,
I just installed the node_import module and now it's time to test it. Apparently there is a wizard to help with the import procedure, which is fine.
Eventually, though, I need to be able to import the nodes in an unsupervised way, would that be possible¿?

With my scenario, it would be even more elegant to use node_import before? here it is:

*cron calls php script
*php script queries and external database and extracts some data
*data is collected in a csv file
*node_import gets the file and adds nodes for each row in it

I wish I could skip al the php->csv->node_import and write directly into the drupal database...

Comments

neopoet’s picture

I would also be interested.

millenniumtree’s picture

I second this. Automated import would make my life so much easier.

jako0013’s picture

Same here. I'm working on trying to accomplish this very same task.

drewschmaltz’s picture

I've sponsored a development of this, and the module is coming along great. E-Mail me at drew@imoria.com to inquire. If you are interested in helping me sponsor this development (the module is already usable, but will be getting some spiffy upgrades) - I will be happy to give you a patch that will make node_import drupal-5 and cron seamless as soon as today. I will also update you with patches as soon as they come in.

goodeit’s picture

awesome news, Drew! Will this support automatically updating nodes as well (or could it tie in with the work here)?

drewschmaltz’s picture

Yep, auto update based on customizable criteria. (ie: if (this = that) {update or do not update node}) Haven't taken a look at the work there yet, I'll get back to you after I do.

To be specific, this patch can/will be able to:

  1. Trigger via cron
  2. Set Max Execution Time
  3. Set Number of Nodes per cron
  4. Cancel jobs
  5. Ability to upload straight from file in a folder already on server (default "files") or upload new file
  6. Ability to skip "preview" step
  7. Import Based on Criteria (if(this=that){import}) where "this" is a column header in the csv file and "that" is a text field. For my project it will be if the updated date is earlier (so it will have =, !=, >=, and <=)

Like I said in my previous post, about 3/4 of this is finished and ready go. Anyone who can help me fund the last 1/4 of it can have the patch as it is now (perfect for everything I listed except # 7). The faster I get the developer the money, the faster we can have this reviewed by the maintainer and get a patch, or updated module up there. Anything is appreciated, let me know if you're willing to help.

zeezhao’s picture

Sounds great! Please do you know roughly how fast the automatic import performs e.g. how many nodes per minute for a given spec machine?

The reason I ask, is I want to know if some performance improvements were also implemented. Please see comments on:
http://drupal.org/node/270584

Thanks

drewschmaltz’s picture

120 nodes per minute is about average. There were some tweaks made, and CCK is to blame for some of the lag, but when you get up 75,000 + it slows down to about 10 / minute.

EDIT: at first, it flies... maybe 700 - 800 / minute.

scottrigby’s picture

Sounds useful! are there currently any plans for a 6.x port? :) Scott

zeezhao’s picture

Ok, thanks. I can help out with testing, if necessary. Please what's the current status of the patch for:

"5. Ability to upload straight from file in a folder already on server (default "files") ..."

asak’s picture

Subscribing (And very exicted about this!)

ianchan’s picture

Subscribing

akaserer’s picture

Subscribing

sammy-node’s picture

sub

asak’s picture

Now that everyone's here...

What/How much would it take to get this completed?

Vic96’s picture

Any update on this? It sounds very promising!

roieki’s picture

I would very much want to see such an improvement to an already great module. Is anyone doing anything or is this thread dead?

okday’s picture

subscribing

funkeyrandy’s picture

any updates on this...?

WoozyDuck’s picture

Subscribing ... Any updated on this?

dealancer’s picture

Drew, Let me help to accomplish automatic import, I need it too, very ugrent :)

pimentoski’s picture

subscribing

dealancer’s picture

Hi,

If i correctly understand problem you need to add new records in tvs/cvs file and then import it in automatically by node Import module via cron. If so, I had the same problem.
For solving that I have created new module Node import via cron, it requires Node import module.
User or bot should append content to the existent files for tasks automatically. And then it is imported via cron.
I hope it will be useful for you. Please test it.

Now I'm working on other module which can convert data from XML to CVS and even images. This is done is for only my case, but in future I'm going to implement that in general way.

Please write here your ideas.

Robrecht Jacques’s picture

Status: Active » Closed (duplicate)

Setting as duplicate of http://drupal.org/node/684512.

blogers’s picture

Issue summary: View changes

dealancer I need drupal 7 module for