addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Need some advice for migrating data into Drupal 7

From: Derek M.
Sent on: Sunday, July 15, 2012 1:02 PM
Hello Drupalers;

I have a scenario I wanted to ask the group about.

I recently began using Drupal as a system to house some of my bigger application projects. I was recently tasked with a project to move a relatively small MySQL database application over to Drupal, and after doing a bit of research I figured I should get some others opinions.

Basically the app will house client records (lots of survey information). Each client has a profile containing about 10 different forms, then each of the forms has about[masked] questions.

After moving all of the data into Drupal I want to run customized reports, and make different views, pulling bits of data from the client's survey forms. 

My proposed plan of attack is this.
1. Create Content Parts for each of the entities here. A content Type for Clients, and then a content type for each type of Survey

2. Import all the data via the Feeds module. (I'm thinking Migrate may be a little robust for this, no?)

Now I wanted to ask about the following
 
1. Will I be able to pull just small bits from many content types to create custom pages, and reports? Am I going to be able to create/manage relationships between the Clients content type and each of the Surveys content types?

2. Am I approaching the import the right way, via feeds module? Or should I be using something more robust like migrate module.

3. Do I have to create a custom content type by hand for each of the 10 forms (50 questions a piece), or is there an easier way to do this?

I appreciate any and all feedback. Because this is sort of a rush project I wanted to just get some opinions before I dive in and have to start over or something.

====================
Derek Moon
[address removed]

Our Sponsors

  • Mediacurrent

    2016 Diamond Sponsorship, supporting ADUG and DrupalCamp ATL.

  • Sevaa Group

    2016 Diamond Sponsorship, supporting ADUG and DrupalCamp ATL.

  • Pantheon

    2016 Platinum Sponsorship, supporting ADUG and DrupalCamp ATL.

  • SiteGround

    2016 Platinum Sponsorship, supporting ADUG and DrupalCamp ATL.

  • Acquia

    2016 Silver Sponsorship, supporting ADUG and DrupalCamp ATL.

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy