Hello everyone,
I have a unique situation, or at least I believe it to be. We are looking to add roughly 500K+ items to our GP 9. We have macro the procedure but due to some small scale testing, we believe that the macro would take hundreds if not thousands of hours to complete and that is not accounting for the breaks as we would have to divide the macro up for performance reasons.
My next thought was to instead add these items via SQL. I started by running the macro in our test environment and running SQL Profiler to catch the save actions. Unfortunately, this hasn't worked to well as it seem only selects are taking place.
I am wondering if anyone has had experience with a bulk upload via SQL or perhaps some other method. Thank you in advance
*This post is locked for comments
Hi,
Of course, if you have Integration Manager or eConnect, you would definitely use those tools. If you've got 500K items to import, I would buy it if I didn't have it.
If you are dead set on doing a table import, you need to look at the GP SDK (software development kit). In the SDK, you'll find a section named 'Table Integration', select 'Design Documents and Transaction Flows' under that section and then 'Item Master Import Guidelines' in the Inventory section.
A Word document will open that explains in detail how to import an Item. Back in the 'old days', the days before Integration Manager and eConnect (yes, I've been around that long) we had to use the Table Import utility to do all of our master file and transaction imports. While no business logic was applied, it was (and still is) super fast.
You can use this article as a guide for which tables to insert into using SQL, or you can use the import utility. To launch the import utility use the following navigation:
Microsoft Dynamics GP > Tools > Integrate > Table Import
It works like a champ, but backup and test, test, test. Be sure to run Check Links after any import accomplished using Table Import or SQL.
Good Luck!
Kind regards,
Leslie
PS I still use table import regularly.
LV
Do you have Integration Manger? If yes, you can import bulk number of items into GP. Or If you have the eConnect tools, you can create customization to import the same.
For SQL importing, referring the tables names from Victoria Yudin-MVP site(victoriayudin.com/.../inventory-tables)
Note: I wouldn't recommend SQL insert. Anyway if you using SQL insert, pleas try this on test environment. Then before go to the live, make sure you have latest backup for company database.
Hope this helps!!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156