Timesheet upload formatting issues - dates
The upload is in a CSV file format. So if the date is 03/08/18 then it drops the "0" to show only "3". ie. CSV changes automatically from dd/mm/yyyy to d/mm/yyyy once saved and closed.
Then in the timesheet upload it rejects the line saying invalid date. So each time this needs to be manually corrected before uploading.
Is it possible to change this somehow?
|
Company
|
Cornerstone Building Developments
|
|
Job Title / Role
|
Group Management Accountant
|
|
I need it...
|
6 months
|
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
1515 SE Water Avenue, Suite 300, Portland, OR 97214 | 800.333.3197 | Contact Us | Terms of Use | Privacy | Support Policies
© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.
Hi Shaun,
Can you give me an example of when a line wouldn't go?
thanks
*ANDREW TUCKER* *Sr. Product Manager APAC*
*Viewpoint, a Trimble Company*
+61.2.9492.4100 *[d]* | +61.2.(0)416.209.722 *[m]*
WEB | TWITTER
| FACEBOOK
| LINKEDIN
This email and any attachments are confidential and may be privileged. If
you are not the named recipient or have otherwise received this
communication in error, please delete it from your inbox, notify the sender
immediately, and do not disclose its contents to any other person, use for
any purpose, or store or copy them in any medium. Thank you for your
cooperation.
On Thu, Mar 19, 2020 at 9:40 AM Aha! <
9a977a55e23234a8e71a56e4-viewpoint@iad-prod1.mailer.aha.io> wrote:
> Aha!
>
> A new comment has been added to JPC-I-112 Timesheet upload formatting
> issues - dates
>
>
> *Shaun Perrett* 3:39pm View comment
>
>
> As a follow-on to this - the Timesheet upload function does not have the
> step in the Validate & Insert part of the process to enable you to view the
> validation report before you post.
>
> This causes lots of issues when you're uploading multiple lines in a file
> & some go but others don't.
>
> Why is this Upload process different to others - can't see why the
> functionality of other JP uploads isn't repeated here.
> Control your notification preferences
>
> in Aha!
> Aha! Labs Inc, 20 Gloria Cir, Menlo Park, CA 94025
> View on Aha! mobile
>
>
As a follow-on to this - the Timesheet upload function does not have the step in the Validate & Insert part of the process to enable you to view the validation report before you post.
This causes lots of issues when you're uploading multiple lines in a file & some go but others don't.
Why is this Upload process different to others - can't see why the functionality of other JP uploads isn't repeated here.