Sign in Register
Go to solution
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 10x admin c-trib
    Aug 31, 2009 @ 18:39
    Jan Skovgaard
    0

    Importing dates from CSV - Possible?

    Using CMSImport

    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 4036 posts 12863 karma points MVP
    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 10x 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 4036 posts 12863 karma points MVP
    Nov 15, 2011 @ 17:34
    Richard Soeteman
    0

    Check this small blogpost when you run into formatting issues.

    Hope that helps,

    Richard

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft