Greetings Listers, I'm stuck on an AIE limitation that I can't seem to get around. I want to do a nightly file import from a .csv file to a target custom AR form. Problem is the .csv file contains duplicate entries and there is no way to get a completely unique key (even using a composite key from multiple columns in the .csv file). After much testing, frustration, and retesting I have found that AIE cannot (successfully) import from a .csv file without a unique key. Period. It's not that it simply will overwrite records where duplicates are encountered, it gets completely confused on the number of records to import and only processes approx. 1/3 of the total data. I've tried every combination of configurations/queries/keys in the AIE mapping and exchange entries.
For reasons I won't detail, I don't have the option of altering the source of the .csv file to insert a unique ID or to filter duplicates out. I'm racking my brain to figure out some script or batch file I can create to run prior to the exchange which inserts a unique column (a counter basically) into the .csv file so that AIE can import it. I've validated that I can manually add a unique column to the .csv and everything imports as expected. Anyone have a clever way to insert a unique column to a .csv file programmatically, or a way to get Remedy to import a .csv nightly which contains non-unique data? I'm trying to avoid a less desireable solution involving running the import tool from workflow as I believe it would require me to pass Admin credentials in the command line to run the import tool. The security implications there concern me. Thanks. Nate. Nathan Aker ITSM Solution Architect McAfee, Inc. 5000 Headquarters Drive Plano, TX 75024 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
