Solved Import user from AD/CSV file

[okba60]

Hello,
I am currently experiencing problems to make an AD import, indeed all my users do not appear (import and then import AD) by clicking on search, I have many users who display but not all.
I miss a lot in those posted, there's a limitation? I have more than 1000 AD users ...


Also via CSV, I took the .csv example given on the site.
I opened via excel (by doing semicolon delimited convert)
When I try to import my CSV, error message:
"Wrong CSV file, the necessary columns do not exist"

Which fields are required? I would like to fill only the columns name, first names, extensions and emails.

Here is attached my csv, what I messed up?
Knowing that my file is in .csv (saved via excel csv delimited by semicolon)

Thank you

 

[JohnS_3CX]

Open our CSV in NotePad++ and then open the one you made in Excel in NotePad++

I think you will see a difference in what Excel does, injecting more characters like " "

 

[StefanW]

yes, an AD just returns on request the first 1000 (or even 500) users.
Now ad-users are also an issue as this also contains "computers" (I don't know why an AD property user is set for a PC until today). You can sync to Azure AD and we read them all from there via API.

 

[okba60]

Open our CSV in NotePad++ and then open the one you made in Excel in NotePad++

I think you will see a difference in what Excel does, injecting more characters like " "

I do it a lot of times, i don't see a difference in excel and notepad++
Nothing like " "

yes, an AD just returns on request the first 1000 (or even 500) users.
Now ad-users are also an issue as this also contains "computers" (I don't know why an AD property user is set for a PC until today). You can sync to Azure AD and we read them all from there via API.

How you a tutorial with ad azure?

 

[StefanW]

a very dirty how-to I have for you
AD - Cloud Connect - Aure AD - 3CX Office API

https://drive.google.com/file/d/1-NAWmUePfFnCYwOb2ug2fO-bZsa0in7u/view

 

[okba60]

I found the problem
Can close topic

 

[AWS2P]

What did you found? can you share your fix? would be nice for those with similar problem

 

[okba60]

You have to add to the csv this fills completed:
authid
authpassword
pin