I have gone through the steps of the import and when it comes to the preview of the import everything looks fine. Once the import has finished it does not show any errors but it has only imported a few of the fields. Is there any known reason for this?

CommentFileSizeAuthor
#7 node_import-node_publication-19.txt55.27 KBstella
#5 node_import-node_company-17[1].txt372.42 KBcspbm

Comments

marvita’s picture

marvita commented

Hi,

I have the same problem, I have some taxonomy terms which are required, so I make them not required to see if that was the problem, but still doesn't import all the data that I need. The weird thing is that import just the taxonomy terms, the title and that's all. Any suggestions?

Cheers!

ozecho’s picture

ozecho commented

Hi, I am having the same problem... was there ever a resolution to this?
Is there a max number of fields that can be imported perhaps (I have 29)?
Happy to post debug info if its useful,

herpderp’s picture

herpderp commented

You should post the debug information. I can verify that node import works for over 29 imports, so it's not that.

If you can give me any more information like the content type and the type of import file, etc, maybe I'll take a look into it. But definately, drop your debug file into the issue.

cspbm’s picture

cspbm commented

I'm having the same problem. The preview is fine yet upon import only a few of the fields come through. If i look at the database table I see the values "0" inserted in the the cells where the content did not fully import. The file is CSV UTC 8 encoded and it's a CCK content type.

Please help. I've checked to make sure no values where required as well.

Thanks

cspbm’s picture

cspbm commented
Priority: Normal » Critical
StatusFileSize
new node_import-node_company-17[1].txt372.42 KB

Attaching a debug report to my previous issue above. Please help.

cspbm’s picture

cspbm commented

As an update - I found the problem. In my custom content type I had two date/time fields. Even though I wasn't even including those fields upon import it was messing up the final import. I did then including them and mapping to those fields (using correct time format) and it still didn't work. But, as soon as I deleted the two date time fields from the content type import was 100% successful.

So the fix needs to involve the data/time fields.

stella’s picture

stella commented
StatusFileSize
new node_import-node_publication-19.txt55.27 KB

I have the same problem. The website and title fields import correctly but two textfields (organisation and author name) don't import at all. I've attached the debug output. I also get this error in the logs:

mysql_real_escape_string() expects parameter 1 to be string, array given in includes/database.mysql.inc  on line 321