# Error when importing from Vanilla

**URL:** <https://meta.discourse.org/t/error-when-importing-from-vanilla/33716>\
**Category:** Migration\
**Created:** [September 24, 2015, 6:16pm UTC](https://meta.discourse.org/t/error-when-importing-from-vanilla/33716 "2015-09-24T18:16:59Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![huulbaek](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/huulbaek/32/46692_2.png) [@huulbaek](https://meta.discourse.org/u/huulbaek)\
**Post date:** [September 24, 2015, 6:16pm UTC](https://meta.discourse.org/t/error-when-importing-from-vanilla/33716/1 "2015-09-24T18:16:59Z")

</div>

So, I am trying my very best to import a ExpressionEngine forum to Discourse. I rewrote some of the Vanilla Porter to make it work with our version of ExpressionEngine (1.6.9) and got the 1.3gb CSV file. But, when finally trying to import to Discourse this happens:

```
$ RAILS_ENV=production ruby script/import_scripts/vanilla.rb /shared/export.txt
loading existing groups...
loading existing users...
loading existing categories...
loading existing posts...
loading existing topics...
parsing file...
reading file...
parsing conversations...
parsing user_conversations...
parsing conversation_messages...
parsing permissions...
parsing users...
parsing roles...
parsing user_roles...
parsing categories...
parsing discussions...
parsing comments...
/usr/local/lib/ruby/2.0.0/csv.rb:1823:in `block (2 levels) in shift': Missing or stray quote in line 157118 (CSV::MalformedCSVError)
	from /usr/local/lib/ruby/2.0.0/csv.rb:1816:in `each'
	from /usr/local/lib/ruby/2.0.0/csv.rb:1816:in `block in shift'
	from /usr/local/lib/ruby/2.0.0/csv.rb:1776:in `loop'
	from /usr/local/lib/ruby/2.0.0/csv.rb:1776:in `shift'
	from /usr/local/lib/ruby/2.0.0/csv.rb:1718:in `each'
	from /usr/local/lib/ruby/2.0.0/csv.rb:1732:in `to_a'
	from /usr/local/lib/ruby/2.0.0/csv.rb:1732:in `read'
	from /usr/local/lib/ruby/2.0.0/csv.rb:1291:in `parse'
	from script/import_scripts/vanilla.rb:63:in `parse_file'
	from script/import_scripts/vanilla.rb:17:in `execute'
	from /var/www/discourse/script/import_scripts/base.rb:45:in `perform'
	from script/import_scripts/vanilla.rb:254:in `<main>'

```

I guess my question is: How would I find out what line 157118 contains? I guess this is a line after the importer has done something to the original CSV? Because the original line looks fine.

---

_[View the full topic](https://meta.discourse.org/t/error-when-importing-from-vanilla/33716)._