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!

Comma & Delimiters
Last Post 11-11-2011 09:24 AM by Paul Bolejack. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
KellyoUser is Offline
river guide
river guide
Posts:113
Avatar

--
08-29-2009 03:46 PM

    Hi DS Guys and Gals,

     

    I am trying out Interactive user import for the first time and it seems like a nice module I can use.

     

    I have found a couple issues I'm not sure how to deal with. When I import a CSV file created in excel, excel puts double quotes around any field that has commas in it ... but when the import is performed those double quotes are ignored by the module and consequently are interpreted as delimiters .. thus messing up the data.

     

    So I tried a tab delimited txt file, but the module only seems to recognise CSV, I cannot select txt as a file type, nor specify tabs as the delimiter. I am using IUI 2.0 on DNN 4.9.4

     

    I'm sure you've been asked this question before but I could not find it here on the support forum.

     

    Thoughts?

     

    Thanks

     

    Kelly

    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    08-31-2009 06:30 AM
    HI, sorry for the late response but just got back into the office. Can you check if the filename extension is .txt or .TXT? Also, open it up in notepad to see if it's straight ASCII file and not binary data. IUI 2.0 should be able to import .txt,.TXT,.csv,.CSV,.xls,.XLS files. Also, you cannot specify TAB as the delimiter because it looks at it as blank spaces and would be very difficult to error trap for this. Please try another delimiter. -- David
    Paul BolejackUser is Offline
    skipping stones
    skipping stones
    Posts:12
    Avatar

    --
    11-11-2011 09:24 AM
    Here's a tip for anyone trying to figure out how to get Excel to use a delimiter other than a comma when saving as a csv file. Apparently Excel uses the List Separator setting in the Windows Regional settings. So, go to Region and Language in the Control Panel and look for the List Separator setting and change it to a semicolon, for example. Save the Excel file as a csv then go back and change the List Separator back to what it was.
    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