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


  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Aug 31, 2009 @ 18:39
    Jan Skovgaard
    0

    Importing dates from CSV - Possible?

    Hi Richard

    Thanks for an übercool package! You rock!

    Currently I'm trying to import dates from an CSV file. The dates (datetime) are formatted like this: 2009-09-06 11:30, which appears to be the format in, which Umbraco is storing the dates.

    But I get this error: "Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery" - Not sure about what it says?

    So I am wondering if it is at all possible? :)

    /Jan

    Copy Link
  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Aug 31, 2009 @ 20:47
    Richard Soeteman
    100

    Hi Jan,

    It is possible, only your timeformat is incorrect I think. What I do is a simple DateTime.Parse. I've modified your format to this 09-06-2009 11:30 and that worked fine.

    Hope it helps you,

    Richard

    Copy Link
  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Aug 31, 2009 @ 21:53
    Jan Skovgaard
    0

    Hi Richard

    I thought it was such a thing but could just not figure out what format it should be in - thanks a ton :)

    /Jan

    Copy Link
  • Richard Soeteman 4054 posts 12927 karma points MVP 2x
    Nov 15, 2011 @ 17:34
    Richard Soeteman
    0

    Check this small blogpost when you run into formatting issues.

    Hope that helps,

    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