Dear reader,
My company has department information stored on an Oracle database. I want to pull the information of the different departments out of this database and use it in my drupal website. The main reason for this is that I want to avoid to fill my database with all the departments manually, cause when department info changes we would have to change two databases then.
I was thinking of hardcoding a content type called department in drupal and by some way reading the Oracle database and filling these department nodes with the data from the Oracle db.
Then I want to be able to create different content types in CCK that can node reference to this department nodes filled with data out of the Oracle database.
Anyone who can push me into the right direction here?
If you need anymore information or have alternative ways to fix my problem please be so kind to share it with me!
kind regards,
Fons
Comments
Table Wizard, Migrate and
Table Wizard, Migrate and Node Import modules are worth a look.
http://drupal.org/project/tw
http://drupal.org/project/migrate
http://drupal.org/project/node_import
Table wizard can Views-enable a table (or create a views-enabled table of imported data).
Migrate turns those views into nodes.
Node import imports from a file directly to nodes.
I would suggest that getting an export of the department information in csv format would be the first step. Once you have that you can run test imports using the above and see what works for you.
CCK support is probably a key issue to weigh -- does the module support the field types you need or not?
Ezra Wolfe
DLC Solutions
EthosCE
"Then I want to be able to
"Then I want to be able to create different content types in CCK that can node reference to this department nodes filled with data out of the Oracle database."
iam facing the same thing i want to use cck files that read employee name from oracle DB, or read clients one something like auto complete field.
is there any solutions rather than import it to our mysql DB?
www.vteam-sy.com