Can you write a header row on a DT output file?

doesnt seem like this can be modified in anyway to happen in the output

You could easily output a header row in the output transformation fairly 
easily, but the gotcha is that unless you've got the driver set up to 
only output one record per output file, you are going to end up with the 
header row also between every record. If you need more than one record 
per file, the only real way to get a header row is to write an output 
post-processer extension for the driver.

Automatically adding a header row at the beginning of each new file 
sounds like a great idea for an easy enhancement to the driver.



-Father Ramon


Jeff Johnson wrote:
> doesnt seem like this can be modified in anyway to happen in the output

I have more than 1 record per file,,so of course I was getting the header
for every record. 

Since I dont know how to write a post-processor extension---I will just
have to write some script and run it through Sed when it closes.

I will look for the header enhancement in 3.6 :)

On Thu, 15 May 2008 20:13:02 +0000, Father Ramon wrote:

> You could easily output a header row in the output transformation fairly 
> easily, but the gotcha is that unless you've got the driver set up to 
> only output one record per output file, you are going to end up with the 
> header row also between every record. If you need more than one record 
> per file, the only real way to get a header row is to write an output 
> post-processer extension for the driver.
> 
> Automatically adding a header row at the beginning of each new file 
> sounds like a great idea for an easy enhancement to the driver.
> 
> 
> 
> -Father Ramon
> 
> 
> Jeff Johnson wrote:
>> doesnt seem like this can be modified in anyway to happen in the
output

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Did you submit the enhancement request?

Also, assuming the header is always first and then repeated... lose them
all:

grep -v `head -1 /path/to/thefile.csv` /path/to/thefile.csv

Watch out for special characters throwing off grep.

Good luck.





Jeff Johnson wrote:
| I have more than 1 record per file,,so of course I was getting the header
| for every record.
|
| Since I dont know how to write a post-processor extension---I will just
| have to write some script and run it through Sed when it closes.
|
| I will look for the header enhancement in 3.6 :)
|
| On Thu, 15 May 2008 20:13:02 +0000, Father Ramon wrote:
|
|> You could easily output a header row in the output transformation fairly
|> easily, but the gotcha is that unless you've got the driver set up to
|> only output one record per output file, you are going to end up with the
|> header row also between every record. If you need more than one record
|> per file, the only real way to get a header row is to write an output
|> post-processer extension for the driver.
|>
|> Automatically adding a header row at the beginning of each new file
|> sounds like a great idea for an easy enhancement to the driver.
|>
|>
|>
|> -Father Ramon
|>
|>
|> Jeff Johnson wrote:
|>> doesnt seem like this can be modified in anyway to happen in the
output
|>> stylesheet.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFILLAB3s42bA80+9kRAsiWAJwJZFIL2Alg+ApjUmZd43MzMflFIQCeM2Fv
3o7J4lZw4MppxIPt9stqhmA=
=UOEb

interesting,,,but if I am going to have to write something anyway,,i will 
just add a header, instead of stripping all the extraneous ones out. 
Thanks!

On Thu, 15 May 2008 21:49:55 +0000, ab@novell.com wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Did you submit the enhancement request?
> 
> Also, assuming the header is always first and then repeated... lose them
> all:
> 
> grep -v `head -1 /path/to/thefile.csv` /path/to/thefile.csv
> 
> Watch out for special characters throwing off grep.
> 
> Good luck.
> 
> 
> 
> 
> 
> Jeff Johnson wrote:
> | I have more than 1 record per file,,so of course I was getting the
> header | for every record.
> |
> | Since I dont know how to write a post-processor extension---I will
> just | have to write some script and run it through Sed when it closes.
> |
> | I will look for the header enhancement in 3.6 :) |
> | On Thu, 15 May 2008 20:13:02 +0000, Father Ramon wrote: |
> |> You could easily output a header row in the output transformation
> fairly |> easily, but the gotcha is that unless you've got the driver
> set up to |> only output one record per output file, you are going to
> end up with the |> header row also between every record. If you need
> more than one record |> per file, the only real way to get a header row
> is to write an output |> post-processer extension for the driver. |>
> |> Automatically adding a header row at the beginning of each new file
> |> sounds like a great idea for an easy enhancement to the driver.
|>
> |>
> |>
> |> -Father Ramon
> |>
> |>
> |> Jeff Johnson wrote:
> |>> doesnt seem like this can be modified in anyway to happen in the
> output |>> stylesheet.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iD8DBQFILLAB3s42bA80+9kRAsiWAJwJZFIL2Alg+ApjUmZd43MzMflFIQCeM2Fv
> 3o7J4lZw4MppxIPt9stqhmA=
> =UOEb
> -----END PGP SIGNATURE-----