Data Import validation errors

Officially Answered

Follow

New post

Cédric Noureau

• August 07, 2018 09:46

Hi,

I am importing data for a specific user and i'm getting a validation error :

I checked and the week (#31) is opened and the timesheet for the user is in the "reopened" state :

Why is it not working ?

 

Regards,

Cédric

0

• 

  7pace tech support

  • August 07, 2018 15:07

  Hi Cédric!

  Could you please check Jan.8th. Feb.8th, Mar.8th week for its approval state?

  It seems that 02/08 means not 2nd of August, but the 8th of February.

  Please let me know if this can help you.

  Kind regards,

  Andarth

  0

  Comment actions Permalink
• 

  Cédric Noureau

  • August 07, 2018 15:15

  Hi,

  We made some more tests and the behavior is a bit confusing.

  If the date we try to import is after the 13th, it works in both formats dd/MM/yy and MM/dd/yy.

  If the date we try import is before the 12th, it is considered only as MM/dd/yy.

   

  So yes you are right, 02/08 means the 8th of february.

  What's confusing is that 13/08 means the 13th of august as does 08/13.

  The behavior of the import should be consistent and accept only dates in one format instead of being "half intelligent" an deducing date format for dates after the 13th.

  It should also be mentioned somewhere what is the supported format (it isn't clearly displayed in the error message).

   

  Regards,

  Cédric

   

  0

  Comment actions Permalink
• 

  7pace tech support

  • August 07, 2018 15:18

  Yes, I agree, it is confusing and I've already reported it to our backlog.

  Sorry about that, it will be improved in our next releases.

  Kind regards,

  Andarth

  0

  Comment actions Permalink

Please sign in to leave a comment.