TDI v7 LDIF to CSV output?

[Peter]

Hi all

I've downloaded the TDI 7 trial pack and I'm trying to use the
filesystem connector to iterate through an LDIF file and output to a
CSV file. I can't seem to get a parser that will allow me to read the
file and set up the attributes I need. Any ideas?

Best Regards

Peter

[Peter]

Guess I should have included what I'm trying to do - I need to iterate
through a list of unique id's, query our directory for the unique id's
and pull back the ldapkey of their sponsor, then pull back the
information for the sponsor and correlate the two. My attempt was to
do this in two passes, get a list of users (what's in my ldif file),
output in csv format. Then run another query based on the ldapkey of
their sponsor and match them up.

thanks again

Peter

[Eddie Hartman]

What error are you getting, Peter? Try turning on Detailed Log
for the LDIF Parser and then run your AL to get more information
about what the Parser is doing. Maybe there is some guidance
there.

Alternatively, you could send me the LDIF file and your Config
XML (which TDI 7 generates each time you save/run in the
Resources > Runtime-<project name> folder of your workspace)

-Eddie

[Peter]

Thanks Eddie!

I figured it out - my initial ldif file was ugly - I'm sure I could
have set conditions to omit the lines I got back containing non key-
pair characters, but I just used a text tool to clean up the data so I
had only key pairs in my ldif. Once I had that in place I easily
outputted my csv file - it took longer to run than it did to build. I
need to figure out how to do this all from one mass assembly line
(query lotus, get the unique id for a set of users (affiliates), use
that list of unique id's to query the corp ldap for both affiliate
unique id and their sponsor's ldap key, then match the two together
and output in one csv file. Trying to clean up our licensing and user
base. Right now I'm creating manual spreadsheets - I think TDI will
do the pattern matching once I have all the data together - just have
to monkey with it. TDI 7 is sooo much better than prior versions.

Thanks again.

Peter

[Eddie Hartman]

Thanks, Peter :) We aims to please.

I scripted a Connector that you can use to do lookups
in files of data (e.g. csv) as long as one column/node
in the file is unique for each entry.

http://www.tdi-users.org/twiki/bin/view/Integrator/HashMap

A TDI 7 version should be around the corner. Just
haven't had time to add a Configuration form, etc.
You could just copy this file into Resources > Scripts
and then inherit it into the Script of a Script Connector.

-Eddie