adewannain Absent Member.
Absent Member.
813 views

Text Delimited with information in output

hello,

I look for during several and don't find solution.

I create a Text Delimited connector with option and now change on user or modification appear in the files but the information are limited.

in fact :

I want, in output in csv, have the name of column and the time of change and appear if is modification or add ou deleted.

I do policy but with add modification and deletd but not appear in files

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE policy PUBLIC "policy-builder-dtd" "C:\Program Files (x86)\Novell\Designer\plugins\com.novell.idm.policybuilder_4.0.0.201206110753\DTD\dirxmlscript4.0.dtd"><policy>
<rule>
<description>Event Transformation - Scope Filtering - Include subtree(s)</description>
<conditions>
<and>
<if-src-dn op="in-subtree">data\users</if-src-dn>
</and>
</conditions>
<actions>
<do-veto disabled="true"/>
</actions>
</rule>
<rule>
<description>groupe membership IT</description>
<comment xml:space="preserve">apartenance au groupe membership IT</comment>
<conditions>
<and>
<if-operation mode="case" op="equal">modify</if-operation>
<if-attr mode="nocase" name="Group Membership" op="equal">data\groups\IT</if-attr>
</and>
</conditions>
<actions>
<do-veto disabled="true"/>
</actions>
</rule>
<rule>
<description>groupe membership IT</description>
<comment xml:space="preserve">apartenance au groupe membership IT</comment>
<conditions>
<and>
<if-operation mode="case" op="equal">add</if-operation>
<if-attr mode="nocase" name="Group Membership" op="equal">data\groups\IT</if-attr>
</and>
</conditions>
<actions>
<do-veto disabled="true"/>
</actions>
</rule>
<rule>
<description>groupe membership IT</description>
<comment xml:space="preserve">apartenance au groupe membership IT</comment>
<conditions>
<and>
<if-operation mode="case" op="equal">delete</if-operation>
<if-attr mode="nocase" name="Group Membership" op="equal">data\groups\IT</if-attr>
</and>
</conditions>
<actions>
<do-veto disabled="true"/>
</actions>
</rule>
</policy>


more in don't find option for have time to change

and Field Names (Field1, Field2, Field3...) not appear in csv.. I see id possible to put yes or not for this apear but I don't have this option ...

help me please
Labels (1)
0 Likes
6 Replies
AutomaticReply Absent Member.
Absent Member.

Re: Text Delimited with information in output

adewannain,

It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.

These forums are peer-to-peer, best effort, volunteer run and that if your issue
is urgent or not getting a response, you might try one of the following options:

- Visit https://www.microfocus.com/support-and-services and search the knowledgebase and/or check
all the other self support options and support programs available.
- Open a service request: https://www.microfocus.com/support
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.microfocus.com)
- You might consider hiring a local partner to assist you.
https://www.partnernetprogram.com/partnerfinder/find.html

Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.microfocus.com/faq.php

Sometimes this automatic posting will alert someone that can respond.

If this is a reply to a duplicate posting or otherwise posted in error, please
ignore and accept our apologies and rest assured we will issue a stern reprimand
to our posting bot.

Good luck!

Your Micro Focus Forums Team
http://forums.microfocus.com



0 Likes
Knowledge Partner
Knowledge Partner

Re: Text Delimited with information in output

On 12/12/2018 6:04 PM, adewannain wrote:
>
> hello,
>
> I look for during several and don't find solution.
>
> I create a Text Delimited connector with option and now change on user
> or modification appear in the files but the information are limited.
>
> in fact :
>
> I want, in output in csv, have the name of column and the time of change
> and appear if is modification or add ou deleted.
>
> I do policy but with add modification and deletd but not appear in files
>
>
>
> Code:
> --------------------
> <?xml version="1.0" encoding="UTF-8"?><!DOCTYPE policy PUBLIC "policy-builder-dtd" "C:\Program Files (x86)\Novell\Designer\plugins\com.novell.idm.policybuilder_4.0.0.201206110753\DTD\dirxmlscript4.0.dtd"><policy>
> <rule>
> <description>Event Transformation - Scope Filtering - Include subtree(s)</description>
> <conditions>
> <and>
> <if-src-dn op="in-subtree">data\users</if-src-dn>
> </and>
> </conditions>
> <actions>
> <do-veto disabled="true"/>
> </actions>
> </rule>
> <rule>
> <description>groupe membership IT</description>
> <comment xml:space="preserve">apartenance au groupe membership IT</comment>
> <conditions>
> <and>
> <if-operation mode="case" op="equal">modify</if-operation>
> <if-attr mode="nocase" name="Group Membership" op="equal">data\groups\IT</if-attr>
> </and>
> </conditions>
> <actions>
> <do-veto disabled="true"/>
> </actions>
> </rule>
> <rule>
> <description>groupe membership IT</description>
> <comment xml:space="preserve">apartenance au groupe membership IT</comment>
> <conditions>
> <and>
> <if-operation mode="case" op="equal">add</if-operation>
> <if-attr mode="nocase" name="Group Membership" op="equal">data\groups\IT</if-attr>
> </and>
> </conditions>
> <actions>
> <do-veto disabled="true"/>
> </actions>
> </rule>
> <rule>
> <description>groupe membership IT</description>
> <comment xml:space="preserve">apartenance au groupe membership IT</comment>
> <conditions>
> <and>
> <if-operation mode="case" op="equal">delete</if-operation>
> <if-attr mode="nocase" name="Group Membership" op="equal">data\groups\IT</if-attr>
> </and>
> </conditions>
> <actions>
> <do-veto disabled="true"/>
> </actions>
> </rule>
> </policy>
> --------------------
>
>
> more in don't find option for have time to change
>
> and Field Names (Field1, Field2, Field3...) not appear in csv.. I see
> id possible to put yes or not for this apear but I don't have this
> option ...
>
> help me please


This is really a question for the Engine-Drivers forum, not really Designer.

So you want the operation type to appear as a field in your CSV?

So perhaps,
delete,objectName
add,objectName,surname,givenname,mail,etc
modify,objectname,surname,givenname,etc

Then you need to define fields that way. Then populate the event with
them, and in the final XSLT transform that converts from XML to CSV
update it appropriately.

If you are having trouble with this particular shim, you might want to
try Stefaan's free Generic Text driver, which is MUCH MUCH simpler to use..

http://vancauwenberge.info/#txtdriver

No XSLT needed.

0 Likes
adewannain Absent Member.
Absent Member.

Re: Text Delimited with information in output

geoffc;2492665 wrote:
On 12/12/2018 6:04 PM,

This is really a question for the Engine-Drivers forum, not really Designer.

So you want the operation type to appear as a field in your CSV?

So perhaps,
delete,objectName
add,objectName,surname,givenname,mail,etc
modify,objectname,surname,givenname,etc

Then you need to define fields that way. Then populate the event with
them, and in the final XSLT transform that converts from XML to CSV
update it appropriately.

If you are having trouble with this particular shim, you might want to
try Stefaan's free Generic Text driver, which is MUCH MUCH simpler to use..

http://vancauwenberge.info/#txtdriver

No XSLT needed.



Hello Thanks for your answer..

I need one files with :

delete,objectname,surname,givenname,etc,date of events
add,objectName,surname,givenname,mail,etc,date of events
modify,objectname,surname,givenname,etc,date of events

the free generic text driver can have professional use ?

it's more easy to use ?
0 Likes
Knowledge Partner
Knowledge Partner

Re: Text Delimited with information in output


> delete,objectname,surname,givenname,etc,date of events
> add,objectName,surname,givenname,mail,etc,date of events
> modify,objectname,surname,givenname,etc,date of events
>
> the free generic text driver can have professional use ?


Ah well, Stefaan supports it, but you cannot pay him to support it. 🙂
(Maybe you can? I am sure he would take your money) I and many others
here have been using it on client sites for years now with pretty darn
good results.

So I feel comfortable running it in production. Your mileage may vary.



> it's more easy to use ?


Much easier.

In the case of his, he does not support what you are asking for
specifically, so what I would do is sub-etp add a policy that tests for
delete|rename events, and then does a modify destination, and add a fake
attr named EventType and include that as a field.

I think this is pretty easy in his driver.

For example, I would define attrs EventType, EventTime, and then do
something like this:

<rule>
<description>[CIS] Convert events</description>
<comment xml:space="preserve">For a forum user</comment>
<comment name="author" xml:space="preserve">Geoffrey Carman</comment>
<comment name="version" xml:space="preserve">1</comment>
<comment name="lastchanged" xml:space="preserve">Dec 17, 2018</comment>
<conditions>
<and>
<if-operation mode="regex"
op="equal">add|modify|delete|rename|move</if-operation>
</and>
</conditions>
<actions>
<do-if>
<arg-conditions>
<and>
<if-operation mode="regex" op="equal">add|modify</if-operation>
</and>
</arg-conditions>
<arg-actions>
<do-add-dest-attr-value class-name="User" name="EventType">
<arg-value type="string">
<token-operation/>
</arg-value>
</do-add-dest-attr-value>
<do-add-dest-attr-value class-name="User" name="EventTime">
<arg-value type="string">
<token-time format="!FULL.DATE" tz="UTC"/>
</arg-value>
</do-add-dest-attr-value>
</arg-actions>
<arg-actions/>
</do-if>
<do-if>
<arg-conditions>
<and>
<if-operation mode="regex" op="equal">delete|rename|move</if-operation>
</and>
</arg-conditions>
<arg-actions>
<do-add-dest-attr-value class-name="User" name="EventType" when="after">
<arg-value type="string">
<token-operation/>
</arg-value>
</do-add-dest-attr-value>
<do-add-dest-attr-value class-name="User" name="CN" when="after">
<arg-value type="string">
<token-operation/>
</arg-value>
</do-add-dest-attr-value>
<do-add-dest-attr-value class-name="User" name="EventTime" when="after">
<arg-value type="string">
<token-time format="!FULL.DATE" tz="UTC"/>
</arg-value>
</do-add-dest-attr-value>
<do-veto/>
</arg-actions>
<arg-actions/>
</do-if>
</actions>
</rule>


0 Likes
adewannain Absent Member.
Absent Member.

Re: Text Delimited with information in output

geoffc;2492708 wrote:

> delete,objectname,surname,givenname,etc,date of events
> add,objectName,surname,givenname,mail,etc,date of events
> modify,objectname,surname,givenname,etc,date of events
>
> the free generic text driver can have professional use ?


Ah well, Stefaan supports it, but you cannot pay him to support it. 🙂
(Maybe you can? I am sure he would take your money) I and many others
here have been using it on client sites for years now with pretty darn
good results.

So I feel comfortable running it in production. Your mileage may vary.



> it's more easy to use ?


Much easier.

In the case of his, he does not support what you are asking for
specifically, so what I would do is sub-etp add a policy that tests for
delete|rename events, and then does a modify destination, and add a fake
attr named EventType and include that as a field.

I think this is pretty easy in his driver.

For example, I would define attrs EventType, EventTime, and then do
something like this:

<rule>
<description>[CIS] Convert events</description>
<comment xml:space="preserve">For a forum user</comment>
<comment name="author" xml:space="preserve">Geoffrey Carman</comment>
<comment name="version" xml:space="preserve">1</comment>
<comment name="lastchanged" xml:space="preserve">Dec 17, 2018</comment>
<conditions>
<and>
<if-operation mode="regex"
op="equal">add|modify|delete|rename|move</if-operation>
</and>
</conditions>
<actions>
<do-if>
<arg-conditions>
<and>
<if-operation mode="regex" op="equal">add|modify</if-operation>
</and>
</arg-conditions>
<arg-actions>
<do-add-dest-attr-value class-name="User" name="EventType">
<arg-value type="string">
<token-operation/>
</arg-value>
</do-add-dest-attr-value>
<do-add-dest-attr-value class-name="User" name="EventTime">
<arg-value type="string">
<token-time format="!FULL.DATE" tz="UTC"/>
</arg-value>
</do-add-dest-attr-value>
</arg-actions>
<arg-actions/>
</do-if>
<do-if>
<arg-conditions>
<and>
<if-operation mode="regex" op="equal">delete|rename|move</if-operation>
</and>
</arg-conditions>
<arg-actions>
<do-add-dest-attr-value class-name="User" name="EventType" when="after">
<arg-value type="string">
<token-operation/>
</arg-value>
</do-add-dest-attr-value>
<do-add-dest-attr-value class-name="User" name="CN" when="after">
<arg-value type="string">
<token-operation/>
</arg-value>
</do-add-dest-attr-value>
<do-add-dest-attr-value class-name="User" name="EventTime" when="after">
<arg-value type="string">
<token-time format="!FULL.DATE" tz="UTC"/>
</arg-value>
</do-add-dest-attr-value>
<do-veto/>
</arg-actions>
<arg-actions/>
</do-if>
</actions>
</rule>



thanks for your reply

for this "rule" I putting in native txt connector or in "http://vancauwenberge.info/#txtdriver" ?
0 Likes
Knowledge Partner
Knowledge Partner

Re: Text Delimited with information in output

On 1/23/2019 5:04 AM, adewannain wrote:
>
> geoffc;2492708 Wrote:
>>
>>> delete,objectname,surname,givenname,etc,date of events
>>> add,objectName,surname,givenname,mail,etc,date of events
>>> modify,objectname,surname,givenname,etc,date of events
>>>
>>> the free generic text driver can have professional use ?

>>
>> Ah well, Stefaan supports it, but you cannot pay him to support it. 🙂
>> (Maybe you can? I am sure he would take your money) I and many others
>> here have been using it on client sites for years now with pretty darn
>> good results.
>>
>> So I feel comfortable running it in production. Your mileage may vary.
>>
>>
>>
>>> it's more easy to use ?

>>
>> Much easier.
>>
>> In the case of his, he does not support what you are asking for
>> specifically, so what I would do is sub-etp add a policy that tests for
>> delete|rename events, and then does a modify destination, and add a
>> fake
>> attr named EventType and include that as a field.
>>
>> I think this is pretty easy in his driver.
>>
>> For example, I would define attrs EventType, EventTime, and then do
>> something like this:
>>
>> <rule>
>> <description>[CIS] Convert events</description>
>> <comment xml:space="preserve">For a forum user</comment>
>> <comment name="author" xml:space="preserve">Geoffrey Carman</comment>
>> <comment name="version" xml:space="preserve">1</comment>
>> <comment name="lastchanged" xml:space="preserve">Dec 17, 2018</comment>
>> <conditions>
>> <and>
>> <if-operation mode="regex"
>> op="equal">add|modify|delete|rename|move</if-operation>
>> </and>
>> </conditions>
>> <actions>
>> <do-if>
>> <arg-conditions>
>> <and>
>> <if-operation mode="regex" op="equal">add|modify</if-operation>
>> </and>
>> </arg-conditions>
>> <arg-actions>
>> <do-add-dest-attr-value class-name="User" name="EventType">
>> <arg-value type="string">
>> <token-operation/>
>> </arg-value>
>> </do-add-dest-attr-value>
>> <do-add-dest-attr-value class-name="User" name="EventTime">
>> <arg-value type="string">
>> <token-time format="!FULL.DATE" tz="UTC"/>
>> </arg-value>
>> </do-add-dest-attr-value>
>> </arg-actions>
>> <arg-actions/>
>> </do-if>
>> <do-if>
>> <arg-conditions>
>> <and>
>> <if-operation mode="regex" op="equal">delete|rename|move</if-operation>
>> </and>
>> </arg-conditions>
>> <arg-actions>
>> <do-add-dest-attr-value class-name="User" name="EventType"
>> when="after">
>> <arg-value type="string">
>> <token-operation/>
>> </arg-value>
>> </do-add-dest-attr-value>
>> <do-add-dest-attr-value class-name="User" name="CN" when="after">
>> <arg-value type="string">
>> <token-operation/>
>> </arg-value>
>> </do-add-dest-attr-value>
>> <do-add-dest-attr-value class-name="User" name="EventTime"
>> when="after">
>> <arg-value type="string">
>> <token-time format="!FULL.DATE" tz="UTC"/>
>> </arg-value>
>> </do-add-dest-attr-value>
>> <do-veto/>
>> </arg-actions>
>> <arg-actions/>
>> </do-if>
>> </actions>
>> </rule>

>
>
> thanks for your reply
>
> for this "rule" I putting in native txt connector or in
> "http://vancauwenberge.info/#txtdriver" ?


Really does not matter. The idea is add an attribute into the flow,
that did not come out of the IDV as a real attribute, so that it can be
written to a file.

So in either driver case, you want to include the event type and maybe
time/date in the file.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.