We are migrating our current intranet to Drupal 6 and there is a lot of data within the current system which can be classified into:
- List data, general lists of fields. Common use is phone list of the employees phone numbers.
- Document repository. Just basically a web version of a file share for documents.
I can easily get the data + meta infomation out, but how do I bulk upload the two types of data into Drupal, as uploading the hundred of thousands of items manually is just not acceptable.
You could try using the Node Import module which lets you bulk create nodes from CSV or Tab separated files. I can't remember as it's quite a long time ago, but I think I used this when I converted a site from Movable Type to Drupal 3 or 4 years ago.
I have been toying with the services and feeds modules. You can use them to move content around. What you actually end up doing is subscribing your new site to your old site and then the content types/taxonomy you select will move. I have not tested this yet. This was only discovered through researching a problem similar to this. I've used feeds before with great success so this should be a cake walk.
Also this post will get the best results on the drupal.stackexchange.com site.