Hello All: We are running AIE 7.5 and have discovered a bug with AIE in regards to how it handles building the Primary Key. We run an import of data in CSV file daily and have been seeing that some of the data records are not getting loaded into Remedy. What we discovered was if any of the data in any column that is used to build the Primary Key has the pattern " AND " such as Name = "JOHN KENNY AND SONS", AIE fails to build the Primary Key and AIE aborts its attempt to create a record in Remedy. Remove the " AND " and the record imports fine. It appears that when AIE goes to build the Primary Key and sees " AND " in the data it treats as the "AND" operator. In our case simply removing any reference to " AND " from the data prior to AIE import is not an option.
Has anyone experienced this issue and if so, is there a fix or workaround you can share. Thanx in advance John _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
