Hi-
I’ve defined a new lookup table using the AppendOrUpdate behavior for new entries.
Then, when I use the “Import from File” feature to bulk import entries from my spreadsheet (which contains duplicates), it displays a success message which confirms that # of rows were imported from my spreadsheet (dupes included). And so, the Lookup Table editor now contains the dupes. ( I expected the aforementioned behavior to treat my dupes as updates to existing entries and NOT add another grid row for each of them.)
Thus, when I attempt to Save my edits, I get an error because duplicates exist in the grid.
Bug or user error ?
Thanks.
New lookup table defined with AppendOrUpdate behavior, but Import From File feature does not respect that setting
Moderator: Phil Barton
-
- Posts: 1377
- Joined: Wed Jan 15, 2014 3:50 pm
- Location: Raleigh, NC
- Contact:
Re: New lookup table defined with AppendOrUpdate behavior, but Import From File feature does not respect that setting
Importing from spreadsheets requires that you clean up your data before you submit it to Select (no duplicates in input spreadsheet).
Bob Richards, Senior Software Developer, SoftPro