I apologize if this has been answered before, but I searched the
archives and didn't find it (unless my Google-fu has failed me).
I'm working on project in which the field we're using as the pivot
attribute sometimes has starting or trailing whitespace.
I want to trim this string, so that if someone ever fixes the whitespace
in the attribute value it will not be seen as a different value.
From what I can tell, this should be possible, but in my testing I
don't seem to be having luck.
We're using an hsqldb database as the destination.
Here's what I've done in my lsc.xml file.
My mainIdentifier looks like this:
<mainIdentifier>srcBean.getDatasetFirstValueById("employeeID").trim()</mainIdentifier>
I've then defined the following dataset:
<dataset>
<name>employeeID</name>
<policy>FORCE</policy>
<forceValues>
<string>srcBean.getDatasetFirstValueById("employeeID").trim()</string>
</forceValues>
</dataset>
I would think this would have LSC trim the attribute for all comparisons.
I've also even changed the InetOrgPerson.xml to rtrim & ltrim the
attribute when it inserts the row and for all comparison operations,
which I wouldn't even think would be necessary with the other changes.
Is there a better way to automatically trim the pivot attributes?
Thanks!
-Dan
--
Dan G. Switzer, II
Giva, Inc.
Email: [email protected]
Web Site: http://www.givainc.com
See Our Customer Successes
http://www.givainc.com/customers-casestudies.htm
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
