0 votes

Hi support,

[https://www.adaxes.com/questions/752/import-data-wizard]

I am trying to do something similiar to this however in our csv file the column is called 'Termination Date' and we cannot change that.

Based on this would you suggest we map this column to Customattributetext1 and then have a business rule 'Before updating a user' on this atrtibute which runs a powershell task as you have highlighted to add the ldap value to the accountExpires attribute?

related to an answer for: Import Data Wizard
by (90 points)

1 Answer

0 votes
by (271k points)

Hello Mike,

There is no need to overcomplicate things this much. You can just use Script 2: Only update existing users from the following repository article to perform the import: https://www.adaxes.com/script-repository/import-new-and-updated-users-from-csv-file-s246.htm.

0

Hello,

So with that script (#2) I just add the following:

$customColumnNames = @{
    "Termination Date" = "accountExpires";

When I run with this I get an error 'parameter is incorrect'

I currently have this at the top:

$csvFilePath = "c:\temp\ITUserreport-test.csv" # TODO: modify me
$userIdColumn = "employee ID" # TODO: modify me
$userIdProperty = "employeeID" # TODO: modify me
$accountPasswordColumn = "AccountPassword" # TODO: modify me
$customColumnNames = @{
    "Termination Date" = "accountExpires";
} # TODO: modify me
$aDObjectProperties = @("Manager") # TODO: modify me
$skipEmptyColumnNames = @("Last Name","Office Location (Office Location Description)","Line Manager","Position Position Title (Label)","Department (Label)","Business Unit (Label)","Users Sys Id","First Name","Preferred Name","Title (Label)","Email","Division (Label)","Job Classification (Label)","Fixed Term End Date","Start Date","Original Start Date","Continuous Service Start Date","Line Manager (Last Name)","Line Manager (First Name)") # TODO: modify me
0

Hello Mike,

For troubleshooting purposes, please, send us (support@adaxes.com) the CSV file you are using.

0

Hello Mike,

As you want to only update the Account Expires property, the $aDObjectProperties variable should be set to an empty array.

$aDObjectProperties = @() # TODO: modify me

Also, make sure to specify a valid expiration date in the corresponding column of CSV file.

0

Hello Mike,

Thank you for the provided details. The issue occurs because you provided a mapping only for one property while there are much more columns in the CSV file. As a result, for all the other columns, their headers were users as property schema names which caused the issue. Specifying column names in the $skipEmptyColumnNames variable only influenced empty columns, but not jsut al specified. We updated the script accordingly. You can copy it from the article. In your case, the variable should be set exactly as below. Pay attention to the $ignoreUnspecifiedColumns variable.

$csvFilePath = "c:\temp\ITUserreport-test.csv" # TODO: modify me
$userIdColumn = "employee ID" # TODO: modify me
$userIdProperty = "employeeID" # TODO: modify me
$accountPasswordColumn = "AccountPassword" # TODO: modify me
$customColumnNames = @{
    "Termination Date" = "accountExpires";
} # TODO: modify me
$ignoreUnspecifiedColumns = $True # TODO: modify me
$aDObjectProperties = @() # TODO: modify me
$skipEmptyColumnNames = @() # TODO: modify me

Related questions

0 votes
1 answer

Is it possible to import a list of user CN values via CSV file into the basket of the web interface or the console to perform an operation?

asked Aug 15, 2014 by rgreggs (250 points)
0 votes
1 answer

Hello, I'm trying to create a business rule that will update a user account expiry date when that user logs in for the first time. I'm new to Adaxes, so I don't have a ... updated by a user's action, such as "Last Logon". Is it possible to make this work?

asked Mar 6 by sjjb2024 (60 points)
0 votes
1 answer

hello i'm new with Adaxes i'm try to creat schuadle task to import a spefice user list by thier username id after that just update City for them by bulk updating . kinly advise

asked Aug 29, 2023 by sudox (20 points)
0 votes
1 answer

Is there a way to update a distribution group using a CSV file as the source through the web portal? This script is an example of how I would do in manually ... import-csv C:\Distro1.csv | foreach {add-distributiongroupmember -id Distro1-member $_.Name }

asked Dec 11, 2012 by mdeflice (350 points)
0 votes
1 answer

Hi, We've got a business rule setup that when an account is expired it mails certain people to take certain actions. This works fine, however we've had an issue lately, where ... as per point 1, but lists the old expiry and new expiry date. Thanks in advance

asked Feb 13, 2018 by gazoco (490 points)
3,339 questions
3,040 answers
7,758 comments
544,917 users