query in database + import database from excel
Dear Drupal Community,
I've made the switch from Rapidweaver a week ago, and have followed the entire Lynda course 'Drupal Essential Training', so I'm quite getting the basics of Drupal and adding content and modules and such.
The site I'm developing requires a certain functionality, however, that I do not know how to implement yet. That is:
My custumer gives me a database Excel file with around 300 different types of textile. Each textile has a different procedure to clean them (well, in fact there are only 5 or 6 different procedures). The visitor to the website will have to enter their textile type (category and number), hit enter, and get the required procedure to clean their textile.
The Excel file looks like:
category - number - some other fields - required procedure
LSA - 9740 - blabla - 3
LSA - 9320 - blabla - 4
etc.
So a breakdown of my problem:
1) how to import a huge Excel file in MySQL?
2) how to make a 'query-page', with a query field and a return procedure?
A thousand thanks for your help!
(links to other posts with similar problems are OK as well, I couldn't find any)
I would..
.suggest looking into the http://drupal.org/project/node_import module and use taxonomy for the "diiferent procedures" some playing around may be required (a gotcha is that the vocabulary should exist prior to any import being made) Then use views to list your records and Taxonomy to sort the records as required, perhaps using exposed views.
Good luck
thanks for your answer! I
thanks for your answer! I only understood half of what you wrote here, but that's even more motivation for me to dig deeper into Drupal ;)
Will keep you posted!
ok
You said:
The Excel file looks like:
category - number - some other fields - required procedure
LSA - 9740 - blabla - 3
LSA - 9320 - blabla - 4
etc.
The "required procedure" is where Taxonomy should be utilised (for Views, navigation...etc) Make sure you have a Vocabulary "procedure" before you import any info.
Good luck!
PS just try to import a few records till you get the hang of it.