| Author | Messages | |
gupnit
Posts:5
 | | 11/19/2009 5:04 PM |
| Gentleman,
This is my first question to the Mailing List and my fingers crossed as I am stuck real bad. Here goes my scenario:
* Basic AD Environment setup in my Lab
* There are 2 OUs - "Users" and "Vista Contacts"
* Users OU has all the Users
* Vista Contacts OU has all the Contacts
* Now what I do is create 1 contact and populate it with this additional information (screenshot)
* Organization Tab: I give on of the User of Users OU as the Manager
* Telephones Tab: Home Field has some number & Notes Field has some questions
* What am I trying to achieve:
* I use CSVDE to export Contact (only 1 in that OU) from Contacts OU, here is the command: csvde -f "D:\test.csv" -d "OU=Vista Contacts,DC=test,DC=com" -r objectCategory=Person
* Ok, so far so good, the CSV gets created and data is populated in that. Here is the Outpu
* DN,objectClass,cn,distinguishedName,instanceType,whenCreated,whenChanged,uSNCreated,info,uSNChanged,name,objectGUID,objectCategory,manager,homePhone
"CN=3497508,OU=Vista Contacts,DC=test,DC=com",contact,3497508,"CN=3497508,OU=Vista Contacts,DC=test,DC=com",4,20091118195859.0Z,20091118195859.0Z,127116,X'513a20576861742077617320746865206e616d65206f6620796f7572206669727374207363686f6f6c3f0d0a413a20610d0a513a20576861742077617320746865206e616d65206f6620796f7572206368696c64686f6f64206265737420667269656e643f0d0a413a206a65726f6d650d0a513a2057686572652077617320796f757220666972737420686f6c696461793f0d0a413a20620d0a513a205768617420617320746865206d6f64656c206f6620796f7572206669727374206361723f0d0a413a20746f6e6b610d0a513a205768617420697320796f7572206661766f75726974652066696c6d3f0d0a413a2063',127116,3497508,X'5cd8010348d4124b8b894634a3d07fe4',"CN=Person,CN=Schema,CN=Configuration,DC=test,DC=com","CN=j10707d,CN=Users,DC=test,DC=com",222222
* Now, I go ahead and delete the Contact
* Here is the problem now, I use CSVDE again to import the Contact using the exported CSV it is giving error. (screenshot attached). The command I use is csvde -i -f "D:\test.csv"
* Issue is when I remove the encrypted information and Manager information the Contact is getting imported.
Need urgent help, as this is something that I need to achieve as a part of one Backup/Recovery scenario I am working on. Well if someone has smoe other way of achieving this, please let me know. I have attached couple of screenshots
Thanks in anticipation of your help !!
Regards
Nitin Gupta
MVP - Exchange
Blogs: http://www.nitingupta.in/blogs && http://exchangetimes.blogspot.com/
Website: http://www.nitingupta.in
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
| | | |
| Barbosa
Posts:2
| | 11/19/2009 5:18 PM |
| Hi, for this use PowerShell
Get-QAdUser
see http://wiki.powergui.org/index.php/Get-QADUser
On Thu, Nov 19, 2009 at 2:59 PM, Nitin Gupta <gupnit@yahoo.com> wrote:
> Gentleman,
>
> This is my first question to the Mailing List and my fingers crossed as I
> am stuck real bad. Here goes my scenario:
>
> - Basic AD Environment setup in my Lab
> - There are 2 OUs - "Users" and "Vista Contacts"
> - Users OU has all the Users
> - Vista Contacts OU has all the Contacts
> - Now what I do is create 1 contact and populate it with this
> additional information (screenshot)
> - Organization Tab: I give on of the User of Users OU as the Manager
> - Telephones Tab: Home Field has some number & Notes Field has some
> questions
> - What am I trying to achieve:
> - I use CSVDE to export Contact (only 1 in that OU) from Contacts
> OU, here is the command: *csvde -f "D:\test.csv" -d "OU=Vista *Contacts,DC=test,DC=com"
> -r objectCategory=Person
> - Ok, so far so good, the CSV gets created and data is populated in
> that. Here is the Outpu
> -
> DN,objectClass,cn,distinguishedName,instanceType,whenCreated,whenChanged,uSNCreated,info,uSNChanged,name,objectGUID,objectCategory,manager,homePhone
> "CN=3497508,OU=Vista
> Contacts,DC=test,DC=com",contact,3497508,"CN=3497508,OU=Vista
> Contacts,DC=test,DC=com",4,20091118195859.0Z,20091118195859.0Z,127116,X'513a20576861742077617320746865206e616d65206f6620796f7572206669727374207363686f6f6c3f0d0a413a20610d0a513a20576861742077617320746865206e616d65206f6620796f7572206368696c64686f6f64206265737420667269656e643f0d0a413a206a65726f6d650d0a513a2057686572652077617320796f757220666972737420686f6c696461793f0d0a413a20620d0a513a205768617420617320746865206d6f64656c206f6620796f7572206669727374206361723f0d0a413a20746f6e6b610d0a513a205768617420697320796f7572206661766f75726974652066696c6d3f0d0a413a2063',127116,3497508,X'5cd8010348d4124b8b894634a3d07fe4',"CN=Person,CN=Schema,CN=Configuration,DC=test,DC=com","CN=j10707d,CN=Users,DC=test,DC=com",222222
> - Now, I go ahead and delete the Contact
> - Here is the problem now, I use CSVDE again to import the Contact
> using the exported CSV it is giving error. (screenshot attached). The
> command I use is *csvde -i -f "D:\test.csv"*
> - Issue is when I remove the encrypted information and Manager
> information the Contact is getting imported.
>
> Need urgent help, as this is something that I need to achieve as a part of
> one Backup/Recovery scenario I am working on. Well if someone has smoe other
> way of achieving this, please let me know. I have attached couple of
> screenshots
>
>
>
> Thanks in anticipation of your help !!
>
>
>
> Regards
>
> *Nitin Gupta*
>
> *MVP - Exchange *
>
> Blogs: http://www.nitingupta.in/blogs &&
> http://exchangetimes.blogspot.com/
>
> Website: http://www.nitingupta.in
>
> ------------------------------
> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage<http://in.rd.yahoo.com/tagline_yyi_1/*http://in.yahoo.com/>
> .
>
--
---
Juliano Barbosa
Analista de Sistemas
Home Page:http://www.flexsolutions.com.br
e-mail: julianomb@gmail.com
Fone: (62)8409-8590
| | | |
| gupnit
Posts:5
| | 11/19/2009 5:30 PM |
| Hi,
Thanks a lot for the reply, unfortunately PowerShell is not an option that I can use.
Regards
Nitin Gupta
Blogs: http://www.nitingupta.in/blogs && http://exchangetimes.blogspot.com/
Website: http://www.nitingupta.in
________________________________
From: Juliano Morais Barbosa <julianomb@gmail.com>
To: activedir@mail.activedir.org
Sent: Thu, 19 November, 2009 10:48:10 PM
Subject: Re: [ActiveDir] Query | CSVDE & Export/Import !
Hi, for this use PowerShell
Get-QAdUser
see http://wiki.powergui.org/index.php/Get-QADUser
On Thu, Nov 19, 2009 at 2:59 PM, Nitin Gupta <gupnit@yahoo.com> wrote:
Gentleman,
>
>This is my first question to the Mailing List and my fingers crossed as I am stuck real bad. Here goes my scenario:
> * Basic AD Environment setup in my Lab
> * There are 2 OUs - "Users" and "Vista Contacts"
> * Users OU has all the Users
> * Vista Contacts OU has all the Contacts
> * Now what I do is create 1 contact and populate it with this additional information (screenshot)
> * Organization Tab: I give on of the User of Users OU as the Manager
> * Telephones Tab: Home Field has some number & Notes Field has some questions
> * What am I trying to achieve:
> * I use CSVDE to export Contact (only 1 in that OU) from Contacts OU, here is the command: csvde -f "D:\test.csv" -d "OU=Vista Contacts,DC=test,DC=com" -r objectCategory=Person
> * Ok, so far so good, the CSV gets created and data is populated in that. Here is the Outpu
> * DN,objectClass,cn,distinguishedName,instanceType,whenCreated,whenChanged,uSNCreated,info,uSNChanged,name,objectGUID,objectCategory,manager,homePhone
>"CN=3497508,OU=Vista Contacts,DC=test,DC=com",contact,3497508,"CN=3497508,OU=Vista Contacts,DC=test,DC=com",4,20091118195859.0Z,20091118195859.0Z,127116,X'513a20576861742077617320746865206e616d65206f6620796f7572206669727374207363686f6f6c3f0d0a413a20610d0a513a20576861742077617320746865206e616d65206f6620796f7572206368696c64686f6f64206265737420667269656e643f0d0a413a206a65726f6d650d0a513a2057686572652077617320796f757220666972737420686f6c696461793f0d0a413a20620d0a513a205768617420617320746865206d6f64656c206f6620796f7572206669727374206361723f0d0a413a20746f6e6b610d0a513a205768617420697320796f7572206661766f75726974652066696c6d3f0d0a413a2063',127116,3497508,X'5cd8010348d4124b8b894634a3d07fe4',"CN=Person,CN=Schema,CN=Configuration,DC=test,DC=com","CN=j10707d,CN=Users,DC=test,DC=com",222222
> * Now, I go ahead and delete the Contact
> * Here is the problem now, I use CSVDE again to import the Contact using the exported CSV it is giving error. (screenshot attached). The command I use is csvde -i -f "D:\test.csv"
> * Issue is when I remove the encrypted information and Manager information the Contact is getting imported.
>Need urgent help, as this is something that I need to achieve as a part of one Backup/Recovery scenario I am working on. Well if someone has smoe other way of achieving this, please let me know. I have attached couple of screenshots
>
>Thanks in anticipation of your help !!
>
>Regards
>Nitin Gupta
>MVP - Exchange
>Blogs: http://www.nitingupta.in/blogs && http://exchangetimes.blogspot.com/
>Website: http://www.nitingupta.in
>
>
________________________________
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
--
---
Juliano Barbosa
Analista de Sistemas
Home Page:http://www.flexsolutions.com.br
e-mail: julianomb@gmail.com
Fone: (62)8409-8590
The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
| | | |
|
|