HomeForum
Welcome, Guest
ETL-Forum
Forum
Visual Importer

Mapped field set to Ignore if Null, I get Error Mandatory Field Required if the field is null
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Mapped field set to Ignore if Null, I get Error Mandatory Field Required if the field is null

Mapped field set to Ignore if Null, I get Error Mandatory Field Required if the field is null 5 years, 7 months ago #415

  • John P
This is probably an easy question but tell me why I keep getting the Error Mandatory Field Required even after I set the mapping instruction to ignore if null.
Reply Quote

RE: Mapped field set to Ignore if Null, I get Error Mandatory Field Required if the field is null 5 years, 7 months ago #416

  • mike8888
  • OFFLINE
  • Expert Boarder
  • Posts: 131
  • Karma: 0
May be your database does not accept null fileds for that particular field

Try to assign default value to your filed

Mike
Reply Quote

RE: Mapped field set to Ignore if Null, I get Error Mandatory Field Required if the field is null 5 years, 7 months ago #418

  • Yep that worked206
It worked but .TPS files (TopSpeed Clarion Database) does accept null values. I’m using the latest ODBC 5.02 Clarion driver. I wonder what’s wrong with my setup.
Reply Quote

RE: Mapped field set to Ignore if Null, I get Error Mandatory Field Required if the field is null 5 years, 7 months ago #419

  • mike8888
  • OFFLINE
  • Expert Boarder
  • Posts: 131
  • Karma: 0
Can I ask you to email us couple of screehshots, so we can see the mapping for the field which is failing.
Mike
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Visual Importer
Powered by Kunena
Time to create page: 0.16 seconds

Testimonials

Well this great product and I’ve ever seen …. Yet.

Inexpensive
User friendly
Trusted and Reliable
Best features
Great support
Very fast and best performance
Recommend for all groups (small, medium, large / enterprise)

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top