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.
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