Update Import
8 years 7 months ago #3738
by jskoala
Update Import was created by jskoala
When I change my import profile operation from "insert" to "update" I get a "Select Primary/Unique Key" message. I can't get past this no matter what fields I select, and I have verified and re-created unique keys on the tables. What am I doing wrong?
Please Log in to join the conversation.
8 years 7 months ago #3739
by jskoala
Replied by jskoala on topic Update Import
The message is displayed when I attempt to save the profile.
Please Log in to join the conversation.
8 years 7 months ago #3740
by jskoala
Replied by jskoala on topic Update Import
Well, I was able to get past it by dropping the PRIMARY key and recreating my unique as the PRIMARY. Is there no way to do an UPDATE import using a NON-PRIMARY UNIQUE key?
Please Log in to join the conversation.
8 years 7 months ago #3745
by Daniel
Thanks
Daniel
Replied by Daniel on topic Update Import
You can already work with Non Primary Unique key. The only reason I can think of for the issue you were having is you had Skip option selected for the columns selected in Primary key in Profile settings.
Thanks
Daniel
Please Log in to join the conversation.