Parse Data Flow
Keith Taylor
that returns records from an Oracle database. One of the fields
returned is the employee's supervisor name. Our HR folks decided to
populate this field "lastname, first name". I want to transform that
to "firstname lastname" before populating that in my domino
directory. I've been searching for an example out there that does
this without success. I imagine this is a gimme for the experts
here. I appreciate your feedback.
Eddie Hartman
Here is an example advanced (JavaScript) map. Note that since the
order that Attributes in a Map are evaluated is NOT ordered, you
cannot base one mapping rule on the result of another in the same
Att Map.
Note also that I am addressing Attributes in "work". If this is to be
in an Input Map then you will use "conn" instead.
---
suprName = work.getString("SupervisorName"); // or whatever it's
called
parts = system.splitString(suprName, ",");
if (parts.length == 2) {
firstName = parts[1];
lastName = parts[0];
}
---
And then you return the value you need in the Attribute Map, or you
can write the values directly to your Entry of choice:
work.setAttribute("FirstName", firstName);
work.setAttribute("LastName", lastName);
Of course, if you programmatically add Attributes to the Work Entry,
then they won't show up in selection lists and drop-downs in the
Config Editor.
Hope this helps!
-Eddie
Keith Taylor
Eddie Hartman
-Eddie