Solved

CSVDE and LDIFDE export showing numerals starting X'434 instead of expected text

Posted on 2010-09-10
6
1,573 Views
Last Modified: 2012-05-10
Whenever i run a csvde export or ldifde export i get a bunch of numbers instead of text.

the command i am running is :

CSVDE -f c:\temp\grpmem.txt -l "dn,member" -r objectClass=group


and i get a bunch of results like this:
"CN=Users,CN=Builtin,DC=fruit,DC=co,DC=uk"X'434e3d446f6d696e6963204e656c736f6e2c4f553d53616c65732c4f553d50656f706c652c4f553d496e6e6f63656e74204c74642c44433d6672756974746f776572732c44433d696e6e6f63656e746472696e6b732c44433d636f2c44433d756b'

using ldifde i am running :
 ldifde -f c:\temp\grpmem.txt

and i get results like this
dn: CN=Innocent,OU=Security Groups,DC=fruit,DC=co,DC=uk
changetype: add
member::  Q049RG9taW5pYyBOZWxzb24sT1U9U2FsZXMsT1U9UGVvcGxlLE9VPUlubm9jZW50IEx0ZCxEQz1mcn VpdHRvd2VycyxEQz1pbm5vY2VudGRyaW5rcyxEQz1jbyxEQz11aw==

We have a mixed environment 1 x 2008 and 2 x 2003 servers.  Im sure this only started happening after we introduced the 2008 server into the mix but im not sure it would affect the scripts like this.

Bascially i have a bunch of scripts that take our production AD and replicates it across to our test environments.  I need to know if can easily convert these characters back to normal text?
0
Comment
Question by:InnocentDrinks
  • 3
  • 2
6 Comments
 
LVL 4

Accepted Solution

by:
williamvanerp earned 500 total points
Comment Utility
It looks like the script is converting special characters into another text. If these characters are used in usernames, you don't easily search and replace since the problobly whould be all different. If its something like a department name, you should get the same results and search and replace program may fix it for you fast and easy.
0
 
LVL 4

Expert Comment

by:williamvanerp
Comment Utility
Looks like its converting special characters into another text. Characters like
0
 

Author Comment

by:InnocentDrinks
Comment Utility
thanks, is there any way i can tell what this is referring to?, it just seems to be randomly selecting users and replacing their information with random characters like aboev.
0
Do email signature updates give you a headache?

Constantly trying to correctly format email signatures? Spending all of your time at every user’s desk to make updates? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today!

 
LVL 4

Expert Comment

by:williamvanerp
Comment Utility
If its random it is not like i discribed. Have you tried to run the command to the 2003 server directly and to the 2008 server to see if there is a difference in outcome? Try this CSVDE -f c:\temp\grpmem.txt -s Servername -l "dn,member" -r objectClass=group where Servername is the name of your 2003 / 2008 DC.
0
 

Author Comment

by:InnocentDrinks
Comment Utility
Hi Will,

After more investigating it seems like it was trying to convert special characters in usernames.  Im not sure why this problem didnt show itself up before but at least i know why it is doing it.  Also just by having 1 member with this special character it will try to convert the whole output string i.e. it does not leave non special usernames intact. wierd
0
 

Expert Comment

by:CarlyleServiceDesk
Comment Utility
Hi all,

Did anyone find a resolution to this?  Out of around 1000 users in our AD, this is happening to 8 accounts only.  The exported data looks fine (with CN= group membership information) for all users except those 8 accounts. I can't seem to find anything unique about those accounts. They definitely don't have elevated privileges.

Thanks,
Nick
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now