Drupal 6 Data import

Migrate data from MS SQL based CMS to Drupal 6

1,500 news articles
3,000 events
3,300 jobs
400 volunteering opps
5,000 organisations

Approach

use node import module
export content as CSV files - basic node requirements
import body content or extra fields via SQL updates

Organisations

Copy available logos to files/logos folder
Logos - Prepare files table ie create rows with fid, file name, path etc
Prepare tblCore CSV with key fields and including cross reference to fid
Run append to files table
Import Orgs via node_import
Import organisation description using SQL update

Other articles - jobs, news, events etc

Images ?
Internal paths?
prepare csv per content type - get new nid from organisations and include for node reference.
Import basic node details
Update body and other fields using SQL update