HELP with a setting issue in GP using integration manager

(0) Share

Report

Posted on by Community Member

I have set up an integration in integration manager for our entities which when I run the integration on my computer all entries are imported into GP 2013 the way they should show up but when 2 other colleagues of mine run the integration on their computers a few of the entries, not all (about 4 out of 14) import backwards (i.e. showing credits before debits). I have checked all version numbers of GP, Excel and Integration manager which we all have the same version number. Would there be a setting in GP that might be different on my computer making all the entries show the debits first then the credits? When I look at the Preview in Integration manager the entries look fine so there is something going on from when they hit "Run" in Integration manager to when they are imported into GP.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

Tom Cruse 1,477 on at

Like (0)

Report
Copy link

Link copied!

Do you have multiple Integration Manager databases? I've seen that happen plenty of times where one person thinks they're running the correct IM but in fact they're pointing to the wrong one.

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report
Copy link

Link copied!

Here is a link to a forum post, which covers setting in IM, which need to be configured on each machine. You likely have a slightly different Integration on your machine than the other users do.

community.dynamics.com/.../138236.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

No we have the same database & in my instructions to each person I copy the name that I have showing to ensure they are pointing to the correct one.

Was this reply helpful? Yes No
Jonathan Fear Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Harry is right. I would think your UseOptimize lines are different in your IM.ini files.

Was this reply helpful? Yes No
Verified answer

Redbeard 12,931 on at

Like (0)

Report
Copy link

Link copied!

community.dynamics.com/.../166779.aspx

Jonathan is right about the exact setting, which is causing this problem - and it varies from workstation to workstation:

1. Open Windows Explorer and go to C:\Program Files (x86)\Microsoft Dynamics\Integration Manager XX\

2. In Notepad open Microsoft.Dynamics.GP.IntegrationManager.ini

3. Change UseOptimizedFiltering=True to UseOptimizedFiltering=False

4. Save and close Notepad, then restart Integration Manager

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Perfect!!!! Thanks for the help everyone & thanks for the path Redbeard!!! Worked perfect to fix everyones import!!!

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

Please remember that IM is not designed to import a large amount of records. Redbeard is absolutely correct with the setting in the ini file for Optimized Filtering. I lost many hours of sleep when I first bumped into this. I would run it once and all records would import and then I would run it again and it would leave records off.

Was this reply helpful? Yes No