FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the SqlServer Adapter Adapter, which may answer your question: CSV text file import , flat file export , Import IDENTITY (Auto Increment) fields , CSV export divided into several files

Suppressing warnings about null fields

  • Michael Orr
  • Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 10 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 or Create an account to join the conversation.

More
6 years 10 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 or Create an account to join the conversation.

  • Michael Orr
  • Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 10 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 or Create an account to join the conversation.

More
6 years 10 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 or Create an account to join the conversation.

Time to create page: 0.370 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en