I just waded through some frustration with AIE 7.6 on a ARS 7.5p6 in a
Windows VM env.
Here's what I experienced:
Make sure the user & pass are correct in the AIE.cfg file. You *can* put the
password in the cfg file in plain-text (just to make sure that's not the
problem). In my case, AIE would not/could not update the aie.cfg file when
you updated the aie-settings form.
Here's how to fix that prob (from BMC sprt):
In the AIE install path, find 'aiecfedit.exe' and open a command-prompt
shell in that directory, then...
If you enter 'aiecfedit' without any parameters in the command prompt, it
will show you what is required. Note the "-y" switch for the path;
double-quote it if it contains spaces and it may or may not want a trailing
slash ("\"). You also may need to include the -x (arservername) switch as
well.
1. Edit the 'aie.cfg' configuration file manually, deleting the entry for
'Password:'. Just leave it blank.
2. In the AIE Console > Configuration > Integration Engine App., enter
once more the User Name and Password, and click on the 'Save' button below.
3. Check the 'aie.cfg' configuration file. If the password was not
entered and encrypted, run the aiecfedit utility again to set the password.
If the "Verify" function on the data exchange get's stuck, (from BMC sprt):
click the "Close" link in the upper right of the form to reset it. You can't
just close the window, you actually need to click the "Close" link on the
form.
If the data exchange "verifies" ok and appears to run ok, but no data is
actually written into your target form and you only get scant vague errors
in the logs (or no errors/hints at all), then it's most likely your source
data.
- Reduce your key field mapping to be as simple as you can possibly make it,
while still being an effective unique key mapping.
- Reduce your data to only the fields you are mapping; *NO* extra
columns. If that works, add more columns to the data (set the exchange to
update existing records) and retry. Lather, rinse, repeat until all data
goes in -or- you identify the problem column(s).
- When mapping, I had to map the columns in the *exact* order they appeared
in the CSV file, or else the exchange would run without complaint, but no
data was actually moved.
- If the logs indicate there are more columns in the .tbl field than the
data file, and if the data is in csv format -- open it in excel and run each
and every column through the excel functions TRIM and CLEAN. Don't forget to
"copy|paste-special|values" the scrubbed data and re-save in csv format.
Anytime you "touch" your mapping(s), be sure to open the data-exchange and
remove/re-add the mapping to make sure it refreshes. I intially got mixed
results by not re-adding it and found it better to be safe and just re-add
it.
The biggest killers seem to be data that includes commas,
line-feeds/carriage returns, other non-printing chars within the data. The
TRIM & CLEAN functions will flatten any data that includes one or more
paragraphs (like note fields) rendering them a mess to read, but I couldn't
get it to work otherwise. I'd love to hear if anyone else has managed to get
AIE to process a flat-file with multiple lines within the data, regardless
of quoted values and escaped quotes within data. I couldn't figure it out...
I don't know if the above problems are normal for everyone, or if my
particular instantiation of AIE is just being more of a curmudgeon than
normal, but that's been my experience with the Atrium v7.6 version of AIE.
Good luck with it.
JDHood
On Fri, Oct 8, 2010 at 12:57 PM, Frex Popo <[email protected]> wrote:
> **
> 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"
