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

       

Log in to post a comment.

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

Sign up for the SourceForge newsletter:





No, thanks