I have a simple site with a front page with a drop-down menu of 20 clinics. When a clinic is selected we are taken to a page with details of that clinic in 35 text fields. This was created in Dreamweaver using dynamic pages, linking to two MySQL databases, one with simply the list of clinics and the other with information of each of the clinics.

How can I convert this to Drupal, and incorporate into new site?

Can I do it 'simply' with CCK?

Paul

Comments

JohnForsythe’s picture

It wouldn't be difficult to use CCK to create a content type with the fields you require. However, migrating your database to a format Drupal can use would require some MySQL knowledge. You may find the Node Import Module helpful. Your other option would be to reinput everything by hand.

Furthermore, are you planning on keeping the same look for the site? If so, your template will need to be converted to a Drupal theme.

If you would like professional assistance with a migration, I can be contacted through the link in my signature.

--
John Forsythe
Blamcast - Custom theme design and more...

nicolash’s picture

As chaosmachine wrote, CCK would be the way to go. I had to migrate a huge amount of data from another MySQL DB and found the node_save() function invaluable. Because Drupal obviously has it's own way of storing things I created a huge mess trying to migrate the data directly (especially if revisions are enabled).

When using node_save, you basically replicate the standard Drupal way as if you would submit a form, but it can be done programmatic and all data will be properly inserted (or updated).

sherifmayika’s picture