New lookup table defined with AppendOrUpdate behavior, but Import From File feature does not respect that setting

Discussions concerning general integration topics.

Moderator: Phil Barton

Post Reply
toddsou
Posts: 52
Joined: Wed Jul 25, 2012 9:39 am

New lookup table defined with AppendOrUpdate behavior, but Import From File feature does not respect that setting

Post by toddsou » Mon May 07, 2018 8:45 am

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.

BobRichards
Posts: 1007
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

Post by BobRichards » Mon May 07, 2018 10:48 am

Importing from spreadsheets requires that you clean up your data before you submit it to Select (no duplicates in input spreadsheet).
Bob Richards, Software Developer, SoftPro

Post Reply