Import order: problem with date

  • lando

    lando - 2007-11-26

    Hi everyone,

    I got a problem when trying to import orders using compiere with the Date field :

    ===========> ImpFormatRow.parseDate: ImpFormatRow.parseDate - 23/11/2007 [14]
    java.text.ParseException: Unparseable date: "23/11/2007"

    I got ComPiere 261, Oracle XE.

    I can't find a "howto" describing an import procedure with dates.

    My csv file has the format DD/MM/AAAA and i put the same in the format in compiere.

    "Help me, you're my only hope"




    • ADAXA

      ADAXA - 2007-11-26

      We found that date import problems went away if we defined the date format in the import loader to be yyyyMMdd.  The excel function =text(<datefield>,"yyyymmdd") easily converts to that format.

      re: "I can't find a "howto" describing an import procedure with dates"  .. there is one on journal entries which obviously have dates at


    • lando

      lando - 2007-11-27

      It's working !

      Thanks a lot !



Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks