Submit your Suggestions for Spectrum

Clearing Data File Format - CSV to support double quotes

Product: Cash Management
   
Idea: Clearing Data File Format

More information: Our import file includes double quotes around dollar amounts above $1000, and commas inside the quotes, which is standard .csv file formatting.
Thus, when we import the file, the system only allows checks below $1000. Checks $1000 and above are listed on the error report.

Desired Enhancement: We would love on the Clearing Data File Format import, if Spectrum allowed for standard .csv file formatting including allowing double quotes to contain numerics with commas. The added step of stripping out the quotes and commas from the amount field is cumbersome and time-consuming.







-------------------------------




Dexter
+ Chaney
• Support: 800-352-8939 • Fax:
206-367-9613 •

www.dexterchaney.com (http://www.dexterchaney.com)

  • Guest
  • Apr 23 2018
  • Attach files
  • +1

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.