Powershell script to import .csv or .xls file from Beaufort on monthly base

hi, i`m looking more info on import options using powershell with a .csv or xls, update user attributes in ad, point excel file exported hr application, (beaufort) and not conform csv file when export users from ad ie (samsaccount name , on) contain employeid wich unique, read there option activate employeeid in ad, not activated yet, is there way use hr application exported xls or covert csv file , use import employee info , update ad ?

the updates should in manager field ( persons manager), phone nr (both mobile , desktop), job tittle,  already found need reference column wich ideally employeid, wich stated in not yet active in ad, have found , how, have yet figure out how define in script.

the point @ company dont want use application synchronize both, on appriciated

have found options stated below using a .vbs file import, since live in age of powershell prefer that

http://gallery.technet.microsoft.com/scriptcenter/en-us/30f07744-2fcd-499d-abe3-4e251014f58a

unless i've misunderstood issue, identity reference in file beaufort employeeid, doesn't exist in ad.  need way map id identity reference in ad. 

if create csv in excel has employeeid in col a, , id referenence in ad in col b (sid, guid, logon name, etc), can read in , use translate employeeid beaufort data identity reference in ad.

this separate csv have create yourself, , maintain.  better employeeid set in
ad, way cross-reference identities if not option.

---

[string](0..33|%{[char][int](46+("686552495351636652556262185355647068516270555358646562655775 0645570").substring(($_*2),2))})-replace " "

Windows Server  >  Windows PowerShell