Generating different files from Source in different formats using XML templates RRS feed

  • Question

  • Hi,

    I need to use a source data (basically a database table with different columns and data loaded or a csv file) and then create different files (lets call them destination files) in different formats (text,excel,pdf etc) based on source data using mappings from columns in source data to columns in destination files. The format and no. of columns would be different for different destination files but source data would be same for all. If a new destination file needs to be created in future, the solution design should as simple as just adding another template for the new file and add to existing templates set.

    any idea on above approach please, what comes in my mind is xml templates using xsd schema but any code references to the same would be greatly appreciated.

    Source data - can be SQL database table or a CSV file

    need to write in C#.NET

    Tuesday, March 8, 2016 11:26 AM


  • Unfortunately this question is way (WAAAY) outside the scope of this forum.  I recommend you look for one of the MSDN forums for help with C#, .NET, and programmatically creating files.  There may be tools that already exist to do these kinds of things.

    Sorry we can't help you here,

    Kevin Remde US DX - IT Pro Evangelism - Microsoft Corporation

    • Marked as answer by Kevin Remde Monday, April 4, 2016 4:23 PM
    Tuesday, March 22, 2016 3:23 PM