Imanami Community

I basically have the following script on a source field:

If InStr(1,DTM.Source("SOMEFIELD"),"abc",vbTextCompare) = 0 Then
    DTM.Result = DTM.Source("SOMEFIELD")
else
 What command do i use to have DTM ignore this field when it process
end if

My source is a text file; updating Active Directory

 Thanks in advance; Tim

Hello Tim,

You can use DTM.CancelRow to abort the processing of the row.  Here is a simple script:

 If True Then
    DTM.Result = DTM.Source("SomeField")
Else
    DTM.CancelRow
End If

Is this the command you where looking for?  If so, please post back with your testing results.

Looking forward to hearing from you soon.

Thanks. However, I don't want to cancel the row/record. I think I need to put my code in the global script on event DTM.RowChaning; The want to check if a specific source field contains something; if it does; don't update, let say, 3 out 5 fields from the source. e.g.

Source: abc.txt Destination: Active Directory

Field1, Field2, Field3, Field4, Field5
ABC,DEF-FEILD,ABC123,ABC345,ABC567

Pseudo code:
If Field 2 contains "-FIELD" then do not update the destination field3 with value from source field3; however continue to update field4 and field5

Also; does Imanami have a bit more detail on the all of DTM field avaialble and their usage? Where do i get the powertools from too ...

 Thanks in advance.

Tim

Hello Dawgs,

This sounds a little more complex then I thought.  Please contact Imanami Client Service to help you develop a script that will fit your business requirement.  You can contact them by calling 925-273-2909 or send an email to roger.manson@imanami.com.

Looking forward to hearing from you soon.