Working with XML
Need guidance/direction with the following task:
I have academic course information (i.e. course title, course number, course description, major, etc.) in an XML file generated periodically from our school's ERP (Datatel Colleague).
I need to display the course information on our website. This content never needs to be updated (in Sitefinity), but it needs to be searchable, and on the academic major pages only the related courses should be displayed.
My questions are:
1. Should I import the XML content into Sitefinity's SQL database, even though the content never needs to be updated therein? And, if so, what API should I be looking into?
2. Should I have Sitefinity talk to the XML file directly and still be able to provide searchable content and content grouped by majors?
3. Should I build a "Courses" module? And, what would that entail?
Any guidance would be greatly appreciated.
Thanks,
Gregory
How is it exposed from the other system, by webservice or just URL?
The other system generates an actual xml file.