Posted: Wed Oct 28, 2009 11:13 am Post subject: XML & TextFile connectors
Hello, I have a couple of questions about XML and text file connectors.
I think XML connector is designed to be read only connector, is it possible to use it for XML output?
Text File connector seems to expect a field formated text file as input/output, I mean your text file has to be composed of several fields of information (fixed position or character separator) so you can identify several columns or fields in the text file and thus move data to those fields (ie, from a table with N columns to a text file with M fields)... but, is there a way to generate a text file with no fields? here you have and example:
let's say we have a MySQL table T with columns N as integer (line number) and C as text (line content), and I want to compose a text file with all content line by line, as if it were typed with a text editor, so I want to copy the content of column C to text file register by register, first register C value to first line of text file, second register C value to second line and so on. How can i do it?
I mean, the resulted text file is not allowed to have a field header neither a field separator, just text