Append CSV file

Question

I have a third-party provider that is asking us for the Name,Phone,Email,Job Title, & Office of every new hire we get sent tot hem in a .CSV file at the end of the week so they can import them into thier software.

If we have a file at c:\user.csv is there a script that we could use that would append that file each time we add a new user?

Thank you,

Comments

Hello,

Unfortunately, there is no such script. However, we can write it for you. It will be executed in a Business Rule triggering After creating a user and append the necessary data into the CSV file. If the solution meets your needs, please, provide us with a sample of the CSV file, clarify the LDAP names of user attributes whose values should be appended to the file and the corresponding column names where the values should be added. Then we will provide you with the script and detailed instructions.

For your information, if you have multiple instances of Adaxes service that share common configuration, the file should be stored in a network share folder. This way, each instance of Adaxes service will be able to write updates into the same file instead of into the separate local ones.

---

Sample of the CSV

CSV = Active Directory Attribute Name = cn Phone = telephoneNumber Email = mail Job Title = title Office = physicalDeliveryOfficeName

File Location would be on a network. \server\folder\sms.csv

Let me know if there is anything I missed or anything else you may need.

Answer 1

Hello,

Thank you for the provided details. To create the Business Rule:

1. Launch Adaxes Administration Console.
2. In the Console Tree, right-click your service node.
3. In the context menu, navigate to New and click Business Rule.
4. On step 2 of the Create Business Rule wizard, select the User object type.
5. Select After crating a user and click Next.
6. Click Add an action.
7. Select Run a program or PowerShell script.
8. Paste the below script into the Script field. In the script:

• $path – Specifies the path to the CSV file.
• $properties – Specifies a map of CSV column names to the value references of corresponding properties.

$path = "\\server\share\users.csv" # TODO: modify me
$properties = [ordered]@{
    "Name"= "%cn%";
    "Phone" = "%telephoneNumber%";
    "Email" = "%mail%";
    "Job Title" = "%title%";
    "Office" = "%physicalDeliveryOfficeName%"
} # TODO: modify me

New-Object PSObject -Property $properties | Export-Csv -Path $path -Append -NoTypeInformation

9. Enter a short description and click OK.
10. Click Next and finish creating the rule.