I do not have the AIE tool right now handy to point you the exact settings, but on the mapping settings there are options that you choose depending on the source data on how to handle exceptions etc. I would encourage you to visit those options and see if anything applies there that may be applicable to you after you switched the original file.. Even if I did have the tool handy, I might have not been to help you beyond pointing you to this direction, I saw the original data format and the original options set for those.. and the new data format..
Joe From: Frex Popo Sent: Friday, October 08, 2010 12:57 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re : AIE and flat files. ** Hello Frank, Done all that but it didnt work Funny enough, I was testing this for a colleague who was having problems in a 7.5 instalation so I assumed since I tried it and did not work, may be we this was a bug/limitation?! Sine you said it works I will try it again. Regards frex -------------------------------------------------------------------------------- De : Frank Caruso <[email protected]> À : [email protected] Envoyé le : Jeu 7 octobre 2010, 14h 38min 13s Objet : Re: AIE and flat files. ** Yes it works. Make sure you uncommented the delimiter section in the TBL file. Also, I found restarting AIE services ensured changes were applied. On Thu, Oct 7, 2010 at 5:16 AM, Frex Popo <[email protected]> wrote: ** Dear all, ARS 7.1 patch04. AIE 7.1 patch03. A sample mapping and exchange for importing flat files to a remedy form comes with the EIE installer. I tested this exchange (sample pull from flat file to some form) and it works fine for \ delimited records. I change this to a comma in the tbl and the dat file, started the exhange, but no records are imported. because of a time factor I didnt spend too much investigating this. Has anyone got this working. I am trying to avoid using the import tool if I can. Kind Regards, frex _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
