Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

user names imported with trailing spaces
Last Post 03-06-2012 07:45 AM by Amy Casey. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
Amy CaseyUser is Offline
going with the flow
going with the flow
Posts:54
Avatar

--
03-04-2012 07:39 AM
    Last week I imported a set of around 2,000 user names that I did not realize at the time all had trailing spaces in the csv cell containing their user name. 

    The users can login fine without including the trailing spaces, which is good, except we pass the user names into a third party support ticking application and when the names get passed all the spaces are there, and therefore the ticketing system does not work. (it cant match up the user names to its own database where the names are stored w/o the spaces). 

    I tried to reimport the csv file after removing the spaces and selecting to overwrite existing users. It ran the re-import and report came back saying it was successful however the spaces are still there. It is as if it didn't overwrite the user names. (I noticed the overwrite all fields box wouldn't stay checked if I left that page of import process and previous to get back to it). I tried just running as new import to see if it would create new users without the spaces and report came back as all failed to import. 

    I tried going to my user approval page and manually removing the spaces from a user name and hitting update, but got an error saying user already exists. (no it wouldn't be ideal to manually do that for 2000 users, but desperate times...) 

    Is there anything i can do to get rid of these spaces? (even in the back end db if necessary)...I really need to fix this. 

    Thanks
    Amy

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    03-05-2012 05:17 AM
    Hi Amy - Give this a shot... This should work, you can run this under Host/SQL (always make a backup obviously):

    Update Users
    Set Username = LTRIM(rtrim(Username))

    Update aspnet_Users
    set Username = LTRIM(rtrim(Username))

    Update aspnet_Users
    set LoweredUsername = LTRIM(rtrim(LoweredUsername))


    Thanks!

    -Chad

    Amy CaseyUser is Offline
    going with the flow
    going with the flow
    Posts:54
    Avatar

    --
    03-06-2012 07:45 AM
    I wanted to check back in, incase anyone comes across this in future, and say I just ran this script and it worked perfectly!

    Thanks a lot Chad!
    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
     
     
       
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi