This discussion is archived
4 Replies Latest reply: Sep 19, 2013 4:59 AM by JTF85 RSS

How to handle source empty field in FDM maps

892775 Newbie
Currently Being Moderated
Dear all,

In our projects, data was extracted from EBS with ERPi adapters to HFM through FDM. In this case, some source fields are empty after the data extraction from EBS. The problem is, how can I deal with the empty field in the maps. For now, the workaround is using wildcard (like *->[None]), sth like that. But there is a risk in it, it may happen to ignore some records with error. Do your guys know any special characters stand for the Null in the mapping?

Thanks!
  • 1. Re: How to handle source empty field in FDM maps
    SH Guru
    Currently Being Moderated
    I don't believe FDM will allow you to have a blank value as a source value for a mapping. Depending on your version of ERPI you will have to handle this at import. For 11.1.1.3 in the import format use an import script to check for the existence of blank values and replace with an appropriate default e.g. None or Blank. For 11.1.2 use the same technique but you will have to put the check code in the importation event scripts as import formats are not used in this version.
  • 2. Re: How to handle source empty field in FDM maps
    892775 Newbie
    Currently Being Moderated
    SH, thanks for your reply, now I use conditional mapping to handle it.

    If Len(varValues(17))>0 Then
    Result = varValues(17)
    Else
    Result = "[ICP None]"
    End If
  • 3. Re: How to handle source empty field in FDM maps
    user5445561 Newbie
    Currently Being Moderated

    We have had a workaround solution since moving to V11. This was not a problem in System 9.

    The issue with blanks not defaulting to [None] is that some values escape the test. Such as forcing default values using "Like (* = [None])". If a new code is in your data that is not in your map, the Validation process foiled since [None] is valid and all blanks are now [None]. Only then do you either have an intersection violation that shows up during Export or you get bad data in HFM.

    I don't like this new "feature" in S11 FDM. We will be submitting a request to have the default functionality added back. Perhaps as an option?

    Mike

  • 4. Re: How to handle source empty field in FDM maps
    JTF85 Journeyer
    Currently Being Moderated

    Just for your awareness 892775, we had used a similar approach when we did an upgrade of FDM, but we found that the conditional map scripts had a significant impact in the performance using this.  We went down the path of putting a datapump script on the import format to make null fields actually return a value of "Blank" and then used explicit mapping to map Blank to [none] and it had a dramatic impact on our performance.

     

    Just my 2 cents

    JTF

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points