Hi Kris
Well, I can't give you any links or samples. Most solutions I've done have been proprietary and anyway not with Office 2007 (as I said, it's too early for that kind of thing - if you beta test that means you work out the code base before there are any samples around!) But I can go into a bit more detail on possible approaches.
1. In any case, you present the user with a selection of data sources. These could be tables in a database, but would more likely be views or stored procs that aggregate tables and pre-filter the data. Say, for example, a list in a Windows Form, or a drop down list on a CommandBar or an Actions pane.
2. The user chooses the data source for which he wants to create a "template". (Insert target controls)
3. This populates a second list with the available field names from the selected data source AND adds the necessary XML into the custom.xml document Part. Selecting a field name inserts the "target" (a ContentControl) into the document and maps it to the matching XML in custom.xml
Have you seen this article
http://msdn2.microsoft.com/en-us/library/ms406053.aspx
|