Hi there, I am importing a .csv file and getting the following error. Is there a work around to this without opening the .csv file every time to do a find/replace. In the excel import node there is a 'SubstitudeInvalidCharacters' options which handles this perfect, but it's not in the .txt/.csv import node.
Error occurred while attempting to open output (0) : "output cause: Reserved character (:) on metadata field (12), name: Ultimate Parent Account: Account Name, type: class com.lavastorm.lang.UnicodeString. "
Thanks in advance,
Recent versions of the product were updated to provide the 'SubstitudeInvalidCharacters' property on the CSV/Delimited Input node.
Jamie Johnny Principal Data Advisor Strategic Accounts Direct 905.812.5934 Cell 647.338.9943
Just returning to your original question about a work around. If the fields in the CSV file are well known and will not change then you could use the following approach:
Given the following example data
Set the 'FieldNames' property to the required valid output field names, e.g.
and set the 'SkipHeaderRows' property 1 to ignore the first line in the file.
However, we recommend that you upgrade to a recent version of the product to ensure it is covered by the support policy.
I'll be getting a new machine which will allow me to run an upgrade.