Welcome Guest! Log in

Topic-icon Question Output File with defined header

More
03 Jul 2015 11:42 #1 by Cedric
Output File with defined header was created by Cedric
Hello,

Is it possible to build a metadata file that contains a defined header ?
This header should be displayed, even though there are no data to extract ...

Thanks for answers

Please Log in or Create an account to join the conversation.

More
07 Jul 2015 11:26 #2 by Thomas BLETON
Replied by Thomas BLETON on topic Output File with defined header
Hi,
Can you please specify where the header should be displayed ?
Are you working with a mapping which reads from a file ? A process which writes to a file ? Which action is being used ?
Thanks

Please Log in or Create an account to join the conversation.

More
07 Jul 2015 13:42 #3 by Cedric
Replied by Cedric on topic Output File with defined header
Hello,

i need to create a file through a process. This file always has a header even if my data request is empty.

For the moment, i generate my data file with the option "Generate If Empty" of the template "Action Process INTEGRATION File (FileExport)".
And then, i put a line with a "Write a file" in append mode "Before" ....

I assume there is something cleaner to do ....

Thanks

Please Log in or Create an account to join the conversation.

More
07 Jul 2015 15:09 #4 by Thomas BLETON
Replied by Thomas BLETON on topic Output File with defined header
Hello,
The "INTEGRATION File (FileExport)" template also has a "Generate Header" option (at the same location as "Generate if Empty").
Please check that it is enabled.
If it is missing in your template, please download the latest template version.
I hope this helps

Please Log in or Create an account to join the conversation.

More
08 Jul 2015 09:17 #5 by Cedric
Replied by Cedric on topic Output File with defined header
Hello,

yes i saw it and tryed to use it. But i did not find where indicate the headers ... :(

Please Log in or Create an account to join the conversation.

More
08 Jul 2015 10:41 - 28 Sep 2016 16:14 #6 by Thomas BLETON
Replied by Thomas BLETON on topic Output File with defined header
The headers are taken from the JDBC result set, they should appear in the result file.
Please send a ticket to the support team.
Edit : attach to the ticket a few screenshot, so that they have enough information : the mapping, the file metadata, the source tables, the query executed by the SQLFileExport action...
Last edit: 28 Sep 2016 16:14 by Thomas BLETON.

Please Log in or Create an account to join the conversation.

More
09 Jul 2015 14:28 #7 by Cedric
Replied by Cedric on topic Output File with defined header
I found it !
i changed the "Physical Name" of the field in the file descriptor...
Some tests to perform but i think it will answer my need !

Thanks

Please Log in or Create an account to join the conversation.