there is one, but this one is quiet bad
You could import the department value from every user as Department Reference List.
But this will lead to a huge log file, because of duplicate entries within AD or empty values.
I did this once, but would never do it again...
Thanks for the advice
Jamie, export an AD extract to a csv file. From there you can manipulate the data as you see fit, and then do a normal data import into a reference list.But of course, that only works for a one off import.