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?