I'm importing ampersands into my title field and it causes Apache2 to blast up to 100% and crash the box, eventually causing an out-of-memory error. Confirmed by re-running import file and it crashes at the same record each time. Deleting that record reliably causes the same crash on the next record with an ampersand in the title.

Comments

Todd Young’s picture

Todd Young commented

Single-apostrophe's are doing it also, when my CSV has double-quote and comma delimiters. Seems like standard escaping is not happening, which seems too common of a bug, which makes me think it might be me (and/or) that I missed something. But I searched for such an issue, so dunno...

Todd Young’s picture

Todd Young commented

Square brackets... OK, I'll stop now and listen to the experts.

Todd Young’s picture

Todd Young commented
Status: Active » Closed (fixed)

Not always though, there's more to this than I originally expected. This morning it's working; there's a ghost in the machine or more variables at play here.

As a noob I think I need to close this out and do more troubleshooting, please stand by.

zeezhao’s picture

zeezhao commented

Also, you need to remember to select the right escape character during the import in "step 3 of 8" - the last column, and the "text delimiter" - the column before it.

If you don't do so, and some of the records have some non-standard characters, it can cause node_import to hang...

Personally, to avoid these issues, when generating a csv for import, I use

- Pipe ("|") as the "Field separator"
- double quote as "Text delimiter"
- Backslash ("\") as "Escape character"