One Star

delete / insert / update with tLDAPOutput

Hello,
I'm having some troubles with the component tLDAPOutput.
First of all, as said in the bug 0015486 (http://www.talendforge.org/bugs/view.php?id=15486), the insert mode "update" still doesn't work for me! Nothing happens when it's only on "update" mode. With "insert or update" mode, it works fine, but in my case I only need to update the entries, not create them, so I'm afraid there are edge effects. I'm using TOS 4.0.0, maybe the bug wasn't fixed yet?
In my project I also need to delete attributes from an LDAP entry. I see in other posts the same unsolved issue (http://www.talendforge.org/forum/viewtopic.php?id=13117, http://www.talendforge.org/forum/viewtopic.php?id=11357, http://www.talendforge.org/forum/viewtopic.php?pid=41596#p41596), but all of them mention the "Use attributes Options" in Advanced settings. The only option I have in Advanced settings is the checkbox tStatCatcherStatistics! So I tried to return the null value in the attribute but it does not change the existing attribute at all, I also tried to return an empty value "" but it does not remove the attribute of the entry (the attribute is empty but still present in the entry). Does that mean that I can't delete attributes in an existing entry?
I don't know, maybe I use the component in a wrong way?
Anyway, thank you in advance for your help!
3 REPLIES
Community Manager

Re: delete / insert / update with tLDAPOutput

Hi
Thanks for reporting! About the first problem, I suggest you to download the latest version v4.2.2 and test again, feel free to reopen issue 15486 if the problem still exist.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: delete / insert / update with tLDAPOutput

Hi Shong,
It was my fault, I did not notice there was a special tab Advanced settings for the UPDATE mode. So when this mode was checked, I was able to access the "Use attributes Options". But it's not written in Reference Guides that the Advanced settings tab is different according to the insert mode or did I miss something in the doc?
Anyway, I tested the UPDATE mode with a "replace" option, it works just fine for updating or creating an attribute.
Yet there is still a problem with null values. In fact I would like to update my entry in LDAP, but when the attribute is null I want it to be removed. I don't know if the value will be null or not before updating the LDAP, so I only use the Attribute option "replace" for all the attributes I want to update. There is a very weird result in the LDAP entry when the attribute is null in the file : the attribute is still there but empty, and the type of the attribut has been modified (from String to Binary). Is this an existing bug?
Here are some screenshots to explain my job.
One Star

Re: delete / insert / update with tLDAPOutput

Could you please help me in understanding why we have different schema for tLDAPInput and tLDAPOutput when i used same repository connection. tLDAPOutput is not showing all attributes from imported LDAP Object.

http://imageshack.us/a/img594/6452/ldapoutputschema.png
http://imageshack.us/a/img28/9843/ldapinputschema.jpg