I'm trying to use the Table Wizard and Migration modules to import data into a new web site we are developing. Table Wizard seems to be working fine - I have created a table with my import data and TW can add the table and create the view. When I open the view it displays the data that I want to import.
I then go to Migrate and add the Content Set. This shows me the correct number of rows to import. I then map the data fields and begin the import.
Here's the problem though. The import says it has successfully imported the records, a "map" and a "msgs" table are created in the DB and the "map" file is populated. When I go to the "Content" menu, none of the imported data is there. I'm hoping someone can help with troubleshooting this, DB configuration tables that I should review or where in the module code I should look to try to catch where the problem is.
we are using Drupal 6.x and MySQL on Red Hat Linux box.
We have found a work-around. When we imported a content type with an existing node nid the module reported that it had added the records and completed successfully. We could not find the new nodes that should have been added though. We are now clearing all existing content from the new database, not entering the existing nid in Migrate mapping, and then importing everything as a new node. We let Migrate assign the nid's