Dynamic data import / export

datenbank

simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

TOPIC: Suppressing warnings about null fields

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

  • Michael Orr
  • Michael Orr's Avatar
  • Offline
  • New Member
  • 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!
The administrator has disabled public write access.

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
The administrator has disabled public write access.

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

  • Michael Orr
  • Michael Orr's Avatar
  • Offline
  • New Member
  • 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
The administrator has disabled public write access.

Suppressing warnings about null fields 8 months 6 days ago #2668

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.077 seconds