OpenIDM 4 – CSV Connector – Unable to push users to CSV

This topic has 4 replies, 2 voices, and was last updated 5 years, 8 months ago by srikanthMedisetti.

  • Author
    Posts
  • #8412
     srikanthMedisetti
    Participant

    Hello All,

    I’m using OpenIDM 4.0 and configured a CSV connector(1.5.0.0). I was trying to reconcile users(Manage\users as source and CSV file as target), the users got created in CSV file successfully but when the user got updated in Manage\user the changes are not being pushed to the target(CSV). So can someone help me in this. Here is my configuration.

    Provisioner.json

    “configurationProperties” : {
    “csvFile” : “C:\\OpenIDMStuff\\CSVConnectorUsers.csv”,
    “headerUid” : “uid”,
    “quoteCharacter” : “\””,
    “headerPassword” : “password”,
    “fieldDelimiter” : “,”,
    “syncFileRetentionCount” : “3”,
    “newlineString” : “\n”,
    “headerName” : “username”,
    “readSchema” : false,
    “uniqueAttribute” : “uid”
    },
    “name” : “CSVFileConnector”,
    “enabled” : true,
    “objectTypes” : {
    “__ACCOUNT__” : {
    “$schema” : “http://json-schema.org/draft-03/schema”,
    “id” : “__ACCOUNT__”,
    “type” : “object”,
    “nativeType” : “__ACCOUNT__”,
    “properties” : {
    “firstName” : {
    “type” : “string”,
    “nativeType” : “string”,
    “nativeName” : “firstName”,
    “required” : false
    },
    “__NAME__” : {
    “type” : “string”,
    “nativeType” : “string”,
    “nativeName” : “__NAME__”,
    “required” : false
    },
    “__UID__” : {
    “type” : “string”,
    “nativeType” : “string”,
    “nativeName” : “__UID__”,
    “required” : true
    },
    “email” : {
    “type” : “string”,
    “nativeType” : “string”,
    “nativeName” : “email”,
    “required” : false
    },
    “status” : {
    “type” : “string”,
    “nativeType” : “string”,
    “nativeName” : “status”,
    “required” : false
    },
    “lastName” : {
    “type” : “string”,
    “nativeType” : “string”,
    “nativeName” : “lastName”,
    “required” : false
    }
    }
    }

    Sync.json

    {
    “target” : “system/CSVFileConnector/__ACCOUNT__”,
    “source” : “managed/user”,
    “name” : “managedUser_sourceCsvfileconnector__ACCOUNT__”,
    “properties” : [
    {
    “target” : “__NAME__”,
    “source” : “userName”
    },
    {
    “target” : “firstName”,
    “source” : “givenName”
    },
    {
    “target” : “email”,
    “source” : “mail”
    },
    {
    “target” : “status”,
    “source” : “accountStatus”
    },
    {
    “target” : “lastName”,
    “source” : “sn”
    }
    ],
    “policies” : [
    {
    “action” : “EXCEPTION”,
    “situation” : “AMBIGUOUS”
    },
    {
    “action” : “EXCEPTION”,
    “situation” : “SOURCE_MISSING”
    },
    {
    “action” : “CREATE”,
    “situation” : “MISSING”
    },
    {
    “action” : “EXCEPTION”,
    “situation” : “FOUND_ALREADY_LINKED”
    },
    {
    “action” : “DELETE”,
    “situation” : “UNQUALIFIED”
    },
    {
    “action” : “EXCEPTION”,
    “situation” : “UNASSIGNED”
    },
    {
    “action” : “EXCEPTION”,
    “situation” : “LINK_ONLY”
    },
    {
    “action” : “IGNORE”,
    “situation” : “TARGET_IGNORED”
    },
    {
    “action” : “IGNORE”,
    “situation” : “SOURCE_IGNORED”
    },
    {
    “action” : “IGNORE”,
    “situation” : “ALL_GONE”
    },
    {
    “action” : “UPDATE”,
    “situation” : “CONFIRMED”
    },
    {
    “action” : “UPDATE”,
    “situation” : “FOUND”
    },
    {
    “action” : “CREATE”,
    “situation” : “ABSENT”
    }
    ],
    “correlationQuery” : [
    {
    “linkQualifier” : “default”,
    “expressionTree” : {
    “all” : [
    “__NAME__”
    ]
    },
    “mapping” : “managedUser_sourceCsvfileconnector__ACCOUNT__”,
    “type” : “text/javascript”,
    “file” : “ui/correlateTreeToQueryFilter.js”
    }
    ],
    “enableSync” : true,
    “recon” : {
    “_id” : “32835105-f657-4aac-bc8d-f41ae6dfea14-4062”,
    “mapping” : “managedUser_sourceCsvfileconnector__ACCOUNT__”,
    “state” : “SUCCESS”,
    “stage” : “COMPLETED_SUCCESS”,
    “stageDescription” : “reconciliation completed.”,
    “progress” : {
    “source” : {
    “existing” : {
    “processed” : 36,
    “total” : “36”
    }
    },
    “target” : {
    “existing” : {
    “processed” : 36,
    “total” : “36”
    },
    “created” : 0
    },
    “links” : {
    “existing” : {
    “processed” : 36,
    “total” : “36”
    },
    “created” : 0
    }
    },
    “situationSummary” : {
    “SOURCE_IGNORED” : 0,
    “MISSING” : 0,
    “FOUND” : 0,
    “AMBIGUOUS” : 0,
    “UNQUALIFIED” : 0,
    “CONFIRMED” : 36,
    “SOURCE_MISSING” : 0,
    “ABSENT” : 0,
    “TARGET_IGNORED” : 0,
    “UNASSIGNED” : 0,
    “FOUND_ALREADY_LINKED” : 0
    },
    “statusSummary” : {
    “FAILURE” : 0,
    “SUCCESS” : 36
    },
    “parameters” : {
    “sourceQuery” : {
    “resourceName” : “managed/user”,
    “queryId” : “query-all-ids”
    },
    “targetQuery” : {
    “resourceName” : “system/CSVFileConnector/__ACCOUNT__”,
    “queryId” : “query-all-ids”
    }
    },
    “started” : “2016-03-04T14:17:00.059Z”,
    “ended” : “2016-03-04T14:17:01.167Z”,
    “duration” : 1108
    }
    }

    Thanks in advance !!

    #8418
     srikanthMedisetti
    Participant

    Seems there is an issue in the latest CSV Connector, I have used the previous version and was able to push the updates to CSV.

    #8424
     tim.sedlack
    Participant

    Would it be possible to configure it using the last version of the CSV connector and see if the problem still exists? Seems like that would be a way to determine pretty quickly if there was a bug in the new version of the CSV (and hopefully you have a support case going on this!)

    Thanks,
    Tim

    #8430
     srikanthMedisetti
    Participant

    I have used CSVConnector 1.5.0.0, but not able to workout with that. Do you have any other updated version?

    And is there any way to push only deltas to the CSV?
    Here is my scenerio:
    Day 1: Reconciled all users and now my CSV contains all the users from IDM.
    Day 2: Now some users got updated in IDM, now if I do a recon I want the users who got updated rather than all users to be present in the CSV.

    Is this possible?

    Thanks,
    Srikanth

    #8519
     srikanthMedisetti
    Participant

    Can anyone please help me in the above scenerio?

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.

©2021 ForgeRock - we provide an identity and access platform to secure every online relationship for the enterprise market, educational sector and even entire countries. Click to view our privacy policy and terms of use.

Log in with your credentials

Forgot your details?