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 226 posts 277 karma points
    Aug 20, 2009 @ 07:30
    Anders Brännmark
    0

    Removing whitespace when using qoutes as seperator

    Bugs

    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";"[email protected]";"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 4035 posts 12842 karma points MVP
    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 4035 posts 12842 karma points MVP
    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 4035 posts 12842 karma points MVP
    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
Please Sign in or register to post replies

Write your reply to:

Draft