Topic
1 reply Latest Post - ‏2012-11-16T14:56:11Z by kimbert@uk.ibm.com
SystemAdmin
SystemAdmin
4179 Posts
ACCEPTED ANSWER

Pinned topic Database to CSV File question

‏2012-11-16T12:01:11Z |
We are trying to design an interface where
a) we will periodically update the Database using CSV files, and
b) periodically download all the contents of the database to a CSV file format with a fixed filename

We created a Message Set for the CSV file and could get it working (insert data into the table). But we are facing issues while downloading the entire contents of the database into a single CSV file. (We could get the flow working for a XML output).

If anyone can help with a solution, it would be much appreciated.

MB Version : 7.0.0.1
Database : DB2

Database COntent :
Two Columns : Column1 and Column2
Desired Output : Filename : Filename.txt (Fixed)
File Content :
Value1,Value2
............
ValueM, ValueN, etc
Updated on 2012-11-16T14:56:11Z at 2012-11-16T14:56:11Z by kimbert@uk.ibm.com
  • kimbert@uk.ibm.com
    kimbert@uk.ibm.com
    508 Posts
    ACCEPTED ANSWER

    Re: Database to CSV File question

    ‏2012-11-16T14:56:11Z  in response to SystemAdmin
    Not possible to diagnose the problem based on that information. We will need to know what you tried, and what happened. 'We are facing issues' doesn't really convey the picture :-)

    I assume that you are using the MRM parser with a TDS format to write the CSV output, so there should be some error messages telling you what went wrong.