0 Replies Latest reply on Mar 6, 2008 3:04 AM by rambo

    CFLDAP and bulk updates ?

    rambo
      I am using CF 7 Enterprise and I am looking to bulk update active directory with content contained in a .csv file.

      The csv file contains content such as telephone number, e-mail address, name, job title, section etc.

      How can I use CFLDAP to bulk update records in Active Directory from content in the csv.

      With the relevant data for each employee contained in AD being updated with the relevant info contained in the CSV?

      i.e. updating or adding the employee phone number in their Active Directory listing with their correct phone number contained in the CSV file.

      And how would the script know which records to update in AD with the correct data for that employee ? The unique field for each employee is their 'employeeno' which is contained in both the csv and as an Active Directory attribute.

      Any ideas ?

      I.E.

      <cfldap
      action="modify"
      modifyType="replace"
      attributes="telephoneNumber=#CSVTelno#"
      DN="dc=domain,dc=co,dc=uk"
      server="server"
      port="389"
      username="username"
      password="password">