Anonymous_User Absent Member.
Absent Member.
164 views

Including column headers in text driver output


Hello,

Newbie to IDM here; been reading a lot of great post by everyone and
like to thank you for the help they provided me so far. I have now
though run across a process which I haven't been able to locate a
solution.

We are using a Text Driver to provide a CSV file to our ISP as a way of
synchronizing our student data. The driver is working great and all the
necessary data is being exported from the ID vault. The only challenge
is the ISP requires a header row, which we are currently adding
manually. The goal would be for the Driver to add this header row for
us, so be can automate the synchronization process.

Is there a way to populate the header row with the @attr-name?

Thanks, Allen


--
allenmorris
------------------------------------------------------------------------
allenmorris's Profile: https://forums.netiq.com/member.php?userid=1565
View this thread: https://forums.netiq.com/showthread.php?t=49207

Labels (1)
0 Likes
3 Replies
Knowledge Partner
Knowledge Partner

Re: Including column headers in text driver output

On 11/12/2013 10:54 AM, allenmorris wrote:
>
> Hello,
>
> Newbie to IDM here; been reading a lot of great post by everyone and
> like to thank you for the help they provided me so far. I have now
> though run across a process which I haven't been able to locate a
> solution.
>
> We are using a Text Driver to provide a CSV file to our ISP as a way of
> synchronizing our student data. The driver is working great and all the
> necessary data is being exported from the ID vault. The only challenge
> is the ISP requires a header row, which we are currently adding
> manually. The goal would be for the Driver to add this header row for
> us, so be can automate the synchronization process.


This is the same basic problem as the earlier discussion of the
notifying on the end of the file being written.

The driver as written, does not provide an 'event' at the start or end
of the file writing.

Clearly this is a needed feature, and in hindsight an oversight.

The generic answer is to write a Java extension to implement this. I
think I have the template for that.

I think (as probably do most) that the driver should somehow do this.
(Heck, I would love an event counter on Pub channel, where @counter=0,
or @counter=200 so you would know how far along in the file you are...)

A simpler option might be a polling script on the recieving end to paste
in the header line. Of ocurse, then you have to maintain that, when you
change the attributes in the filter as well.

On a side note, I was looking at a newer version of the Delim text
driver, and they changed the XSLT around, and it looks like they iterate
through the config option listing the fields and handle each, instead of
the old XSLT where they basically hardcoded the attributes in the ITP
and OTP stylesheets to be handled.

I like this approach much better.


0 Likes
cpedersen Outstanding Contributor.
Outstanding Contributor.

Re: Including column headers in text driver output

Geoffrey,

I covered that here:
https://www.netiq.com/communities/cool-solutions/how-to-handle-parallel-processing/

You loop through the input document and add an op-attr with a counter...

Casper


On 11/12/13, 5:16 PM, Geoffrey Carman wrote:
> On 11/12/2013 10:54 AM, allenmorris wrote:
>>
>> Hello,
>>
>> Newbie to IDM here; been reading a lot of great post by everyone and
>> like to thank you for the help they provided me so far. I have now
>> though run across a process which I haven't been able to locate a
>> solution.
>>
>> We are using a Text Driver to provide a CSV file to our ISP as a way of
>> synchronizing our student data. The driver is working great and all the
>> necessary data is being exported from the ID vault. The only challenge
>> is the ISP requires a header row, which we are currently adding
>> manually. The goal would be for the Driver to add this header row for
>> us, so be can automate the synchronization process.

>
> This is the same basic problem as the earlier discussion of the
> notifying on the end of the file being written.
>
> The driver as written, does not provide an 'event' at the start or end
> of the file writing.
>
> Clearly this is a needed feature, and in hindsight an oversight.
>
> The generic answer is to write a Java extension to implement this. I
> think I have the template for that.
>
> I think (as probably do most) that the driver should somehow do this.
> (Heck, I would love an event counter on Pub channel, where @counter=0,
> or @counter=200 so you would know how far along in the file you are...)
>
> A simpler option might be a polling script on the recieving end to paste
> in the header line. Of ocurse, then you have to maintain that, when you
> change the attributes in the filter as well.
>
> On a side note, I was looking at a newer version of the Delim text
> driver, and they changed the XSLT around, and it looks like they iterate
> through the config option listing the fields and handle each, instead of
> the old XSLT where they basically hardcoded the attributes in the ITP
> and OTP stylesheets to be handled.
>
> I like this approach much better.
>
>


0 Likes
Anonymous_User Absent Member.
Absent Member.

Re: Including column headers in text driver output


Thanks to you both for your input.

I'll give your ideas a try.

Allen


--
allenmorris
------------------------------------------------------------------------
allenmorris's Profile: https://forums.netiq.com/member.php?userid=1565
View this thread: https://forums.netiq.com/showthread.php?t=49207

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.