Closed (fixed)
Project:
Import / Export API
Version:
5.x-1.1
Component:
Code
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
21 Jun 2007 at 20:26 UTC
Updated:
29 Jun 2007 at 19:42 UTC
I am new to this module (which is fantastic...thanks) and I can't figure out how to get data from a different database. My goal is to pull some node-like data from a MS SQL database (which I have done in the past using odbc) and put it into my Drupal-based Intranet. Do I need to write a new dbget engine (hopefully not as that seems a bit daunting)? Can I specify the db source in the entity definition (the API has documentation on specifying the table but not the db)?
Any help would be greatly appreciated.
- jacob
Comments
Comment #1
Sunil Mohan commentedI would suggest that you export some existing nodes from drupal and study the output XML/CSV format.
Then somehow export your MS SQL data into that kind of XML format. Then import is straight forward using this module.
Comment #2
jacoblane commentedThanks, will do.
Comment #3
jacoblane commented