Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Import order: problem with date

lando
2007-11-26
2013-05-02
  • 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"

    Thanks

    Regards,

    LC

     
    • 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 http://www.adaxa.com.au/index.php?option=com_content&task=view&id=54&Itemid=27

      regards

       
    • lando
      lando
      2007-11-27

      It's working !

      Thanks a lot !

      LC