Import CSV with particular text after "CN="

[assangflexx]

Hi all,

Like the title says. I have a bunch of information in a CSV file that i want to have in my FMP database.

About CSV (Also in attachement)

First row says only information.

Second Row and so on begins Distribution list and users (separated in a own cell)

First collumn contains the name of the D.list and one of the usernames. Then each second column has his own user in it.

When I import, it only wants to import the first column. Is there a way without conversion or change original csv to import all the users.

Goal is, i want to keep and look easy information from the Active Directory about users. I already have scripts that updates, import changes or add non-existing records (users).

Who can help me :

distro_tmp2.csv.zip

[Matthew F]

When I unzip your your CSV file it is all messed up. Instead of carriage returns or line endings their are dozens of semi-colons and sometimes multiple return characters. Also some values have double quotes around them. It won't open correctly in Excel or Filemaker until you strip these out. Once that is done it imports fine.

[assangflexx]

Well, the same thing said my fellow worker yesterday. He isn't a FileMakerPro expert, but that was his logical thinking.

Already trying with different commands. Now playing with ADFIND.

Does someone know a programm, commandline where you can create your own style of output. So i can make the output exactly how FMP it wants.

[comment]

There is no need to "create your own style of output". Filemaker can import a variety of standard formats. One of them is CSV - but your earlier file does not conform to the standard.

[assangflexx]

Can someone tell me than if there is a easier way to import data from Active Directory into FMP.

Adfind didn't do the trick i wanted.

Is it possible to use Powershell within FMP? Like FMP can call a command to CMD

[Wim Decorte]

Can someone tell me than if there is a easier way to import data from Active Directory into FMP.

Adfind didn't do the trick i wanted.

Is it possible to use Powershell within FMP? Like FMP can call a command to CMD

Yes you can, with the Send Event script step you can execute anything, including powershell scripts. You can even dynamically generate your powershell scripts and then use "export field contents" to create them on the hard disk and execute them.

The challenge is in having the powershell script talk back to FM. You can use interop and the FM activeX interface for that but it'll be shaky. You can also use fmDotNet in your powershell script and push the data directly to filemaker server...