Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Suppressing warnings about null fields

More
7 years 11 months ago #2661 by Michael Orr
Suppressing warnings about null fields was created by Michael Orr
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 to join the conversation.

More
7 years 11 months ago #2663 by FlowHeater-Team
Replied by FlowHeater-Team on topic Suppressing warnings about null fields
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.

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.

Please Log in to join the conversation.

More
7 years 11 months ago #2667 by Michael Orr
Replied by Michael Orr on topic Suppressing warnings about null fields
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 to join the conversation.

More
7 years 11 months ago #2668 by FlowHeater-Team
Replied by FlowHeater-Team on topic Suppressing warnings about null fields
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.

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.

Please Log in to join the conversation.

Time to create page: 0.367 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.