creating header record for data upload

[jaw5]

I'm creating a file for a data upload that needs 1 header record for the file. how can I make a header record a separate line in a csv file using cognos ?

 

[drlex]

If you're using Impromptu, there is an option to have the first line as a header derived from the field names- select 'save as', choose .csv and then view the options before saving.

soi la, soi carré

 

[jaw5]

I'm am using Impromptu, but the only options that are available are "Include column headings", "Quote strings", "Delimiter character", "ASCII value", and the value for end of line (CR LF, LF CR, CR, LF)

 

[drlex]

And "include column headings" is not what you want?

soi la, soi carré

 

[jaw5]

This is an import file. I want 1 line for each record in the query, but I need a header line for the file that contains a description of the version of the software that we are importing the file into.

I tried make a main query for the header, with a subreport for all of the detail lines, but the fields in the subreport query also populate the header.

I may just have to add it with a text editor . . .

 

[drlex]

Ah, OK - I was thinking that the "1 header record" referred strictly to a columns (fields) header.
As you say, either use a text editor to prefix the file or use a short batch file/VB code/cognos script to do such automatically.


soi la, soi carré

 

[jaw5]

Thanks for all of your help. I really appreciate it. Sorry to be such a newbie!