Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Anders Brännmark 228 posts 280 karma points
    Aug 20, 2009 @ 07:30
    Anders Brännmark
    0

    Removing whitespace when using qoutes as seperator

    Looks like it removes whitespace when using qoutes on import of members. I had a CSV file with the following setup:

     

    Login;Name;Email;Password
    1;"Kalle Persson";"kalle@kalle.com";"sdsdd111"

    When importing it removes the whitespace in the name "column". When removing qoutes it works. Needed qoutes as in email the data was incorrectly format with ; sometimes.

    So how do I remove 500 members the easiest way?

     

    Copy Link
  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Oct 08, 2009 @ 16:03
    Richard Soeteman
    0

    Hi Anders sorry about didn't get back to you. I've missed this post somehow. I'm not understandig your problem I think. Which character in the above example gets removed?

    I have a usercontrol btw which removes all members. Do you still need that?

    Cheers,

    Richard

    Copy Link
  • Sean Mooney 131 posts 158 karma points c-trib
    Dec 18, 2009 @ 19:01
    Sean Mooney
    0

    I have the same problem when I use CSV and " as the Text Indicator

    This is the csv that is generated from Excel

    column one, column two, "column three with spaces", column four

    And when I import it, column three gets imported as: columnthreewithspaces

    Copy Link
  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Feb 16, 2010 @ 09:21
    Richard Soeteman
    0

    HI All,

    Missed the post again :-( I've uploaded a new release where this is solved.

    Cheers,

    Richard

     

    Copy Link
  • James 1 post 21 karma points
    Mar 10, 2010 @ 11:26
    James
    0

    Hi,

     

    I am trying to import some content into an Ubmbraco instance, and I am suffering from the same issue.

    The content is exported with "some text", but all whitespace is removed during the import from the CSV so it becomes "sometext"

    I am running 4.03, which I believe is the most current. Can you tell me which release will have this issue fixed.

    re:I"'ve uploaded a new release where this is solved."

    Thanks

    Jim

    Copy Link
  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Mar 12, 2010 @ 20:29
    Richard Soeteman
    0

    Hi Jim,

    The newest CMSImport V1.0.3 should have fixed this. This one is only available from our.umbraco.org/projects the normal repository uses the old UmbImport 1.0.2 package.

    Cheers,

    Richard

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies