You’re offline. This is a read only version of the page.
176
Hi All, I am using CSV as a source to integrate Quotes to GP through Integration Manager.
In Excel i have given a Line Number and used the same to sort by in Lines Source in Integration Manager. But after Integration, Lines are completely jumbled not sure which sequence Integration Manager is reading lines. Could you please advice how to integrate the same sequence as in CSV file so line items will be integrated in the correct order in the quote.
Screen shots below:
Left side GP.. Right side Integration Manager (Preview)
pls. advice..
Are you able to Preview the each of the source queries? (That often gives a clue about what may be going on with the most common issue being the file is not available because it is still open in Excel.)
If you only changed one of the INI files, you can try running the integration with the one that you didn't update.
Post your INI file here if you want anyone to look at it to see if there is a format issue with it.
If you remove the line you added, does the integration work again (albeit in the wrong sort order)?
Here is a GPUG post that may have some insights:
I changed UseOptimizedFiltering=FALSE and this is the error I receive. I did not move the files or change any thing else and before I changed only the filtering it imported everything in a jumbled order.
|
Opening source query... |
|
ERROR: Unable to open source queries because Query 'DPI Sales Header Invoicing' is not found in the database. - Add failed. Duplicate key value supplied. |
|
Unable to open source queries because Query 'DPI Sales Header Invoicing' is not found in the database. - Add failed. Duplicate key value supplied. |
|
Add failed. Duplicate key value supplied. |
|
Integration Failed |
|
Integration Results |
|
0 documents were read from the source query. |
|
0 documents were attempted: |
|
0 integrated without warnings. |
|
0 integrated with warnings. |
|
0 failed to integrate. |
Thank you so much, I do believe I found the path in my Program files. This is a Configuration Settings type file and runs in the back ground as a system setting. Every time I read about the UseOptimizedFiltering=False option. I was looking in my options inside Integration Manager, inside GP, inside the settings of the integration I build as a line item option. None of those were getting me anywhere. I went back to the link you posted and finally saw the UseOptimizedFiltering=False with in the instructions although she is speaking of another setting it does work for my scenario. I like her blog so I will go back to that as well. I will be testing my upload and hopefully have success. If I can get this done it will save us DAYS in billing process. Thanks for your time!!
UseOptimizedFiltering is one of the switches that can be added to / set in the Integration Manager INI files.
It has nothing to do with your CSV file. INI files are in your Integration Manager install folder.
[If you have someone you work with for Windows issues, they are likely to be able to better explain how to edit an INI file. While the process is simple enough, there are various folder view settings with your specific computer/user that make it difficult to walk through the process via a post like this. If you can find the INI file(s) on your computer, you could attach them to this post for someone to comment on the change that is needed to it.]
The INI file is a text file found in the install folder. It can be edited with a text editor (like Notepad). If you aren't familiar with modifying INI files, do you have someone in IT who can assist with this?
[INI is the file extension used on Windows computers that is an abbreviation for Initialization.]
Jen Kunz has a blog on making a different modification to the two Integration Manager INI files here: jenkuntz.ca/.../
[Note: The setting she is discussing in her blog is different than the one we are discussing here. Here "How do I do that?" section has a screenshot of what an INI file looks like when it is opened in NotePad.
I am having sort of the same issue and I have read exactly as you stated multiple times but I have no idea how to find this setting. Can you further explain how to change from True to false? Step by step? Also it may be because I don't understand what the INI file is, I like this user was using CSV.
Thanks You. It looks worked.
Have you tried adding:
UseOptimizedFiltering=False
to the IM and/or RunIM initialization (INI) files?
[These are workstation-level INI files.]
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (