AnsweredAssumed Answered

PROGRAM SEEMS TO FORGET

Question asked by RivianWarder on Oct 16, 2008
Latest reply on Oct 17, 2008 by bdam_1

Summary

PROGRAM SEEMS TO FORGET

Description of the issue

I IMPORT ORDERS FROM AN EXCEL SPRED SHEET THEY ARE "NEW" ORDERS AND SOME CHANGES TO "OLD" ORDERS.When I try to import files from an Excel file I will get duplicates or errors here is what I must do in order to import files properly:(my "ORDER" field is a number that never changes no matter what other information changes on an order. So when I import I have the "Update Matching Records" set to "=" order#)But the program seems to forget that. and i have to turn the "Match Set" off / Download / Delete Dupliucates / Turn "Match Set" back on / Download again.If I do all of those steps (15-20min of time) has been the only way to get the "New" orders and update the "Old" orders without duplicating everything.I have been messing around with every combination of things to get it to import without all the hassle. (I have 92 layout copies in my recycle bin) And the above process is the only way I can get it done on a consistent basis.

Outcomes