Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Update Import

More
5 months 3 weeks ago #3745

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 or Create an account to join the conversation.

  • jskoala
  • jskoala's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
5 months 3 weeks ago #3740

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 or Create an account to join the conversation.

  • jskoala
  • jskoala's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
5 months 3 weeks ago #3739

The message is displayed when I attempt to save the profile.

Please Log in or Create an account to join the conversation.

  • jskoala
  • jskoala's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
5 months 3 weeks ago #3738

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 or Create an account to join the conversation.