Transfering multiple .cvs into a tmySQLOutput

[FGuijarro]

Hi,

I´m trying to merge 5 .cvs files (all of them have same schema) and copying data into tMysqlOutput.

I´m getting the detail message: "Invalid character constant" but I´m not able to know the problem.

Design is attached in uploaded jpg file.

• INPUTS: 4 .cvs files. Each file contains 4 columns: name, prefix, date and price
• OUTPUT: (DB tmysqlOutput)
  • Output DB has same 4 columns as the input
  • ID column added: `id` bigint(20) NOT NULL AUTO_INCREMENT

• TFileList: contains path where 5 .cvs files are located

• TFileInputDelimited contains:
  • File name: ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))
  • Schema: same as output MySQL DB
• tUnite contains:
  • same mySQLOutput DB schema
• mySQLOutput contains:
  • mySQLOutput schema

Is there any design issue?

Thanks for any help you may offer me.

[Anonymous]

Hello,

You don't necessarily need the Merge component.

You could enable log4j debug/trace logs to see which files are being opened by tFileList (maybe it opens the wrong file?)

Also the fileInput Character Encoding can be changed and it should match with the input file. Maybe you have an accent there (áéúűó) that requires a different setting? (UTF-8 , ISO8859-xx, etc) Notepad++ makes it relatively easy to understand which encoding is used.

Cheers,

Balázs

[FGuijarro]

Thanks for your feedback!

The "merge component" you mean... tUnite?

Where can I change the fileInput character Encoding? Content for those files are simple... no accents, no symbols... just numbers, and plain letters.

What about to add one more column in the output than the input files have?

Should I unsynchronize the output schema because of that added new column? (id auto sequence)

Thank you!