FlowHeater Logo

FlowHeater Support Forum

simply more productive

Download the freeware version (10 Mb)

Up to 100,000 records can be processed with the freeware version!

Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Suppressing warnings about null fields

Suppressing warnings about null fields 1 year 8 months ago #2661

  • Michael Orr
  • Michael Orr's Avatar Topic Author
  • Offline
  • Posts: 2
I am converting about 2 million records for delimited text to SQL Server. Most records contain 300 fields and several of these fields are likely to contain null values. When these are converted to integer, date or decimal SQL fields I get a warning like "The value [] unable converted to date!", There are about 10 warnings for each of the 2 million records, and they are not a concern. However there are so many messages I cannot tell if there are some other important warning messages (e.g. about truncation). Is there a way I can suppress or eliminate these Null warnings without suppressing other warning messages?
I would appreciate any advice you can give me.
Thanks!

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

Suppressing warnings about null fields 1 year 8 months ago #2663

Hello Michael,

I’m wonder why till now no one complain about this strange feature :unsure: Of course this makes no sense. In case the SQL Server field allows DBNULL no warning should occur if an empty string is the value.

I’ve made a short modification. You can download a fixed version here

FlowHeaterBeta 32 Bit
FlowHeaterBeta 64 Bit

Note: It´s planned to release the next official version latest end of April.

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

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Suppressing warnings about null fields 1 year 8 months ago #2667

  • Michael Orr
  • Michael Orr's Avatar Topic Author
  • Offline
  • Posts: 2
Thanks! :)

I really appreciate the fast response.

I installed the 64-bit version and tested it.

The write messages about nulls are now suppressed but I am still getting all of the read warnings messages for null fields. There are over 20 million of them!

Is it possible for you to suppress the read warnings too?

Mike Orr

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

Suppressing warnings about null fields 1 year 8 months ago #2668

Hello Mike,

In the TextFile Adapter on the READ side you just have to switch the defined data type to “String”. Only in special cases you have to define the exact data type for CSV files . FlowHeater needs just the right format (defined on READ) to transform the containing string value to the desired once on the WRITE side.

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

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
  • Page:
  • 1
Time to create page: 0.103 seconds