Error when importing from Vanilla

I accept that answer :smile:

This is what I ended up doing should someone else get themselves in the same situation (I doubt that!):

  1. Make copy of MySQL database.
  2. Convert database copy and tables to UTF-8 if necessary.
  3. Export to CSV via Vanilla Porter - requires some small changes in the source to support older ExpressionEngine versions.
  4. Install Vanilla and import CSV into new database.
  5. Use vanilla_mysql.rb to import from this database - either remotely or locally.

@riking: Regarding that last step I had to make minor correction because users is not defined in

   next if all_records_exist? :users, users.map {|u| u['UserID'].to_i}

Not making any PR’s because I know nothing about Ruby.

3 Likes