When running a Direct Import to Update Only, the import routine overwrites all fields with values from the import data whether the table fields have content or not. NULL values in the import file overwrite/delete existing table values. I need the option at the Template level to determine whether NULLs should overwrite table data. We are attempting to regularly update fields in EM Equipment with values from a spreadsheet and the import will not update every field identified in the import each time.
Duane Priest
| Company | Utilitra LLC |
| Job Title / Role | Systems Specialist |
| I need it... | Yesterday...Come on already |
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.
© 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.
This is the type of thing you can do with a User Routine. Basically delete from IMWE for a specific Identifier (field) when the UploadVal is null.
I have some JC Cost Adjustment imports where the file includes some overhead costs so the job is null. Instead of editing the import file I just remove them at the end of the import. If you've got a bit of SQL skills, reach out and I'll hook you up. brent.schrock@fortisconstruction.com